Approximate rewriting of queries using views

Foto Afrati, Manik Chandrachud, Rada Chirkova, Prasenjit Mitra

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Scopus citations

Abstract

We study approximate, that is contained and containing, rewritings of queries using views. We consider conjunctive queries with arithmetic comparisons (CQACs), which capture the full expressive power of SQL select-project-join queries. For contained rewritings, we present a sound and complete algorithm for constructing, for CQAC queries and views, a maximally-contained rewriting (MCR) whose all CQAC disjuncts have up to a predetermined number of view literals. For containing rewritings, we present a sound and efficient algorithm pruned-MiCR, which computes a CQAC containing rewriting that does not contain any other CQAC containing rewriting (i.e., computes a minimally containing rewriting, MiCR) and that has the minimum possible number of relational subgoals. As a result, the MiCR rewriting produced by our algorithm may be very efficient to execute. Both algorithms have good scalability and perform well in many practical cases, due to their extensive pruning of the search space, see [1].

Original languageEnglish (US)
Title of host publicationAdvances in Databases and Information Systems - 13th East European Conference, ADBIS 2009, Proceedings
Pages164-178
Number of pages15
DOIs
StatePublished - Nov 25 2009
Event13th East European Conference on Advances in Databases and Information Systems, ADBIS 2009 - Riga, Latvia
Duration: Sep 7 2009Sep 10 2009

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume5739 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

Other13th East European Conference on Advances in Databases and Information Systems, ADBIS 2009
CountryLatvia
CityRiga
Period9/7/099/10/09

All Science Journal Classification (ASJC) codes

  • Theoretical Computer Science
  • Computer Science(all)

Fingerprint Dive into the research topics of 'Approximate rewriting of queries using views'. Together they form a unique fingerprint.

  • Cite this

    Afrati, F., Chandrachud, M., Chirkova, R., & Mitra, P. (2009). Approximate rewriting of queries using views. In Advances in Databases and Information Systems - 13th East European Conference, ADBIS 2009, Proceedings (pp. 164-178). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 5739 LNCS). https://doi.org/10.1007/978-3-642-03973-7_13