Parallel evaluation of multi-join queries

Research output: Chapter in Book/Report/Conference proceedingChapterAcademicpeer-review

47 Citations (Scopus)
117 Downloads (Pure)

Abstract

A number of execution strategies for parallel evaluation of multi-join queries have been proposed in the literature; their performance was evaluated by simulation. In this paper we give a comparative performance evaluation of four execution strategies by implementing all of them on the same parallel database system, PRISMA/DB. Experiments have been done up to 80 processors. The basic strategy is to first determine an execution schedule with minimum total cost and then parallelize this schedule with one of the four execution strategies. These strategies, coming from the literature, are named: Sequential Parallel, Synchronous Execution, Segmented Right-Deep, and Full Parallel. Based on the experiments clear guidelines are given when to use which strategy.
Original languageUndefined
Title of host publicationACM SIGMOD International Conference on Management of Data (SIGMOD 1995)
Place of PublicationNew York, NY, USA
PublisherACM Press
Pages115-126
Number of pages12
ISBN (Print)0-89791-731-6
DOIs
Publication statusPublished - May 1995

Publication series

Name
PublisherACM Press

Keywords

  • EWI-7369
  • IR-66477
  • DB-PDB: PARALLEL DATABASES

Cite this

Wilschut, A. N., Flokstra, J., & Apers, P. M. G. (1995). Parallel evaluation of multi-join queries. In ACM SIGMOD International Conference on Management of Data (SIGMOD 1995) (pp. 115-126). [10.1145/223784.223803] New York, NY, USA: ACM Press. https://doi.org/10.1145/568271.223803, https://doi.org/10.1145/223784.223803