异构数据库同步技术的研究与实现

Research and Implementation of Synchronization Technology of Heterogeneous Database

随着信息化应用的不断深入,企业内部不同应用系统、企业与外部信息系统数据同步的需求日益强烈。由于各信息系统使用的数据库管理软件各不相同,导致数据之间无法实现同步与共享,因此,需要设计一种异构数据库之间同步的方法,解决不同信息系统数据间的同步问题。本论文在现有成熟数据库产品的基础上,分析了数据同步过程中的关键问题,如数据类型差异、数据捕获策略、同步振荡等。针对这些问题,设计采用建立映射模式的方法、触发器与控制表相结合的方法以及在同步任务中对控制表进行干预的方法予以解决。最后,在QT(跨平台软件开发框架)下,设计实现异构数据库同步系统,实验验证表明,本系统达到了较好的数据同步效果。

With the development of information applications,there is a growing demand for data synchronization between different application systems within enterprises,between enterprises,and amongst external information systems.However,due to different database management soft ware used by different information systems,data synchronization and sharing cannot be achieved.Therefore,it is necessary to design a method of synchronization between heterogeneous databases to realize data synchronization of different information systems.Based on existing mature database products,this paper analyzes key issues in the process of data synchronization,such as data type difference,data capture strategy,synchronous oscillation and so on.In order to solve these problems,methods of establishing mapping pattern,combining trigger with control table,and intervening control table in synchronization task are designed.At last,under the framework of QT(the cross-platform software development framework),a heterogeneous database synchronization system is designed and implemented.Experimental results show that the system achieves better data synchronization effect.