Buffer Pool Aware Query Optimization
Summary: Shows that large buffer pools invalidate disk-residency assumptions in traditional optimizers, changing scan/join cost tradeoffs and enabling different plan choices. Proposes a generic architecture to incorporate buffer residency into costing and plan selection, and quantifies benefits. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,027 | Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS | 2007 | VLDB | 0.0001458537 |
| 4,075 | Towards Predicting Query Execution Time for Concurrent and Dynamic Database Workloads | 2013 | VLDB | 6.4699689e-05 |
| 6,277 | Uncertainty Aware Query Execution Time Prediction | 2014 | VLDB | 5.1260947e-05 |
| 9,289 | MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases | 2009 | VLDB | 4.3585828e-05 |
| 12,272 | Building Disclosure Risk Aware Query Optimizers for Relational Databases | 2010 | VLDB | 4.1905499e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 11 of 11 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0040465394 |
| 63 | Improved Histograms for Selectivity Estimation of Range Predicates | 1996 | SIGMOD | 0.00063595699 |
| 100 | On the Propagation of Errors in the Size of Join Results | 1991 | SIGMOD | 0.00050033475 |
| 123 | A Decomposition Storage Model | 1985 | SIGMOD | 0.00045235743 |
| 181 | LEO - DB2's LEarning Optimizer | 2001 | VLDB | 0.00036970794 |
| 212 | Join Synopses for Approximate Query Answering | 1999 | SIGMOD | 0.00033997204 |
| 221 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033182072 |
| 269 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00029665158 |
| 292 | Shoring Up Persistent Applications | 1994 | SIGMOD | 0.00028735468 |
| 309 | Extensible Query Processing in Starburst | 1989 | SIGMOD | 0.00028195213 |
| 396 | An Adaptive Query Execution System for Data Integration* | 1999 | SIGMOD | 0.00024439334 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,913 | Flexible Buffer Allocation Based on Marginal Gains | 1991 | SIGMOD | 0.00010114422 |
| 4,695 | Adaptive Database Buffer Allocation Using Query Feedback | 1993 | VLDB | 5.9847623e-05 |
| 6,333 | Parallelizing Extensible Query Optimizers | 2009 | SIGMOD | 5.1013149e-05 |
| 1,046 | Buffering Database Operations for Enhanced Instruction Cache Performance | 2004 | SIGMOD | 0.00014446882 |
| 870 | Parametric Query Optimization | 1992 | VLDB | 0.00015709369 |
| 3,601 | Database Buffer Size Investigation for OLTP Workloads | 1997 | SIGMOD | 6.9285208e-05 |
| 12,436 | Managing Query Compilation Memory Consumption to Improve DBMS Throughput | 2007 | CIDR | 4.1905499e-05 |
| 2,976 | In-Memory Performance for Big Data | 2015 | VLDB | 7.7865451e-05 |
| 8,795 | Resource-Adaptive Query Execution with Paged Memory Management | 2025 | CIDR | 4.4446768e-05 |
| 1,729 | Integration of Buffer Management and Query Optimization in Relational Database Environment | 1989 | VLDB | 0.00010730915 |