异构数据库更新同步研究与实现  

Research and Implementation of Heterogeneous Database Update Synchronization

作　　者：肖刚[1] XIAO Gang(Information and Teaching Resource Center,Ningbo Radio and Television University,Ningbo 315016,China)

机构地区：[1]宁波广播电视大学信息与教学资源中心

出　　处：《软件导刊》2019年第10期182-185,共4页Software Guide

基　　金：宁波市教育科学规划项目(2017YGH039)

摘　　要：数据库同步是实现不同系统之间数据共享的有效方法。现有异构数据库同步模型能有效解决记录的同步新增,但由于同步记录查询基于数据表名和关键字值,若不考虑同步数据库节点变化,将导致数据库不适用于某些遗留系统。针对该问题,提出同步控制和主从记录映射方法,在同步控制层记录主从记录映射关系。在采用双向中间件方法的同步技术基础上,设计基于标准数据格式的数据转换,降低数据转换模块开发维护成本,并根据模型应用WCF框架实现系统。实践应用表明,该模型可实现异构数库之间同步更新。In order to achieve data sharing among different systems,database synchronization is an effective method.Database synchronization is an effective method for data sharing.Existing synchronization model of heterogeneous database can effectively solve the synchronous added records,but for synchronous update,the synchronization record search is based on the data table name and keyword value,and does not consider the change of the synchronization node,therefore they are not applicable for some legacy systems.To solve the above problem,synchronous control and master-slave record mapping are proposed.In the synchronous control layer,the mapping relationship between the master and slave records is recorded.At the same time,based on the synchronization technology of two-way middleware,the data conversion based on standard data format is designed to reduce the development and maintenance cost of data conversion module.Based on the model,the WCF framework is applied to implement the system,and the practice shows that the model can effectively solve the update synchronization between heterogeneous databases.

关 键 词：异构数据库 数据库同步 主从记录映射 标准数据格式 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]