Research On Multi-Source ETL Model Based On The Information Resource Directory

The enterprises' informatization become more and more important along with the implementation of strategic action plan about national“Internet+”,the application of “Two Depth Fusion” and Big Data applied in vary of enterprises.Relatively inflexible and isolated architecture of information resource system can not meet the business of enterprise development in sharing information resource demand.The fundamental reason lies in the informatization construction of enterprises,individual enterprises have established a separate information management system with different functions,and various departments within a enterprise often developed many independent information systems.Because of the data comes from different databases and the data format is inconsistent,the system can not achieve exchanging and sharing of information resources.So the information island comes out.At present,the most effective way to break the information island is to build an information resource sharing platform.The focus on this paper is to discuss how to exchange information between heterogeneous platforms and heterogeneous systems to realize the sharing of multi-source heterogeneous information resource during the process of building enterprise information resource sharing model.To solve this problem,the international organization for Standardization has developed a series standards of MFI(Metamodel Framework for Interoperability).To describe meta information,the standard gives a specific standardized “metadata model”of the registration of the information model and mapping information registration.The integration of heterogeneous data resource has been fundamentally resolved.The ETL technology mainly includes three parts: data extraction,transformation and loading.In the process of data integration,it is often used to deal with complex data source and heterogeneous data.The characteristics of ETL model of enterprise information resource directory are based on international standard with a high degree of data integration and a good deal of heterogeneous data,which shields some defects in traditional database technology.It not only has the advantages of traditional database,but also makes the data more integrated and stable.So it is feasible to use ETL to solve the problem of enterprise information resource sharing.In global enterprise's point of view,an information resource integration architecture is designed,which is merged into ETL,MFI-12 of information model registration standards,MFI-10 of mapping model registration standards,MFI-7 of service registration standards,and provided users with a query interface.It enables users to obtain the data in the underlying source model by shielding the underlying data source and only querying the instruction in the global shared model.This paper is based on integrated integration,exchange and share as the way,international standard as the support and information resource directory as the core of the multi-source ETL sharing model.And through the information resource directory ETL system can be verified.