Answering queries using views

DMCA

Answering queries using views (1995)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Alon Y. Levy , Alberto O. Mendelzon , Yehoshua Sagiv , Divesh Srivastava

Venue:	In PODS Conference
Citations:	443 - 32 self

BibTeX

@INPROCEEDINGS{Levy95answeringqueries,
    author = {Alon Y. Levy and Alberto O. Mendelzon and Yehoshua Sagiv and Divesh Srivastava},
    title = {Answering queries using views},
    booktitle = {In PODS Conference},
    year = {1995},
    pages = {95--104}
}

OpenURL

Abstract

We consider the problem of computing answers to queries by using materialized views. Aside from its potential in optimizing query evaluation, the problem also arises in applications such as Global Information Systems, Mobile Computing and maintaining physical data independence. We consider the problem of nding a rewriting of a query that uses the materialized views, the problem of nding minimal rewritings, and nding complete rewritings (i.e., rewritings that use only the views). We show that all the possible rewritings can be obtained by considering containment mappings from the views to the query, and that the problems we consider are NP-complete when both the query and the views are conjunctive and don't involve built-in comparison predicates. We show that the problem has two independent sources of complexity (the number of possible containment mappings, and the complexity of deciding which literals from the original query can be deleted). We describe a polynomial time algorithm for nding rewritings, and show that under certain conditions, it will nd the minimal rewriting. Finally, we analyze the complexity of the problems when the queries and views may be disjunctive and involve built-in comparison predicates. 1

Keyphrases

materialized view minimal rewriting built-in comparison predicate query evaluation global information system original query complete rewriting possible containment mapping mobile computing possible rewriting polynomial time algorithm certain condition physical data independence containment mapping independent source

DMCA