【作者】 杜军威；

【导师】 隋树林；

【作者基本信息】 青岛科技大学 ， 控制理论与控制工程， 2005， 硕士

【摘要】 由于企业信息化建设的不断深入、软硬件资源的升级和各种应用的扩展,造成了多种异构数据库并存的问题。其异构性表现为多方面:数据模式不同、同一种数据模式下的不同产品和同一种产品的多个不同版本。为了节约成本充分利用原有资源,企业内和企业间经常需要在异构数据库之间交换信息。而这些异构数据库的物理分布是跨部门、跨地区的。所以如何实现异构数据库之间信息的转换和如何实现转换结果的跨地区的传输成为本课题的关键部分。而构建该系统的平台主要是面向Web应用,其数据库多为关系模型,所以本文主要讨论面向Web的异构关系型数据库的转换。 在选择转换技术时,由于XML已经成为Internet企业应用的标准数据交换格式。所以本文研究以XML为公共模型,通过关系数据库与XML的可逆双向转换,建立异构关系数据源的统一转换工具。转换过程保留关系数据库的完整性约束。在选择传输技术时,由于SOAP是基于XML的传输协议,可以方便的解析和传输XML文档,所以在网络传输选择SOAP技术。本文的工作主要体现在三大部分: 第一,讨论了关系数据库模式和XML的结构描述(XML Schema)之间的双向映射机制,提出保留数据库的各种语义的映射算法。 第二,讨论了关系型数据库数据和XML文档之间的转换算法,并基于DOM技术和JDSC接口分别完成对XML文档和数据库的存取。 第三,讨论了SOAP协议的通信实现,完成基于请求式的客户端和服务器端的设计。实现数据库结构和数据的转换结果跨网络传输。更多还原

【Abstract】 With the enterprise informationization developing, the resource of software and hardware upgrading and the variety of application expanding, the heterogeneous problems of database systems emerge more and more seriously. And the heterogeneous shows as follows: different data models, different products in the same model and different versions in the same product In order to save cost and apply the existing information resource more effectively, heterogeneous database often has to be translated and moved among internal and external enterprises. On the other hand, these heterogeneous databases are located at different place and connected at different networks. Therefore, how to construct the exchanging platform of heterogeneous databases and how to communicate the result of transforming data among different place are the key technology. Moreover, the platform is for Web application and the relational databases are dominant in business, this paper mainly discusses data exchanging among heterogeneous relational databases based on Web.XML has emerged as the dominant standard data exchange formats for Internet-based business applications, so it is first technology selected. This paper takes XML as a public model and studies the conversion technology among heterogeneous relational database systems by means of reversible conversion between relational and XML, and this process keep on entity integrity constraints of source database. Moreover, the SOAP technology is based on XML, and it parses and transplant XML document easily. So we emphasize the communication mechanisms based on SOAP and explain how to use SOAP to implement the communication for cross platform.. This thesis makes three main contributions.更多还原