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)
Incoming Non-self Citations Over Time
Authors
- 1. Baoqing Cai (Huazhong University of Science and Technology)
- 2. Yu Liu (Huazhong University of Science and Technology)
- 3. Lin Ma (University of Michigan)
- 4. Pingqi Huang (Huazhong University of Science and Technology)
- 5. Bingcheng Lian (Huazhong University of Science and Technology)
- 6. Ke Zhou (Huazhong University of Science and Technology)
- 7. Jia Yuan (University of Arizona)
- 8. Jie Yang (Tencent)
- 9. Xiaofan Cai (Tencent)
- 10. Peijun Wu (Tencent)
BibTeX Citation
@article{cai_vldb25,
title = {{SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression}},
author = {Cai, Baoqing and Liu, Yu and Ma, Lin and Huang, Pingqi and Lian, Bingcheng and Zhou, Ke and Yuan, Jia and Yang, Jie and Cai, Xiaofan and Wu, Peijun},
journal = {PVLDB},
series = {{VLDB} '25},
volume = {18},
number = {6},
pages = {1865--1878},
doi = {10.14778/3725688.3725712},
url = {https://doi.org/10.14778/3725688.3725712},
year = {2025}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,559 | OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning | 2026 | VLDB | 5.093636e-05 |
| 10,565 | LakeHelm: Zero-Shot Lakehouse Advisor for Joint Engine-Format Selection and Configuration | 2026 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
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.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 11,613 | Budget-Conscious Fine-Grained Configuration Optimization for Spatio-Temporal Applications | 2022 | VLDB |
| 2 | 60 | Integrating Compression and Execution in Column-Oriented Database Systems | 2006 | SIGMOD |
| 3 | 921 | Query Optimization In Compressed Database Systems | 2001 | SIGMOD |
| 4 | 7,173 | CompressDB: Enabling Efficient Compressed Data Direct Processing for Various Databases | 2022 | SIGMOD |
| 5 | 5,755 | Compression Aware Physical Database Design | 2011 | VLDB |
| 6 | 1,950 | How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans | 2007 | SIGMOD |
| 7 | 8,436 | Adaptive Compression for Fast Scans on String Columns | 2021 | SIGMOD |
| 8 | 4,084 | Comprehensive and Efficient Workload Compression | 2021 | VLDB |
| 9 | 1,266 | Compressing SQL Workloads | 2002 | SIGMOD |
| 10 | 3,292 | Compacting Transactional Data in Hybrid OLTP&OLAP Databases | 2012 | VLDB |