DBScholar

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
8410
Venue
VLDB
Year
1994
Pagerank
0.00037330605
Overall Rank
74 | 99.50%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{shatdal_vldb94,
        title = {{Cache Conscious Algorithms for Relational Query Processing}},
        author = {Shatdal, Ambuj and Kant, Chander and Naughton, Jeffrey F.},
        journal = {PVLDB},
        series = {{VLDB} '94},
        pages = {510--521},
        year = {1994}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 53 citing papers.

Rank Citing Paper Year Venue Pagerank
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.0006312782
49 Weaving Relations for Cache Performance 2001 VLDB 0.00043781096
67 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00038461275
109 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.000331207
163 On Supporting Containment Queries in Relational Database Management Systems 2001 SIGMOD 0.00027839792
204 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00025342994
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
305 GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management 2006 SIGMOD 0.00021872796
360 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00020182846
545 Improving Index Performance through Prefetching 2001 SIGMOD 0.00016766463
631 Relational Joins on Graphics Processors 2008 SIGMOD 0.00015591241
658 Rethinking Database Algorithms for Phase Change Memory 2011 CIDR 0.0001523554
721 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00014631814
771 Conjunctive Selection Conditions in Main Memory 2002 PODS 0.00014161995
883 Analyzing the Energy Efficiency of a Database Server 2010 SIGMOD 0.00013421859
892 Rack-Scale In-Memory Join Processing using RDMA 2015 SIGMOD 0.00013376761
932 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00013119305
1,028 Generic Database Cost Models for Hierarchical Memory Systems 2002 VLDB 0.00012557617
1,452 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.00010745803
1,632 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 0.0001016847
1,717 Improving the Performance of List Intersection 2009 VLDB 9.9327227e-05
1,773 Ibex—An Intelligent Storage Engine with Support for Advanced SQL Off-loading 2014 VLDB 9.7895875e-05
2,140 Revisiting Co-Processing for Hash Joins on the Coupled CPU-GPU Architecture 2013 VLDB 9.0991487e-05
2,394 A Case for Staged Database Systems 2003 CIDR 8.6362653e-05
2,679 Database Servers on Chip Multiprocessors: Limitations and Opportunities 2007 CIDR 8.2675008e-05
2,848 GPL: A GPU-based Pipelined Query Processing Engine 2016 SIGMOD 8.0538815e-05
2,962 To Partition, or Not to Partition, That is the Join Question in a Real System 2021 SIGMOD 7.9170451e-05
3,406 Cache-Conscious Radix-Decluster Projections 2004 VLDB 7.4392655e-05
3,471 In-Cache Query Co-Processing on Coupled CPU-GPU Architectures 2015 VLDB 7.3885861e-05
3,726 Parallelizing Query Optimization 2008 VLDB 7.1697834e-05
3,791 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR 7.1235328e-05
3,969 Cache-conscious Frequent Pattern Mining on a Modern Processor 2005 VLDB 6.9837297e-05
4,535 Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects 2022 SIGMOD 6.6419266e-05
4,639 MQJoin: Efficient Shared Execution of Main-Memory Joins 2016 VLDB 6.5918791e-05
5,515 FPGA-based Multithreading for In-Memory Hash Joins 2015 CIDR 6.189963e-05
5,812 MCJoin: A Memory-Constrained Join for Column-Store Main-Memory Databases. 2012 SIGMOD 6.0782357e-05
5,829 Inspector Joins 2005 VLDB 6.073697e-05
6,161 Data Partitioning for In-Memory Systems: Myths, Challenges, and Opportunities 2019 CIDR 5.9537202e-05
6,207 The 3D Hash Join: Building On Non-Unique Join Attributes 2022 CIDR 5.9429869e-05
6,682 STEPS Towards Cache-Resident Transaction Processing 2004 VLDB 5.8039833e-05
6,694 The Drill Down Benchmark 1998 VLDB 5.7990789e-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,591 Efficiently Processing Joins and Grouped Aggregations on GPUs 2025 SIGMOD 5.5900315e-05
7,760 NOCAP: Near-Optimal Correlation-Aware Partitioning Joins 2023 SIGMOD 5.5505651e-05
7,792 Cache-Oblivious Query Processing 2007 CIDR 5.5431413e-05
8,207 The HV-tree: a Memory Hierarchy Aware Version Index 2010 VLDB 5.4666057e-05
8,904 A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory 2023 VLDB 5.3483178e-05
8,948 EaseDB: A Cache-Oblivious In-Memory Query Processor 2007 SIGMOD 5.3463915e-05
9,890 Databases in the Era of Memory-Centric Computing 2025 CIDR 5.1997534e-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
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00083340894
215 AlphaSort: A RISC Machine Sort 1994 SIGMOD 0.00024507963
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,947 Revisiting Reuse in Main Memory Database Systems 2017 SIGMOD
2 3,760 Query Processing in Tertiary Memory Databases 1995 VLDB
3 4,764 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB
4 8,948 EaseDB: A Cache-Oblivious In-Memory Query Processor 2007 SIGMOD
5 2,870 Database Architectures for New Hardware 2004 VLDB
6 1,110 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB
7 109 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB
8 7,792 Cache-Oblivious Query Processing 2007 CIDR
9 29 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB
10 932 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD