The Research Of Heterogeneous Data Transformation In Data Exchange Platform

This thesis mainly studies heterogeneous data transformation in data exchange platform.Data exchange platform aims at providing a uniform and cononical data exchange framework following a data criterion for the operation systems inside and outside enterprises.And it solves the info-isolated-island problem caused by different applications, different databases, different kinds of data definition and operating environment. Data transformation technology is one of critical parts of data exchange platform solutions.The technology mainly solves the problems of the definition of data regulation and the data format transformation. And the technology is closely related to the high efficiency and steady application of the whole data exchange platform. The studies of data transformation technology has important application value.Based on the enterprise information integrated project in a mining company,this thesis lucubrates and analysis the data transformation technology of the heterogeneous data in the data exchange platform fields. The main research contents of this thesis are recapitulated as follows,1. Through literature review, this thesis studies the existing data exchange methods and strategies, and summarizes the data exchange platform architecture and technologies related to data exchange.2. This thesis researches all the cases of heterogeneous data in enterprise operation systems, and makes some examples to explain it clearly. Then it summarizes the feature of databases of operation systems in a mining company, the information about the databases and the imformation about the tables.And it mainly analysises the data types and logical relationships, then summarizes the logical relationships while data is being exchanged.3. This thesis studies the same feature of the existing data transformation models, and amends the existing data transformation models, then drafts a data criterion which is suitable to data transformation. This criterion includes a data resource criterion and a data mapping criterion.Then this thesis gives some samples.4. This thesis designs a cross-platform and cross-system exchange platform in which data is secure. And this thesis allso describes its system architecture, and implements a prototype system, then gives some operatation parts.At last, this thesis analysises the runtime result.The data transformation criterion drafted in this thesis and data transformation technology implemented in this thesis can realize the function of data integrate and data exchange between heterogeneous data in enterprises and this transformation technology has efficient, normalized, very safe, open and extensible characteristics.