DBScholar

Back to papers

D-Bot: Database Diagnosis System using Large Language Models

Summary: D-Bot: LLM-driven DB diagnosis that ingests docs, auto-prompts and retrieves tools, and uses tree-search plus collaboration to pinpoint root causes. Tested on 539 anomalies from six apps; finds unseen root causes in minutes and beats heuristics and GPT-4. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
h001340b5e1ec5247
Venue
VLDB
Year
2024
Pagerank
9.948529e-05
Overall Rank
1,656 | 88.91%
DOI
10.14778/3675034.3675043
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{zhou_vldb24,
        title = {{D-Bot: Database Diagnosis System using Large Language Models}},
        author = {Zhou, Xuanhe and Li, Guoliang and Sun, Zhaoyan and Liu, Zhiyuan and Chen, Weize and Wu, Jianming and Liu, Jiesi and Feng, Ruohang and Zeng, Guoyang},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {10},
        pages = {2514--2527},
        doi = {10.14778/3675034.3675043},
        url = {https://doi.org/10.14778/3675034.3675043},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 31 of 31 citing papers.

Rank Citing Paper Year Venue Pagerank
3,158 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.5676704e-05
3,286 In-depth Analysis of Graph-based RAG in a Unified Framework 2025 VLDB 7.441688e-05
3,426 AutoTQA: Towards Autonomous Tabular Question Answering through Multi-Agent Large Language Models 2024 VLDB 7.2967299e-05
3,839 Automatic Database Configuration Debugging using Retrieval-Augmented Language Models 2025 SIGMOD 6.9704205e-05
3,909 SQLStorm: Taking Database Benchmarking into the LLM Era 2025 VLDB 6.9127576e-05
3,914 AOP: Automated and Interactive LLM Pipeline Orchestration for Answering Complex Queries 2025 CIDR 6.9084826e-05
4,004 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 6.846192e-05
4,351 Chat2Data: An Interactive Data Analysis System with RAG, Vector Databases and LLMs 2024 VLDB 6.634024e-05
4,383 R-Bot: An LLM-based Query Rewrite System 2025 VLDB 6.6140223e-05
4,729 LLM for Data Management 2024 VLDB 6.4317927e-05
5,908 Unify: A System For Unstructured Data Analytics 2025 VLDB 5.9343313e-05
7,092 E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model 2025 VLDB 5.5868637e-05
7,257 RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems 2025 VLDB 5.5579707e-05
9,256 SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation 2026 VLDB 5.1860131e-05
9,946 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.0910746e-05
10,323 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 5.0241309e-05
10,325 Andromeda: Debugging Database Performance Issues with Retrieval-Augmented Large Language Models 2025 SIGMOD 5.0241309e-05
10,326 D-Bot: An LLM-Powered DBA Copilot 2025 SIGMOD 5.0241309e-05
10,543 HAMMER: An Automatic RAG Tuning System via Hierarchical Memory-Guided Monte Carlo Tree Search 2026 SIGMOD 4.9605343e-05
10,653 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 4.9605343e-05
10,787 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB 4.9605343e-05
10,792 Pisco: An Isolation Bug Case Reduction and Deduplication Framework 2026 VLDB 4.9605343e-05
10,978 DBAgent: An RL-Based Agent for Autonomous Database Operations and Maintenance 2026 VLDB 4.9605343e-05
10,988 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9605343e-05
11,099 Graph-Based Retrieval-Augmented Generation: Applications, Challenges, Solutions, and Opportunities 2026 VLDB 4.9605343e-05
11,260 PLM4NDV: Minimizing Data Access for Number of Distinct Values Estimation with Pre-trained Language Models 2025 SIGMOD 4.9605343e-05
11,335 ChatTS: Aligning Time Series with LLMs via Synthetic Data for Enhanced Understanding and Reasoning 2025 VLDB 4.9605343e-05
11,346 LobRA: Multi-tenant Fine-tuning over Heterogeneous Data 2025 VLDB 4.9605343e-05
11,439 GalaxyWeaver: Autonomous Table-to-Graph Conversion and Schema Optimization with Large Language Models 2025 VLDB 4.9605343e-05
11,471 DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs 2025 VLDB 4.9605343e-05
13,656 Data Management for Agentic Memory: Foundations, Systems, and Challenges 2026 VLDB -
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028611216
382 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.0001946654
411 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.0001874043
583 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR 0.00015964021
757 DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016 SIGMOD 0.00014202187
1,238 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.00011375179
1,771 Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases 2020 VLDB 9.6775181e-05
1,888 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.4148912e-05
2,389 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5228689e-05
4,351 Chat2Data: An Interactive Data Analysis System with RAG, Vector Databases and LLMs 2024 VLDB 6.634024e-05
5,098 DBPA: A Benchmark for Transactional Database Performance Anomalies 2023 SIGMOD 6.2631174e-05
6,126 iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks 2019 SIGMOD 5.8614712e-05
8,639 A Learned Query Rewrite System 2023 VLDB 5.2825942e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 10,324 Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents 2026 VLDB
2 10,323 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD
3 10,978 DBAgent: An RL-Based Agent for Autonomous Database Operations and Maintenance 2026 VLDB
4 9,607 Demonstration of DB-GPT: Next Generation Data Interaction System Empowered by Large Language Models 2024 VLDB
5 10,325 Andromeda: Debugging Database Performance Issues with Retrieval-Augmented Large Language Models 2025 SIGMOD
6 3,839 Automatic Database Configuration Debugging using Retrieval-Augmented Language Models 2025 SIGMOD
7 2,995 Panda: Performance Debugging for Databases using LLM Agents 2024 CIDR
8 4,383 R-Bot: An LLM-based Query Rewrite System 2025 VLDB
9 10,787 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB
10 10,326 D-Bot: An LLM-Powered DBA Copilot 2025 SIGMOD