Real-time Workload Pattern Analysis for Large-scale Cloud Databases

Summary: AWM: real-time mining of complex cloud DB workloads by encoding streaming SQL into semantic+execution embeddings and per-business-group clustering. Integrates offline-labeled classification and pattern-based query optimizations; +66% accuracy, -22% latency vs SOTA. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13197
Venue: VLDB
Year: 2023
Pagerank: 7.1010535e-05
Overall Rank: 3,429 | 76.15%
DOI: 10.14778/3611540.3611557

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,298	TFB: Towards Comprehensive and Fair Benchmarking of Time Series Forecasting Methods	2024	VLDB	9.0742746e-05
3,114	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	7.5451724e-05
6,750	Breaking It Down: An In-depth Study of Index Advisors	2024	VLDB	4.9392771e-05
8,020	The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions	2024	VLDB	4.6040862e-05
9,915	Camel: Efficient Compression of Floating-Point Time Series	2024	SIGMOD	4.2561557e-05
10,212	SQLBarber: A System Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads	2026	SIGMOD	4.1945683e-05
10,217	This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch!	2026	SIGMOD	4.1945683e-05
10,750	Quantifying Point Contributions: A Lightweight Framework for Efficient and Effective Query-Driven Trajectory Simplification	2025	VLDB	4.1945683e-05
10,850	Mayura: Exploiting Similarities in Motifs for Temporal Co-Mining	2025	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 28 of 28 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
156	Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases	2017	SIGMOD	0.00040504295
333	Neo: A Learned Query Optimizer	2019	VLDB	0.00027206884
359	Self-Driving Database Management Systems	2017	CIDR	0.0002592783
424	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023616398
640	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00018759152
716	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017723171
868	Profiling, What-if Analysis, and Cost-based Optimization of MapReduce Programs	2011	VLDB	0.00015789681
1,022	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.00014614917
2,047	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	9.6920209e-05
2,139	Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases	2020	VLDB	9.4640037e-05
2,230	Performance and Resource Modeling in Highly-Concurrent OLTP Workloads	2013	SIGMOD	9.2322426e-05
2,925	Shared Workload Optimization	2014	VLDB	7.888494e-05
3,216	WiSeDB: A Learning-based Workload Management Advisor for Cloud Databases	2016	VLDB	7.3601267e-05
3,248	A Learned Query Rewrite System using Monte Carlo Tree Search	2022	VLDB	7.3258782e-05
4,152	openGauss: An Autonomous Database System	2021	VLDB	6.4060406e-05
4,355	LargeEA: Aligning Entities for Large-scale Knowledge Graphs	2022	VLDB	6.259483e-05
4,390	LogStore: A Cloud-Native and Multi-Tenant Log Database	2021	SIGMOD	6.2279149e-05
4,468	Comprehensive and Efficient Workload Compression	2021	VLDB	6.1584035e-05
4,661	PreQR: Pre-training Representation for SQL Understanding	2022	SIGMOD	6.0137947e-05
5,473	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	5.4885366e-05
5,637	Database Workload Characterization with Query Plan Encoders	2022	VLDB	5.3979505e-05
6,004	Compression of Uncertain Trajectories in Road Networks	2020	VLDB	5.2415551e-05
6,757	KEA: Tuning an Exabyte-Scale Data Infrastructure	2021	SIGMOD	4.9372134e-05
7,127	Guided automated learning for query workload re-optimization	2019	VLDB	4.8230386e-05
7,597	Oracle Workload Intelligence	2015	SIGMOD	4.7007801e-05
7,622	Workload Optimization using SharedDB	2013	SIGMOD	4.6935227e-05
8,729	OneProvenance: Efficient Extraction of Dynamic Coarse-Grained Provenance From Database Query Event Logs	2023	VLDB	4.4582221e-05
9,446	TRACE: Real-time Compression of Streaming Trajectories in Road Networks	2021	VLDB	4.3404859e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
4,961	Releasing Cloud Databases from the Chains of Performance Prediction Models	2017	CIDR	5.7984657e-05
514	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.0002124895
5,861	Machine Learning for Databases	2021	VLDB	5.298883e-05
13,425	Data Mining Algorithms as a Service in the Cloud: Exploiting Relational Database Systems	2013	SIGMOD	-
3,076	Learning a Partitioning Advisor for Cloud Databases	2020	SIGMOD	7.6107677e-05
7,989	RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems	2025	VLDB	4.6124681e-05
10,787	AnalyticDB-PG: A Cloud-native High-performance Data Warehouse in Alibaba Cloud	2025	VLDB	4.1945683e-05
3,152	AnalyticDB: Real-time OLAP Database System at Alibaba Cloud	2019	VLDB	7.4711766e-05
4,549	Database-Agnostic Workload Management	2019	CIDR	6.0926728e-05
5,637	Database Workload Characterization with Query Plan Encoders	2022	VLDB	5.3979505e-05