基于Web服务的SQL到XQuery查询转换系统的研究
摘要
传统的数据大多数都是存储在关系数据库中,随着XML成为网络上信息交换、共享的标准,许多厂商都推出了支持XML的产品,但由于目前组织内部的信息系统如ERP系统大多还是建立在具有高稳定性、高成熟度特性的关系型数据库系统中,这两种不同型态的数据共享成为一个很重要的课题。本文在对国内外研究现状进行综合分析的基础上对SQL查询语言和XQuery查询语言进行研究,提出了一个基于Web服务的从SQL到XQuery转换系统模型,使既有的建立在关系型数据库基础上的信息系统可与XML资料进行数据交换。
首先给出了Web服务的体系结构,并分析了SQL和XQuery两种查询语言的特点,主要从完整性约束等六个方面进行了分析,转换系统模型所需要的映射字典的也主要基于这些差异性。
其次给出映射字典的格式及映射字典的建立过程。
然后给出转换模块的实现算法及算法分析。为辅助转换过程,设计了六个集合,通过一系列的转换法则对这些集合进行操作,从而达到查询语句转换的目的。当基于关系数据库的信息系统对转换系统下达SQL查询句要求时,转换模块根据事先储存在映射字典的对应资料来执行转换机制,将SQL查询语句转换成一个相同语意的XQuery查询语句。
最后给出查询转换系统的模型。本系统在德国房地产分析系统及基于RosettaNet的供应链中进行了应用,并对转换系统的转换效率进行了分析。
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.
首先给出了Web服务的体系结构,并分析了SQL和XQuery两种查询语言的特点,主要从完整性约束等六个方面进行了分析,转换系统模型所需要的映射字典的也主要基于这些差异性。
其次给出映射字典的格式及映射字典的建立过程。
然后给出转换模块的实现算法及算法分析。为辅助转换过程,设计了六个集合,通过一系列的转换法则对这些集合进行操作,从而达到查询语句转换的目的。当基于关系数据库的信息系统对转换系统下达SQL查询句要求时,转换模块根据事先储存在映射字典的对应资料来执行转换机制,将SQL查询语句转换成一个相同语意的XQuery查询语句。
最后给出查询转换系统的模型。本系统在德国房地产分析系统及基于RosettaNet的供应链中进行了应用,并对转换系统的转换效率进行了分析。
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.
引文
1. W3C.Extensible Markup Language(XML)1.0. http://www.w3.org/TR/1991/REC-XML,1998
2. H.S. Thompsom. W3C XML Pointer, XML Base and XML Linking. http://www.w3. org/XML/Linking, 2002
3. M. Froumentin. The Extensible Stylesheet Language(XSL). http://www.w3.org/Style/ XSL, 2002
4. P.L. Hégaret. Document Object Model(DOM). http://www.w3.org/DOM, 2002
5. T. Bray, D. Hollander, A. Layman. Namespaces in XML. http://www.w3.org/TR/Rec-xml-names, 1999
6. D.C.Fallside. XML Schema Part0,1,2. http://www.w3.org/TR/2001/REC-xmlschema-20010502, 2001
7. M. Marchiori. XML Query. http://www.w3.org/XML/Query, 2002
8. Liam Quin. Extensible Markup Language (XML). http://www.w3/XML, 2002
9. J. Bosak, T. Bray, D. Connolly, etc. W3C XML Specification DTD. http://www.w3/ XML/1998/06/xmlreport.htm,June, 1998
10. M.Carey, D.Florescu, Z.Ives,Y.Lu,J.Shanmugasundaram.XPERANTO:Publishing Object-relational Data as XML.In Proceedings of WebDB,Dallas,TX,2000,(5): 105-110
11. 王自强,冯博琴.基于 XML 的 EDI 的研究与实现.计算机工程与应用,2003,(13): 187-189
12. Ronald J Vetter Charles Ward.Mosaic and the World-Wide Web[J].Computer,1994, 27(10):49-56
13. 柴晓路,梁宇奇.Web Services 技术、架构和应用.北京:电子工业出版社,2003:20-25
14. 沈伯青,杨宗凯.WEB 服务的基石:UDDI 技术.计算机工程与应用,2003,(3):147-150
15. Web Service Description Language(WSDL)1.1. http://www.w3.org/TR,2003
16. 周必水,倪慧丽.简单对象访问协议 SOAP 的研究与分析.微电子学与计算机,2002, (5):25-27
17. Hao Ying. SOAP protocol and its application[J]. Computer Engineering, 2002,27(6): 128-130
18. Zhang Wenbing, Chen Enhong. System inter-operation based on SOAP[J]. Computer Application, 2002,22(5):55-56
19. Florescu, D. Kossmann.Storing and Querying XML Data using an RDBMS. IEEE Data Engineering Bulletin, 1999,22(3):85-89
20. T. Kudrass. Management of XML Documents without Schema in Relational Databases. XML and Databases, 2001,(10):148-153
21. Jayavel Shanmugasundaram, H. Gang, Kristin Tufte. Relational databases for querying XML documents: Limitations and opportunities. Proceedings of 25th International Conference on Very Large Data Bases, 1999,Scotland:302-304
22. Y. Chen, S. Davidson, Y. Zheng, Constraints preserving schema mapping from XML to relations. WebDB, 2002,(3):62-65
23. 苟先太,金炜东.分布式计算在下一代网络中的应用研究.计算机应用,2003,23(8): 67-69
24. Jeffery B. Enterprise client/server computing[J]. Info Sys manag, 1996,12(4):38-43
25. 刘卫东,徐恪,刘亚霄.松散耦合的分布式信息系统.清华大学学报(自然科学版),2002,42(1):40-43
26. 王占杰,安之廷,李金波.web 服务协议栈安全研究.计算机应用研究,2003,(6):4-6
27. 李浩,沈琦.XML Schema 中的面向对象思想.计算机系统应用,2004,(2):36-39
28. 陈晓峰,王世安.SOAP 消息系统的研究与实现.沈阳工业大学学报,2003,25(2):155-157
29. Vinoski S.Web services interaction models-part 1:current practice[J].IEEE Internet Computing,2002,6(3):89-91
30. 马殿富,葛声,刘旭东.WSDL 表示模型与实现方法.北京航空航天大学学报,2003, 29(10):856-859
31. 施友松,侯晓霞.基于 UDDI 的分布式发现/发布策略及其实现.计算机应用与软件,2004,21(10):28-30
32. 林杰,张丽峰,薛行.基于 UDDI 的分布模型管理.计算机集成制造系统-CIMS.2004, 10(3):276-280
33. 杨勇,杨薇薇.web服务的一种通用集成模型的研究.华中科技大学学报(自然科学版),2004,32(1):44-46
34. Houston P J, Wjlikie F G, Anderson T J. Component-based development, CORBA and RM-ODP Software[J]. 1998,145(1):22-28
35. 詹永照,谢力,孙钟秀.使用CORBA实现各种分布式应系统的策略[J].计算机科学,1999,26(4):13-16
36. D Gavalas, D Greenwood, M Ghanbari. Mobile software agents for decentralized network and system management[J]. Microprocessors and Microsystems, 2001,25(2): 122-124
37. 童咪娜,金远平.XML 数据库查询语言特性研究.计算机应用,2001,21(9):69-71
38. Ceri B. Comparative Analysis of Five XML Query Languages. SIGMOD Record, 2000,29(1):68-79
39. A.Deutsch, M.F.Fernandez, D.Suciu. A Query Language for XML. Proc of VLDB(C), 1999,(3):56-57
40. Serge Abiteboul.Wiener.The Lorel Query Language for Semistructured Data[J] International. Journal on Digital Libraries, 1997,1(1):68-88
41. A.Deutsch, M.F.Fernandez,D.Florescu. XML-QL:A Query Language for XML. the Query Language Workshop, 1998,(3):78-79
42. D.Chamberlin, D.Florescu, J.Robie. XQuery 1.0:An XML Query Language.W3C Working Draft, 2001:12-16
43. A.Deutsch, M.F.Fernandez, D.Suciu. A Query Language for XML. International. Journal on Digital Libraries, 1999,2(3):56-57
44. B.Hsu, N.Koudas. Semantic Query Optimization for Query Plans of Heterogeneous Multidatabase Systems. Journal of Knowkedge and Data Engineering, 2000,12(6): 960-976
45. J Shanmugasundaram, K Tufte. Relational Databases for Querying XML Documents. Proc of VLDB[C], 1999,(2):21-23
46. D Florescu, D Kossmann. Storing and Querying XML Data Using an RDBMS[J]. IEEE Data Eng Bulletin, 1999,22(3):27-34
47. Zhong Hao. Preserving Constraints in Mapping XML DTD to Relational Schema[A]. 7th ISFSt[C]. 2002,(4):323-327
48. Yu Hailiang, Zhang Yu, Chen Yiyun. Teleform-a web interface description model based on XML[J]. MiniMicro Systems, 2003,24(12):2111-2117
49. Zhou Darren, Zhang Yu. Binding mechanism of 3-tiered WEB intrface mode[J]. Mini-Micor Systems, 2002,23(5):536-539
50. 张昱,付雄.含 XPATH 的表达式的解析与应用.小型微型计算机系统,2004,25(3): 442-446
51. 郭云怡,张永林.管理信息系统的数据完整性约束及其实现方法.计算机应用研究, 2001,(6):55-57
52. Elisa B, Barbara C. Integrating XML and Database[J]. IEEE Internet Computing, 2001,5(4):84-88
53. 王爱冬,张涛.XML 与数据库映射技术研究.湘潭师范学院学报(自然科学版),2004,26(1):53-54
54. 张宏展,赵辉.一种 flat/xml 转换工具的研究与实现.计算机应用研究,2001,(11): 131-133
55. 张小明.基于分布对象的异步消息的研究与实现.[国防科学技术大学工学博士学位论文].2001:12-22
56. 贺学林.SOAP 消息处理器的设计与实现.微型机与应用,2004,(3):31-34
57. 田捷,熊前兴.基于 SOAP 的消息传递安全性技术研究.计算机应用,2003,3(1): 284-286
58. 王芳,李正凡.用 SAX 解析 XML 文档的实现方法.华东交通大学学报,2004,21(1): 84-86
59. 雷庆,吴扬扬.基于 SAX 和 DOM 的 XML 嵌套信息提取.计算机工程与设计,2004, 25(12):2308-2312
60. 赵俊岚.XML 编程中的 DOM 与 SAX 技术.计算机工程,2005,30(24):70-72
61. 李明琨,龙敏.基于 RosettaNet 标准的集成供应链管理.物流技术,2003,(12):39-42
62. 熊光彩,莫蓉.XML 文档对象模型研究与应用.计算机工程与设计,2002,23(5):1-4
2. H.S. Thompsom. W3C XML Pointer, XML Base and XML Linking. http://www.w3. org/XML/Linking, 2002
3. M. Froumentin. The Extensible Stylesheet Language(XSL). http://www.w3.org/Style/ XSL, 2002
4. P.L. Hégaret. Document Object Model(DOM). http://www.w3.org/DOM, 2002
5. T. Bray, D. Hollander, A. Layman. Namespaces in XML. http://www.w3.org/TR/Rec-xml-names, 1999
6. D.C.Fallside. XML Schema Part0,1,2. http://www.w3.org/TR/2001/REC-xmlschema-20010502, 2001
7. M. Marchiori. XML Query. http://www.w3.org/XML/Query, 2002
8. Liam Quin. Extensible Markup Language (XML). http://www.w3/XML, 2002
9. J. Bosak, T. Bray, D. Connolly, etc. W3C XML Specification DTD. http://www.w3/ XML/1998/06/xmlreport.htm,June, 1998
10. M.Carey, D.Florescu, Z.Ives,Y.Lu,J.Shanmugasundaram.XPERANTO:Publishing Object-relational Data as XML.In Proceedings of WebDB,Dallas,TX,2000,(5): 105-110
11. 王自强,冯博琴.基于 XML 的 EDI 的研究与实现.计算机工程与应用,2003,(13): 187-189
12. Ronald J Vetter Charles Ward.Mosaic and the World-Wide Web[J].Computer,1994, 27(10):49-56
13. 柴晓路,梁宇奇.Web Services 技术、架构和应用.北京:电子工业出版社,2003:20-25
14. 沈伯青,杨宗凯.WEB 服务的基石:UDDI 技术.计算机工程与应用,2003,(3):147-150
15. Web Service Description Language(WSDL)1.1. http://www.w3.org/TR,2003
16. 周必水,倪慧丽.简单对象访问协议 SOAP 的研究与分析.微电子学与计算机,2002, (5):25-27
17. Hao Ying. SOAP protocol and its application[J]. Computer Engineering, 2002,27(6): 128-130
18. Zhang Wenbing, Chen Enhong. System inter-operation based on SOAP[J]. Computer Application, 2002,22(5):55-56
19. Florescu, D. Kossmann.Storing and Querying XML Data using an RDBMS. IEEE Data Engineering Bulletin, 1999,22(3):85-89
20. T. Kudrass. Management of XML Documents without Schema in Relational Databases. XML and Databases, 2001,(10):148-153
21. Jayavel Shanmugasundaram, H. Gang, Kristin Tufte. Relational databases for querying XML documents: Limitations and opportunities. Proceedings of 25th International Conference on Very Large Data Bases, 1999,Scotland:302-304
22. Y. Chen, S. Davidson, Y. Zheng, Constraints preserving schema mapping from XML to relations. WebDB, 2002,(3):62-65
23. 苟先太,金炜东.分布式计算在下一代网络中的应用研究.计算机应用,2003,23(8): 67-69
24. Jeffery B. Enterprise client/server computing[J]. Info Sys manag, 1996,12(4):38-43
25. 刘卫东,徐恪,刘亚霄.松散耦合的分布式信息系统.清华大学学报(自然科学版),2002,42(1):40-43
26. 王占杰,安之廷,李金波.web 服务协议栈安全研究.计算机应用研究,2003,(6):4-6
27. 李浩,沈琦.XML Schema 中的面向对象思想.计算机系统应用,2004,(2):36-39
28. 陈晓峰,王世安.SOAP 消息系统的研究与实现.沈阳工业大学学报,2003,25(2):155-157
29. Vinoski S.Web services interaction models-part 1:current practice[J].IEEE Internet Computing,2002,6(3):89-91
30. 马殿富,葛声,刘旭东.WSDL 表示模型与实现方法.北京航空航天大学学报,2003, 29(10):856-859
31. 施友松,侯晓霞.基于 UDDI 的分布式发现/发布策略及其实现.计算机应用与软件,2004,21(10):28-30
32. 林杰,张丽峰,薛行.基于 UDDI 的分布模型管理.计算机集成制造系统-CIMS.2004, 10(3):276-280
33. 杨勇,杨薇薇.web服务的一种通用集成模型的研究.华中科技大学学报(自然科学版),2004,32(1):44-46
34. Houston P J, Wjlikie F G, Anderson T J. Component-based development, CORBA and RM-ODP Software[J]. 1998,145(1):22-28
35. 詹永照,谢力,孙钟秀.使用CORBA实现各种分布式应系统的策略[J].计算机科学,1999,26(4):13-16
36. D Gavalas, D Greenwood, M Ghanbari. Mobile software agents for decentralized network and system management[J]. Microprocessors and Microsystems, 2001,25(2): 122-124
37. 童咪娜,金远平.XML 数据库查询语言特性研究.计算机应用,2001,21(9):69-71
38. Ceri B. Comparative Analysis of Five XML Query Languages. SIGMOD Record, 2000,29(1):68-79
39. A.Deutsch, M.F.Fernandez, D.Suciu. A Query Language for XML. Proc of VLDB(C), 1999,(3):56-57
40. Serge Abiteboul.Wiener.The Lorel Query Language for Semistructured Data[J] International. Journal on Digital Libraries, 1997,1(1):68-88
41. A.Deutsch, M.F.Fernandez,D.Florescu. XML-QL:A Query Language for XML. the Query Language Workshop, 1998,(3):78-79
42. D.Chamberlin, D.Florescu, J.Robie. XQuery 1.0:An XML Query Language.W3C Working Draft, 2001:12-16
43. A.Deutsch, M.F.Fernandez, D.Suciu. A Query Language for XML. International. Journal on Digital Libraries, 1999,2(3):56-57
44. B.Hsu, N.Koudas. Semantic Query Optimization for Query Plans of Heterogeneous Multidatabase Systems. Journal of Knowkedge and Data Engineering, 2000,12(6): 960-976
45. J Shanmugasundaram, K Tufte. Relational Databases for Querying XML Documents. Proc of VLDB[C], 1999,(2):21-23
46. D Florescu, D Kossmann. Storing and Querying XML Data Using an RDBMS[J]. IEEE Data Eng Bulletin, 1999,22(3):27-34
47. Zhong Hao. Preserving Constraints in Mapping XML DTD to Relational Schema[A]. 7th ISFSt[C]. 2002,(4):323-327
48. Yu Hailiang, Zhang Yu, Chen Yiyun. Teleform-a web interface description model based on XML[J]. MiniMicro Systems, 2003,24(12):2111-2117
49. Zhou Darren, Zhang Yu. Binding mechanism of 3-tiered WEB intrface mode[J]. Mini-Micor Systems, 2002,23(5):536-539
50. 张昱,付雄.含 XPATH 的表达式的解析与应用.小型微型计算机系统,2004,25(3): 442-446
51. 郭云怡,张永林.管理信息系统的数据完整性约束及其实现方法.计算机应用研究, 2001,(6):55-57
52. Elisa B, Barbara C. Integrating XML and Database[J]. IEEE Internet Computing, 2001,5(4):84-88
53. 王爱冬,张涛.XML 与数据库映射技术研究.湘潭师范学院学报(自然科学版),2004,26(1):53-54
54. 张宏展,赵辉.一种 flat/xml 转换工具的研究与实现.计算机应用研究,2001,(11): 131-133
55. 张小明.基于分布对象的异步消息的研究与实现.[国防科学技术大学工学博士学位论文].2001:12-22
56. 贺学林.SOAP 消息处理器的设计与实现.微型机与应用,2004,(3):31-34
57. 田捷,熊前兴.基于 SOAP 的消息传递安全性技术研究.计算机应用,2003,3(1): 284-286
58. 王芳,李正凡.用 SAX 解析 XML 文档的实现方法.华东交通大学学报,2004,21(1): 84-86
59. 雷庆,吴扬扬.基于 SAX 和 DOM 的 XML 嵌套信息提取.计算机工程与设计,2004, 25(12):2308-2312
60. 赵俊岚.XML 编程中的 DOM 与 SAX 技术.计算机工程,2005,30(24):70-72
61. 李明琨,龙敏.基于 RosettaNet 标准的集成供应链管理.物流技术,2003,(12):39-42
62. 熊光彩,莫蓉.XML 文档对象模型研究与应用.计算机工程与设计,2002,23(5):1-4
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |