Query evaluation techniques for large databases
- 1 June 1993
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Computing Surveys
- Vol. 25 (2) , 73-169
- https://doi.org/10.1145/152610.152611
Abstract
Database management systems will continue to manage large data volumes. Thus, efficient algorithms for accessing and manipulating large sets and sequences will be required to provide acceptable performance. The advent of object-oriented and extensible database systems will not solve this problem. On the contrary, modern data models exacerbate the problem: In order to manipulate large sets of complex objects as efficiently as today's database systems manipulate simple records, query-processing algorithms and software will become more complex, and a solid understanding of algorithm and architectural issues is essential for the designer of database management software.This survey provides a foundation for the design and implementation of query execution facilities in new database management systems. It describes a wide array of practical query evaluation techniques for both relational and postrelational database systems, including iterative execution of complex query evaluation plans, the duality of sort- and hash-based set-matching algorithms, types of parallel query execution and their implementation, and special operators for emerging database application domains.Keywords
This publication has 127 references indexed in Scilit:
- A survey of parallel execution strategies for transitive closure and logic programsDistributed and Parallel Databases, 1993
- Dataflow query execution in a parallel main-memory environmentDistributed and Parallel Databases, 1993
- Optimization of parallel query execution plans in XPRSDistributed and Parallel Databases, 1993
- A pipeline N-way join algorithm based on the 2-way semijoin programIEEE Transactions on Knowledge and Data Engineering, 1991
- The implementation of POSTGRESIEEE Transactions on Knowledge and Data Engineering, 1990
- Maintaining materialized views without accessing base dataInformation Systems, 1988
- Partitioned storage for temporal databasesInformation Systems, 1988
- Approximating the number of unique values of an attribute without sortingInformation Systems, 1987
- Deadlock detection in distributed databasesACM Computing Surveys, 1987
- The relational model with relation-valued attributesInformation Systems, 1986