Incremental database synchronization update mechanism under heterogeneous environment
He Pan · Jisuanji gongcheng yu sheji · 2011
The problem of heterogeneous databases exist changes in data capture and data synchronization in enterprise data integration is analyzed and a variety of ways to change data capture are compared comparison.A method combining triggers with log tables for change data capture is put forward based on the researches above,and a 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 trans-portation mechanism to synchronize the incremental data captured by each distributed databases and the central database.A prototype system of incremental data synchronization is implemented for distributed heterogeneous database and finally tested it using an example to verify the feasibility and rationality of the design.