Rewriting and evaluating XPath queries using views

Rewriting and evaluating queries using views, also known as answering queries using views, is to utilize previously defined and materialized views to evaluate queries in order to save the cost of accessing large real database. It is a classic problem, and appears in many applications, such as query optimization, data integration, data warehouse and query caching. With the prevalence of XML technologies, rewriting XML queries using XML views has caught the attention of both researchers and system designers, and is believed to be a promising technique in web and database applications. Since XPath serves as the core sub-language of the major XML query languages, such as XQuery and XSLT, it is of immense value to study how to rewrite and evaluate XPath queries using XPath views. In this thesis, contained rewriting for XPath queries using XPath views is studied. Contained rewriting is proposed to provide best effort to answer a user’s query when equivalent rewriting does not exit. Given a query and a view, there may be an exponential number of contained rewritings. Some of them are redundant because the query answers produced by these redundant contained rewritings can be covered by other contained rewritings. Obviously, it is unnecessary to evaluate redundant contained rewritings on materialized views. We investigate the problem and propose a series of methods to discover all irredundant contained rewritings, and we show the correctness of the proposed methods. Furthermore, we study the evaluation of a group of contained rewritings on a given materialized

[1]  Marvin H. Solomon,et al.  The GMAP: a versatile tool for physical data independence , 1996, The VLDB Journal.

[2]  Divesh Srivastava,et al.  Answering Queries with Aggregation Using Views , 1996, VLDB.

[3]  Mong-Li Lee,et al.  Efficient Mining of XML Query Patterns for Caching , 2003, VLDB.

[4]  Jianxin Li,et al.  Fast ELCA computation for keyword queries on XML data , 2010, EDBT '10.

[5]  Alex Thomo,et al.  Query containment and rewriting using views for regular path queries under constraints , 2003, PODS.

[6]  Yannis Papakonstantinou,et al.  Query rewriting for semistructured data , 1999, SIGMOD '99.

[7]  Michael R. Genesereth,et al.  Answering recursive queries using views , 1997, PODS '97.

[8]  Alin Deutsch,et al.  Reformulation of XML Queries and Constraints , 2003, ICDT.

[9]  Jeffrey Xu Yu,et al.  Contained Rewritings of XPath Queries Using Views Revisited , 2008, WISE.

[10]  Jianxin Li,et al.  Holistic Constraint-Preserving Transformation from Relational Schema into XML Schema , 2008, DASFAA.

[11]  Jianxin Li,et al.  Filtering Techniques for Rewriting XPath Queries Using Views , 2008, WISE.

[12]  Rada Chirkova,et al.  On rewriting XPath queries using views , 2009, EDBT '09.

[13]  Jianxin Li,et al.  Containment between Unions of XPath Queries , 2009, DASFAA.

[14]  Chee Yong Chan,et al.  Minimization of tree pattern queries with constraints , 2008, SIGMOD Conference.

[15]  Elke A. Rundensteiner,et al.  XCache: XQuery-based Caching System , 2002, WebDB.

[16]  Jun Gao,et al.  MQTree Based Query Rewriting over Multiple XML Views , 2007, DEXA.

[17]  Jeffrey Xu Yu,et al.  XPath Rewriting Using Multiple Views , 2008, DEXA.

[18]  Thomas Schwentick,et al.  XPath query containment , 2004, SGMD.

[19]  Xiaolei Qian,et al.  Query folding , 1996, Proceedings of the Twelfth International Conference on Data Engineering.

[20]  Jeffrey Xu Yu,et al.  On Tree Pattern Query Rewriting Using Views , 2007, WISE.

[21]  Jignesh M. Patel,et al.  Structural joins: a primitive for efficient XML query pattern matching , 2002, Proceedings 18th International Conference on Data Engineering.

[22]  Carsten Lutz,et al.  The complexity of query containment in expressive fragments of XPath 2.0 , 2007, PODS.

[23]  Michael Benedikt,et al.  XPath satisfiability in the presence of DTDs , 2008, JACM.

[24]  Shuigeng Zhou,et al.  A Theoretic Framework for Answering XPath Queries Using Views , 2005, XSym.

[25]  Jianxin Li,et al.  Efficient Top-k Search Across Heterogeneous XML Data Sources , 2008, DASFAA.

[26]  Alon Y. Halevy,et al.  Containment of Nested XML Queries , 2004, VLDB.

[27]  James Clark,et al.  XSL Transformations (XSLT) Version 1.0 , 1999 .

[28]  Alin Deutsch,et al.  Rewriting nested XML queries using nested views , 2006, SIGMOD Conference.

[29]  Thomas Schwentick,et al.  XPath Containment in the Presence of Disjunction, DTDs, and Variables , 2003, ICDT.

[30]  Hao Tang,et al.  Materialized View Selection in XML Databases , 2009, DASFAA.

[31]  Keishi Tajima,et al.  Answering XPath Queries over Networks by Sending Minimal Views , 2004, VLDB.

[32]  Dan Suciu,et al.  Containment and equivalence for a fragment of XPath , 2004, JACM.

[33]  Jeffrey Xu Yu,et al.  Independence of Containing Patterns Property and Its Application in Tree Pattern Query Rewriting Using Views , 2008, World Wide Web.

[34]  Alin Deutsch,et al.  XPath Rewriting Using Multiple Views: Achieving Completeness and Efficiency , 2008, WebDB.

[35]  Quanzhong Li,et al.  Indexing and Querying XML Data for Regular Path Expressions , 2001, VLDB.

[36]  Kewen Wang,et al.  Finding Irredundant Contained Rewritings of Tree Pattern Queries Using Views , 2009, APWeb/WAIM.

[37]  Dan Suciu,et al.  Query Caching and View Selection for XML Databases , 2005, VLDB.

[38]  Alin Deutsch,et al.  Efficient Rewriting of XPath Queries Using Query Set Specifications , 2009, Proc. VLDB Endow..

[39]  Rada Chirkova,et al.  A formal perspective on the view selection problem , 2002, The VLDB Journal.

[40]  Laks V. S. Lakshmanan,et al.  Tree pattern query minimization , 2002, The VLDB Journal.

[41]  Jeffrey Xu Yu,et al.  Chasing Tree Patterns under Recursive DTDs , 2010, DASFAA.

[42]  Z. Meral Özsoyoglu,et al.  Rewriting XPath Queries Using Materialized Views , 2005, VLDB.

[43]  Peter T. Wood,et al.  Containment for XPath Fragments under DTD Constraints , 2003, ICDT.

[44]  Laks V. S. Lakshmanan,et al.  On Testing Satisfiability of Tree Pattern Queries , 2004, VLDB.

[45]  Beng Chin Ooi,et al.  XR-tree: indexing XML data for efficient structural joins , 2003, Proceedings 19th International Conference on Data Engineering (Cat. No.03CH37405).

[46]  Ioana Manolescu,et al.  Structured Materialized Views for XML Queries , 2007, VLDB.

[47]  S. Sudarshan,et al.  Extending query rewriting techniques for fine-grained access control , 2004, SIGMOD '04.

[48]  Alon Y. Halevy,et al.  MiniCon: A scalable algorithm for answering queries using views , 2000, The VLDB Journal.

[49]  Roy Goldman,et al.  DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases , 1997, VLDB.

[50]  Carlo Zaniolo,et al.  Efficient Structural Joins on Indexed XML Documents , 2002, VLDB.

[51]  Peter T. Wood Minimising Simple XPath Expressions , 2001, WebDB.

[52]  Jianxin Li,et al.  Processing XML Keyword Search by Constructing Effective Structured Queries , 2009, APWeb/WAIM.

[53]  Alin Deutsch,et al.  The Query Set Specification Language (QSSL) , 2003, WebDB.

[54]  Jianxin Li,et al.  Suggestion of promising result types for XML keyword search , 2010, EDBT '10.

[55]  Laks V. S. Lakshmanan,et al.  Answering tree pattern queries using views , 2006, VLDB.

[56]  Alon Y. Halevy,et al.  Answering queries using views: A survey , 2001, The VLDB Journal.

[57]  Diego Calvanese,et al.  Answering regular path queries using views , 2000, Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073).

[58]  Steven J. DeRose,et al.  Xml pointer language (xpointer) version 1 , 2001 .

[59]  Patrick Valduriez,et al.  Join indices , 1987, TODS.

[60]  Wenfei Fan,et al.  Rewriting Regular XPath Queries on XML Views , 2007, 2007 IEEE 23rd International Conference on Data Engineering.

[61]  Jeffrey Xu Yu,et al.  Minimal common container of tree patterns , 2009, CIKM.

[62]  Chee Yong Chan,et al.  ViewJoin: Efficient view-based evaluation of tree pattern queries , 2010, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010).

[63]  Scott Boag,et al.  XQuery 1.0 : An XML Query Language , 2007 .

[64]  Jeffrey Xu Yu,et al.  Transforming Tree Patterns with DTDs for Query Containment Test , 2008, DEXA.

[65]  Kam-Fai Wong,et al.  Multiple Materialized View Selection for XPath Query Rewriting , 2008, 2008 IEEE 24th International Conference on Data Engineering.

[66]  Dan Suciu,et al.  Containment and equivalence for an XPath fragment , 2002, PODS.

[67]  Hamid Pirahesh,et al.  A Framework for Using Materialized XPath Views in XML Query Processing , 2004, VLDB.

[68]  Xiaoying Wu,et al.  Answering XML queries using materialized views revisited , 2009, CIKM.