ComputingComputer ScienceAlgorithmsDatabasesDistributed SystemsDatabase ManagementDistributed DatabasesQuery ManagementQuery OptimizationQuery ProcessingRelational AlgebraDistributed Query OptimizationExponential Time ComplexityFederated Query OptimizationFederated Query ProcessingFederated Query SystemsPolynomial Time ComplexityPolynomial-time Algorithms
Query folding refers to the activity of determining if and how a query can be answered using a given set of resources, which might be materialized views, cached results of previous queries, or queries answerable by other databases. We investigate query folding in the context where queries and resources are conjunctive queries. We develop an exponential time algorithm that finds all complete or partial foldings, and a polynomial time algorithm for the subclass of acyclic conjunctive queries. Our results can be applied to query optimization in centralized databases, to query processing in distributed databases, and to query answering in federated databases.
13
Principles of database and knowledge-base systems
Choice Reviews Online · 1989 · 2.7K citations
Optimal implementation of conjunctive queries in relational data bases
Ashok K. Chandra, Philip M. Merlin · 1977 · 1.2K citations · Full text
Optimizing queries with materialized views
Surajit Chaudhuri, R. Krishnamurthy, Spyros Potamianos et al. · 2002 · 374 citations
Equivalences among Relational Expressions
A. V. Aho, Yehoshua Sagiv, Jeffrey D. Ullman · SIAM Journal on Computing · 1979 · 364 citations
Computing, Computer Science, Algebra +15