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: 12065
Venue: VLDB
Year: 2019
Pagerank: 5.4079618e-05
Overall Rank: 8,583 | 41.12%
DOI: 10.14778/3291264.3291265

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
4,084	Comprehensive and Efficient Workload Compression	2021	VLDB	6.9151691e-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
60	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0003955489
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
156	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028636811
234	Self-Driving Database Management Systems	2017	CIDR	0.00023810722
365	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00020041735
768	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014173242
846	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.00013658824
858	Interpretable and Informative Explanations of Outcomes	2015	VLDB	0.0001356511
1,894	Optimizing Queries On Compressed Bitmaps	2000	VLDB	9.5268052e-05
7,098	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.7046615e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,755	Compression Aware Physical Database Design	2011	VLDB
2	5,383	Compressed Representations of Conjunctive Query Results	2018	PODS
3	8,410	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB
4	10,946	LogLite: Lightweight Plug-and-Play Streaming Log Compression	2025	VLDB
5	5,073	Database Workload Characterization with Query Plan Encoders	2022	VLDB
6	7,173	CompressDB: Enabling Efficient Compressed Data Direct Processing for Various Databases	2022	SIGMOD
7	7,363	Adaptive Log Compression for Massive Log Data	2013	SIGMOD
8	921	Query Optimization In Compressed Database Systems	2001	SIGMOD
9	1,266	Compressing SQL Workloads	2002	SIGMOD
10	4,084	Comprehensive and Efficient Workload Compression	2021	VLDB