| 异构数据库更新同步研究与实现 |
| |
| 引用本文： | 肖刚.异构数据库更新同步研究与实现[J].教育技术导刊,2019,18(10):182-185. |
| |
| 作者姓名： | 肖刚 |
| |
| 作者单位： | 宁波广播电视大学 信息与教学资源中心，浙江 宁波 315016 |
| |
| 基金项目： | 宁波市教育科学规划项目（2017YGH039） |
| |
| 摘 要： | 数据库同步是实现不同系统之间数据共享的有效方法。现有异构数据库同步模型能有效解决记录的同步新增，但由于同步记录查询基于数据表名和关键字值，若不考虑同步数据库节点变化，将导致数据库不适用于某些遗留系统。针对该问题，提出同步控制和主从记录映射方法，在同步控制层记录主从记录映射关系。在采用双向中间件方法的同步技术基础上，设计基于标准数据格式的数据转换，降低数据转换模块开发维护成本，并根据模型应用WCF框架实现系统。实践应用表明，该模型可实现异构数库之间同步更新。
|
| 关 键 词： | 异构数据库 数据库同步 主从记录映射 标准数据格式 |
| 收稿时间： | 2018-12-26 |
Research and Implementation of Heterogeneous Database Update Synchronization |
| |
| XIAO Gang.Research and Implementation of Heterogeneous Database Update Synchronization[J].Introduction of Educational Technology,2019,18(10):182-185. |
| |
| Authors: | XIAO Gang |
| |
| Institution: | Information and Teaching Resource Center，Ningbo Radio and Television University，Ningbo 315016， China |
| |
| Abstract: | 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. |
| |
| Keywords: | heterogeneous database data synchronization master-slave record mapping standard data format |
|
| 点击此处可从《教育技术导刊》浏览原始摘要信息 |
| 点击此处可从《教育技术导刊》下载免费的PDF全文 |
