Application Of ETL Technology In Petrochemical Information Heterogeneous Data Based On XHQ

With the continuous development of information technology, data integration applications trend has increasingly penetrated into all walks of life. In recent years, with the introduction of new software products abroad, the domestic petrochemical industry, combined with advanced management concepts, and promote the development of the process of enterprise information, from the development of a single management information system (MIS) mode to the development of01(operational intelligence) mode changes in enterprise application integration platform for enterprise management, planning and management, decision analysis to provide information technology support.In order to achieve the optimal allocation of resources, the information is highly integrated enterprise business model, how to solve shared between business systems Petrochemical information system interoperability of heterogeneous data must first solve the problem. In this thesis, Hing Lan Petrochemical Company (hereinafter referred to as XLSH) information system integration platform project as the background, integrated platform for real-time operations of Siemens (hereinafter referred to as XHQ) development platform for the project to01(operational intelligence) model for unified business integration database structures. In this process, my work mainly in the data source layer, to ETL model, using the Oracle ODI tools for various business systems heterogeneous data extraction, transformation, loading work to complete the integration of heterogeneous data sharing, unified data format work, integrated database structures to provide data support for enterprise information integration platform.XLSH heterogeneous data integration system uses a layered architecture thinking of XHQ, from the system integration of heterogeneous data sources, data storage and business applications are processed separately at three levels, with the main focus on the data source layer. Through a variety of heterogeneous data sources for analysis, according to the XHQ mode, design XLSH heterogeneous systems integration framework, research and development in the XHQ heterogeneous data integration tools by ETL mode automatically complete the data extraction, transformation, cleaning, loading work in the practical application.In this paper the design of data integration tools are XHQ platform as the basis for the petrochemical enterprise business needs analysis as a precondition to complete the configuration of heterogeneous data sources, data extraction, data integration, data storage functions. In the information systems integration platform run by the integration of heterogeneous databases must satisfy XLSH stability during operations, real-time and change of the characteristics of decision support services for enterprise information system integration platform provides good data analysis support.