The Research And Application Of The Data Integration Model In The BI System

Enterprise informatization construction has become the key project of corporate cons-truction; the perfection of business intelligence is the most important embodiment of Enterprise informatization. With the maturing of the business intelligence technology, data integration has a wider range of application; more and more enterprises begin to use busin-ess intelligence to the daily management of enterprises. Data integration technology cont-inues to mature in the future. It will get more attention in the filed of business intelligence research and application.This article describes the prospects of the BI application and the development of data integration as well as the key technology. After analysing the basic theory of the data integration and the existing data integration technology in detail, it points out the inperfections of existing tools, reviews the different needs of various industries of the BI system. This paper presents a BI system model of heterogeneous data integration solutions, the solution can realize the custom operation of the users in a certain range. This integrated model can be more flexible and convinent to extract data according to user demands from heterogeneous data sources for analysis and can be a more efficient, stable BI system data support.In this paper, it researches several methods of heterogeneous data integration, analysis the mapping of data between heterogeneous data types and heterogeneous data integratio-n rules. It uses the inside data of the car sales business as the background, proposes the establishment of a custom integration of heterogeneous data model. The integration model of heterogeneous data is divided into integration mode and integration style to do logic design. Function modules, such as database connector module, data integration module, timing updating module and setting module, are established to accomplish the heterogen-eous data integration tasks. The application of the model can converse and integrate the data of a variety of database used at present according to the business needs of the BI syst-em. The integrated data model can integrate the data of the heterogeneous data source according to the users’demands in the premise of ensuring the data accuracy. The user can set integrated conditions; integrated rules and data update cycle according to the needs to realize data integration of heterogeneous data.