Semantic Optimization of XQuery by Rewriting

Queries on XML data are increasingly widespread in use and scope of application. However, optimization strategies are not yet as developed as they are for traditional DBMSs. Current strategies mostly involve logical or physical query plan optimization. We propose a novel optimization for XQuery using semantic information from the XML schema, where we rewrite a query into an equivalent query with fewer XPath expressions based on schema information. Our experimental results indicate that this optimization can result in substantial performance gains.

[1]  Byron Choi,et al.  The XQuery Formal Semantics: A Foundation for Implementation and Optimization , 2002 .

[2]  Amélie Marian,et al.  Implementing Xquery 1.0: The Galax Experience , 2003, VLDB.

[3]  Raghu Ramakrishnan,et al.  Database Management Systems , 1976 .

[4]  Toshiyuki Amagasa,et al.  XRel: a path-based approach to storage and retrieval of XML documents using relational databases , 2001, ACM Trans. Internet Techn..

[5]  Cong Yu,et al.  TIMBER: A native XML database , 2002, The VLDB Journal.

[6]  Paul Cotton Implementing XQuery , 2002, SIGMOD '02.

[7]  Sourav S. Bhowmick,et al.  Efficient processing of XPath queries using indexes , 2007, Inf. Syst..

[8]  Alin Deutsch,et al.  The next+ framework for logical xquery optimization , 2004, VLDB 2004.

[9]  Jeffrey F. Naughton,et al.  Recursive XML schemas, recursive XML queries, and relational storage: XML-to-SQL query translation , 2004, Proceedings. 20th International Conference on Data Engineering.

[10]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .

[11]  Dan Suciu,et al.  SilkRoute: trading between relations and XML , 2000, Comput. Networks.

[12]  Elke A. Rundensteiner,et al.  Updating Views Over Recursive XML , 2007, EROW.

[13]  Dan Suciu,et al.  Optimizing regular path expressions using graph schemas , 1998, Proceedings 14th International Conference on Data Engineering.

[14]  Eugene J. Shekita,et al.  Querying XML Views of Relational Data , 2001, VLDB.

[15]  Jennifer Widom,et al.  Query Optimization for XML , 1999, VLDB.