IDEAS home Printed from https://ideas.repec.org/a/cvr/ijisrt/202607ijisrt26jul1270.html

Autonomous Database Administration Using Generative AI and Retrieval-Augmented Generation for Intelligent Enterprise Cloud Systems

Author

Listed:
  • Jipsa Mathew

  • Thomas Philip

Abstract

Enterprise database environments have grown into sprawling, heterogeneous estates spanning on-premises systems, Oracle Cloud Infrastructure, Amazon Web Services, and Microsoft Azure, placing an unsustainable operational burden on human database administrators (DBAs). Traditional automation, rooted in rule-based monitoring and narrow machine learning models, addresses isolated tasks such as index tuning or anomaly scoring, but it cannot reason across the full administrative lifecycle, nor explain its decisions in terms a human operator can trust and act upon. This paper introduces the Artificial Intelligence Driven Autonomous Database Administration System (AIDAS), a novel conceptual framework that unifies generative artificial intelligence, retrieval-augmented generation (RAG), vector search, multi-agent large language model (LLM) orchestration, and the Model Context Protocol (MCP) into a single governed architecture for autonomous enterprise database administration. AIDAS is organized as a seven-layer pipeline spanning telemetry ingestion, enterprise knowledge retrieval, standardized tool access, multi-agent reasoning, governed execution, and continuous institutional-memory capture. Unlike prior LLM-for-database systems, which typically target a single task such as diagnosis or query rewriting, AIDAS is architected to intelligently automate monitoring, incident detection, root cause analysis, infrastructure troubleshooting, performance and query optimization, security monitoring, compliance validation, automated documentation, and decision support as a coherent whole, while remaining portable across heterogeneous cloud database platforms through an MCP-based integration fabric. The paper presents the system architecture, the enterprise RAG pipeline, the multi-agent decision workflow, a formal orchestration algorithm, an implementation strategy, and four enterprise use cases. Because AIDAS is presented as a design-science contribution rather than a deployed and empirically measured system, the performance discussion is framed conceptually against patterns reported in the cited AIOps and LLM-for-database literature, and empirical validation is explicitly identified as future work. Six original contributions are articulated and differentiated from existing enterprise AI database solutions, and the paper concludes with a candid discussion of limitations, including hallucination risk, MCP security exposure, and the governance requirements of autonomous change execution in production environments.

Suggested Citation

  • Jipsa Mathew & Thomas Philip, 2026. "Autonomous Database Administration Using Generative AI and Retrieval-Augmented Generation for Intelligent Enterprise Cloud Systems," International Journal of Innovative Science and Research Technology (IJISRT), IJISRT Publication, vol. 11(07), pages 4013-4031, October.
  • Handle: RePEc:cvr:ijisrt:2026:07:ijisrt26jul1270
    DOI: https://doi.org/10.38124/ijisrt/26jul1270
    as

    Download full text from publisher

    File URL: https://www.ijisrt.com/autonomous-database-administration-using-generative-ai-and-retrievalaugmented-generation-for-intelligent-enterprise-cloud-systems
    Download Restriction: no

    File URL: https://libkey.io/https://doi.org/10.38124/ijisrt/26jul1270?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    More about this item

    Keywords

    ;
    ;
    ;
    ;
    ;
    ;
    ;
    ;
    ;
    ;

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:cvr:ijisrt:2026:07:ijisrt26jul1270. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Rahul Goyel (email available below). General contact details of provider: https://www.ijisrt.com/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.