基于XML的异构数据集成模式的研究

Study of Heterogeneous Data Integration Based on XML

随着信息技术的发展,任何一个独立单位都有可能成为一个异构的数据源.为实现企业异构数据库间信息的共享和集成,对数据集成的原理以及主要技术进行了研究,重点分析了XML与数据库之间的映射、XML文档存储模式、将XML查询转化为SQL的查询转换问题以及如何将关系数据发布为XML文档,并提出了相应的解决方法.该方案简单易行,保证了各系统仍然按照原来的方式运行,只需要进行信息交换时通过转换接口把本地数据库数据转换成XML文档即可.

With the development of information technology, even a single department probably becomes a heterogeneous data source. The principle and technology of the heterogeneous database integration is researched for share and integration of the enterprise information. It analyzes the mapping between the database and XML, pattern of storing XML Documents, query transformation from XML query to SQL query and how to publish relational data as XML document, and proposes the corresponding solution. That project goes in brief and easily, promising that all systems are still operating according to the original approach, just while we have the need for exchange of information, converting the local database data into XML documents through the transformation interface.