异构环境下数据库增量同步更新机制

摘要

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 transportation 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.%分析企业数据集成中存在异构数据库的变化数据捕获与数据同步问题,对多种变更数据捕获方式进行比较,提出了一种将触发器和日志表相结合的变更数据捕获方法.设计了一种基于Web服务的分布式异构数据库增量同步更新机制,建立了中心数据库,通过事件驱动传输体系,将分布式数据库和中心数据库各自将捕获的增量数据进行同步,实现了分布式异构数据库增量同步更新系统原型.最后用实例对系统进行了测试,结果表明了该设计的可行性和合理性.