DBScholar

Back to papers

Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory

Summary: Analyzes shared-memory multiprocessor hash joins with processor-proportional memory and a global hash table, modeling synchronization and processing costs. Shows hybrid hash join is not universally optimal: hash-based nested loops wins elapsed time for similarly sized inputs. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
8134
Venue
VLDB
Year
1990
Pagerank
8.5330174e-05
Overall Rank
2,470 | 83.06%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{lu_vldb90,
        title = {{Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory}},
        author = {Lu, Hongjun and Tan, Kian-Lee and Shan, Ming-Chien},
        journal = {PVLDB},
        series = {{VLDB} '90},
        pages = {198},
        year = {1990}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank Citing Paper Year Venue Pagerank
209 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB 0.00024932174
631 Relational Joins on Graphics Processors 2008 SIGMOD 0.00015591241
1,720 Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins 1992 VLDB 9.9265634e-05
2,104 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB 9.1594086e-05
3,250 On Optimal Processor Allocation To Support Pipelined Hash Joins 1993 SIGMOD 7.597429e-05
3,508 Multi-Join Optimization for Symmetric Multiprocessors 1993 VLDB 7.3566888e-05
3,863 Using Shared Virtual Memory for Parallel Join Processing 1993 SIGMOD 7.0649349e-05
4,652 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD 6.5851924e-05
4,668 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB 6.5761032e-05
6,515 Revisiting Pipelined Parallelism in Multi-Join Query Processing 2005 VLDB 5.8550491e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

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

Rank Cited Paper Year Venue Pagerank
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00083340894
80 Hashing Methods and Relational Algebra Operations 1984 VLDB 0.00036536643
152 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00029038365
242 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD 0.00023604323
1,650 Some Experimental Results on Distributed Join Algorithms in a Local Network 1985 VLDB 0.00010115373
3,011 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD 7.8532781e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 8,904 A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory 2023 VLDB
2 4,652 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD
3 904 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB
4 252 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB
5 209 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB
6 3,011 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD
7 4,668 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB
8 152 Multiprocessor Hash-Based Join Algorithms 1985 VLDB
9 242 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD
10 360 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD