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: 9385
Venue: VLDB
Year: 2006
Pagerank: 0.00018488168
Overall Rank: 661 | 95.41%
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.00036859633
371	Self-Driving Database Management Systems	2017	CIDR	0.00025382677
423	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023628474
510	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.00021420477
886	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00015563003
1,321	Automated Demand-driven Resource Scaling in Relational Database-as-a-Service	2016	SIGMOD	0.00012605455
1,474	Accelerating Relational Databases by Leveraging Remote Memory and RDMA	2016	SIGMOD	0.00011781099
1,856	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00010319105
1,892	Black or White? How to Develop an AutoTuner for Memory-based Analytics	2020	SIGMOD	0.00010176219
2,024	Storage Management in AsterixDB	2014	VLDB	9.7528344e-05
3,431	Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service	2015	VLDB	7.0984188e-05
3,655	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.8723042e-05
3,692	iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases	2019	VLDB	6.8328808e-05
4,180	LlamaTune: Sample-Efficient DBMS Configuration Tuning	2022	VLDB	6.3725334e-05
4,216	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	6.3448176e-05
4,377	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	6.2331947e-05
5,834	An Efficient Transfer Learning Based Configuration Adviser for Database Tuning	2024	VLDB	5.3082111e-05
5,920	Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems	2021	VLDB	5.2686888e-05
6,066	Flexible Resource Allocation for Relational Database-as-a-Service	2023	VLDB	5.225259e-05
6,265	Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems	2019	VLDB	5.1294788e-05
7,217	Breaking Down Memory Walls in LSM-based Storage Systems	2020	SIGMOD	4.7936491e-05
7,325	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	4.7564908e-05
7,690	ROBUS: Fair Cache Allocation for Data-parallel Workloads	2017	SIGMOD	4.6723821e-05
8,795	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	4.4446768e-05
8,797	Avoiding Read Stalls on Flash Storage	2022	SIGMOD	4.4444672e-05
8,806	Your Read is Our Priority in Flash Storage	2022	VLDB	4.44219e-05
9,955	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	4.2332427e-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.1905499e-05
10,247	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	4.1905499e-05
10,643	Saving Private Hash Join	2025	VLDB	4.1905499e-05
10,676	Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems	2025	VLDB	4.1905499e-05
10,934	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.1905499e-05
10,971	Object-oriented Unified Encrypted Memory Management for Heterogeneous Memory Architectures	2024	SIGMOD	4.1905499e-05
12,394	Dynamic Partitioning of the Cache Hierarchy in Shared Data Centers	2008	VLDB	4.1905499e-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.00030196528
760	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.00017003914
1,289	Memory Management during Run Generation in External Sorting	1998	SIGMOD	0.00012779036
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.00010471365
1,981	Managing Memory to Meet Multiclass Workload Response Time Goals	1993	VLDB	9.8739039e-05
2,307	Dynamic Memory Allocation for Multiple-Query Workloads	1993	VLDB	9.0635131e-05
2,623	Goal-Oriented Buffer Management Revisited*	1996	SIGMOD	8.4368672e-05
3,185	Partially Preemptible Hash Joins	1993	SIGMOD	7.4241724e-05
4,149	Memory-Contention Responsive Hash Joins	1994	VLDB	6.4043572e-05
4,826	Dynamic Memory Adjustment for External Mergesort	1997	VLDB	5.8892345e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.00010471365
183	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00036859633
10,676	Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems	2025	VLDB	4.1905499e-05
9,358	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	4.3480651e-05
6,429	Self-Managing Technology in Database Management Systems	2004	VLDB	5.0595863e-05
12,662	SMART: Making DB2 (More) Autonomic	2002	VLDB	4.1905499e-05
9,892	Foundations of Automated Database Tuning	2005	SIGMOD	4.2572136e-05
423	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023628474
2,069	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	9.6356256e-05
6,494	Foundations of Automated Database Tuning	2006	VLDB	5.0334983e-05