【作者】 刘永伟；

【导师】 叶德谦；

【作者基本信息】 燕山大学 ， 计算机应用技术， 2006， 硕士

【摘要】 传统的数据大多数都是存储在关系数据库中,随着XML成为网络上信息交换、共享的标准,许多厂商都推出了支持XML的产品,但由于目前组织内部的信息系统如ERP系统大多还是建立在具有高稳定性、高成熟度特性的关系型数据库系统中,这两种不同型态的数据共享成为一个很重要的课题。本文在对国内外研究现状进行综合分析的基础上对SQL查询语言和XQuery查询语言进行研究,提出了一个基于Web服务的从SQL到XQuery转换系统模型,使既有的建立在关系型数据库基础上的信息系统可与XML资料进行数据交换。首先给出了Web服务的体系结构,并分析了SQL和XQuery两种查询语言的特点,主要从完整性约束等六个方面进行了分析,转换系统模型所需要的映射字典的也主要基于这些差异性。其次给出映射字典的格式及映射字典的建立过程。然后给出转换模块的实现算法及算法分析。为辅助转换过程,设计了六个集合,通过一系列的转换法则对这些集合进行操作,从而达到查询语句转换的目的。当基于关系数据库的信息系统对转换系统下达SQL查询句要求时,转换模块根据事先储存在映射字典的对应资料来执行转换机制,将SQL查询语句转换成一个相同语意的XQuery查询语句。最后给出查询转换系统的模型。本系统在德国房地产分析系统及基于RosettaNet的供应链中进行了应用,并对转换系统的转换效率进行了分析。更多还原

【Abstract】 The data is stored in RDB traditionally, along with XML becoming the standard of theexchange of information and the sharing of data in the network, many merchants promote theproducts which support XML, because the current information system exists in theorganization such as ERP system mostly established on relational database managementsystem which has high stability and high maturity, the sharing of the two kind of data becomesan important topic. On the research of SQL and XQuery based on domestic and foreignpresent situations, a Sql-To-XQuery system model based on web service is presented, whichcan exchange the data between the information system based on relational database and theXML data.Firstly, the architecture of web service is presented, and two kind of query languagesSQL and the XQuery are analyzed, the analysis is carried on from six aspects such as thecomplete restraint, the mapping dictionary which needed by the conversion system model isbased on these differences mainly.Secondly, format and the establishment process of the mapping dictionary are presented.Thirdly, the algorithm and the algorithmic analysis of the conversion model are presented.For the assistance of conversion process, several sets are designed, then a series of conversionprinciples are carried on to these sets, thus the goal of converting query sentence isachieved.When the SQL query sentence request is sent from the system based on the relationaldatabase information system to the conversion model, the conversion model will be able tocarries out the conversion mechanism stored in the mapping dictionary beforehand, andconvert the SQL sentence to the XQuery sentence in the same meaning.Finally, the conversion model is presented. This conversion system is applied to Germanreal estate analysis system and supply chain based on RosettaNet, and the efficiency of theconversion system is analyzed.更多还原