Query rewriting using views : a theoretical and practical perspective

Abstract : In this work, we address the problem of query rewriting using views, by adopting both a theoretical and a pragmatic perspective. In the first and main chapter, we approach the topic of finding all minimal (i.e. with no redundant relational atoms) conjunctive query reformulations for a relational conjunctive query, under constraints expressed as embedded dependencies, including the relationship between the source and the target schemas. We present a novel sound and complete algorithm, the Provenance-Aware Chase & Backchase, that solves the minimal reformulations problem with practically relevant performance. We provide a detailed theoretical characterization of our algorithm. We further present the optimized implementation and the experimental evaluation thereof, and exhibit natural scenarios yielding speed-ups of up to two orders of magnitude between the execution of a best view-based rewriting found by a commercial DBMS and that of a best rewriting found by our algorithm. We generalize the Provenance-Aware Chase & Backchase towards directly finding minimum-cost reformulations for monotonic cost functions, and show the performance improvements this adaptation further enables. With our algorithm, we introduce a novel chase flavour, the Provenance-Aware Chase, which is interesting on its own, as a means of reasoning about the interaction between provenance and constraints. In the second chapter, we move to an XML context and revisit the previous work of Cautis, Deutsch and Onose on the problem of finding XPath query rewritings with a single level of intersection of multiple views. We enrich the analysis of the rewriting problem by showing its links to the problems of DAG-tree equivalence and union-freeness. We refine the rule-based rewriting technique proposed by Cautis, Deutsch and Onose to ensure its polynomial complexity and improve its completeness, and present a range of optimizations on the rewriting procedures, necessary to achieve practical performance. We provide a complete implementation comprising these optimizations and a thorough experimental evaluation thereof, showing the performanceand utility of the polynomial rewriting technique.
Document type :
Theses
Complete list of metadatas

Cited literature [67 references]  Display  Hide  Download

https://pastel.archives-ouvertes.fr/tel-01661323
Contributor : Abes Star <>
Submitted on : Monday, December 11, 2017 - 10:53:30 PM
Last modification on : Thursday, October 17, 2019 - 12:36:10 PM

File

TheseIleana2.pdf
Version validated by the jury (STAR)

Identifiers

  • HAL Id : tel-01661323, version 1

Collections

Citation

Ioana Ileana. Query rewriting using views : a theoretical and practical perspective. Databases [cs.DB]. Télécom ParisTech, 2014. English. ⟨NNT : 2014ENST0062⟩. ⟨tel-01661323⟩

Share

Metrics

Record views

155

Files downloads

103