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
8220
Venue
VLDB
Year
1994
Pagerank
0.00055253195
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.00076209479
80 Weaving Relations for Cache Performance 2001 VLDB 0.00055735291
104 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00049475932
124 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.0004501099
193 On Supporting Containment Queries in Relational Database Management Systems 2001 SIGMOD 0.00035591171
238 GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management 2006 SIGMOD 0.00031596093
240 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00031526134
350 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB 0.00026368305
403 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB 0.00024176677
538 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00020632609
622 Improving Index Performance through Prefetching 2001 SIGMOD 0.00018976783
687 Rethinking Database Algorithms for Phase Change Memory 2011 CIDR 0.00018097447
692 Analyzing the Energy Efficiency of a Database Server 2010 SIGMOD 0.00018045529
754 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00017093267
771 Relational Joins on Graphics Processors 2008 SIGMOD 0.00016813054
790 Conjunctive Selection Conditions in Main Memory 2002 PODS 0.0001659522
1,046 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00014446882
1,100 Generic Database Cost Models for Hierarchical Memory Systems 2002 VLDB 0.00014062265
1,121 Improving the Performance of List Intersection 2009 VLDB 0.00013838956
1,196 Rack-Scale In-Memory Join Processing using RDMA 2015 SIGMOD 0.00013378379
1,685 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.0001090924
1,882 Ibex - An Intelligent Storage Engine with Support for Advanced SQL Off-loading 2014 VLDB 0.00010210181
2,003 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 9.8198787e-05
2,329 A Case for Staged Database Systems 2003 CIDR 9.0237899e-05
2,523 Revisiting Co-Processing for Hash Joins on the Coupled CPU-GPU Architecture 2013 VLDB 8.599693e-05
2,782 Database Servers on Chip Multiprocessors: Limitations and Opportunities 2007 CIDR 8.1278531e-05
3,471 GPL: A GPU-based Pipelined Query Processing Engine 2016 SIGMOD 7.0628019e-05
3,627 Cache-conscious Frequent Pattern Mining on a Modern Processor 2005 VLDB 6.900129e-05
3,719 To Partition, or Not to Partition, That is the Join Question in a Real System 2021 SIGMOD 6.8141176e-05
3,723 Cache-Conscious Radix-Decluster Projections 2004 VLDB 6.8132331e-05
4,089 In-Cache Query Co-Processing on Coupled CPU-GPU Architectures 2015 VLDB 6.4559891e-05
4,255 Parallelizing Query Optimization 2008 VLDB 6.3080082e-05
4,359 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR 6.2493951e-05
5,165 Inspector Joins 2005 VLDB 5.6477024e-05
5,251 Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects 2022 SIGMOD 5.6003972e-05
5,298 MQJoin: Efficient Shared Execution of Main-Memory Joins 2016 VLDB 5.5762694e-05
5,723 MCJoin: A Memory-Constrained Join for Column-Store Main-Memory Databases. 2012 SIGMOD 5.3530385e-05
5,732 FPGA-based Multithreading for In-Memory Hash Joins 2015 CIDR 5.3473621e-05
5,923 The Drill Down Benchmark 1998 VLDB 5.2675323e-05
6,439 STEPS Towards Cache-Resident Transaction Processing 2004 VLDB 5.0550138e-05
6,523 The 3D Hash Join: Building On Non-Unique Join Attributes 2022 CIDR 5.0228804e-05
6,538 Data Partitioning for In-Memory Systems: Myths, Challenges, and Opportunities 2019 CIDR 5.0173391e-05
7,373 Cache-Oblivious Query Processing 2007 CIDR 4.744464e-05
7,752 Efficiently Processing Joins and Grouped Aggregations on GPUs 2025 SIGMOD 4.6558737e-05
7,842 NOCAP: Near-Optimal Correlation-Aware Partitioning Joins 2023 SIGMOD 4.6336361e-05
8,069 The HV-tree: a Memory Hierarchy Aware Version Index 2010 VLDB 4.5893806e-05
8,779 EaseDB: A Cache-Oblivious In-Memory Query Processor 2007 SIGMOD 4.4485572e-05
8,855 A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory 2023 VLDB 4.4306395e-05
9,143 Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs 2023 SIGMOD 4.381112e-05
9,742 Databases in the Era of Memory-Centric Computing 2025 CIDR 4.2856385e-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.001426258
85 AlphaSort: A RISC Machine Sort 1994 SIGMOD 0.00053652634
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.9242249e-05
3,742 Query Processing in Tertiary Memory Databases 1995 VLDB 6.7950057e-05
5,304 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 5.5738777e-05
8,779 EaseDB: A Cache-Oblivious In-Memory Query Processor 2007 SIGMOD 4.4485572e-05
2,582 Database Architectures for New Hardware 2004 VLDB 8.4982366e-05
1,195 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB 0.00013404419
124 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.0004501099
7,373 Cache-Oblivious Query Processing 2007 CIDR 4.744464e-05
52 Database Architecture Optimized for the new Bottleneck: Memory Access 1999 VLDB 0.00066322421
1,046 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00014446882