SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression

Summary: Defines the OLTP-specific compression objective for knob tuning and introduces SCompression: slice-by-time compression that preserves concurrency and transaction context so compressed workloads reflect config-sensitive performance variation. Segments workloads, slices to retain concurrency, and cluster-samples slices under time constraints; replays compressed workloads to speed up tuning up to 40× with ≈5% performance loss. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13844
Venue: VLDB
Year: 2025
Pagerank: 4.2332427e-05
Overall Rank: 9,955 | 30.82%
DOI: 10.14778/3725688.3725712

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,271	OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning	2026	VLDB	4.1905499e-05
10,278	LakeHelm: Zero-Shot Lakehouse Advisor for Joint Engine-Format Selection and Configuration	2026	VLDB	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 28 of 28 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
183	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00036859633
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
661	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00018488168
662	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.00018478597
704	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017785557
779	QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning	2019	VLDB	0.00016719473
1,300	Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes	2016	SIGMOD	0.00012711153
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011944621
2,022	Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms	2020	VLDB	9.7623022e-05
2,085	The Case for Predictive Database Systems: Opportunities and Challenges	2011	CIDR	9.5749968e-05
3,105	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	7.5567226e-05
3,655	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.8723042e-05
3,661	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD	6.8680306e-05
3,692	iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases	2019	VLDB	6.8328808e-05
3,995	ResTune: Resource Oriented Tuning Boosted by Meta-Learning for Cloud Databases	2021	SIGMOD	6.5475871e-05
4,180	LlamaTune: Sample-Efficient DBMS Configuration Tuning	2022	VLDB	6.3725334e-05
4,280	Primitives for Workload Summarization and Implications for SQL	2003	VLDB	6.28375e-05
4,377	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	6.2331947e-05
4,469	Comprehensive and Efficient Workload Compression	2021	VLDB	6.1535623e-05
4,587	MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems	2021	SIGMOD	6.0594195e-05
4,799	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	5.9082876e-05
5,318	LOCAT: Low-Overhead Online Configuration Auto-Tuning of Spark SQL Applications	2022	SIGMOD	5.5685434e-05
5,834	An Efficient Transfer Learning Based Configuration Adviser for Database Tuning	2024	VLDB	5.3082111e-05
6,364	ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning	2022	SIGMOD	5.0895007e-05
8,036	Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems	2022	SIGMOD	4.5965825e-05
9,012	Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems	2024	VLDB	4.4059413e-05
9,469	Database Gyms	2023	CIDR	4.3304872e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
11,418	Budget-Conscious Fine-Grained Configuration Optimization for Spatio-Temporal Applications	2022	VLDB	4.1905499e-05
132	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00043697853
1,098	Query Optimization In Compressed Database Systems	2001	SIGMOD	0.00014070252
7,431	CompressDB: Enabling Efficient Compressed Data Direct Processing for Various Databases	2022	SIGMOD	4.7274757e-05
6,160	Compression Aware Physical Database Design	2011	VLDB	5.1750659e-05
1,908	How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans	2007	SIGMOD	0.00010130401
8,444	Adaptive Compression for Fast Scans on String Columns	2021	SIGMOD	4.5043421e-05
4,469	Comprehensive and Efficient Workload Compression	2021	VLDB	6.1535623e-05
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011944621
3,686	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB	6.839208e-05