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.2978746e-05
Overall Rank: 8,638 | 41.93%
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
3,815	Comprehensive and Efficient Workload Compression	2021	VLDB	7.0075744e-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.000392237
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035351639
151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028672526
224	Self-Driving Database Management Systems	2017	CIDR	0.00024013745
371	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00019829769
751	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.0001425375
861	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.00013402933
878	Interpretable and Informative Explanations of Outcomes	2015	VLDB	0.00013302631
1,930	Optimizing Queries On Compressed Bitmaps	2000	VLDB	9.351027e-05
7,231	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.5793e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,853	Compression Aware Physical Database Design	2011	VLDB
2	5,489	Compressed Representations of Conjunctive Query Results	2018	PODS
3	8,563	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB
4	11,334	LogLite: Lightweight Plug-and-Play Streaming Log Compression	2025	VLDB
5	5,194	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,507	Adaptive Log Compression for Massive Log Data	2013	SIGMOD
8	900	Query Optimization In Compressed Database Systems	2001	SIGMOD
9	1,242	Compressing SQL Workloads	2002	SIGMOD
10	3,815	Comprehensive and Efficient Workload Compression	2021	VLDB