Skip to main content
SpringerLink
Log in
Book cover

Encyclopedia of Database Systems pp 1849–1852Cite as

Multi-Query Optimization

  • Reference work entry

Synonyms

Multiple query optimization; Global query optimization; Common subexpression elimination; 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 sub-expressions (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...

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   2,500.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Recommended Reading

  1. Dalvi N.N., Sanghai S.K., Roy P., and Sudarshan S. Pipelining in multi-query optimization. J. Comput. Syst. Sci., 66(4):728–762, 2003.

    Article  MathSciNet  MATH  Google Scholar 

  2. Diwan A.A., Sudarshan S., and Thomas D. Scheduling and Caching in Multi-Query Optimization. In Proc. 13th Int. Conf. Management of Data, 2006.

    Google Scholar 

  3. Fan W., Yu J.X., Lu H., Lu J., and Rastogi R. Query translation from XPATH to SQL in the presence of recursive DTDs. In Proc. 31st Int. Conf. on Very Large Data Bases, 2005, pp. 337–348.

    Google Scholar 

  4. Graefe G. and McKenna W.J. The Volcano Optimizer Generator: Extensibility and Efficient Search. In Proc. 9th Int. Conf. on Data Engineering, 1993, pp. 209–218.

    Google Scholar 

  5. Krishnamurthy S., Wu C., and Franklin M. On-the-fly sharing for streamed aggregation. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 2006, pp. 623–634.

    Google Scholar 

  6. Mistry H., Roy P., Sudarshan S., and Ramamritham K. Materialized view selection and maintenance using multi-query optimization. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 2001, pp. 307–318.

    Google Scholar 

  7. Park J. and Segev A. Using common subexpressions to optimize multiple queries. In Proc. 4th Int. Conf. on Data Engineering, 1988, pp. 311–319.

    Google Scholar 

  8. Rao J. and Ross K.A. Reusing invariants: a new strategy for correlated queries. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 1998, pp. 37–48.

    Google Scholar 

  9. Rosenthal A. and Chakravarthy U.S. Anatomy of a modular multiple query optimizer. In Proc. 14th Int. Conf. on Very Large Data Bases, 1988, pp. 230–239.

    Google Scholar 

  10. Roy P., Seshadri S., Sudarshan S., and Bhobe S. Efficient and extensible algorithms for multi query optimization. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 2000, pp. 249–260.

    Google Scholar 

  11. Sellis T.K. Multiple query optimization. ACM Trans. Database Syst., 13(1):23–52, 1988.

    Article  Google Scholar 

  12. Shim K., Sellis T., and Nau D. Improvements on a heuristic algorithm for multiple-query optimization. Data Knowl. Eng., 12:197–222, 1994.

    Article  Google Scholar 

  13. Subramanian S.N. and Venkataraman S. Cost-based optimization of decision support queries using transient views. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 1998, pp. 319–330.

    Google Scholar 

  14. Zhou J., Larson P.Å., Freytag J.C., and Lehner W. Efficient exploitation of similar subexpressions for query processing. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 2007, pp. 533–544.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Aster Data Systems, Inc., Redwood City, CA, USA

    Prasan Roy

  2. Indian Institute of Technology, Bombay, India

    S. Sudarshan

Authors
  1. Prasan Roy
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. S. Sudarshan
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. College of Computing, Georgia Institute of Technology, 266 Ferst Drive, 30332-0765, Atlanta, GA, USA

    LING LIU (Professor) (Professor)

  2. Database Research Group David R. Cheriton School of Computer Science, University of Waterloo, 200 University Avenue West, N2L 3G1, Waterloo, ON, Canada

    M. TAMER ÖZSU (Professor and Director, University Research Chair) (Professor and Director, University Research Chair)

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer Science+Business Media, LLC

About this entry

Cite this entry

Roy, P., Sudarshan, S. (2009). Multi-Query Optimization. In: LIU, L., ÖZSU, M.T. (eds) Encyclopedia of Database Systems. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-39940-9_239

Download citation

Publish with us

Policies and ethics

Search

Navigation