数据同步中差异数据捕获的设计与实现

综合触发器和影子表法进行数据库变化的捕捉跟踪过程是由使用触发器来定位变化的记录、使用影子表跟踪相应记录的变化、在关系映射索引下进行差异记录的异构运算等步骤实现。综合法在传输数据变化时完成异构数据结构的转化，实现异构数据的应用级同步，为日益增多的数据库应用同步提供一个的解决实现。

The design and implementation synchronization problems for heteromerous database

As the basis of database synchronization,capture data change also has a great impact in other respects.Although there are a variety of ways to capture the data changes in a database,none of them can support heterogeneous data transformation very well.In addition,all of them are inadequate in terms of robustness,and have difficulties in meeting the requirements of complex logic in data synchronization.This article introduces a method—integrated use of triggers and shadow tables—to archive the data change capture simply.A trigger is used to locate the changed records,and a shadow table used to track the corresponding changes in synchronization.Heterogeneous computing between source and target is guided by the records generated by the trigger when capturing the data mutations,whilst completing the data synchronization and transformation of heterogeneous data.This solution allows archive synchronization of heterogeneous data on an application-level,and offers an option for meeting the requirements of database synchronization.