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 35 of 35 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 |
|---|---|---|---|---|
| 189 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.00025846085 |
| 583 | Automatic Performance Diagnosis and Tuning in Oracle | 2005 | CIDR | 0.00015964021 |
| 1,652 | SQL Memory Management in Oracle9i | 2002 | VLDB | 9.9624199e-05 |
| 1,824 | Memory Management during Run Generation in External Sorting | 1998 | SIGMOD | 9.545532e-05 |
| 2,224 | Managing Memory to Meet Multiclass Workload Response Time Goals | 1993 | VLDB | 8.8023428e-05 |
| 2,385 | Dynamic Memory Allocation for Multiple-Query Workloads | 1993 | VLDB | 8.5255503e-05 |
| 2,423 | Goal-Oriented Buffer Management Revisited* | 1996 | SIGMOD | 8.4781834e-05 |
| 3,236 | Partially Preemptible Hash Joins | 1993 | SIGMOD | 7.4849664e-05 |
| 4,136 | Memory-Contention Responsive Hash Joins | 1994 | VLDB | 6.7717644e-05 |
| 4,677 | Dynamic Memory Adjustment for External Mergesort | 1997 | VLDB | 6.4575536e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,652 | SQL Memory Management in Oracle9i | 2002 | VLDB |
| 2 | 74 | Automatic Database Management System Tuning Through Large-scale Machine Learning | 2017 | SIGMOD |
| 3 | 8,900 | Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems | 2025 | VLDB |
| 4 | 9,655 | Db2une: Tuning Under Pressure via Deep Learning | 2024 | VLDB |
| 5 | 6,844 | Self-Managing Technology in Database Management Systems | 2004 | VLDB |
| 6 | 13,183 | SMART: Making DB2 (More) Autonomic | 2002 | VLDB |
| 7 | 10,267 | Foundations of Automated Database Tuning | 2005 | SIGMOD |
| 8 | 313 | Tuning Database Configuration Parameters with iTuned | 2009 | VLDB |
| 9 | 2,420 | Towards Automated Performance Tuning For Complex Workloads | 1994 | VLDB |
| 10 | 6,265 | Foundations of Automated Database Tuning | 2006 | VLDB |