Database Paper Browser

Back to papers

Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited

Summary: Empirical re-evaluation of in-memory, multi-core joins comparing sort-merge (NUMA-aware) and radix-hash. Radix-hash remains superior; sort-merge only matches it at very large data volumes; fastest implementations and hardware-conscious guidance are provided. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
10963
Venue
VLDB
Year
2014
Pagerank
0.0002353359
Overall Rank
248 | 98.28%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 81 citing papers.

Rank Citing Paper Year Venue Pagerank
232 Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age 2014 SIGMOD 0.00024053681
631 Rethinking SIMD Vectorization for In-Memory Databases 2015 SIGMOD 0.0001567363
845 Cache locality is not enough: High-Performance Nearest Neighbor Search with Product Quantization Fast Scan 2016 VLDB 0.00013697323
869 Rack-Scale In-Memory Join Processing using RDMA 2015 SIGMOD 0.00013544947
939 Memory-Efficient Hash Joins 2015 VLDB 0.00013119219
952 The End of Slow Networks: It's Time for a Redesign 2016 VLDB 0.00013057502
1,134 DimmWitted: A Study of Main-Memory Statistical Analytics 2014 VLDB 0.00012114015
1,167 A Comprehensive Study of Main-Memory Partitioning and its Application to Large-Scale Comparison- and Radix-Sort 2014 SIGMOD 0.00011962775
1,244 An Experimental Comparison of Thirteen Relational Equi-Joins in Main Memory 2016 SIGMOD 0.00011578969
1,472 A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 2020 SIGMOD 0.00010732517
1,761 ByteSlice: Pushing the Envelop of Main Memory Data Processing with a New Storage Layout 2015 SIGMOD 9.896048e-05
1,969 Track Join: Distributed Joins with Minimal Network Traffic 2014 SIGMOD 9.4734585e-05
2,245 Cache-Efficient Aggregation: Hashing Is Sorting 2015 SIGMOD 8.9438948e-05
2,355 Parallel Data Analysis Directly on Scientific File Formats 2014 SIGMOD 8.7760682e-05
2,627 A Memory Bandwidth-Efficient Hybrid Radix Sort on GPUs 2017 SIGMOD 8.3942863e-05
2,890 Distributed Join Algorithms on Thousands of Cores 2017 VLDB 8.0599178e-05
2,923 To Partition, or Not to Partition, That is the Join Question in a Real System 2021 SIGMOD 8.0260054e-05
3,077 Extracting Top-K Insights from Multi-dimensional Data 2017 SIGMOD 7.8500127e-05
3,104 Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment 2021 VLDB 7.821278e-05
3,391 Improving Main Memory Hash Joins on Intel Xeon Phi Processors: An Experimental Approach 2015 VLDB 7.5236414e-05
3,441 RUMA has it: Rewired User-space Memory Access is Possible! 2016 VLDB 7.478809e-05
3,613 Fast Queries Over Heterogeneous Data Through Engine Customization 2016 VLDB 7.3244021e-05
3,657 Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads 2021 SIGMOD 7.2857285e-05
3,725 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR 7.2359749e-05
3,825 The Case for a Learned Sorting Algorithm 2020 SIGMOD 7.1511577e-05
3,950 Tensors: An abstraction for general data processing 2021 VLDB 7.069497e-05
3,953 Scaling Up Concurrent Main-Memory Column-Store Scans: Towards Adaptive NUMA-aware Data and Task Placement 2015 VLDB 7.0678334e-05
3,969 PARADIS: An Efficient Parallel Algorithm for In-place Radix Sort 2015 VLDB 7.056455e-05
4,119 SIMD- and Cache-Friendly Algorithm for Sorting an Array of Structures 2015 VLDB 6.952036e-05
4,482 Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects 2022 SIGMOD 6.7350602e-05
4,508 Adaptive NUMA-aware data placement and task scheduling for analytical workloads in main-memory column-stores 2017 VLDB 6.723068e-05
4,537 The Art of Balance: A RateupDBTM Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.7115627e-05
4,580 MQJoin: Efficient Shared Execution of Main-Memory Joins 2016 VLDB 6.6916493e-05
4,777 FPGA-based Data Partitioning 2017 SIGMOD 6.5814136e-05
5,011 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.4695774e-05
5,049 On the Surprising Difficulty of Simple Things: the Case of Radix Partitioning 2015 VLDB 6.4542093e-05
5,115 Density-optimized Intersection-free Mapping and Matrix Multiplication for Join-Project Operations 2022 VLDB 6.4228413e-05
5,447 FPGA-based Multithreading for In-Memory Hash Joins 2015 CIDR 6.2838155e-05
5,518 Distributed GPU Joins on Fast RDMA-capable Networks 2023 SIGMOD 6.2532393e-05
5,682 Charting the Design Space of Query Execution using VOILA 2021 VLDB 6.1875556e-05
6,051 Patience is a Virtue: Revisiting Merge and Sort on Modern Processors 2014 SIGMOD 6.0550809e-05
6,055 Data Partitioning for In-Memory Systems: Myths, Challenges, and Opportunities 2019 CIDR 6.0541822e-05
6,160 The 3D Hash Join: Building On Non-Unique Join Attributes 2022 CIDR 6.0319298e-05
6,164 Elastic Pipelining in an In-Memory Database Cluster 2016 SIGMOD 6.0304568e-05
6,460 A Morsel-Driven Query Execution Engine for Heterogeneous Multi-Cores 2019 VLDB 5.9293379e-05
6,495 What Is the Price for Joining Securely? Benchmarking Equi-Joins in Trusted Execution Environments 2022 VLDB 5.9185619e-05
6,669 Evaluating Multi-GPU Sorting with Modern Interconnects 2022 SIGMOD 5.8676379e-05
7,016 MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model 2020 VLDB 5.7830692e-05
7,159 Fast Multi-Column Sorting in Main-Memory Column-Stores 2016 SIGMOD 5.7449713e-05
7,634 NOCAP: Near-Optimal Correlation-Aware Partitioning Joins 2023 SIGMOD 5.6365306e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

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

Previous Page 1 / 1 Next

Semantically Similar Papers