Design and Evaluation of Parallel Pipelined Join Algorithms

Summary: Parallel, pipelined join algorithms for DBMSs: sort-merge, hashing, hybrids. Analytical analysis shows hash-partitioning reduces time; hash methods beat sort-merge in cases, with replication of the smaller relation and shared memory providing gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2361
Venue: SIGMOD
Year: 1987
Pagerank: 8.3924401e-05
Overall Rank: 2,640 | 81.64%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
463	The Design Of Xprs	1988	VLDB	0.00022464669
861	A Taxonomy and Performance Model of Data Skew Effects in Parallel Joins	1991	VLDB	0.00015848554
1,847	Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins	1992	VLDB	0.00010333796
2,619	Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory	1990	VLDB	8.4431973e-05
7,976	On the Optimality of Strategies for Multiple Joins	1990	PODS	4.613363e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
9	Implementation Techniques For Main Memory Database Systems	1984	SIGMOD	0.0014279444
20	GAMMA - A High Performance Dataflow Database Machine	1986	VLDB	0.00086459551
30	Hashing Methods and Relational Algebra Operations	1984	VLDB	0.00078672446
78	Multiprocessor Hash-Based Join Algorithms	1985	VLDB	0.00056413752
1,278	Some Experimental Results on Distributed Join Algorithms in a Local Network	1985	VLDB	0.00012868969

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,847	Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins	1992	VLDB	0.00010333796
3,260	On Optimal Processor Allocation To Support Pipelined Hash Joins	1993	SIGMOD	7.3122611e-05
4,460	Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor	1991	VLDB	6.1635864e-05
78	Multiprocessor Hash-Based Join Algorithms	1985	VLDB	0.00056413752
404	Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited	2014	VLDB	0.00024143076
540	Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs	2011	SIGMOD	0.0002063443
351	Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs	2009	VLDB	0.0002636504
4,781	On Parallel Execution Of Multiple Pipelined Hash Joins	1994	SIGMOD	5.9261504e-05
2,619	Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory	1990	VLDB	8.4431973e-05
232	A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment	1989	SIGMOD	0.00032122485