[1]曹亮,王茜,卢菁.XML数据在关系数据库中存储和检索的研究和实现[J].东南大学学报(自然科学版),2002,32(1):124-127.[doi:10.3969/j.issn.1001-0505.2002.01.028]
 Cao Liang,Wang Qian,Lu Jing.Research and implementation of storing and retrieving the XML data in RDBMS[J].Journal of Southeast University (Natural Science Edition),2002,32(1):124-127.[doi:10.3969/j.issn.1001-0505.2002.01.028]
点击复制

XML数据在关系数据库中存储和检索的研究和实现()
分享到:

《东南大学学报(自然科学版)》[ISSN:1001-0505/CN:32-1178/N]

卷:
32
期数:
2002年第1期
页码:
124-127
栏目:
计算机科学与工程
出版日期:
2002-01-20

文章信息/Info

Title:
Research and implementation of storing and retrieving the XML data in RDBMS
作者:
曹亮 王茜 卢菁
东南大学计算机科学与工程系, 南京 210096
Author(s):
Cao Liang Wang Qian Lu Jing
Department of Computer Science and Engineerin, Southeast University, Nanjing 210096, China
关键词:
XML RDBMS XML-QL SQL
Keywords:
XML RDBMS XML-QL SQL
分类号:
TP311.131
DOI:
10.3969/j.issn.1001-0505.2002.01.028
摘要:
论述了关系型数据和XML数据之间的相互转换,给出了将XML数据存储在关系数据库和将存储在关系数据库的XML数据恢复为XML形式的算法.由于实际数据类型的复杂性,使用Schema来定义XML文档类型.试验结果表明算法具有较好的性能.讨论了将XML-QL查询语句转换为SQL查询语句的设计,根据文中XML数据存储在关系型数据库中的算法,可以对XML-QL查询语句的语法、语义进行分析以转换为相应形式的SQL语句来在关系数据库中查询被存储的XML数据,并返回相应的结果集.
Abstract:
The conversion of relational data into XML and vice versa is expounded and an algorithm of converting XML data to relational data and recovering the data back to XML format is presented. Because of the complexity of data type in use, Schema is adopted to define the XML document type. The experiment shows that the algorithms have good performance. The problem of converting XML-QL into SQL is also discussed. According to the XML data storing algorithms mentioned in this paper,it is enabled to analyze the syntax and semantics of the XML-QL query and convert it into SQL to query stored XML data in the RDBMS, which can return to the dataset accordingly.

参考文献/References:

[1] Widom Jennifer.Data management for XML:research directions(electronic version)[J].IEEE Data Engineering Bulletin,1999,22(3):44-52.
[2] Suciu Dan.An overview of semistructured data[J].SIGACT News,1998,29(4):28-38.
[3] Florescu Daniela,Kossmann Donnald,Manolescu Ioana.Integrating keyword search into XML queryprocessing[J].Computer Networks,2000(33):119-135.
[4] Deutsch Alin,Fernandez Mary,Florescu Daniela.A query language for XML[J].Computer Networks,1999(31):1155-1169.
[5] Biron P V,Malhotra A.XML schema part 2:datatypes.W3C.http://www.w3.org/TR/xmlschema-2.2000-04/2001-02-20.

相似文献/References:

[1]王韦伟,孙庆鸿.基于XML的分布异构数据集成平台[J].东南大学学报(自然科学版),2006,36(5):715.[doi:10.3969/j.issn.1001-0505.2006.05.007]
 Wang Weiwei,Sun Qinghong.Intergrated platform of distributed heterogeneous data based on XML[J].Journal of Southeast University (Natural Science Edition),2006,36(1):715.[doi:10.3969/j.issn.1001-0505.2006.05.007]
[2]潘顺,金远平,欧阳晔.结构化数据到XML数据的语义映射[J].东南大学学报(自然科学版),2002,32(3):331.[doi:10.3969/j.issn.1001-0505.2002.03.005]
 Pan Shun,Jin Yuanping,Ou Yangye.Semantic mapping from structured data to XML data[J].Journal of Southeast University (Natural Science Edition),2002,32(1):331.[doi:10.3969/j.issn.1001-0505.2002.03.005]

备注/Memo

备注/Memo:
作者简介: 曹亮(1977—), 男, 硕士生; 王茜(联系人), 女, 教授, qwang@seu.edu.cn.
更新日期/Last Update: 2002-01-20