The Application Of Data Integration Technology In One Coal Enterprise

With the rapid development of science and information technology, and deepening of reform of coal industry system, coal corporate information management will become important foundation for its sustainable development. At present data of business management system of many coal corporate separates from and closed to each other, which leads to rapid expansion of data, and they cannot flow, share and mix between different systems inside the corporate. All above deepen the fragmentation of data, and therefore form the "data islet". In order to solve this problem and improve the production efficiency and economic benefit of corporate to adapt the demand of future development, the corporate's needs for application integration, business integration and even data integration become pressing.The object of this research project is a large diversified and comprehensive developing coal mining enterprise. Since 1980s, this enterprise carried out information construction in different business management continuously. With the development of enterprise management demands and improvement of information application, the present achievements of information construction could not meet the demand of enterprise's future management level. We need to construct a data integration platform set finance management system, HR management system, facilities management system, production design system, supply system and transportation and marketing system and so on in one, which makes the data in each system can integrate seamlessly with history information, improve the sharing and exchanging of heterogeneous data of coal enterprises, and improve the data processing efficiency in management.Data integration technologies means to collect data from different sources, of different forms, and different characteristics together logically or physically so as to provide all-round share of data for the enterprises. This research mainly adopts data warehouse technology to carry out enterprises data integration while data integration adopting ETL method. ETL(the process of data's extract, transformation and loading) method is one that can realize heterogeneous data's Centralized storage and management. It means to extract data from various data source and then after transformation, cleaning and loading, meanwhile you can organize and revise the data, to make the data meets the demand of data warehouse, and finally, these data is transmitted from a system to a unified, complete data warehouse, to realize the aim of data integration.