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
- 12035
- Venue
- VLDB
- Year
- 2020
- Pagerank
- 9.4640037e-05
- Overall Rank
- 2,139 | 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,634 |
Exathlon: A Benchmark for Explainable Anomaly Detection over Time Series |
2021 |
VLDB |
0.00011058945 |
| 1,956 |
D-Bot: Database Diagnosis System using Large Language Models |
2024 |
VLDB |
9.960627e-05 |
| 3,429 |
Real-time Workload Pattern Analysis for Large-scale Cloud Databases |
2023 |
VLDB |
7.1010535e-05 |
| 3,473 |
AI Meets Database: AI4DB and DB4AI |
2021 |
SIGMOD |
7.062864e-05 |
| 4,152 |
openGauss: An Autonomous Database System |
2021 |
VLDB |
6.4060406e-05 |
| 4,238 |
Panda: Performance Debugging for Databases using LLM Agents |
2024 |
CIDR |
6.331901e-05 |
| 4,868 |
DBPA: A Benchmark for Transactional Database Performance Anomalies |
2023 |
SIGMOD |
5.8629636e-05 |
| 5,777 |
ImDiffusion: Imputed Diffusion Models for Multivariate Time Series Anomaly Detection |
2024 |
VLDB |
5.3308813e-05 |
| 6,765 |
Automatic Database Configuration Debugging using Retrieval-Augmented Language Models |
2025 |
SIGMOD |
4.9325583e-05 |
| 6,885 |
PilotScope: Steering Databases with Machine Learning Drivers |
2024 |
VLDB |
4.895386e-05 |
| 6,901 |
BALANCE: Bayesian Linear Attribution for Root Cause Localization |
2023 |
SIGMOD |
4.8925595e-05 |
| 7,020 |
LLM for Data Management |
2024 |
VLDB |
4.8595728e-05 |
| 7,989 |
RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems |
2025 |
VLDB |
4.6124681e-05 |
| 10,244 |
DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs |
2026 |
VLDB |
4.1945683e-05 |
| 10,822 |
DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs |
2025 |
VLDB |
4.1945683e-05 |
| 11,250 |
CORE-Sketch: On Exact Computation of Median Absolute Deviation with Limited Space |
2023 |
VLDB |
4.1945683e-05 |
| 11,286 |
DHive: Query Execution Performance Analysis via Dataflow in Apache Hive |
2023 |
VLDB |
4.1945683e-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.0010864752 |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059038975 |
| 183 |
Automatic Database Management System Tuning Through Large-scale Machine Learning |
2017 |
SIGMOD |
0.00036721403 |
| 716 |
Query-based Workload Forecasting for Self-Driving Database Management Systems |
2018 |
SIGMOD |
0.00017723171 |
| 801 |
SageDB: A Learned Database System |
2019 |
CIDR |
0.00016505496 |
| 1,022 |
DBSherlock: A Performance Diagnostic Tool for Transactional Databases |
2016 |
SIGMOD |
0.00014614917 |
| 1,516 |
k-Shape: Efficient and Accurate Clustering of Time Series |
2015 |
SIGMOD |
0.00011586255 |
| 1,534 |
PerfXplain: Debugging MapReduce Job Performance |
2012 |
VLDB |
0.00011468393 |
| 1,729 |
Cloud-Native Database Systems at Alibaba: Opportunities and Challenges |
2019 |
VLDB |
0.0001073728 |
| 2,047 |
Automatically Indexing Millions of Databases in Microsoft Azure SQL Database |
2019 |
SIGMOD |
9.6920209e-05 |
| 2,230 |
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads |
2013 |
SIGMOD |
9.2322426e-05 |
| 3,658 |
Towards a Hands-Free Query Optimizer through Deep Learning |
2019 |
CIDR |
6.8704209e-05 |
| 4,415 |
Semi-Automatic Index Tuning: Keeping DBAs in the Loop |
2012 |
VLDB |
6.205081e-05 |
| 4,658 |
ExplainIt! - A Declarative Root-cause Analysis Engine for Time Series Data |
2019 |
SIGMOD |
6.0183783e-05 |
| 5,732 |
TcpRT: Instrument and Diagnostic Analysis System for Service Quality of Cloud Databases at Massive Scale in Real-time |
2018 |
SIGMOD |
5.3501728e-05 |
Semantically Similar Papers