Synonyms
Common subexpression elimination; Global query optimization; Multiple query optimization; Optimization of DAG-structured query evaluation plans
Definition
Multi-query optimization is the task of generating an optimal combined evaluation plan for a collection of multiple queries. Unlike traditional single-query optimization, multi-query optimization can exploit commonalities between queries, for example by computing common subexpressions (i.e., subexpressions that are shared by multiple queries) once and reusing them, or by sharing scans of relations from disk.
Historical Background
Early work on multi-query optimization includes work by Sellis [11], Park and Segev [7] and Rosenthal and Chakravarthy [9]. Shim et al. [12] consider heuristics to reduce the cost of multi-query optimization. However, even with heuristics, these approaches are extremely expensive for situations where each query may have a large number of alternative evaluation plans.
Subramanian and Venkataraman [13...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Dalvi NN, Sanghai SK, Roy P, Sudarshan S. Pipelining in multi-query optimization. J Comput Syst Sci. 2003;66(4):728–62.
Diwan AA, Sudarshan S, Thomas D. Scheduling and caching in multi-query optimization. In: Proceedings of the 13th International Conference on Management of Data; 2006.
Fan W, Yu JX, Lu H, Lu J, Rastogi R. Query translation from XPATH to SQL in the presence of recursive DTDs. In: Proceedings of the 31st International Conference on Very Large Data Bases; 2005. p. 337–48.
Graefe G, McKenna WJ. The volcano optimizer generator: extensibility and efficient search. In: Proceedings of the 9th International Conference on Data Engineering; 1993. p. 209–18.
Krishnamurthy S, Wu C, Franklin M. On-the-fly sharing for streamed aggregation. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2006. p. 623–34.
Mistry H, Roy P, Sudarshan S, Ramamritham K. Materialized view selection and maintenance using multi-query optimization. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2001. p. 307–18.
Park J, Segev A. Using common subexpressions to optimize multiple queries. In: Proceedings of the 4th International Conference on Data Engineering; 1988. p. 311–9.
Rao J, Ross KA. Reusing invariants: a new strategy for correlated queries. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1998. p. 37–48.
Rosenthal A, Chakravarthy US. Anatomy of a modular multiple query optimizer. In: Proceedings of the 14th International Conference on Very Large Data Bases; 1988. p. 230–9.
Roy P, Seshadri S, Sudarshan S, Bhobe S. Efficient and extensible algorithms for multi query optimization. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2000. p. 249–60.
Sellis TK. Multiple query optimization. ACM Trans Database Syst. 1988;13(1):23–52.
Shim K, Sellis T, Nau D. Improvements on a heuristic algorithm for multiple-query optimization. Data Knowl Eng. 1994;12(2):197–222.
Subramanian SN, Venkataraman S. Cost-based optimization of decision support queries using transient views. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1998. p. 319–30.
Zhou J, Larson PÅ, Freytag JC, Lehner W. Efficient exploitation of similar subexpressions for query processing. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2007. p. 533–44.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Roy, P., Sudarshan, S. (2018). Multi-query Optimization. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_239
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_239
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering