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: h4f765816a95b6a48
Venue: VLDB
Year: 2021
Pagerank: 7.9081605e-05
Overall Rank: 2,886 | 80.60%
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 22 of 22 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,626	Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects	2022	SIGMOD	7.1524537e-05
3,655	Tile-based Lightweight Integer Compression in GPU	2022	SIGMOD	7.1260841e-05
3,689	RTIndex: Exploiting Hardware-Accelerated GPU Raytracing for Database Indexing	2023	VLDB	7.0943075e-05
3,888	Orchestrating Data Placement and Query Execution in Heterogeneous CPU-GPU DBMS	2022	VLDB	6.945725e-05
4,137	The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product	2021	VLDB	6.7861661e-05
5,371	Distributed GPU Joins on Fast RDMA-capable Networks	2023	SIGMOD	6.1584802e-05
5,541	Vortex: Overcoming Memory Capacity Limitations in GPU-Accelerated Large-Scale Data Analytics	2025	VLDB	6.0902254e-05
5,615	BOSS - An Architecture for Database Kernel Composition	2024	VLDB	6.0652416e-05
6,151	Efficiently Processing Joins and Grouped Aggregations on GPUs	2025	SIGMOD	5.8697699e-05
6,414	Evaluating Multi-GPU Sorting with Modern Interconnects	2022	SIGMOD	5.7927521e-05
6,667	Powerful GPUs or Fast Interconnects: Analyzing Relational Workloads on Modern GPUs	2025	VLDB	5.7152948e-05
7,097	Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs	2023	SIGMOD	5.601767e-05
8,236	Scaling your Hybrid CPU-GPU DBMS to Multiple GPUs	2024	VLDB	5.3710413e-05
8,274	Scaling GPU-Accelerated Databases beyond GPU Memory Size	2025	VLDB	5.3642256e-05
8,595	A Case for Graphics-driven Query Processing	2023	VLDB	5.3062403e-05
9,429	Efficiently Joining Large Relations on Multi-GPU Systems	2025	VLDB	5.1786456e-05
9,863	GPU Acceleration of SQL Analytics on Compressed Data	2026	VLDB	5.1176637e-05
10,042	MEMO: Fine-grained Tensor Management For Ultra-long Context LLM Training	2025	SIGMOD	5.0921006e-05
10,723	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB	4.9793485e-05
10,905	ZipFlow: a Compiler-based Framework to Unleash Compressed Data Movement for Modern GPUs	2026	VLDB	4.9793485e-05
10,906	RayBooster: A Ray Tracing Engine to Accelerate SedonaDB	2026	VLDB	4.9793485e-05
11,865	Scaling Equi-Joins	2022	SIGMOD	4.9793485e-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
210	Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs	2009	VLDB	0.00024851502
251	Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited	2014	VLDB	0.00023143736
361	Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs	2011	SIGMOD	0.00020006406
423	Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems	2012	VLDB	0.00018491327
616	Relational Joins on Graphics Processors	2008	SIGMOD	0.00015561564
771	The Yin and Yang of Processing Data Warehousing Queries on GPU Devices	2013	VLDB	0.00014085862
969	Memory-Efficient Hash Joins	2015	VLDB	0.0001278184
2,122	Revisiting Co-Processing for Hash Joins on the Coupled CPU-GPU Architecture	2013	VLDB	9.0084047e-05

Semantically Similar Papers

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