Independence of containing patterns property and its application in tree pattern query rewriting using views

Loading...
Thumbnail Image
File version
Author(s)
Wang, Junhu
Yu, Jeffrey Xu
Liu, Chengfei
Griffith University Author(s)
Primary Supervisor
Other Supervisors
Editor(s)
Date
2009
Size

201300 bytes

File type(s)

application/pdf

Location
License
Abstract

We show that several classes of tree patterns observe the independence of containing patterns property, that is, if a pattern is contained in the union of several patterns, then it is contained in one of them. We apply this property to two related problems on tree pattern rewriting using views. First, given view V and query Q, is it possible for Q to have an equivalent rewriting using V which is the union of two or more tree patterns, but not an equivalent rewriting which is a single pattern? This problem is of both theoretical and practical importance because, if the answer is no, then, to find an equivalent rewriting of a tree pattern using a view, we should use more efficient methods, such as the polynomial time algorithm of Xu and ֺsoyoglu (2005), rather than try to find the union of all contained rewritings (which takes exponential time in the worst case) and test its equivalence to Q. Second, given a set S of views, we want to know under what conditions a subset S' of S is redundant in the sense that for any query Q, the contained rewritings of Q using the views in S' are contained in those using the views in S?-?S'. Solving this problem can help us to, for example, choose the minimum number of views to be cached, or better design the virtual schema in a mediated data integration system, or avoid repeated calculation in query optimization. For the first problem, we identify several classes of tree patterns for which the equivalent rewriting can be expressed as a single tree pattern. For the second problem, we present necessary and sufficient conditions for S' to be redundant with respect to some classes of tree patterns. For both problems we consider extension to cases where there are rewritings using the intersection of multiple views and/or where a schema graph is present.

Journal Title

World Wide Web

Conference Title
Book Title
Edition
Volume

12

Issue

1

Thesis Type
Degree Program
School
Publisher link
Patent number
Funder(s)
Grant identifier(s)
Rights Statement
Rights Statement

© 2009 Springer Netherlands. This is the author-manuscript version of this paper. Reproduced in accordance with the copyright policy of the publisher. The original publication is available at www.springerlink.com

Item Access Status
Note
Access the data
Related item(s)
Subject

Data management and data science

Distributed computing and systems software

Information systems

Database systems

Persistent link to this record
Citation
Collections