Primitives for Workload Summarization and Implications for SQL

Summary: Proposes a compact set of primitives for scalable SQL workload summarization, enabling DBA tasks and query-log analytics. Shows SQL inadequacies for these primitives and outlines extensions to SQL and the relational engine to support efficient, practical summarization. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9020
Venue: VLDB
Year: 2003
Pagerank: 6.28375e-05
Overall Rank: 4,280 | 70.26%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,811	Changing the Face of Database Cloud Services with Personalized Service Level Agreements	2015	CIDR	6.7372095e-05
4,469	Comprehensive and Efficient Workload Compression	2021	VLDB	6.1535623e-05
4,480	Variance Aware Optimization of Parameterized Queries	2010	SIGMOD	6.1433292e-05
4,547	Database-Agnostic Workload Management	2019	CIDR	6.0904384e-05
6,364	ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning	2022	SIGMOD	5.0895007e-05
7,602	Oracle Workload Intelligence	2015	SIGMOD	4.6964845e-05
9,955	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	4.2332427e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
72	Combining Fuzzy Information from Multiple Systems	1996	PODS	0.00058498396
160	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040053897
171	Fuzzy Queries in Multimedia Database Systems	1998	PODS	0.00038843975
181	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036970794
262	Efficient Progressive Skyline Computation	2001	VLDB	0.00029962961
517	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00021193179
527	Self-tuning Histograms: Building Histograms Without Looking at Data	1999	SIGMOD	0.00020862475
640	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018780632
736	Congressional Samples for Approximate Answering of Group-By Queries	2000	SIGMOD	0.00017414831
746	An Optimal and Progressive Algorithm for Skyline Queries	2003	SIGMOD	0.00017212135
1,331	ICICLES: Self-tuning Samples for Approximate Query Answering	2000	VLDB	0.00012553948
1,952	Groupwise Processing of Relational Queries	1997	VLDB	9.9806285e-05
2,813	A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries	2001	SIGMOD	8.0816314e-05
7,996	On Relational Support for XML Publishing: Beyond Sorting and Tagging	2003	SIGMOD	4.606878e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,168	A Language and a Physical Organization Technique for Summary Tables	1985	SIGMOD	7.4547451e-05
1,506	Summarizing Relational Databases	2009	VLDB	0.0001159691
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010663123
3,539	General purpose database summarization	2005	VLDB	6.9925094e-05
1,794	Summary Graphs for Relational Database Schemas	2011	VLDB	0.00010516799
5,645	Database Workload Characterization with Query Plan Encoders	2022	VLDB	5.3928148e-05
8,360	Query Log Compression for Workload Analytics	2019	VLDB	4.5314883e-05
1,270	Schema Summarization	2006	VLDB	0.00012911456
4,469	Comprehensive and Efficient Workload Compression	2021	VLDB	6.1535623e-05
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011944621