Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment

Summary: Multi-GPU join algorithms for very large tables; three designs: nested-loop, global-sort-merge, hybrid. Addresses CPU–GPU data-transfer bottlenecks; shows scalability and up to 25× vs multi-core CPU and 2.8× vs single-GPU. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12775
Venue: VLDB
Year: 2021
Pagerank: 7.7231028e-05
Overall Rank: 3,134 | 78.50%
DOI: 10.14778/3436905.3436927

Incoming Non-self Citations Over Time

Authors

1. Ran Rui (University of South Florida)
2. Hao Li (University of South Florida)
3. Yi-Cheng Tu (University of South Florida)

BibTeX Citation

@article{rui_vldb21,
        title = {{Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment}},
        author = {Rui, Ran and Li, Hao and Tu, Yi-Cheng},
        journal = {PVLDB},
        series = {{VLDB} '21},
        volume = {14},
        number = {4},
        pages = {708--720},
        doi = {10.14778/3436905.3436927},
        url = {https://doi.org/10.14778/3436905.3436927},
        year = {2021}
}

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,144	Tile-based Lightweight Integer Compression in GPU	2022	SIGMOD	6.8744592e-05
4,243	Orchestrating Data Placement and Query Execution in Heterogeneous CPU-GPU DBMS	2022	VLDB	6.8073248e-05
4,535	Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects	2022	SIGMOD	6.6419266e-05
4,603	The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product	2021	VLDB	6.6105578e-05
5,053	RTIndex: Exploiting Hardware-Accelerated GPU Raytracing for Database Indexing	2023	VLDB	6.3844953e-05
5,587	Distributed GPU Joins on Fast RDMA-capable Networks	2023	SIGMOD	6.1596139e-05
6,065	Vortex: Overcoming Memory Capacity Limitations in GPU-Accelerated Large-Scale Data Analytics	2025	VLDB	5.9895288e-05
6,774	Evaluating Multi-GPU Sorting with Modern Interconnects	2022	SIGMOD	5.7778738e-05
6,957	Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs	2023	SIGMOD	5.7303405e-05
7,058	BOSS - An Architecture for Database Kernel Composition	2024	VLDB	5.7154673e-05
7,432	Powerful GPUs or Fast Interconnects: Analyzing Relational Workloads on Modern GPUs	2025	VLDB	5.6199783e-05
7,591	Efficiently Processing Joins and Grouped Aggregations on GPUs	2025	SIGMOD	5.5900315e-05
8,487	A Case for Graphics-driven Query Processing	2023	VLDB	5.4153858e-05
8,808	Scaling your Hybrid CPU-GPU DBMS to Multiple GPUs	2024	VLDB	5.3661351e-05
9,333	Efficiently Joining Large Relations on Multi-GPU Systems	2025	VLDB	5.2887551e-05
9,880	MEMO: Fine-grained Tensor Management For Ultra-long Context LLM Training	2025	SIGMOD	5.2040783e-05
10,541	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB	5.093636e-05
10,580	GPU Acceleration of SQL Analytics on Compressed Data	2026	VLDB	5.093636e-05
10,985	Scaling GPU-Accelerated Databases beyond GPU Memory Size	2025	VLDB	5.093636e-05
11,556	Scaling Equi-Joins	2022	SIGMOD	5.093636e-05

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
209	Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs	2009	VLDB	0.00024932174
252	Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited	2014	VLDB	0.00023242719
360	Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs	2011	SIGMOD	0.00020182846
423	Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems	2012	VLDB	0.00018725853
631	Relational Joins on Graphics Processors	2008	SIGMOD	0.00015591241
823	The Yin and Yang of Processing Data Warehousing Queries on GPU Devices	2013	VLDB	0.00013792901
959	Memory-Efficient Hash Joins	2015	VLDB	0.00012953588
2,140	Revisiting Co-Processing for Hash Joins on the Coupled CPU-GPU Architecture	2013	VLDB	9.0991487e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	209	Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs	2009	VLDB
2	3,011	Design and Evaluation of Parallel Pipelined Join Algorithms	1987	SIGMOD
3	1,320	From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System	2015	SIGMOD
4	2,104	Optimization of Multi-Way Join Queries for Parallel Execution	1991	VLDB
5	5,399	Efficient Massively Parallel Join Optimization for Large Queries*	2022	SIGMOD
6	5,587	Distributed GPU Joins on Fast RDMA-capable Networks	2023	SIGMOD
7	4,535	Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects	2022	SIGMOD
8	7,591	Efficiently Processing Joins and Grouped Aggregations on GPUs	2025	SIGMOD
9	631	Relational Joins on Graphics Processors	2008	SIGMOD
10	9,333	Efficiently Joining Large Relations on Multi-GPU Systems	2025	VLDB