SYSTEM AND METHOD TO IMPROVE DATA SYNCHRONIZATION AND INTEGRATION OF HETEROGENEOUS DATABASES DISTRIBUTED ACROSS ENTERPRISE AND CLOUD USING BI-DIRECTIONAL TRANSACTIONAL BUS OF ASYNCHRONOUS CHANGE DATA SYSTEM

摘要

Disclosed are a method and/or a system to improve data synchronization and integration of heterogeneous databases distributed across enterprise and/or cloud using bi-directional transactional bus of asynchronous change data system. In one embodiment, a method of snapshot materialization and application consistency includes running a change capture system to capture all changes by collecting a change capture data, running an initial bulk load of all data in a source system, and applying all change transactions to a particular transaction id. The method includes removing a reappearance of a record using keys that handle de-duplication of entries and deeming a snapshot of a target system. The change capture data concerns in the source system in an order of its occurrence. A logical clock value determines the order in which the changes have occurred. The changes are a transactional and/or a non-transactional. The transaction boundaries are preserved as part of the change capture data.