The EXODUS optimizer generator
- 1 December 1987
- journal article
- conference paper
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 16 (3) , 160-172
- https://doi.org/10.1145/38714.38734
Abstract
This paper presents the design and an initial performance evaluation of the query optimizer generator designed for the EXODUS extensible database system. Algebraic transformation rules are translated into an executable query optimizer, which transforms query trees and selects methods for executing operations according to cost functions associated with the methods. The search strategy avoids exhaustive search and it modifies itself to take advantage of past experience. Computational results show that an optimizer generated for a relational system produces access plans almost as good as those produced by exhaustive search, with the search time cut to a small fraction.Keywords
This publication has 16 references indexed in Scilit:
- Programming constructs for database system implementation in EXODUSPublished by Association for Computing Machinery (ACM) ,1987
- Rule-based transformation of relational queries into iterative programsPublished by Association for Computing Machinery (ACM) ,1986
- Query Optimization in Database SystemsACM Computing Surveys, 1984
- Making smalltalk a database systemPublished by Association for Computing Machinery (ACM) ,1984
- Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate FunctionsJournal of the ACM, 1982
- Access paths in the "Abe" statistical query facilityPublished by Association for Computing Machinery (ACM) ,1982
- The functional data model and the data languages DAPLEXACM Transactions on Database Systems, 1981
- An optimal evaluation of Boolean expressions in an online query systemCommunications of the ACM, 1977
- System RACM Transactions on Database Systems, 1976
- Optimizing the performance of a relational algebra database interfaceCommunications of the ACM, 1975