|
| This Article | ||
| ||
| Share | ||
| Bibliographic References | ||
| Add to: | ||
| | ||
| Search | ||
| ||
20th International Conference on Data Engineering (ICDE'04)
An Efficient Framework for Order Optimization
Boston, Massachusetts
March 30-April 02
ISBN: 0-7695-2065-0
| ASCII Text | x | ||
| Thomas Neumann, Guido Moerkotte, "An Efficient Framework for Order Optimization," Data Engineering, International Conference on, pp. 461, 20th International Conference on Data Engineering (ICDE'04), 2004. | |||
| BibTex | x | ||
| @article{ 10.1109/ICDE.2004.1320019, author = {Thomas Neumann and Guido Moerkotte}, title = {An Efficient Framework for Order Optimization}, journal ={Data Engineering, International Conference on}, volume = {0}, year = {2004}, issn = {1063-6382}, pages = {461}, doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2004.1320019}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, } | |||
| RefWorks Procite/RefMan/Endnote | x | ||
| TY - CONF JO - Data Engineering, International Conference on TI - An Efficient Framework for Order Optimization SN - 1063-6382 SP EP A1 - Thomas Neumann, A1 - Guido Moerkotte, PY - 2004 KW - null VL - 0 JA - Data Engineering, International Conference on ER - | |||
Since the introduction of cost-based query optimization, the performance-critical role of interesting orders has been recognized. Some algebraic operators change interesting orders (e.g. sort and select), while others exploit interesting orders (e.g. merge join). The two operations performed by any query optimizer during plan generation are 1) computing the resulting order given an input order and an algebraic operator and 2) determining the compatibility between a given input order and the required order a given algebraic operator can beneficially exploit. Since these two operations are called millions of times during plan generation, they are highly performance-critical. The third crucial parameter is the space requirement for annotating every plan node with its output order. Lately, a powerful framework for reasoning about orders has been developed, which is based on functional dependencies. Within this framework, the current state-of-the-art algorithms for implementing the above operations both have a lower bound time requirement of Ω(n), where n is the number of functional dependencies involved. Further, the lower bound for the space requirement for every plan node is Ω(n). We improve these bounds by new algorithms with upper time bounds O(1). That is, our algorithms for both operations work in constant time during plan generation, after a one-time preparation step. Further, the upper bound for the space requirement for plan nodes is O(1) for our approach. Besides, our algorithm reduces the search space by detecting and ignoring irrelevant orderings. Experimental results with a full fledged query optimizer show that our approach significantly reduces the total time needed for plan generation. As a corollary of our experiments, it follows that the time spent for order processing is a non-negligible part of plan generation.
Citation:
Thomas Neumann, Guido Moerkotte, "An Efficient Framework for Order Optimization," icde, pp.461, 20th International Conference on Data Engineering (ICDE'04), 2004
Usage of this product signifies your acceptance of the Terms of Use.
