Efficient evaluation of XML middle-ware queries
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
XAL: an algebra for XML query optimization
ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
Querying XML Views of Relational Data
Proceedings of the 27th International Conference on Very Large Data Bases
DBPL '01 Revised Papers from the 8th International Workshop on Database Programming Languages
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Towards an Industrial Strength SQL/XML Infrastructure
ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Native Xquery processing in oracle XMLDB
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Towards an enterprise XML architecture
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Conquering the heterogeneity and evolutionary nature of XML using XML union views
DBA'06 Proceedings of the 24th IASTED international conference on Database and applications
Xpath on steroids: exploiting relational engines for xpath performance
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Effective and efficient update of xml in RDBMS
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Using a relational database for scalable XML search
The Journal of Supercomputing
Grouping and optimization of XPath expressions in DB2® pureXML
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Towards a physical XML independent XQuery/SQL/XML engine
Proceedings of the VLDB Endowment
A relational data harmonization approach to XML
Journal of Information Science
Pay-as-you-go: an adaptive approach to provide full context-aware text search over document content
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
A framework for XML-Based integration of data, visualization and analysis in a biomedical domain
XSym'05 Proceedings of the Third international conference on Database and XML Technologies
Hi-index | 0.01 |
Oracle XML DB integrates XML storage and querying using the Oracle relational and object relational framework. It has the capability to physically store XML documents by shredding them as relational or object relational data, and creating logical XML documents using SQL/XML publishing functions. However, querying XML in a relational or object relational database poses several challenges. The biggest challenge is to efficiently process queries against XML in a database whose fundamental storage is table-based and whose fundamental query engine is tuple-oriented. In this paper, we present the 'XML Query Rewrite' technique used in Oracle XML DB. This technique integrates querying XML using XPath embedded inside SQL operators and SQL/XML publishing functions with the object relational and relational algebra. A common set of algebraic rules is used to reduce both XML and object queries into their relational equivalent. This enables a large class of XML queries over XML type tables and views to be transformed into their semantically equivalent relational or object relational queries. These queries are then amenable to classical relational optimisations yielding XML query performance comparable to relational. Furthermore, this rewrite technique lays out a foundation to enable rewrite of XQuery [1] over XML.