Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Parallel Query Processing

  • Esther Pacitti
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1077

Synonyms

Multiprocessor query processing

Definition

Parallel query processing designates the transformation of high-level queries into execution plans that can be efficiently executed in parallel, on a multiprocessor computer. This is achieved by exploiting the way data is placed in parallel and the various execution techniques offered by the parallel database system. As in query processing, the transformation from the query into the execution plan to be executed must be both correct and yield efficient execution. Correctness is obtained by using well-defined mappings in some algebra, e.g., relational algebra, which provides a good abstraction of the execution system. Efficient execution is crucial for high-performance, e.g., good query response time or high query throughput. It is obtained by exploiting efficient parallel execution techniques and query optimization which selects the most efficient parallel execution plan among all equivalent plans.

The main forms of parallelism which...

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

Recommended Reading

  1. 1.
    Graefe G. Query evaluation techniques for large databases. ACM Comput Surv. 1993;25(2):73–170.CrossRefGoogle Scholar
  2. 2.
    Kossmann D. The state of the art in distributed query processing. ACM Comput Surv. 2000;32(4):422–69.CrossRefGoogle Scholar
  3. 3.
    Lanzelotte R, Valduriez P, Zait M, Ziane M. Industrial-strenght parallel query optimization: issues and lessons. Inf Syst. 1994;19(4):311–30.CrossRefGoogle Scholar
  4. 4.
    Özsu MT, Valduriez P. Principles of distributed database systems. 2nd ed. Upper Saddle River: Prentice-Hall; 1999.Google Scholar
  5. 5.
    Valduriez P, Pacitti E. Parallel database systems. In: Hammer J, Scheider M, editors. Handbook of database technology. CRC; 2007.Google Scholar

Copyright information

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

Authors and Affiliations

  1. 1.INRIA and LINAUniversity of NantesNantesFrance

Section editors and affiliations

  • Patrick Valduriez
    • 1
  1. 1.INRIALINANantesFrance