Xml-based Heterogeneous Database Synchronization Technology Research

At present, enterprises or research institutions using different data management systems are very common phenomenon. So many enterprises establish a data center in order to integrate the heterogeneous data sources into the central database. How to ensure the consistency of the shared data and propose a solution which is effective and safe to maintain data replication between different databases is one of the important issues needed to be considered in modern enterprise application systems.XML has many features such as independence of the platform, high structure, easy to transport by the net and so on. It is a good carrier to exchange the heterogeneous data and transport information. Because of these features and advantages, XML is used as a bridge between heterogeneous databases'converting. It provides a strong support to heterogeneous databases'join, heterogeneous database conversion, and data replication. Web Services have many good features such as commonality, loosely coupled and platform-independent. With Web Services, any two applications, as long as reading and writing XML, will be able to communicate.In this paper, the research is based on XML, in order to solve the problem of the heterogeneous databases synchronization. On the question of how to solve the data between heterogeneous database conversion problems and how to solve the transmission of information between heterogeneous databases, this paper carries out a detailed analysis.At first, with the analysis of lack of existing data changing capture and synchronization strategy combine with the use of triggers, this paper gives an improvement efficient method for heterogeneous database's data capture. This data capture approach dose not only need change the original application form, but also applies to any databases which support triggers. And the changing table is designed to record changes in the data control information. This approach saves storage space. Secondly, XML is used as an intermediary to achieve the conversion of data between heterogeneous databases. This paper uses Web Services technology to solve the problem of communication. Finally, in reference to the database cluster load-balancing strategy, this paper proposes an improved scheduling algorithm based on the data replication model. This algorithm can make a better decision on the application database replication operation for the data center.This paper proposes a system framework for synchronization of heterogeneous database based on XML and a detailed analysis of the various function. At the end, this paper verifies the feasibility of the earlier work.