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
12223
Venue
VLDB
Year
2020
Pagerank
9.430385e-05
Overall Rank
1,949 | 86.63%
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 17 of 17 citing papers.

Rank Citing Paper Year Venue Pagerank
1,534 Exathlon: A Benchmark for Explainable Anomaly Detection over Time Series 2021 VLDB 0.00010464308
1,920 D-Bot: Database Diagnosis System using Large Language Models 2024 VLDB 9.4846185e-05
2,888 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.9941489e-05
3,662 openGauss: An Autonomous Database System 2021 VLDB 7.2166682e-05
3,757 Panda: Performance Debugging for Databases using LLM Agents 2024 CIDR 7.1483644e-05
4,398 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.7248611e-05
5,023 DBPA: A Benchmark for Transactional Database Performance Anomalies 2023 SIGMOD 6.3979497e-05
5,420 ImDiffusion: Imputed Diffusion Models for Multivariate Time Series Anomaly Detection 2024 VLDB 6.2246363e-05
5,856 Automatic Database Configuration Debugging using Retrieval-Augmented Language Models 2025 SIGMOD 6.0644656e-05
6,101 LLM for Data Management 2024 VLDB 5.9774273e-05
6,462 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 5.8717744e-05
7,506 BALANCE: Bayesian Linear Attribution for Root Cause Localization 2023 SIGMOD 5.6029996e-05
7,825 RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems 2025 VLDB 5.5367884e-05
10,532 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB 5.093636e-05
11,049 DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs 2025 VLDB 5.093636e-05
11,450 CORE-Sketch: On Exact Computation of Median Absolute Deviation with Limited Space 2023 VLDB 5.093636e-05
11,485 DHive: Query Execution Performance Analysis via Dataflow in Apache Hive 2023 VLDB 5.093636e-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.0006567919
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
86 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00035316107
461 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00018068441
568 SageDB: A Learned Database System 2019 CIDR 0.0001641553
798 DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016 SIGMOD 0.00013919795
1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010392475
1,559 Cloud-Native Database Systems at Alibaba: Opportunities and Challenges 2019 VLDB 0.00010362456
1,579 k-Shape: Efficient and Accurate Clustering of Time Series 2015 SIGMOD 0.00010305183
1,694 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.9953156e-05
1,931 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.4664741e-05
3,051 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.8121919e-05
4,039 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.9424878e-05
4,548 ExplainIt! - A Declarative Root-cause Analysis Engine for Time Series Data 2019 SIGMOD 6.63688e-05
5,539 TcpRT: Instrument and Diagnostic Analysis System for Service Quality of Cloud Databases at Massive Scale in Real-time 2018 SIGMOD 6.1817228e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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