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

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

作　　者：刘树[1] 徐硕[1] 黄其泉[1] 孙璐[1] 丁然[1] 王立华[1] 

机构地区：[1]中国水产科学研究院渔业工程研究所,北京100141

出　　处：《计算机应用与软件》2012年第12期189-191,200,共4页Computer Applications and Software

基　　金：中国水产科学研究院院部中央级公益性科研院所基本科研业务费专项资金项目(2010C021)

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

关 键 词：数据同步 触发器 分布式数据库 

分 类 号：TP301[自动化与计算机技术—计算机系统结构]