Query Log Compression for Workload Analytics

Summary: LogR compresses massive SQL logs as interpretable mixtures of co-occurring structural patterns, preserving aggregate workload statistics beyond sampling. A tunable space–fidelity trade-off, efficient construction, and information-theoretic guarantees yield stronger summaries than prior methods. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: h297b3cf30e950346
Venue: VLDB
Year: 2019
Pagerank: 5.2779628e-05
Overall Rank: 8,663 | 41.94%
DOI: 10.14778/3291264.3291265
PDF: Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

1. Ting Xie (State University of New York at Buffalo)
2. Varun Chandola (State University of New York at Buffalo)
3. Oliver Kennedy (State University of New York at Buffalo)

BibTeX Citation

@article{xie_vldb19,
        title = {{Query Log Compression for Workload Analytics}},
        author = {Xie, Ting and Chandola, Varun and Kennedy, Oliver},
        journal = {PVLDB},
        series = {{VLDB} '19},
        volume = {12},
        number = {3},
        pages = {183--196},
        doi = {10.14778/3291264.3291265},
        url = {https://doi.org/10.14778/3291264.3291265},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,818	Comprehensive and Efficient Workload Compression	2021	VLDB	6.983427e-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
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00039323387
89	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035265687
151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028611216
224	Self-Driving Database Management Systems	2017	CIDR	0.00023973185
372	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00019768921
756	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014209974
864	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.00013358173
879	Interpretable and Informative Explanations of Outcomes	2015	VLDB	0.00013255435
1,939	Optimizing Queries On Compressed Bitmaps	2000	VLDB	9.3280163e-05
7,249	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.5586903e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,866	Compression Aware Physical Database Design	2011	VLDB
2	5,512	Compressed Representations of Conjunctive Query Results	2018	PODS
3	8,589	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB
4	11,395	LogLite: Lightweight Plug-and-Play Streaming Log Compression	2025	VLDB
5	5,211	Database Workload Characterization with Query Plan Encoders	2022	VLDB
6	6,737	CompressDB: Enabling Efficient Compressed Data Direct Processing for Various Databases	2022	SIGMOD
7	7,529	Adaptive Log Compression for Massive Log Data	2013	SIGMOD
8	900	Query Optimization In Compressed Database Systems	2001	SIGMOD
9	1,246	Compressing SQL Workloads	2002	SIGMOD
10	3,818	Comprehensive and Efficient Workload Compression	2021	VLDB