Research on Incremental Heterogeneous Database Synchronization Update Based on Web Service

This paper analyzes the problem of heterogeneous databases exist changes in data capture and data synchronization in enterprise data integration, a variety of ways to change data capture for comparison, A method combining triggers with log tables for change data capture is put forward based on the researches above, and an incremental synchronization mechanism based on web service is designed for distributed heterogeneous databases. The establishment of a central database, it takes use of the event-driven data transportation mechanism to synchronize the incremental data captured by each distributed databases and the center database. This paper then implemented a prototype system of incremental data synchronization for distributed heterogeneous database and finally tested it using an example to verify the feasibility and rationality of the design.