DBScholar

Back to papers

A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment

Summary: Parallel-join comparison of Grace, Hybrid hash, Simple hash, and sort-merge on a shared-nothing Gamma. Vary distribution, memory, and bit-vector filters; Hybrid hash dominates, but skewed inner keys with limited memory favor sort-merge. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h206c14c6b46bfef0
Venue
SIGMOD
Year
1989
Pagerank
0.00023099455
Overall Rank
249 | 98.34%
DOI
10.1145/67544.66937

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{schneider_sigmod89,
        title = {{A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment}},
        author = {Schneider, Donovan A. and DeWitt, David J.},
        series = {{SIGMOD} '89},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/67544.66937},
        url = {https://dl.acm.org/doi/10.1145/67544.66937},
        year = {1989}
}

Incoming Citations (Sorted by Pagerank)

Showing 45 of 45 citing papers.

Rank Citing Paper Year Venue Pagerank
220 An Evaluation of Non-Equijoin Algorithms 1991 VLDB 0.00024275691
250 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB 0.00023080446
359 Efficient Parallel Set-Similarity Joins Using MapReduce 2010 SIGMOD 0.00019963275
448 Query Optimization for Parallel Execution 1992 SIGMOD 0.00018120468
491 Practical Skew Handling in Parallel Joins 1992 VLDB 0.00017383221
610 Relational Joins on Graphics Processors 2008 SIGMOD 0.00015540189
799 A Comparison of Join Algorithms for Log Processing in MapReduce 2010 SIGMOD 0.00013839554
836 A Taxonomy and Performance Model of Data Skew Effects in Parallel Joins 1991 VLDB 0.00013534835
885 Rack-Scale In-Memory Join Processing using RDMA 2015 SIGMOD 0.00013222753
888 Requirements for Science Data Bases and SciDB 2009 CIDR 0.00013213294
921 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB 0.00013036878
1,215 Bucket Spreading Parallel Hash: A New, Robust, Parallel Hash Join Method for Data Skew in the Super Database Computer (SDC) 1990 VLDB 0.0001147464
1,259 Handling Data Skew in Multiprocessor Database Computers Using Partition Tuning 1991 VLDB 0.00011296701
1,291 Hybrid-Range Partitioning Strategy: A New Declustering Strategy for Multiprocessor Database Machines 1990 VLDB 0.00011147286
1,419 A Demonstration of SciDB: A Science-Oriented DBMS 2009 VLDB 0.00010704914
1,746 Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins 1992 VLDB 9.718559e-05
1,808 An Adaptive Hash Join Algorithm for Multiuser Environments 1990 VLDB 9.5852314e-05
1,832 A Scalable Hash Ripple Join Algorithm 2002 SIGMOD 9.5365548e-05
2,125 Revisiting Co-Processing for Hash Joins on the Coupled CPU-GPU Architecture 2013 VLDB 8.9903827e-05
2,151 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB 8.9483042e-05
2,240 Spinning Fast Iterative Data Flows 2012 VLDB 8.7716808e-05
2,280 Parallel evaluation of multi-join queries 1995 SIGMOD 8.6972041e-05
2,515 Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory 1990 VLDB 8.3437209e-05
2,694 Parity Striping of Disc Arrays: Low-Cost Reliable Storage with Acceptable Throughput 1990 VLDB 8.1088976e-05
2,972 Scalable and Adaptive Online Joins 2014 VLDB 7.7844791e-05
3,954 Using Shared Virtual Memory for Parallel Join Processing 1993 SIGMOD 6.8871795e-05
3,977 Estimation of Query-Result Distribution and its Application in Parallel-Join Load Balancing 1996 VLDB 6.8707656e-05
4,133 HUGE: An Efficient and Scalable Subgraph Enumeration System 2021 SIGMOD 6.7738028e-05
4,713 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD 6.4397959e-05
4,775 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB 6.4086699e-05
4,809 Applying Hash Filters to Improving the Execution of Bushy Trees 1993 VLDB 6.3910269e-05
4,864 Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems 1993 VLDB 6.3625965e-05
5,680 Skew-Aware Join Optimization for Array Databases 2015 SIGMOD 6.0233693e-05
6,616 Revisiting Pipelined Parallelism in Multi-Join Query Processing 2005 VLDB 5.7157572e-05
6,743 Near-Optimal Distributed Band-Joins through Recursive Partitioning 2020 SIGMOD 5.6766099e-05
7,284 Submodularity of Distributed Join Computation 2018 SIGMOD 5.5505534e-05
7,580 Cache-oblivious High-performance Similarity Join 2019 SIGMOD 5.4754557e-05
7,939 Design Trade-offs for a Robust Dynamic Hybrid Hash Join 2022 VLDB 5.4058938e-05
8,007 Scaling GPU-Accelerated Databases beyond GPU Memory Size 2025 VLDB 5.3916546e-05
8,965 A Parallel Strategy for Transitive Closure using Double Hash-Based Clustering 1990 VLDB 5.2361195e-05
9,878 Implementation and Analysis of a Parallel Collection Query Language 1996 VLDB 5.1046184e-05
11,827 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.9605343e-05
11,915 Scaling Equi-Joins 2022 SIGMOD 4.9605343e-05
12,826 Visualizing the robustness of query execution 2009 CIDR 4.9605343e-05
13,368 Predictive Dynamic Load Balancing of Parallel and Distributed Rule and Query Processing 1994 SIGMOD 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023948467
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00081781676
46 Benchmarking Database Systems: A Systematic Approach 1983 VLDB 0.00044656322
55 GAMMA - A High Performance Dataflow Database Machine 1986 VLDB 0.00040385073
83 Hashing Methods and Relational Algebra Operations 1984 VLDB 0.00035942723
156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00028431734
977 A Benchmark of NonStop SQL on the Debit Credit Transaction 1988 SIGMOD 0.00012712127
6,976 A Performance Analysis of the Gamma Database Machine 1988 SIGMOD 5.6140776e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,886 Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment 2021 VLDB
2 9,093 A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory 2023 VLDB
3 921 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB
4 212 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB
5 4,775 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB
6 250 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB
7 360 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD
8 156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB
9 2,515 Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory 1990 VLDB
10 3,072 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD