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

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

Research and implementation of a distributed heterogeneous database integration system

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.