This book focuses on the optimization of general conjunctive queries (GCQ) using integrity constraints and in the presence of materialized views. A GCQ is a conjunctive query with arbitrary built-in predicates. The integrity constraints we consider are disjunctive constrained tuple- generating dependencies (DCTGDs)which include many traditional integrity constraints such as functional dependencies, inclusion dependencies, and constrained tuple-generating dependencies. We first present an improved method for testing general conjunctive query containment using relevance mappings. We then present a method for testing general conjunctive query containment in the presence of DCTGDs. Our method generalizes and improves previous algorithms for the semantic containment problem of conjunctive queries. When materialized views exist, we study the problem of rewriting a union of general conjunctive queries using the view relations under the open world assumption and present a general approach for such problems. Our approach can rewrite unions of general conjunctive queries when both the query and the views involve built-in predicates.
Recommendations
View-based query processing: On the relationship between rewriting, answering and losslessness
As a result of the extensive research in view-based query processing, three notions have been identified as fundamental, namely rewriting, answering, and losslessness. Answering amounts to computing the tuples satisfying the query in all databases ...
Exploiting Embedded Synopsis for Exact and Approximate Query Processing
Database and Expert Systems ApplicationsAbstractOrganizing data in structured forms is a mainstream approach to improve the efficiency of query processing on database. For example, a B+Tree index is widely employed to limit the search space for selective queries, speeding up the query ...
View-based query processing: on the relationship between rewriting, answering and losslessness
ICDT'05: Proceedings of the 10th international conference on Database TheoryAs a result of the extensive research in view-based query processing, three notions have been identi.ed as fundamental, namely rewriting, answering, and losslessness. Answering amounts to computing the tuples satisfying the query in all databases ...