Skip to main content

Parallel Query Optimization

  • Reference work entry
  • First Online:
Book cover Encyclopedia of Database Systems
  • 184 Accesses

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

  1. Ballinger C, Fryer R. Born to be parallel. why parallel origins give teradata an enduring performance edge. IEEE Data Eng Bull. 1997;20(2):3–12.

    Google Scholar 

  2. Barclay T, Barnes R, Gray J, Sundaresan P. Loading databases using dataflow parallelism. ACM SIGMOD Rec. 1994;23(4):72–83.

    Article  Google Scholar 

  3. Baru CK, Fecteau G, Goyal A, Hsiao H-I, Jhingran A, Padmanabhan S, Wilson WG. An overview of DB2 parallel edition. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1995. p. 460–2.

    Google Scholar 

  4. Boral H, Alexander W, Clay L, Copeland GP, Danforth S, Franklin MJ, Hart BE, Smith MG, Valduriez P. Prototyping Bubba, a highly parallel database system. IEEE Trans Knowl Data Eng. 1990;2(1): 4–24.

    Article  Google Scholar 

  5. Bratbergsengen K. Algebra operations on a parallel computer – performance evaluation. In: Proceedings of the 5th International Workshop on Data Machines; 1987. p. 415–28.

    Google Scholar 

  6. Chen A, Kao Y-F, Pong M, Shak D, Sharma S, Vaishnav J, Zeller H. Query processing in nonstop SQL. IEEE Data Eng Bull. 1993;16(4):29–41.

    Google Scholar 

  7. DeWitt DJ, Gerber RH, Graefe G, Heytens ML, Kumar KB, Muralikrishna M. GAMMA – a high performance dataflow database machine. In: Proceedings of the 12th International Conference on Very Large Data Bases; 1986. p. 228–37.

    Google Scholar 

  8. DeWitt DJ, Gray J. Parallel database systems: the future of high performance database systems. Commun ACM. 1992;35(6):85–98.

    Article  Google Scholar 

  9. DeWitt DJ, Smith M, Boral H. A single-user performance evaluation of the Teradata database machine. In: Proceedings of the 2nd International Workshop on High Performance Transaction Systems; 1987.

    Google Scholar 

  10. Fushimi S, Kitsuregawa M, Tanaka H. An overview of the system software of a parallel relational database machine GRACE. In: Proceedings of the 12th International Conference on Very Large Data Bases; 1986. p. 209–19.

    Google Scholar 

  11. Graefe G. Encapsulation of parallelism in the volcano query processing system. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1990. p. 102–11.

    Google Scholar 

  12. Graefe G, Davison DL. Encapsulation of parallelism and architecture-independence in extensible database query execution. IEEE Trans Softw Eng. 1993;19(8):749–64.

    Article  Google Scholar 

  13. Jhingran A, Malkemus T, Padmanabhan S. Query optimization in DB2 parallel edition. IEEE Data Eng. Bull. 1997;20(2):27–34.

    Google Scholar 

  14. Lee MK, Freytag JC, Lohman GM. Implementing an interpreter for functional rules in a query optimizer. In: Proceedings of the 14th International Conference on Very Large Data Bases; 1988. p. 218–29.

    Google Scholar 

  15. Mohan C, Pirahesh H, Tang WG, Wang Y. Parallelism in relational database management systems. IBM Sys J. 1994;33(2):349–71.

    Article  Google Scholar 

  16. Neches PM. The anatomy of a database computer system. In: Digest of papers – COMPCON; 1985. p. 252–4.

    Google Scholar 

  17. Selinger P, Astrahan M, Chamberlin D, Lorie R, Price T. Access path selection in a relational database management system. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1979. p. 23–34.

    Google Scholar 

  18. Stonebraker M, Katz RH, Patterson DA, Ousterhout JK. The design of XPRS. In: Proceedings of the 14th International Conference on Very Large Data Bases; 1988. p. 318–30.

    Google Scholar 

  19. von Bueltzingsloewen G. Optimizing SQL queries for parallel execution. In: Proceedings of the ODBF Workshop on Database Query Optimization; 1989.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Goetz Graefe .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Zeller, H., Graefe, G. (2018). Parallel 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_1079

Download citation

Publish with us

Policies and ethics