English (United Kingdom)

https://curated-unify.zendy.io/wp-json/zendy-region/v1/featured_content/oa?rat=en

https://curated-unify.zendy.io/wp-json/zendy-region/v1/highlighted_journal/

Global: Zendy Plus annual

Presents the access of premium content as premium feature

Premium Content

Presents the keyphrase highlighting as premium feature

Keyphrase Highlighting

Presents the summarisation as premium feature

Summarisation

Insights

Presents the pdf analysis as premium feature

PDF Analysis

Presents the zaia usage as premium feature

ZAIA

Global: Zendy Tools annual

Global: Zendy Free Plan

Global: Zendy Tools monthly

Global: Zendy Plus monthly

This paper summarizes the development of data integration and the present situation of the development in domestic and abroad. It also analyzes the yearbook data, find that different years, different regions of the data has very big differences in the structure, name, dimension, data type, and other aspects, and the current data integration technology cannot be effectively integrate yearbook data. However, metadata exactly can well solve the problems, using metadata not only can realize the effective integration about local yearbook data, but also can achieve different platforms, different subsystem, different software sharing yearbook data. So, metadata is helpful for effectively improving yearbook data utilization rate. 1 A SUMMARY OF DATA INTEGRATION The worldwide Data Integration project index drawn by Patrick Ziegler, as shown in figure 1, describes the development of data integration. The traditional data integration technology mainly includes many multiple database System and the federal database System. With the development of the distributed network technology, in order to increase the processing of Web data and semistructured data and integrate data sources which have new forms, new technologies occurred , such as the data integration system based on agent , the integration technology based on ontology, etc. As web service technology developed, researchers launched a research based on the web service integration technology. Compared with the overseas research, domestic research about the data integration technology started relatively late, however, it is developed very quickly. Relatively speaking, the researches that southeast university computer science and engineering researchers did was earlier that they developed versatile based on a distributed heterogeneous data sources integration system prototype — CORBA, aiming at integrating data from different data sources in the way of playing at the same time. Chinese people's university researchers paid more attention to doing research on the question of Web enquires and semi-structured data model. To sum up, at present both at home and abroad, there is as yet a promising potential and development space in the research of the integration of heterogeneous data. The mentioned representative research works as above, almost all didn't refer to the data inconsistency solution. And metadata can well solves the problem; therefore, here we did a research on how to achieve statistical yearbook data integration by metadata, in order to achieve better results. 2 ISOMORPHIC MANAGEMENT OF THE YEARBOOK DATA The article fully analyzes the different years, different regions of the Yearbook, and thinks about metadata management strategy. Finally it definite the yearbook with four metadata (Yearbook, Special Topic, Report, Statistics Field), they include the relationship between layers. That is a yearbook includes a number of topics, a topic includes several reports, a report includes a lot of Statistics Field. Meanwhile, it further refines the various metadata. it uses the metadata (Yearbook ID, Yearbook Name, Type, Start Date, End Date, Publisher, Date of Purchase, Note) to define Yearbook; uses the metadata (Special Topic ID, 569 Miao G. and Gou J.. YEARBOOK DATA INTEGRATION BASED ON COMMON WAREHOUSE MODEL. DOI: 10.5220/0003586205690573 In Proceedings of the 13th International Conference on Enterprise Information Systems (PMSS-2011), pages 569-573 ISBN: 978-989-8425-56-0 Copyright c 2011 SCITEPRESS (Science and Technology Publications, Lda.) Figure 1: Data Integration project index. Belonged Yearbook ID, Chinese name, English name, notes) to define Special Topic; uses the metadata(Report ID, Belonged Special Topic ID, Report Chinese name, Store name, notes) to define Report; uses the metadata (SF_ID, Belonged Report ID,SF-Name, SF-S-name, SF-Unit, SF-Level, SFRow-span, SF-Column-span, SF-Extend, notes) to define Statistics Field. Through these definitions, it can make the reports with same structure. In order to realize isomorphic management of the yearbook data from different years, different regions, transforming the tables with different levels, different structure into the two-dimensional structure and storing it in Oracle database is critical. In the integration of the yearbook, it uses the rows of spanning, the columns of spanning, the rows of extensions to solve this problem, and has achieved good effect. 3 MAPPING OF THE YEARBOOK DATA In order to complete mapping, it need to get out relevant field from mass data table, then store it in one or a few tables, as figure 2 shows. Figure 2. Data spaces 2006‐ Collaborate Integration 2004‐ Grid& Integration 2004‐