Back to papers
Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases
Summary: Diagnoses root causes of intermittent slow queries (iSQs) in cloud DBs; iSQUAD maps iSQs to external performance factors with ML. Offline clustering with anomaly extraction, TOPIC, Bayesian Case Model; online diagnosis with DBA labeling; Alibaba OLTP data yields 80.4% F1.
(summarized by gpt-5-nano on Feb 09 2026)
- Paper ID
- 12036
- Venue
- VLDB
- Year
- 2020
- Pagerank
- 9.4565836e-05
- Overall Rank
- 2,140 | 85.13%
- DOI
-
10.14778/3389133.3389136
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 17 of 17 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 1,640 |
Exathlon: A Benchmark for Explainable Anomaly Detection over Time Series |
2021 |
VLDB |
0.00011048873 |
| 1,953 |
D-Bot: Database Diagnosis System using Large Language Models |
2024 |
VLDB |
9.9701097e-05 |
| 3,435 |
Real-time Workload Pattern Analysis for Large-scale Cloud Databases |
2023 |
VLDB |
7.0946114e-05 |
| 3,466 |
AI Meets Database: AI4DB and DB4AI |
2021 |
SIGMOD |
7.0645718e-05 |
| 4,151 |
openGauss: An Autonomous Database System |
2021 |
VLDB |
6.4020605e-05 |
| 4,234 |
Panda: Performance Debugging for Databases using LLM Agents |
2024 |
CIDR |
6.3300159e-05 |
| 4,870 |
DBPA: A Benchmark for Transactional Database Performance Anomalies |
2023 |
SIGMOD |
5.8583776e-05 |
| 5,785 |
ImDiffusion: Imputed Diffusion Models for Multivariate Time Series Anomaly Detection |
2024 |
VLDB |
5.3257637e-05 |
| 6,564 |
Automatic Database Configuration Debugging using Retrieval-Augmented Language Models |
2025 |
SIGMOD |
5.0037892e-05 |
| 6,883 |
PilotScope: Steering Databases with Machine Learning Drivers |
2024 |
VLDB |
4.8918682e-05 |
| 6,904 |
BALANCE: Bayesian Linear Attribution for Root Cause Localization |
2023 |
SIGMOD |
4.8878659e-05 |
| 7,016 |
LLM for Data Management |
2024 |
VLDB |
4.8561622e-05 |
| 7,993 |
RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems |
2025 |
VLDB |
4.6080455e-05 |
| 10,244 |
DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs |
2026 |
VLDB |
4.1905499e-05 |
| 10,827 |
DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs |
2025 |
VLDB |
4.1905499e-05 |
| 11,252 |
CORE-Sketch: On Exact Computation of Median Absolute Deviation with Limited Space |
2023 |
VLDB |
4.1905499e-05 |
| 11,288 |
DHive: Query Execution Performance Analysis via Dataflow in Apache Hive |
2023 |
VLDB |
4.1905499e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 15 of 15 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 13 |
Mining Association Rules between Sets of Items in Large Databases |
1993 |
SIGMOD |
0.0010863639 |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059446482 |
| 183 |
Automatic Database Management System Tuning Through Large-scale Machine Learning |
2017 |
SIGMOD |
0.00036859633 |
| 704 |
Query-based Workload Forecasting for Self-Driving Database Management Systems |
2018 |
SIGMOD |
0.00017785557 |
| 796 |
SageDB: A Learned Database System |
2019 |
CIDR |
0.00016541749 |
| 1,024 |
DBSherlock: A Performance Diagnostic Tool for Transactional Databases |
2016 |
SIGMOD |
0.00014601525 |
| 1,510 |
k-Shape: Efficient and Accurate Clustering of Time Series |
2015 |
SIGMOD |
0.00011588558 |
| 1,533 |
PerfXplain: Debugging MapReduce Job Performance |
2012 |
VLDB |
0.00011462982 |
| 1,721 |
Cloud-Native Database Systems at Alibaba: Opportunities and Challenges |
2019 |
VLDB |
0.00010741822 |
| 2,050 |
Automatically Indexing Millions of Databases in Microsoft Azure SQL Database |
2019 |
SIGMOD |
9.6883066e-05 |
| 2,239 |
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads |
2013 |
SIGMOD |
9.2163469e-05 |
| 3,658 |
Towards a Hands-Free Query Optimizer through Deep Learning |
2019 |
CIDR |
6.8700949e-05 |
| 4,412 |
Semi-Automatic Index Tuning: Keeping DBAs in the Loop |
2012 |
VLDB |
6.1999789e-05 |
| 4,655 |
ExplainIt! - A Declarative Root-cause Analysis Engine for Time Series Data |
2019 |
SIGMOD |
6.0126689e-05 |
| 5,740 |
TcpRT: Instrument and Diagnostic Analysis System for Service Quality of Cloud Databases at Massive Scale in Real-time |
2018 |
SIGMOD |
5.3451127e-05 |
Semantically Similar Papers