一种基于触发器的数据同步系统的研究及关键技术实现

RESEARCH ON A TRIGGER-BASED DATA SYNCHRONISATION SYSTEM AND THE IMPLEMENTATION OF KEY TECHNIQUES

针对分布式数据库系统内以及不同业务系统间数据同步和共享的需求,提出一种数据同步系统的实现方法。首先分析各数据同步模式及同步过程,其次给出该同步系统的框架和实现流程,最后着重讨论基于触发器的变化捕获器的实现。系统采取只记录主键来获取变化的方式,兼顾到应用程序对数据表的操作,尽可能减少同步过程对应用程序执行效率的影响。

Aiming at the demands of data synchronisation and sharing inside the distributed database and among different business sys- tems, a method of implementing data synchronisation system is proposed in this paper. Firstly, various kinds of data synchronisation mode and their processes are analysed; secondly, the data synchronisation frame and the implementation flow are presented; finally, the implementation of trigger-based data change acquirer is emphatically discussed. The data synchronisation system adopts such a the way in which the data change is captured only by recording the primary key and considers the operation of table by the application program as well. Thus, the influence on application program execution efficiency by synchronisation process is limited as much as possible.