Abstract
Query optimizers in current database management systems (DBMS) often face problems such as intolerably long optimization time and/or poor optimization results when optimizing complex queries. To tackle this challenge, we present a new similarity-based optimization technique in this paper. The key idea is to identify groups of similar subqueries that often appear in a complex query and share the optimization result within each group in the query. An efficient algorithm to identify similar queries in a given query and optimize the query based on similarity is presented. Our experimental results demonstrate that the proposed technique is quite promising in optimizing complex queries in a DBMS.
Research supported by the IBM Toronto Lab and The University of Michigan.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bennett, K., Ferris, M.C., Ioannidis, Y.: A genetic algorithm for database query optimization. In: Proc. of Int’l Conf. on Genetic Algorithms, pp. 400–407 (1991)
Chaudhuri, S.: An overview of query optimization in relational systems. In: Proc. of ACM PODS, pp. 34–43 (1998)
Graefe, G.: Query Evaluation Techniques for Large Databases. ACM Comp. Surveys 25(2), 111–152 (1993)
Ibaraki, T., Kameda, T.: On the optimal nesting order for computing N-relational joins. ACM Trans. on DB Syst. 9(3), 482–502 (1984)
Ioannidis, Y.E., Wong, E.: Query Optimization by Simulated Annealing. In: Proc. of ACM SIGMOD, pp. 9–22 (1987)
Jarke, M., Koch, J.: Query Optimization in Database Systems. ACM Comp. Surveys 16(2), 111–152 (1984)
Matysiak, M.: Efficient Optimization of Large Join Queries Using Tabu Search. Infor. Sci. 83(1-2) (1995)
Selinger, P.G., et al.: Access Path Selection in a Relational Database Management System. In: Proc. of ACM SIGMOD, pp. 23–34 (1979)
Swami, A., Iyer, B.R.: A polynomial time algorithm for optimizing join queries. In: Proc. of IEEE ICDE, pp. 345–354 (1993)
Swami, A., Gupta, A.: Optimization of Large Join Queries. In: Proc. of ACM SIGMOD, pp. 8–17 (1988)
Tao, Y., Zhu, Q., Zuzarte, C.: Exploiting Common Subqueries for Complex Query Optimization. In: Proc. of CASCON, pp. 21–34 (2002)
Tao, Y., Zhu, Q., Zuzarte, C.: Optimizing Complex Queries by Exploiting Similarities of Subqueries. Technical Report CIS-TR-0301-03, CIS Dept, U. of Michigan, Dearborn, MI 48128, USA (March 2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Tao, Y., Zhu, Q., Zuzarte, C. (2003). Exploiting Similarity of Subqueries for Complex Query Optimization. In: MaÅ™Ãk, V., Retschitzegger, W., Å tÄ›pánková, O. (eds) Database and Expert Systems Applications. DEXA 2003. Lecture Notes in Computer Science, vol 2736. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45227-0_73
Download citation
DOI: https://doi.org/10.1007/978-3-540-45227-0_73
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40806-2
Online ISBN: 978-3-540-45227-0
eBook Packages: Springer Book Archive