Research Of Distributed Integration System Of Heterogeneous Data Sources

The integration of heterogeneous data Sources (IHDS), a classical problem in the database domain, is the foundation of information integration and conformity. In recent years along with the rapid development of network, IHDS becomes a hotspot in research again.This paper makes a general systematic research on the design and realization method about the integrated information system of heterogeneous database. A model of heterogeneous database integration system is pronounced which is based on three-layer architecture. The system supports the global transaction management and parallel query processing of SQL database and supports the expanding of system applications and the increasing of the number of the integrated databases.Firstly, according to the current situation studied about IHDS, and aiming at the enterprise application's characters and requirements, I bring forward a concept of Distributed Integrationof Heterogeneous Data Source (DIHDS).Secondly, adopt the Global Pattern and the middleware technology to design DIHDS, and has proposed the global query language naming GSQL to provide a unified interface of system.Thirdly, in consideration of the efficiency and frequency, visiting instruction is divided into two kinds: instruction towards single data source and instruction towards multiple data source, this paper has designed and realized them separately. For the sake of enterprise applications better accessing many associated tables, fully utilize the function of view in data integeration.Finally, constructs the key technology and principle involved to enterprises differently in the integrated system of data source to carry on research, technological solution that the proposition system realizes.Lastly, I have researched a lot of pivotal technologies involved in DIHDR realization, and put forward my own scheme in an angle of technology.