The Design And Implementation Of Data Synchronization Middleware For Distributed Heterogeneous Database

With the wide use of databases and rapid development of network and distributed technology, distributed database applications are more and more widely used; the most important is how to make sure the data consistency in each node of the database, and it become an urgent need for database development. But the characteristic of application and the employ circumstance make the choice diversity of database products. So it is necessary to design an infrastructural and generic platform to synchronize data in heterogeneous database systems.To maintain consistency of the data of heterogeneous databases is not a simple data replication, while we need to consider how to properly store and maintain its heterogeneous data accuracy and integrity. This paper designed and implement an application independent middleware system for heterogeneous database synchronization. The main contributions of this paper were summarized as follows.(1) A logical Message Queue model was designed,which made the message communications security and timely and also adapted different network environment.(2)A logical message structure and transport mode were designed, which made the whole synchronization process use managing with transaction.(3) The project of synchronization between distributed heterogeneous databases was designed.(4) A logical interface API was encapsulated, and made the system middleware.(5) A practicable synchronization middleware was designed and implement, the synchronization middleware was tested and validated.According to the contributions above, I designed and implement a practicable middleware product of data synchronization for distributed heterogeneous database. And the product of feasibility was validated in test.