Efficient optimization of a class of relational expressions
ACM Transactions on Database Systems (TODS)
Relational Data-Base Management Systems
ACM Computing Surveys (CSUR)
Optimizing the performance of a relational algebra database interface
Communications of the ACM
A relational model of data for large shared data banks
Communications of the ACM
Access path selection in a relational database management system
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Common expression analysis in database applications
SIGMOD '82 Proceedings of the 1982 ACM SIGMOD international conference on Management of data
Common expression analysis in database applications
SIGMOD '82 Proceedings of the 1982 ACM SIGMOD international conference on Management of data
Hi-index | 0.00 |
An expression applying to a relational database is optimized by mapping the expression upon set expressions which, in turn, are transformed into logical expressions. These logical expressions then are optimized, taking into account the constraints that are inherent in relational expressions and the costs of those expressions. Subsequently a reverse transformation to relational expressions is applied. The method is developed for the traditional relational operators and is applicable to a variety of cost criteria. Common subexpressions as well as redundant expressions are optimized. A new relational operation "split" is proposed that may be used effectively in an optimized expression. Results obtained with a model for the optimization method are presented.