LLM As DBA

  • 2023-08-11 08:55:19
  • Xuanhe Zhou, Guoliang Li, Zhiyuan Liu
  • 0

Abstract

Database administrators (DBAs) play a crucial role in managing, maintainingand optimizing a database system to ensure data availability, performance, andreliability. However, it is hard and tedious for DBAs to manage a large numberof database instances (e.g., millions of instances on the cloud databases).Recently large language models (LLMs) have shown great potential to understandvaluable documents and accordingly generate reasonable answers. Thus, wepropose D-Bot, a LLM-based database administrator that can continuously acquiredatabase maintenance experience from textual sources, and provide reasonable,well-founded, in-time diagnosis and optimization advice for target databases.This paper presents a revolutionary LLM-centric framework for databasemaintenance, including (i) database maintenance knowledge detection fromdocuments and tools, (ii) tree of thought reasoning for root cause analysis,and (iii) collaborative diagnosis among multiple LLMs. Our preliminaryexperimental results that D-Bot can efficiently and effectively diagnose theroot causes and our code is available atgithub.com/TsinghuaDatabaseGroup/DB-GPT.

 

Quick Read (beta)

loading the full paper ...