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)

Paper ID: 9384
Venue: VLDB
Year: 2006
Pagerank: 0.00018469455
Overall Rank: 663 | 95.39%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 34 of 34 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
183	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00036721403
359	Self-Driving Database Management Systems	2017	CIDR	0.0002592783
424	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023616398
514	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.0002124895
887	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00015578896
1,322	Automated Demand-driven Resource Scaling in Relational Database-as-a-Service	2016	SIGMOD	0.00012610912
1,497	Accelerating Relational Databases by Leveraging Remote Memory and RDMA	2016	SIGMOD	0.00011685781
1,855	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00010315245
1,902	Black or White? How to Develop an AutoTuner for Memory-based Analytics	2020	SIGMOD	0.00010157713
2,021	Storage Management in AsterixDB	2014	VLDB	9.7601304e-05
3,269	iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases	2019	VLDB	7.2998062e-05
3,436	Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service	2015	VLDB	7.0948913e-05
3,812	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.7373184e-05
4,240	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	6.3318228e-05
4,380	LlamaTune: Sample-Efficient DBMS Configuration Tuning	2022	VLDB	6.2396606e-05
4,399	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	6.2225151e-05
5,918	Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems	2021	VLDB	5.2737135e-05
6,062	Flexible Resource Allocation for Relational Database-as-a-Service	2023	VLDB	5.2302798e-05
6,151	An Efficient Transfer Learning Based Configuration Adviser for Database Tuning	2024	VLDB	5.183652e-05
6,268	Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems	2019	VLDB	5.133857e-05
7,218	Breaking Down Memory Walls in LSM-based Storage Systems	2020	SIGMOD	4.7982543e-05
7,329	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	4.7610574e-05
7,689	ROBUS: Fair Cache Allocation for Data-parallel Workloads	2017	SIGMOD	4.6765769e-05
8,426	Avoiding Read Stalls on Flash Storage	2022	SIGMOD	4.5162792e-05
8,435	Your Read is Our Priority in Flash Storage	2022	VLDB	4.5139996e-05
8,798	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	4.4489415e-05
9,956	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	4.2373024e-05
10,217	This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch!	2026	SIGMOD	4.1945683e-05
10,247	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	4.1945683e-05
10,635	Saving Private Hash Join	2025	VLDB	4.1945683e-05
10,668	Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems	2025	VLDB	4.1945683e-05
10,931	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.1945683e-05
10,968	Object-oriented Unified Encrypted Memory Management for Heterogeneous Memory Architectures	2024	SIGMOD	4.1945683e-05
12,386	Dynamic Partitioning of the Cache Hierarchy in Shared Data Centers	2008	VLDB	4.1945683e-05

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
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0003022091
765	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.00017016449
1,290	Memory Management during Run Generation in External Sorting	1998	SIGMOD	0.00012795586
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.0001047003
1,978	Managing Memory to Meet Multiclass Workload Response Time Goals	1993	VLDB	9.8808322e-05
2,299	Dynamic Memory Allocation for Multiple-Query Workloads	1993	VLDB	9.0697388e-05
2,624	Goal-Oriented Buffer Management Revisited*	1996	SIGMOD	8.4332581e-05
3,181	Partially Preemptible Hash Joins	1993	SIGMOD	7.4283072e-05
4,149	Memory-Contention Responsive Hash Joins	1994	VLDB	6.4078379e-05
4,832	Dynamic Memory Adjustment for External Mergesort	1997	VLDB	5.8924168e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.0001047003
183	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00036721403
10,668	Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems	2025	VLDB	4.1945683e-05
9,352	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	4.3522361e-05
6,433	Self-Managing Technology in Database Management Systems	2004	VLDB	5.0642403e-05
12,653	SMART: Making DB2 (More) Autonomic	2002	VLDB	4.1945683e-05
9,893	Foundations of Automated Database Tuning	2005	SIGMOD	4.2612967e-05
424	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023616398
2,065	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	9.6410693e-05
6,520	Foundations of Automated Database Tuning	2006	VLDB	5.0307595e-05