• 中国计算机学会会刊
  • 中国科技核心期刊
  • 中文核心期刊

J4 ›› 2015, Vol. 37 ›› Issue (10): 1909-1916.

• 论文 • 上一篇    下一篇

分布式异构数据库集成系统研究与实现

徐爱萍,宋先明,徐武平   

  1. (武汉大学计算机学院,湖北 武汉 430072)
  • 收稿日期:2015-07-25 修回日期:2015-09-21 出版日期:2015-10-25 发布日期:2015-10-25
  • 基金资助:

    国家水体污染控制与治理科技重大专项(2013ZX0750300106);湖北省重大科技创新计划资助项目(2013AAA020)

Research and implementation of a distributed
heterogeneous database integration system   

XU Aiping,SONG Xianming,XU Wuping   

  1. (School of Computer,Wuhan University,Wuhan 430072,China)
  • Received:2015-07-25 Revised:2015-09-21 Online:2015-10-25 Published:2015-10-25

摘要:

由于历史原因和数据库技术的不断发展,很多部门已经积累并且还会大量积累各种异构数据,其异构性主要表现在数据库类型和数据结构的不同。针对这一问题进行研究,以三峡库区水环境及水文分布式异构数据库为例,在分析水环境和水文数据需求的基础上,构建了水文及水环境数据交换架构和数据共享平台;采用异构多源数据库引擎中间件解决了不同种类数据库之间的数据交换问题;针对大量历史数据的交换问题提供了分批导入数据交换方式;使用数据目录注册的方式使得集成平台的管理和使用便捷通用。本研究的异构多源数据库引擎不仅可以方便地连接目前主流的各种数据库,还基于Web Services技术解决了连接Web数据接口的问题。研究成果可满足不同应用环境的异构数据集成需求。关键词:

关键词: 异构数据, 数据共享, GDBE, 数据集成, 中间件, 集成系统

Abstract:

Because of historical reasons and the development of database technology, many enterprises and institutions have accumulated and will accumulate a large variety of heterogeneous data. The heterogeneity is mainly manifested in database types and data structures. Aiming at this problem, we take the hydrological distributed heterogeneous database of the Three Gorges Reservoir water environment for example, and build the hydrologic and water environment data exchange architecture and data sharing platform based on the analysis of water environment and hydrological data requirements.The problem of data exchange between different databases has solved through heterogeneous multisource database engine middleware. As for the historical data exchange problem which is in a large number, we present a partially imported data exchange mode. The use of the data catalogue registration technique makes the management and use of the integration platform more convenient and general. The heterogeneous multi-source database engine can not only facilitate the connection of various current mainstream databases, but also solve the problem of connecting web data interfaces using web services techniques. Experimental results show that the proposal can meet the demand of heterogeneous data integration in different application environments.

Key words: heterogeneous data;data sharing;GDBE;data integration;middleware;integration system