Abstract
Query optimization is a hard combinatorial optimization problem, which makes enumerative optimization strategies unacceptable as the query size grows. In order to cope with complex large join queries, combinatorial optimization algorithms, such as Simulating Annealing and Iterative Improvement were proposed as alternatives to traditional enumerative algorithms. In this paper, we propose to apply to optimization of complex large join queries the relatively new combinatorial optimization technique called Tabu Search. We have tested this technique on queries of different sizes and different types and have shown that Tabu Search obtains almost always better query execution plans than other combinatorial optimization techniques.
Preview
Unable to display preview. Download preview PDF.
References
W. W. Chu and P. Hurley, Optimal Query Processing for Distributed Database Systems, IEEE Transactions on Computers C-31 (9), 1982, pp. 835–850.
D.H. Fishman, et. al., IRIS: An Object-Oriented DBMS, ACM Transactions on Office Information Systems, 5(1), 1987, pp. 48–69.
F. Glover, Tabu Search-part I, ORSA Journal on Computing 1(1989), pp.190–206.
F. Glover, Tabu Search-part II, ORSA Journal on Computing 2(1990), pp.4–32.
D. E. Goldberg, Genetic Algorithms in Search, Optimization and Machine Learning, Addison-Wesley, 1989.
G. Graefe, R. L. Cole, D. L. Davison, W. J. McKenna, and R. H. Wolniewicz, Extensible Query Optimization and Parallel Execution in Volcano, in Query Processing for Advanced Database Applications (eds. J. C. Freytag, G. Vossen and D. Maier), Morgan-Kaufman, San Mateo, CA, 1992.
G. Graefe and W. J. McKenna, The Volcano Optimizer Generator: Extensibility and Efficient Search, Proc. of the 9th Conference on Data Engineering, Vienna, Austria, 1993, pp. 209–218.
P. Hansen, B. Jaaumard, Algorithms for the maximum satisfiability problem, RUT-COR research report 43–87, Rutgers University, 1987.
A. Hertz, D. de Werra, Using Tabu Search Techniques for Graph Coloring, Computing, Vol. 39, pp. 345–351, 1987.
T. Ibaraki and T. Kameda, Optimal Nesting for Computing N-relational Joins, ACM Transactions on Database Systems, 9(3), 1984, pp. 482–502.
Y. E. Ioannidis and Y. Kang, Randomized Algorithms for Optimizing Large Join Queries, Proc. of ACM-SIGMOD Conference on Management of Data, 1990, pp. 312–321.
Y. E. Ioannidis and Y. Kang, Left-Deep vs. Bushy Trees: An Analysis of Strategy Spaces and its Implications for Query Optimization, Proc. of ACM-SIGMOD Conference on Management of Data, 1991, pp. 168–177.
Y. E. Ioannidis and E. Wong, Query Optimization by Simulated Annealing, Proc. of ACM-SIGMOD Conference on Management of Data, 1987, pp. 9–22.
M. Jarke and J. Koch, Query Optimization in Database Systems, ACM Computing Surveys, Vol. 16, No. 2, 1984, pp. 111–152.
R. Krishnamurthy, H. Boral, and C. Zaniola, Optimization of Nonrecursive Queries, Proc. of the 12th VLDB Conference, Kyoto, Japan, 1986, pp. 128–137.
G.M. Lohman, C. Mohan, L.M. Haas, B.G. Lindsay, P.G. Salinger, P.F. Wilms, and D. Daniels, Query Processing in R *, Query Processing in Database Systems (Kim, Batory, and Reiner (eds.), 1985), pp.31–47, Springer-Verlag Pub.
K. Ono and G. M. Lohman, Measuring the Complexity of Join Enumeration in Query Optimization, Proc. of the 16th VLDB Conference, Brisbane, Australia, 1990, pp. 314–325.
P.G. Selinger, M.M. Astrahan, D.D. Chamberlin, R.A. Lorie, and T.G. Price, Access Path Selection in a Relational Database Management System, Proc. of ACM-SIGMOD, 1979, pp. 23–34.
A. Swami, Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques, Proc. of ACM-SIGMOD Conference on Management of Data, 1989, pp. 367–376.
A. Swami and A. Gupta, Optimization of Large Join Queries, Proc. of ACM-SIGMOD Conference on Management of Data, 1988, pp.8–17.
A. Swami and B. R. Iyer, A Polynomial Time Algorithm for Optimizing Join Queries, Proc. of the 9th IEEE Conference on Data Engineering, Vienna, Austria, 1993, pp. 345–354.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Morzy, T., Matysiak, M., Salza, S. (1994). Tabu search optimization of large join queries. In: Jarke, M., Bubenko, J., Jeffery, K. (eds) Advances in Database Technology — EDBT '94. EDBT 1994. Lecture Notes in Computer Science, vol 779. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-57818-8_60
Download citation
DOI: https://doi.org/10.1007/3-540-57818-8_60
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-57818-5
Online ISBN: 978-3-540-48342-7
eBook Packages: Springer Book Archive