Database Paper Browser

Back to papers

Cache Conscious Algorithms for Relational Query Processing

Summary: Cache-conscious redesign of relational query processing leverages CPU cache hierarchies to narrow the DRAM–CPU gap. Demonstrates 8–200% speedups over traditional algorithms by reordering and structuring operators to maximize cache reuse. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
8219
Venue
VLDB
Year
1994
Pagerank
0.00055548574
Overall Rank
81 | 99.44%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 53 citing papers.

Rank Citing Paper Year Venue Pagerank
35 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00076197749
80 Weaving Relations for Cache Performance 2001 VLDB 0.00055721729
103 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00049150032
124 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00045103515
193 On Supporting Containment Queries in Relational Database Management Systems 2001 SIGMOD 0.00035610321
238 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00031642425
239 GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management 2006 SIGMOD 0.00031617428
351 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB 0.0002636504
404 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB 0.00024143076
531 Improving Index Performance through Prefetching 2001 SIGMOD 0.00020790058
540 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.0002063443
576 Rethinking Database Algorithms for Phase Change Memory 2011 CIDR 0.00019865648
694 Analyzing the Energy Efficiency of a Database Server 2010 SIGMOD 0.00018061803
757 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00017078358
775 Relational Joins on Graphics Processors 2008 SIGMOD 0.00016823862
795 Conjunctive Selection Conditions in Main Memory 2002 PODS 0.00016600368
1,050 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00014453896
1,101 Generic Database Cost Models for Hierarchical Memory Systems 2002 VLDB 0.00014070632
1,124 Improving the Performance of List Intersection 2009 VLDB 0.00013847565
1,206 Rack-Scale In-Memory Join Processing using RDMA 2015 SIGMOD 0.00013281657
1,686 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.00010917794
1,881 Ibex - An Intelligent Storage Engine with Support for Advanced SQL Off-loading 2014 VLDB 0.00010217568
1,999 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 9.8235392e-05
2,328 A Case for Staged Database Systems 2003 CIDR 9.0225171e-05
2,519 Revisiting Co-Processing for Hash Joins on the Coupled CPU-GPU Architecture 2013 VLDB 8.6078505e-05
2,778 Database Servers on Chip Multiprocessors: Limitations and Opportunities 2007 CIDR 8.1321802e-05
3,465 GPL: A GPU-based Pipelined Query Processing Engine 2016 SIGMOD 7.0695873e-05
3,623 Cache-conscious Frequent Pattern Mining on a Modern Processor 2005 VLDB 6.9062146e-05
3,721 To Partition, or Not to Partition, That is the Join Question in a Real System 2021 SIGMOD 6.8179379e-05
3,722 Cache-Conscious Radix-Decluster Projections 2004 VLDB 6.8176075e-05
4,085 In-Cache Query Co-Processing on Coupled CPU-GPU Architectures 2015 VLDB 6.4620277e-05
4,261 Parallelizing Query Optimization 2008 VLDB 6.31244e-05
4,363 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR 6.2552614e-05
5,166 Inspector Joins 2005 VLDB 5.6521853e-05
5,247 Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects 2022 SIGMOD 5.6057839e-05
5,293 MQJoin: Efficient Shared Execution of Main-Memory Joins 2016 VLDB 5.5815698e-05
5,714 MCJoin: A Memory-Constrained Join for Column-Store Main-Memory Databases. 2012 SIGMOD 5.3578116e-05
5,721 FPGA-based Multithreading for In-Memory Hash Joins 2015 CIDR 5.3525009e-05
5,922 The Drill Down Benchmark 1998 VLDB 5.2724392e-05
6,447 STEPS Towards Cache-Resident Transaction Processing 2004 VLDB 5.0588602e-05
6,524 The 3D Hash Join: Building On Non-Unique Join Attributes 2022 CIDR 5.0274964e-05
6,540 Data Partitioning for In-Memory Systems: Myths, Challenges, and Opportunities 2019 CIDR 5.0219214e-05
7,378 Cache-Oblivious Query Processing 2007 CIDR 4.7480163e-05
7,751 Efficiently Processing Joins and Grouped Aggregations on GPUs 2025 SIGMOD 4.6603427e-05
7,836 NOCAP: Near-Optimal Correlation-Aware Partitioning Joins 2023 SIGMOD 4.6380835e-05
8,065 The HV-tree: a Memory Hierarchy Aware Version Index 2010 VLDB 4.5937864e-05
8,782 EaseDB: A Cache-Oblivious In-Memory Query Processor 2007 SIGMOD 4.452826e-05
8,855 A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory 2023 VLDB 4.4348906e-05
9,142 Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs 2023 SIGMOD 4.3853149e-05
9,743 Databases in the Era of Memory-Centric Computing 2025 CIDR 4.2897489e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 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
84 AlphaSort: A RISC Machine Sort 1994 SIGMOD 0.00053866006
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
6,777 Revisiting Reuse in Main Memory Database Systems 2017 SIGMOD 4.9288776e-05
3,740 Query Processing in Tertiary Memory Databases 1995 VLDB 6.8015038e-05
5,301 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 5.5790928e-05
8,782 EaseDB: A Cache-Oblivious In-Memory Query Processor 2007 SIGMOD 4.452826e-05
2,582 Database Architectures for New Hardware 2004 VLDB 8.5007371e-05
1,195 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB 0.00013406526
124 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00045103515
7,378 Cache-Oblivious Query Processing 2007 CIDR 4.7480163e-05
52 Database Architecture Optimized for the new Bottleneck: Memory Access 1999 VLDB 0.00066474881
1,050 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00014453896