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.4929201e-05
Overall Rank
1,857 | 87.52%
DOI
10.14778/3389133.3389136

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,544 Exathlon: A Benchmark for Explainable Anomaly Detection over Time Series 2021 VLDB 0.00010304574
1,658 D-Bot: Database Diagnosis System using Large Language Models 2024 VLDB 9.9642078e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8742664e-05
3,169 Panda: Performance Debugging for Databases using LLM Agents 2024 CIDR 7.5696238e-05
3,682 openGauss: An Autonomous Database System 2021 VLDB 7.1013922e-05
4,114 Automatic Database Configuration Debugging using Retrieval-Augmented Language Models 2025 SIGMOD 6.7971182e-05
4,468 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.5863349e-05
5,077 DBPA: A Benchmark for Transactional Database Performance Anomalies 2023 SIGMOD 6.2858696e-05
5,149 LLM for Data Management 2024 VLDB 6.2551644e-05
5,559 ImDiffusion: Imputed Diffusion Models for Multivariate Time Series Anomaly Detection 2024 VLDB 6.0849722e-05
5,871 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 5.9639223e-05
7,236 RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems 2025 VLDB 5.5790509e-05
7,652 BALANCE: Bayesian Linear Attribution for Root Cause Localization 2023 SIGMOD 5.4772833e-05
10,716 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB 4.9793485e-05
10,908 DBAgent: An RL-Based Agent for Autonomous Database Operations and Maintenance 2026 VLDB 4.9793485e-05
11,412 DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs 2025 VLDB 4.9793485e-05
11,762 CORE-Sketch: On Exact Computation of Median Absolute Deviation with Limited Space 2023 VLDB 4.9793485e-05
11,795 DHive: Query Execution Performance Analysis via Dataflow in Apache Hive 2023 VLDB 4.9793485e-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.00064420972
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
78 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00036684414
460 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017842695
555 SageDB: A Learned Database System 2019 CIDR 0.00016506678
782 DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016 SIGMOD 0.00014022168
1,513 Cloud-Native Database Systems at Alibaba: Opportunities and Challenges 2019 VLDB 0.00010429438
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010402594
1,579 k-Shape: Efficient and Accurate Clustering of Time Series 2015 SIGMOD 0.00010186397
1,708 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.8224587e-05
1,939 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.3331247e-05
3,060 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.6928239e-05
4,058 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.8257215e-05
4,609 ExplainIt! - A Declarative Root-cause Analysis Engine for Time Series Data 2019 SIGMOD 6.503039e-05
5,650 TcpRT: Instrument and Diagnostic Analysis System for Service Quality of Cloud Databases at Massive Scale in Real-time 2018 SIGMOD 6.0521709e-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,145 Query-Driven Learning for Next Generation Predictive Modeling & Analytics 2019 SIGMOD
3 6,112 iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks 2019 SIGMOD
4 629 Performance Prediction for Concurrent Database Workloads 2011 SIGMOD
5 10,148 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB
6 10,735 AQD: Online Adaptive Query Dispatcher for HTAP Databases 2026 VLDB
7 4,468 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB
8 5,650 TcpRT: Instrument and Diagnostic Analysis System for Service Quality of Cloud Databases at Massive Scale in Real-time 2018 SIGMOD
9 5,033 Why Did My Query Slow Down? 2009 CIDR
10 7,236 RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems 2025 VLDB