The Research And Application Of Heterogeneous Database Integration Based On Xml

With the rapid growth of information, more and more applications have to access to heterogeneous data sources. Due to the geographical distribution of these different data sources with different platforms, different operating systems, different database models, different semantic representation, and different database management systems (DBMS),it is always difficult to access these data.So, it is urgent to use existing information technology to dynamically integrate these heterogeneous data resources and make information sharing efficient.This article firstly introduces the heterogeneous database’s origin, concept and conducts the research of data conflict between isomerism data, explores the solution of the data conflict, provides the important guarantee for the data exchange. Through the use of intermediate data, we get the achievement of data exchange between heterogeneous data sources. In the data exchange model, XML is used as middle data to express the data structure information and the value information. Through analyzing the data information documents to obtain the data exchange translation rule documents and carrying on the formal description technique to the matching rule, the data exchange module enables to be independent from the concrete data conversion computation and carry on the data exchange flexibly through explaining different matching rule between the XML patterns. The mapping documents can be obtained through analyzing the source structure documents, the object construction documents and the user-defined translation rule documents. Finally according to the mapping documents and the source value information documents, the data exchange can be realized from the source data to the digital target information. In the end, this article applies the framework to the data exchange of e-government systems in heterogeneous systems. Via data exchange, different departments’information system can work more closely, achieve the information sharing, data exchange, and improve the work efficiency of the government.In this paper, making use of the features of XML Platform’s independency, we design the System Integration and Data Exchange. We also focus the mapping rules between the database and XML,through XML,the transmission media, accomplish the integration and sharing of the heterogeneous database. And such a system would have a stronger versatility.