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: 13843
Venue: VLDB
Year: 2025
Pagerank: 4.2373024e-05
Overall Rank: 9,956 | 30.74%
DOI: 10.14778/3725688.3725712

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 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.1945683e-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.00036721403
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
661	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.00018481174
663	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00018469455
716	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017723171
782	QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning	2019	VLDB	0.00016729063
1,312	Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes	2016	SIGMOD	0.00012652548
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011947004
2,020	Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms	2020	VLDB	9.762624e-05
2,084	The Case for Predictive Database Systems: Opportunities and Challenges	2011	CIDR	9.5820534e-05
3,114	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	7.5451724e-05
3,269	iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases	2019	VLDB	7.2998062e-05
3,522	ResTune: Resource Oriented Tuning Boosted by Meta-Learning for Cloud Databases	2021	SIGMOD	7.0096727e-05
3,653	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD	6.8743355e-05
3,812	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.7373184e-05
4,287	Primitives for Workload Summarization and Implications for SQL	2003	VLDB	6.2891702e-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
4,468	Comprehensive and Efficient Workload Compression	2021	VLDB	6.1584035e-05
4,590	MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems	2021	SIGMOD	6.0620053e-05
4,842	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	5.8826802e-05
5,833	LOCAT: Low-Overhead Online Configuration Auto-Tuning of Spark SQL Applications	2022	SIGMOD	5.3106182e-05
6,151	An Efficient Transfer Learning Based Configuration Adviser for Database Tuning	2024	VLDB	5.183652e-05
6,366	ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning	2022	SIGMOD	5.0943443e-05
8,082	Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems	2022	SIGMOD	4.5905454e-05
9,006	Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems	2024	VLDB	4.4101482e-05
9,467	Database Gyms	2023	CIDR	4.3346412e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
11,415	Budget-Conscious Fine-Grained Configuration Optimization for Spatio-Temporal Applications	2022	VLDB	4.1945683e-05
131	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0004370331
1,100	Query Optimization In Compressed Database Systems	2001	SIGMOD	0.00014072277
7,429	CompressDB: Enabling Efficient Compressed Data Direct Processing for Various Databases	2022	SIGMOD	4.7320139e-05
6,157	Compression Aware Physical Database Design	2011	VLDB	5.1801143e-05
1,905	How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans	2007	SIGMOD	0.00010138448
8,487	Adaptive Compression for Fast Scans on String Columns	2021	SIGMOD	4.4999394e-05
4,468	Comprehensive and Efficient Workload Compression	2021	VLDB	6.1584035e-05
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011947004
3,689	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB	6.8396366e-05