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,026 | Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS | 2007 | VLDB | 0.00014589172 |
| 4,088 | Towards Predicting Query Execution Time for Concurrent and Dynamic Database Workloads | 2013 | VLDB | 6.4603918e-05 |
| 6,278 | Uncertainty Aware Query Execution Time Prediction | 2014 | VLDB | 5.1309442e-05 |
| 9,284 | MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases | 2009 | VLDB | 4.362769e-05 |
| 12,264 | Building Disclosure Risk Aware Query Optimizers for Relational Databases | 2010 | VLDB | 4.1945683e-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.0040449103 |
| 64 | Improved Histograms for Selectivity Estimation of Range Predicates | 1996 | SIGMOD | 0.00063612837 |
| 99 | On the Propagation of Errors in the Size of Join Results | 1991 | SIGMOD | 0.00050022914 |
| 123 | A Decomposition Storage Model | 1985 | SIGMOD | 0.00045255007 |
| 182 | LEO - DB2's LEarning Optimizer | 2001 | VLDB | 0.00036962631 |
| 211 | Join Synopses for Approximate Query Answering | 1999 | SIGMOD | 0.00033981214 |
| 220 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033194808 |
| 268 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00029662304 |
| 292 | Shoring Up Persistent Applications | 1994 | SIGMOD | 0.00028741386 |
| 307 | Extensible Query Processing in Starburst | 1989 | SIGMOD | 0.00028211308 |
| 394 | An Adaptive Query Execution System for Data Integration* | 1999 | SIGMOD | 0.00024460855 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,910 | Flexible Buffer Allocation Based on Marginal Gains | 1991 | SIGMOD | 0.00010120833 |
| 4,697 | Adaptive Database Buffer Allocation Using Query Feedback | 1993 | VLDB | 5.9904278e-05 |
| 6,337 | Parallelizing Extensible Query Optimizers | 2009 | SIGMOD | 5.1053757e-05 |
| 1,050 | Buffering Database Operations for Enhanced Instruction Cache Performance | 2004 | SIGMOD | 0.00014453896 |
| 876 | Parametric Query Optimization | 1992 | VLDB | 0.00015716096 |
| 3,595 | Database Buffer Size Investigation for OLTP Workloads | 1997 | SIGMOD | 6.9373987e-05 |
| 12,427 | Managing Query Compilation Memory Consumption to Improve DBMS Throughput | 2007 | CIDR | 4.1945683e-05 |
| 2,964 | In-Memory Performance for Big Data | 2015 | VLDB | 7.80643e-05 |
| 8,798 | Resource-Adaptive Query Execution with Paged Memory Management | 2025 | CIDR | 4.4489415e-05 |
| 1,728 | Integration of Buffer Management and Query Optimization in Relational Database Environment | 1989 | VLDB | 0.00010739366 |