JOURNAL OF YANGTZE RIVER SCIENTIFIC RESEARCH INSTI ›› 2011, Vol. 28 ›› Issue (6): 71-75.

• HEALTHY CHANGJIANG RIVER • Previous Articles     Next Articles

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

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

CLC Number: