首页 | 本学科首页   官方微博 | 高级检索  
     

基于SQL的XML查询的有效实现
引用本文:郑仕辉,周傲英,季文,梁宇奇,张龙,田增平.基于SQL的XML查询的有效实现[J].计算机研究与发展,2001,38(4):422-429.
作者姓名:郑仕辉  周傲英  季文  梁宇奇  张龙  田增平
作者单位:复旦大学计算机科学与工程系
基金项目:国家自然科学基金!(6 0 0 0 30 16,6 0 0 0 30 0 8),国家重点基础研究“九七三”基金项目!(G19980 30 4-14 )资助
摘    要:讨论了关系数据库中利用SQL语句实现XML查询的问题,首先提出了一个利用映射信息(映射图)将带正则路径表达式的XML查询重写为一组简单路径查询的算法,该过程中的一个关键问题的Kleene表达式不能直接利用映射图重写,为此,提出了利用路径实例的统计信息来扩展Kleene表达式的算法,然后,进一步描述了将简单路径表达式查询重写为SQL查询的方法,这些算法在XML-关系系统原型VXMLR中实现,初步性能研究表明提出了方法是有效的。

关 键 词:映射图  关系数据库  数据查询  SQL  XML

EFFECTIVE EVALUATION OF XML QUERIES WITH SQL STATEMENTS
ZHENG Shi-Hui,ZHOU Ao-Ying,JI Wen-Yun,LIANG Yu-Qi,ZHANG Long,TIAN Zeng-Ping.EFFECTIVE EVALUATION OF XML QUERIES WITH SQL STATEMENTS[J].Journal of Computer Research and Development,2001,38(4):422-429.
Authors:ZHENG Shi-Hui  ZHOU Ao-Ying  JI Wen-Yun  LIANG Yu-Qi  ZHANG Long  TIAN Zeng-Ping
Abstract:In this paper, a problem is studied, which evaluates XML queries using SQL statements in relational database systems. At first, an algorithm is proposed, which rewrites a regular path expression based XML query as a group of simple path expression based queries using mapping information(mapping graph). A key problem in this process is that a Kleene expression cannot be rewritten using mapping graph directly. To handle this problem, statistical information of path instances is gathered to expand Kleene expressions. After that, an approach to rewrite a simple path expression into a SQL statement is described. The approaches presented are implemented in a virtual XML relational prototype system VXMLR. A preliminary performance study shows that the approaches are very effective.
Keywords:mapping graph  Kleene path expression  RPE  SPE rewriting  SPE  SQL rewriting  
本文献已被 CNKI 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号