
Workload compression is crucial for database optimization—powering knob tuning, indexing, MV selection, and more. But most prior work targets OLAP with query-only methods.
In our new VLDB paper, we present SCompression, a time-sliced workload compression technique for OLTP. The key idea: don’t just choose which queries to keep—preserve concurrency and transaction context so the compressed trace still reflects real system behavior.
On a knob-tuning task across real-world and benchmark workloads, SCompression accelerates tuning up to 40× with only ~5% performance impact.
Paper: vldb.org/pvldb/vol18/p1…
This work was led by visiting PhD student in our group, Baoqing Cai, who will present it at VLDB soon. Happy to discuss—online or in person!
English














