DBScholar

Back to papers

Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases

Summary: Introduces iSQUAD for diagnosing intermittent slow queries caused by external database or machine issues, rather than SQL defects. Combines anomaly extraction, dependency cleansing, TOPIC clustering, and Bayesian case modeling for low-label, interpretable online diagnosis (80.4% F1). (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h7646acd4945ef519
Venue
VLDB
Year
2020
Pagerank
9.5032324e-05
Overall Rank
1,849 | 87.58%
DOI
10.14778/3389133.3389136
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{ma_vldb20,
        title = {{Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases}},
        author = {Ma, Minghua and Yin, Zheng and Zhang, Shenglin and Wang, Sheng and Zheng, Christopher and Jiang, Xinhao and Hu, Hanwen and Luo, Cheng and Li, Yilin and Qiu, Nengjun and Li, Feifei and Chen, Changcheng and Pei, Dan},
        journal = {PVLDB},
        series = {{VLDB} '20},
        volume = {13},
        number = {8},
        pages = {1176--1189},
        doi = {10.14778/3389133.3389136},
        url = {https://doi.org/10.14778/3389133.3389136},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 18 of 18 citing papers.

Rank Citing Paper Year Venue Pagerank
1,545 Exathlon: A Benchmark for Explainable Anomaly Detection over Time Series 2021 VLDB 0.00010299696
1,659 D-Bot: Database Diagnosis System using Large Language Models 2024 VLDB 9.9625133e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8716173e-05
3,171 Panda: Performance Debugging for Databases using LLM Agents 2024 CIDR 7.5661555e-05
3,680 openGauss: An Autonomous Database System 2021 VLDB 7.1016555e-05
4,113 Automatic Database Configuration Debugging using Retrieval-Augmented Language Models 2025 SIGMOD 6.7964307e-05
4,470 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.5833414e-05
4,727 LLM for Data Management 2024 VLDB 6.4461562e-05
5,080 DBPA: A Benchmark for Transactional Database Performance Anomalies 2023 SIGMOD 6.2830313e-05
5,561 ImDiffusion: Imputed Diffusion Models for Multivariate Time Series Anomaly Detection 2024 VLDB 6.0820916e-05
5,700 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 6.028998e-05
7,238 RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems 2025 VLDB 5.5764098e-05
7,658 BALANCE: Bayesian Linear Attribution for Root Cause Localization 2023 SIGMOD 5.4746904e-05
10,726 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB 4.9769913e-05
10,917 DBAgent: An RL-Based Agent for Autonomous Database Operations and Maintenance 2026 VLDB 4.9769913e-05
11,418 DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs 2025 VLDB 4.9769913e-05
11,768 CORE-Sketch: On Exact Computation of Median Absolute Deviation with Limited Space 2023 VLDB 4.9769913e-05
11,801 DHive: Query Execution Performance Analysis via Dataflow in Apache Hive 2023 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

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.00064391979
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
78 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00036675568
461 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017841988
555 SageDB: A Learned Database System 2019 CIDR 0.0001650754
783 DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016 SIGMOD 0.0001401708
1,512 Cloud-Native Database Systems at Alibaba: Opportunities and Challenges 2019 VLDB 0.00010425349
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010398346
1,579 k-Shape: Efficient and Accurate Clustering of Time Series 2015 SIGMOD 0.00010182038
1,708 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.8184303e-05
1,940 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.3298436e-05
3,057 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.6960881e-05
4,058 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.8230003e-05
4,611 ExplainIt! - A Declarative Root-cause Analysis Engine for Time Series Data 2019 SIGMOD 6.5004232e-05
5,649 TcpRT: Instrument and Diagnostic Analysis System for Service Quality of Cloud Databases at Massive Scale in Real-time 2018 SIGMOD 6.0497711e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,059 Database-Agnostic Workload Management 2019 CIDR
2 12,151 Query-Driven Learning for Next Generation Predictive Modeling & Analytics 2019 SIGMOD
3 6,113 iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks 2019 SIGMOD
4 629 Performance Prediction for Concurrent Database Workloads 2011 SIGMOD
5 10,152 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB
6 10,745 AQD: Online Adaptive Query Dispatcher for HTAP Databases 2026 VLDB
7 4,470 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB
8 5,649 TcpRT: Instrument and Diagnostic Analysis System for Service Quality of Cloud Databases at Massive Scale in Real-time 2018 SIGMOD
9 5,035 Why Did My Query Slow Down? 2009 CIDR
10 7,238 RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems 2025 VLDB