Native Xquery processing in oracle XMLDB

ABSTRACT

With XQuery becoming the standard language for querying XML, and the relational SQL platform being recognized as an important platform to store and process XML, the SQL/XML standard is integrating XML query capability into the SQL system by introducing new SQL functions and constructs such as XMLQuery() and XMLTable. This paper discusses the Oracle XMLDB XQuery architecture for supporting XQuery in the Oracle ORDBMS kernel which has the XQuery processing tightly integrated with the SQL/XML engine using native XQuery compilation, optimization and execution techniques.

REFERENCES

• 1: Scott Boag, Don Chamberlin, Mary F. Fernández, Daniela Florescu, Jonathan Robie, Jérôme Siméon. XQuery 1.0: An XML Query Language http://www.w3.org/TR/xquery/.
• 2: Mary Fernández, Ashok Malhotra, Jonathan Marsh, Marton Nagy, Norman Walsh. XQuery 1.0 and XPath 2.0 Data Model http://www.w3c.org/TR/xpath-datamodel/
• 3: Denise Draper, Peter Fankhauser, Mary Fernández, Ashok Malhotra, Kristoffer Rose, Michael Rys, Jérôme Siméon, Philip Wadler. XQuery 1.0 and XPath 2.0 Formal Semantics http://www.w3c.org/TR/xquery-semantics/.
• 4: Ashok Malhotra, Jim Melton, Jonathan Robie, Michael Rys. XML Syntax for XQuery 1.0 (XQueryX) http://www.w3.org/TR/2003/WD-xqueryx-20031219/
• 5: World Wide Web Consortium, "XML Schema Standard" http://www.w3c.org/XML/Schema
• 6: The international Committee for Information Technology Standard H2.3 Task Group, http://www.sqlx.org
• 7: Andrew Eisenberg , Jim Melton, SQL/XML is making good progress, ACM SIGMOD Record, v.31 n.2, June 2002 [doi>10.1145/565117.565141]
• 8: SQL/XML 2003, the first edition of the SQL/XML standard published by the ISO as part 14 of the SQL standard: ISO/IEC 9075--14:2003.
• 9: Andrew Eisenberg, Jim Melton. SQL/XML Advancements. http://www.sigmod.org/sigmod/record/issues/0409/11.JimMe Iton.pdf.
• 10: Mary Fernández, Jérôme Siméon, Byron Choi, Amelie Marian, Gargi Sur. Implementing XQuery 1.0: The Galax Experience. VLDB 2003.
• 11: Ioana Manolescu , Daniela Florescu , Donald Kossmann, Answering XML Queries on Heterogeneous Data Sources, Proceedings of the 27th International Conference on Very Large Data Bases, p.241-250, September 11-14, 2001
• 12: Daniela Florescu , Chris Hillery , Donald Kossmann , Paul Lucas , Fabio Riccardi , Till Westmann , J. Carey , Arvind Sundararajan, The BEA streaming XQuery processor, The VLDB Journal — The International Journal on Very Large Data Bases, v.13 n.3, p.294-315, September 2004 [doi>10.1007/s00778-004-0137-1]
• 13: Xin Zhang , Bradford Pielech , Elke A. Rundesnteiner, Honey, I shrunk the XQuery!: an XML algebra optimization approach, Proceedings of the 4th international workshop on Web information and data management, November 08-08, 2002, McLean, Virginia, USA [doi>10.1145/584931.584936]
• 14: David DeHaan , David Toman , Mariano P. Consens , M. Tamer Özsu, A comprehensive XQuery to SQL translation using dynamic interval encoding, Proceedings of the 2003 ACM SIGMOD international conference on Management of data, June 09-12, 2003, San Diego, California [doi>10.1145/872757.872832]
• 15: Ravi Murthy, Sandeepan Banerjee. XML Schemas in Oracle XML DB. VLDB 2003.
• 16: Muralidhar Krishnaprasad, Zhen Hua Liu, Anand Manikutty, Jim Warner, Vikas Arora, Susan Kotsovolos. Query rewrite for XML in Oracle XMLDB. VLDB 2004.
• 17: Muralidhar Krishnaprasad , Zhen Hua Liu , Anand Manikutty , James W. Warner , Vikas Arora, Towards an Industrial Strength SQL/XML Infrastructure, Proceedings of the 21st International Conference on Data Engineering (ICDE'05), p.991-1000, April 05-08, 2005 [doi>10.1109/ICDE.2005.144]
• 18: Jayavel Shanmugasundaram , Jerry Kiernan , Eugene J. Shekita , Catalina Fan , John Funderburk, Querying XML Views of Relational Data, Proceedings of the 27th International Conference on Very Large Data Bases, p.261-270, September 11-14, 2001
• 19: Jayavel Shanmugasundaram , Eugene J. Shekita , Rimon Barr , Michael J. Carey , Bruce G. Lindsay , Hamid Pirahesh , Berthold Reinwald, Efficiently Publishing Relational Data as XML Documents, Proceedings of the 26th International Conference on Very Large Data Bases, p.65-76, September 10-14, 2000
• 20: Jason McHugh, Jennifer Widom. Compile-Time Path Expansion in Lore. http://www-db.stanford.edu/lore/pubs/re.pdf
• 21: Hamid Pirahesh , Joseph M. Hellerstein , Waqar Hasan, Extensible/rule based query rewrite optimization in Starburst, Proceedings of the 1992 ACM SIGMOD international conference on Management of data, p.39-48, June 02-05, 1992, San Diego, California, United States
• 22: Torsten Grust, Sherif Sakr, Jens Teubner. XQuery on SQL Hosts. VLDB 2004
• 23: Albrecht Schmidt, Florian Wass, Martin Kersten, Michael J. Carey, Ioana Manolescu, Ralph Busse. Xmark: A Benchmark for XML Data Management. VLDB 2002.