Design And Achieve Of Heterogeneous Data Exchange System

With the rapid development of Internet and database technology currently, enterprise require database cyberization and large-scale development. Group of companies inevitably have multiple large heterogeneous databases, along with the huge demand for enterprise to share interactive information and decision analysis more importantly, for data exchange between multiple heterogeneous database technology in large enterprise database management becomes critical and difficult. So now heterogeneous data exchange technology has become a major research trend in database technology, more and more heterogeneous data exchange system catches large and medium-sized firms.Based on the current situation in-depth understanding of the needs of enterprise database systems currently investigated for heterogeneous data exchange, as for the Daqing oil Company Information Center to urge exploration and development of databases and A1, A2 heterogeneous database data exchange problem practical application, this thesis does expand this research work on the Daqing heterogeneous data exchange system. This thesis introduces the research status of heterogeneous data exchange system, and then discusses the basic concepts of ETL processes and data exchange XML databases, and related knowledge, and analyzes the development of key technology tools. Through analysis to determine the basic idea as the ETL data exchange theory and describe XML technology as the development of tools to build a data carrier established technical route. Combined Daqing Oilfield database with demand analysis, it expands the system design, and ultimately a more reliable enterprise heterogeneous data exchange system formed.In this system design and development process, my work mainly involved is: research status of a switching technology heterogeneous data analysis; 2) key technical analysis techniques heterogeneous data exchange; 3) Daqing Oil Field heterogeneous data exchange system requirements analysis; 4) Daqing Oilfield heterogeneous data exchange system detailed design work; 5) implementation of Daqing Oilfield heterogeneous data exchange system; 6) system features detailed testing and analysis of results.Through the analysis and design of this thesis, to achieve a viable apply to SMEs heterogeneous data exchange system solutions. By testing the system, certifying that the system can effectively handle data exchange Daqing Oilfield each system database. Therefore, the basic completion of this research study and implementation of heterogeneous data exchange system for SMEs to establish their own heterogeneous data exchange system will certainly help.