OPTIMAL IMPLEMENTATION OF CONJUNCTIVE QUERIES IN RELATIONAL DATA BASES

OPTIMAL IMPLEMENTATION OF CONJUNCTIVE QUERIES IN RELATIONAL DATA BASES

| Ashok K. Chandra and Philip M. Merlin
The paper by Ashok K. Chandra and Philip M. Merlin discusses the implementation of conjunctive queries in relational databases. They define conjunctive queries and the generalized join operator, which plays a crucial role in answering these queries. The authors show that while answering conjunctive queries is NP-complete, an implementation can be found that is within a constant factor of optimal. They introduce the concept of a unique minimal equivalent query for each conjunctive query, similar to minimal finite automata. The paper includes examples of conjunctive queries and explains how they can be efficiently answered using matrix multiplication. It also defines the generalized join operation and provides a formal proof that it can be computed in time proportional to the size of the relations involved. The authors discuss the complexity of boolean and conjunctive queries, noting that boolean queries are PSPACE-complete, while conjunctive queries are NP-complete. The paper further explores query minimization, proving that every conjunctive query has a unique minimal equivalent query. This minimal query can be obtained by "combining variables," a process similar to combining states in minimal finite automata. The authors provide an algorithm to find this minimal query and demonstrate how it can be used to construct a near-optimal program for answering the query, with a running time within a constant factor of optimal. Finally, the paper discusses the model of computation and optimization techniques, including the use of algebraic operations on relations. It concludes by highlighting the practical implications of their findings and the potential for significant speed improvements in database queries.The paper by Ashok K. Chandra and Philip M. Merlin discusses the implementation of conjunctive queries in relational databases. They define conjunctive queries and the generalized join operator, which plays a crucial role in answering these queries. The authors show that while answering conjunctive queries is NP-complete, an implementation can be found that is within a constant factor of optimal. They introduce the concept of a unique minimal equivalent query for each conjunctive query, similar to minimal finite automata. The paper includes examples of conjunctive queries and explains how they can be efficiently answered using matrix multiplication. It also defines the generalized join operation and provides a formal proof that it can be computed in time proportional to the size of the relations involved. The authors discuss the complexity of boolean and conjunctive queries, noting that boolean queries are PSPACE-complete, while conjunctive queries are NP-complete. The paper further explores query minimization, proving that every conjunctive query has a unique minimal equivalent query. This minimal query can be obtained by "combining variables," a process similar to combining states in minimal finite automata. The authors provide an algorithm to find this minimal query and demonstrate how it can be used to construct a near-optimal program for answering the query, with a running time within a constant factor of optimal. Finally, the paper discusses the model of computation and optimization techniques, including the use of algebraic operations on relations. It concludes by highlighting the practical implications of their findings and the potential for significant speed improvements in database queries.
Reach us at info@study.space
Understanding Optimal implementation of conjunctive queries in relational data bases