| 摘 要: 数据同步是分布式环境中维护各节点数据库数据一致性的一项关键技术。本文针对存在物理隔离网闸的应 用环境，提出一种基于触发器的SQL文件级异构数据库同步方法，该方法适用于企业异构数据库同步。文中将阐述隔离 网闸环境下异构数据库同步的工作原理，提出同步系统的总体框架，给出变化捕获、SQL文件生成、文件传输、数据更 新和故障处理这五个环节的实现细节。最后通过在洪水预报系统中的实际应用，验证本文方法的高效性及可靠性。 |
| 关键词: 数据同步；网闸；异构数据库；触发器；SQL |
|
中图分类号: TP302.7
文献标识码: A
|
|
| Research and Implementation of Heterogeneous Database Synchronization Based on Netgap |
|
CUI Hengxiang，FENG Jing，MA Weijun，ZHANG Qing，PANG Kun，YU Kun1,2,3,4
|
1.( 1.Institute of Meteorology and Oceanography, PLA University of Science and Technology, Nanjing 211101, China;2.
2.Air Force Meteorological Center of Nanjing Military Area Command, Nanjing 210018, China;3.
3.96151 Army, Huangshan 245000, China;4.
4.61741 Army, Beijing 100000, China)
|
| Abstract: Data synchronization is a key technology to maintain the consistency of the database in distributed environment.In view of the application environment with physical isolation gateway,this paper proposes a new method of SQL file-level heterogeneous database synchronization based on trigger,which is suitable for enterprise.Then,expounds the principle of the gap under the environment of heterogeneous database synchronization,proposes overall framework for the synchronization system,and the implementation details of the five parts of the steps are given,such as the change capture,file generation,file transfer,data update and fault handling.The efficiency and reliability of this method is verified by the practical application of the flood forecasting system. |
| Keywords: data synchronization;netgap;heterogeneous database;trigger;SQL |
