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
h8e3b9639cb7dc020
Venue
VLDB
Year
1990
Pagerank
8.3437209e-05
Overall Rank
2,515 | 83.15%
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
212 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB 0.00024786576
610 Relational Joins on Graphics Processors 2008 SIGMOD 0.00015540189
1,746 Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins 1992 VLDB 9.718559e-05
2,151 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB 8.9483042e-05
3,310 On Optimal Processor Allocation To Support Pipelined Hash Joins 1993 SIGMOD 7.4176249e-05
3,583 Multi-Join Optimization for Symmetric Multiprocessors 1993 VLDB 7.1705907e-05
3,954 Using Shared Virtual Memory for Parallel Join Processing 1993 SIGMOD 6.8871795e-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
6,616 Revisiting Pipelined Parallelism in Multi-Join Query Processing 2005 VLDB 5.7157572e-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.00081781676
83 Hashing Methods and Relational Algebra Operations 1984 VLDB 0.00035942723
156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00028431734
249 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD 0.00023099455
1,676 Some Experimental Results on Distributed Join Algorithms in a Local Network 1985 VLDB 9.8971983e-05
3,072 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD 7.6662888e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 9,093 A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory 2023 VLDB
2 4,713 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD
3 921 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB
4 250 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB
5 212 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB
6 3,072 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD
7 4,775 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB
8 156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB
9 249 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