摘 要: 为解决当前分布式系统中多数据源、多异构数据库问题,针对现有的数据库同步方案在实际应用中所暴露 出的资源损耗大、可移植性差、应用范围窄等问题,在分析了现有的数据同步技术的各自优缺点的基础上,提出了采用 Sql plus和Merge语句相结合的数据库同步方案,并对数据同步的系统进行了设计,最后通过功能比较和性能分析,该 方案在资源损耗、可移植性、应用范围等方面更具优势。 |
关键词: 数据同步;数据转换;数据复制 |
中图分类号: TP311.132
文献标识码: A
|
|
Research and Implementation of Database Synchronization Technology |
LIU Juanjuan,LIU Shuai
|
(Institute of Disaster Prevention, Sanhe 116023, China )
|
Abstract: In order to solve the various existing problems in the distributed system,including multiple data sources,multiple heterogeneous databases,low resource efficiency exposed in the practical application of the database synchronization scheme,poor portability,and narrow application range,the paper analyzes the respective advantages and disadvantages of existing data synchronization techniques,puts forward a new database synchronization method with the combination of Sql plus and Merge statements,and designs the data synchronization system.Finally,the results of function comparison and performance analysis show that the scheme proposed in this paper is at a great advantage in several aspects,such as resource consumption,portability and application range. |
Keywords: data synchronization;data conversion;data replication |