DBScholar

Back to papers

2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm

Summary: Introduces 2Q, a self-tuning two-queue buffer replacement algorithm with O(1) access overhead, avoiding LRU/2’s priority-queue cost. Empirically matches LRU/2 and improves over LRU on real and simulated traces, especially for scans and large random workloads. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
he7c2c6333f9a3929
Venue
VLDB
Year
1994
Pagerank
0.00015829023
Overall Rank
593 | 96.02%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{johnson_vldb94,
        title = {{2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm}},
        author = {Johnson, Theodore and Shasha, Dennis},
        journal = {PVLDB},
        series = {{VLDB} '94},
        pages = {439},
        year = {1994}
}

Incoming Citations (Sorted by Pagerank)

Showing 32 of 32 citing papers.

Rank Citing Paper Year Venue Pagerank
390 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00019265472
1,210 Processing a Trillion Cells per Mouse Click 2012 VLDB 0.0001152237
1,817 Broadcast Disks: Data Management for Asymmetric Communication Environments 1995 SIGMOD 9.5704315e-05
2,438 Goal-Oriented Buffer Management Revisited* 1996 SIGMOD 8.4633712e-05
3,001 Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service 2015 VLDB 7.7640097e-05
3,399 Orca: Scalable Temporal Graph Neural Network Training with Theoretical Guarantees 2023 SIGMOD 7.3314353e-05
3,953 Storage Workload Estimation for Database Management Systems 2007 SIGMOD 6.9001886e-05
4,202 The Case for Distributed Shared-Memory Databases with RDMA-Enabled Memory Disaggregation 2023 VLDB 6.7343438e-05
4,355 Interaction of Query Evaluation and Buffer Management for Information Retrieval 1998 SIGMOD 6.6381897e-05
4,393 Sharing Data and Work Across Concurrent Analytical Queries 2013 VLDB 6.618354e-05
5,019 2R: Efficiently Isolating Cold Pages in Flash Storages 2020 VLDB 6.3104018e-05
5,022 Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems 2021 VLDB 6.309271e-05
5,162 HotPrefix: Hotness-Aware KV Cache Scheduling for Efficient Prefix Sharing in LLM Inference Systems 2026 SIGMOD 6.2449391e-05
5,943 Operation-Aware Buffer Management in Flash-based Systems 2011 SIGMOD 5.9361142e-05
5,950 DEX: Scalable Range Indexing on Disaggregated Memory 2024 VLDB 5.934065e-05
6,491 HetCache: Synergising NVMe Storage and GPU acceleration for Memory-Efficient Analytics 2023 CIDR 5.7649204e-05
6,934 Breaking Down Memory Walls in LSM-based Storage Systems 2020 SIGMOD 5.6382919e-05
7,036 Increasing Buffer-Locality for Multiple Index Based Scans through Intelligent Placement and Index Scan Speed Control 2007 VLDB 5.613732e-05
7,905 Write-Aware Timestamp Tracking: Effective and Efficient Page Replacement for Modern Hardware 2023 VLDB 5.4277185e-05
8,724 Resource-Adaptive Real-Time New Event Detection 2007 SIGMOD 5.2880532e-05
8,777 PreVision: An Out-of-Core Matrix Computation System with Optimal Buffer Replacement 2024 SIGMOD 5.2789044e-05
9,624 MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases 2009 VLDB 5.1483437e-05
10,295 Request Window: an Approach to Improve Throughput of RDBMS-based Data Integration System by Utilizing Data Sharing Across Concurrent Distributed Queries 2007 VLDB 5.0422244e-05
10,507 ReStore: A Reinforcement Learning Approach for Data Migration in Multi-Tiered Storage 2026 SIGMOD 4.9769913e-05
10,913 Clock2Q+: A Simple and Efficient Replacement Algorithm for Metadata Cache in VMware vSAN 2026 VLDB 4.9769913e-05
10,921 Tuning the Lookahead Distance for PostgreSQL Asynchronous IO 2026 VLDB 4.9769913e-05
11,051 Demystifying and Improving Lazy Promotion in Cache Eviction 2026 VLDB 4.9769913e-05
11,435 Sampling-based Predictive Database Buffer Management 2025 VLDB 4.9769913e-05
11,821 Making Cache Monotonic and Consistent 2023 VLDB 4.9769913e-05
12,875 Dynamic Partitioning of the Cache Hierarchy in Shared Data Centers 2008 VLDB 4.9769913e-05
13,141 A Multi-version Cache Replacement and Prefetching Policy for Hybrid Data Delivery Environments 2002 VLDB 4.9769913e-05
13,305 L/MRP: A Buffer Management Strategy for Interactive Continuous Data Flows in a Multimedia DBMS 1995 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

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

Rank Cited Paper Year Venue Pagerank
128 An Evaluation of Buffer Management Strategies for Relational Database Systems 1985 VLDB 0.00030399615
212 The LRU-K Page Replacement Algorithm For Database Disk Buffering 1993 SIGMOD 0.00024758235
844 Exploiting Inheritance and Structure Semantics for Effective Clustering and Buffering in an Object-Oriented DBMS 1989 SIGMOD 0.00013529166
1,520 Predictive Load Control for Flexible Buffer Allocation 1991 VLDB 0.00010378432
2,123 Priority-Hints: An Algorithm for Priority-Based Buffer Management 1990 VLDB 9.00518e-05
2,560 Extensible Buffer Management of Indexes 1992 VLDB 8.2955773e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 11,051 Demystifying and Improving Lazy Promotion in Cache Eviction 2026 VLDB
2 13,326 Estimating Page Fetches for Index Scans with Finite LRU Buffers 1994 SIGMOD
3 11,435 Sampling-based Predictive Database Buffer Management 2025 VLDB
4 1,968 Integration of Buffer Management and Query Optimization In Relational Database Environment 1989 VLDB
5 3,001 Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service 2015 VLDB
6 2,560 Extensible Buffer Management of Indexes 1992 VLDB
7 4,794 Adaptive Database Buffer Allocation Using Query Feedback 1993 VLDB
8 2,123 Priority-Hints: An Algorithm for Priority-Based Buffer Management 1990 VLDB
9 6,172 Index Access with a Finite Buffer 1987 VLDB
10 212 The LRU-K Page Replacement Algorithm For Database Disk Buffering 1993 SIGMOD