DMCA
Optimizing Join Orders (1993)
| Citations: | 26 - 3 self |
BibTeX
@TECHREPORT{Steinbrunn93optimizingjoin,
author = {Michael Steinbrunn and Guido Moerkotte and Alfons Kemper},
title = {Optimizing Join Orders},
institution = {},
year = {1993}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
Recent developments in database technology, such as deductive database systems, have given rise to the demand for new, cost-effective optimization techniques for join expressions. In this paper many different algorithms that compute approximative solutions for optimizing join orders are studied since traditional dynamic programming techniques are not appropriate for complex problems. First, two possible solution spaces, the space of left-deep and bushy processing trees, respectively, are evaluated from a statistical point of view. The result is that the common limitation to left-deep processing trees is, from a purely statistical point of view, only advisable for certain cost models. Basically, optimizers from three classes are analysed: heuristic, randomized and genetic algorithms. Each one is extensively scrutinized with respect to its working principle and its fitness for the desired application. It turns out that randomized and genetic algorithms are well suited for op...
Keyphrases
join order genetic algorithm statistical point database technology paper many different algorithm deductive database system recent development traditional dynamic programming technique desired application approximative solution left-deep processing tree possible solution space certain cost model cost-effective optimization technique join expression common limitation bushy processing tree complex problem
