Adaptive Self-Tuning Memory in DB2
Summary: DB2's STMM provides adaptive, self-tuning control of per-heap and cumulative DB memory. Blending control theory and cost-benefit analysis, it allocates memory across statement cache, sort, and buffer pools with fast convergence and stable response. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Adam J. Storm (IBM Canada)
- 2. Christian Garcia-Arellano (IBM Canada)
- 3. Sam S. Lightstone (IBM Canada)
- 4. Yixin Diao (IBM)
- 5. M. Surendra (IBM)
BibTeX Citation
@article{storm_vldb06,
title = {{Adaptive Self-Tuning Memory in DB2}},
author = {Storm, Adam J. and Garcia-Arellano, Christian and Lightstone, Sam S. and Diao, Yixin and Surendra, M.},
journal = {PVLDB},
series = {{VLDB} '06},
pages = {1081--1092},
year = {2006}
}Incoming Citations (Sorted by Pagerank)
Showing 34 of 34 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 184 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.00026256101 |
| 625 | Automatic Performance Diagnosis and Tuning in Oracle | 2005 | CIDR | 0.0001566968 |
| 1,706 | SQL Memory Management in Oracle9i | 2002 | VLDB | 9.9628446e-05 |
| 1,801 | Memory Management during Run Generation in External Sorting | 1998 | SIGMOD | 9.7286236e-05 |
| 2,184 | Managing Memory to Meet Multiclass Workload Response Time Goals | 1993 | VLDB | 9.0045033e-05 |
| 2,360 | Dynamic Memory Allocation for Multiple-Query Workloads | 1993 | VLDB | 8.6956893e-05 |
| 2,466 | Goal-Oriented Buffer Management Revisited* | 1996 | SIGMOD | 8.5428771e-05 |
| 3,223 | Partially Preemptible Hash Joins | 1993 | SIGMOD | 7.6256187e-05 |
| 4,104 | Memory-Contention Responsive Hash Joins | 1994 | VLDB | 6.8987972e-05 |
| 4,955 | Dynamic Memory Adjustment for External Mergesort | 1997 | VLDB | 6.4297637e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,706 | SQL Memory Management in Oracle9i | 2002 | VLDB |
| 2 | 86 | Automatic Database Management System Tuning Through Large-scale Machine Learning | 2017 | SIGMOD |
| 3 | 9,775 | Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems | 2025 | VLDB |
| 4 | 9,441 | Db2une: Tuning Under Pressure via Deep Learning | 2024 | VLDB |
| 5 | 6,700 | Self-Managing Technology in Database Management Systems | 2004 | VLDB |
| 6 | 12,846 | SMART: Making DB2 (More) Autonomic | 2002 | VLDB |
| 7 | 10,047 | Foundations of Automated Database Tuning | 2005 | SIGMOD |
| 8 | 347 | Tuning Database Configuration Parameters with iTuned | 2009 | VLDB |
| 9 | 2,403 | Towards Automated Performance Tuning For Complex Workloads | 1994 | VLDB |
| 10 | 6,131 | Foundations of Automated Database Tuning | 2006 | VLDB |