长江科学院院报 ›› 2011, Vol. 28 ›› Issue (6): 71-75.

• 信息技术应用 • 上一篇    下一篇

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

胡金龙1 ,许 卫2 ,房福龙1 ,李 刚1 ,曹晓宁1   

  1. 1. 江苏省水文水资源勘测局,南京 210029 ; 2. 长江科学院 武汉长澳大地工程有限公司,武汉 430010
  • 出版日期:2011-06-01 发布日期:2012-11-08

Synchronous Replication Technology of Heterogeneous Database and Its Application

HU Jin-long1 , XU Wei2 , FANG Fu-long1 , LI Gang1 ,CAO Xiao-ning1   

  1. 1.Jiangsu Provincial Hydrology & Water Resource Survey Bureau, Nanjing 210029,China ;2.Geo-engineering  Yangtze Australia Co.Ltd, Yangtze River Scientific Research Institute , Wuhan 430010,China
  • Online:2011-06-01 Published:2012-11-08

摘要: 信息资源共享是单位或部门信息化建设的主要目标,但由于信息化项目建设常常缺乏统筹规划,致使不同类型、不同结构的数据库管理系统广泛介入,于是,不同程度地导致数据库管理系统库表结构、技术体制和软件应用等方面难以统一,直接影响了公共数据信息资源有效、广泛共享。以江苏省水文自动化测报系统集成为案例,通过对异构数据库进行相关分析后,利用成熟的分布式数据库技术,引入数据库复制,采用集中和自治相结合的控制机制,探讨基于异构数据库之间数据同步复制技术与实现方法 , 从而解决异构数据库之间信息共享问题,为异构数据库之间实现数据共享和数据同步提供一种有效的方案,使系统内所有数据库数据保持一致和同步,或者根据需要保持部分数据一致和同步。所推荐的分布式异构数据库数据复制技术简单、易懂,具有完全异构性、 DBMS 无关性,以及较强的通用性和可靠性等特点。

关键词: 异构 ,  , 分布式 ,  ,  , 数据库 ,  ,  , 同步复制

Abstract: It is the basic requirement of daily business management and the main purpose of informatization construction to share information resources. Nonetheless, the lack of overall planning and technical standard stipulation during the informatization construction lead to the involvement of various database management systems of different types and structures, which makes it hard to unify the table structure, technical system and software application of the database management system, directly affecting the effective and extensive sharing of common information resources. Taking the automatic hydrological telemetry and precaution system integration in Jiangsu Province as an example, this paper analyzed the Heterogeneous Database(HDB) and then studied the synchronous replication technology and the application methods among the HDBs. The study was made by database replication of mature distributed database techniques in coalition with concentrated and autonomous control mechanism. The study was meant to solve the information sharing problems of the HDBs so that the distributed database system can be more reliable and timely, and be used universally. It is also aimed at providing an effective plan for data sharing and synchronization, as well as a mature, effective technique easy to use for the integration of systems among HDBs so that all data are synchronized and unified partly or completely. The data replication technology of distributed HDBs recommended in this paper is easy to operate and simple in terms of defining parameters and configurating the systems, and is also completely heterogeneous, DBMS independent, reliable, and can be used more widely.

Key words: heterogeneous  ,   distributed  ,   database ,    replication

中图分类号: