异构数据库数据集成的研究与实现

由于企业间数据的交互和共享越来越广泛,迫切需要对异构数据库数据进行集成。根据异构数据集成的需要,提出了利用XML技术集成异构数据库数据源的一个框架。框架核心部分由3层结构组成,综合管理层负责数据抽取和数据交互,XML数据库层负责数据预处理和查询,装配管理层根据需要过滤和组装数据,最终得到需要的数据。用Java编程实现了一个原型系统,对Oracle和SQL server实际数据源做了数据集成测试。实验结果证明该架构是一个较优的解决方案。

Research and Implementation on Data Integration of Heterogeneous Database

For the more and more extensive alternation and share among the enterprise data,there is exigent need of integrating data from heterogeneous database.Since the need,in the paper,a frame integrating data from heterogeneous database based on XML is designed.The core part is made up of three layers.The Integration Manager layer is mainly responsible for data extracting,the XML Database layer with preceding disposal and querying,and the Assembly Manager layer mainly filtrates and assembles data with the need,then get the data at last.We implemented a simple system with Java and tested it with Oracle and SQL server data.The experiment result proves that it is a good method.