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 |
|---|---|---|---|---|
| 187 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.00025914764 |
| 598 | Automatic Performance Diagnosis and Tuning in Oracle | 2005 | CIDR | 0.0001575517 |
| 1,660 | SQL Memory Management in Oracle9i | 2002 | VLDB | 9.9581502e-05 |
| 1,823 | Memory Management during Run Generation in External Sorting | 1998 | SIGMOD | 9.5571894e-05 |
| 2,214 | Managing Memory to Meet Multiclass Workload Response Time Goals | 1993 | VLDB | 8.8167314e-05 |
| 2,387 | Dynamic Memory Allocation for Multiple-Query Workloads | 1993 | VLDB | 8.5355701e-05 |
| 2,438 | Goal-Oriented Buffer Management Revisited* | 1996 | SIGMOD | 8.4633712e-05 |
| 3,250 | Partially Preemptible Hash Joins | 1993 | SIGMOD | 7.4905507e-05 |
| 4,144 | Memory-Contention Responsive Hash Joins | 1994 | VLDB | 6.7782012e-05 |
| 4,694 | Dynamic Memory Adjustment for External Mergesort | 1997 | VLDB | 6.4643405e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,660 | SQL Memory Management in Oracle9i | 2002 | VLDB |
| 2 | 78 | Automatic Database Management System Tuning Through Large-scale Machine Learning | 2017 | SIGMOD |
| 3 | 9,190 | Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems | 2025 | VLDB |
| 4 | 9,627 | Db2une: Tuning Under Pressure via Deep Learning | 2024 | VLDB |
| 5 | 6,827 | Self-Managing Technology in Database Management Systems | 2004 | VLDB |
| 6 | 13,142 | SMART: Making DB2 (More) Autonomic | 2002 | VLDB |
| 7 | 10,237 | Foundations of Automated Database Tuning | 2005 | SIGMOD |
| 8 | 322 | Tuning Database Configuration Parameters with iTuned | 2009 | VLDB |
| 9 | 2,426 | Towards Automated Performance Tuning For Complex Workloads | 1994 | VLDB |
| 10 | 6,254 | Foundations of Automated Database Tuning | 2006 | VLDB |