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.
|Title of host publication||ACM SIGMOD International Conference on Management of Data (SIGMOD 1995)|
|Place of Publication||New York, NY, USA|
|Number of pages||12|
|Publication status||Published - May 1995|
- DB-PDB: PARALLEL DATABASES
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