Enhancing Database Performance through a Comparison of Traditional and AI-Driven Query Optimization Techniques

Uzo Blessing Chimezie, Atanda Aminat Oluchi and Levi Arinze Ugwu
Additional contact information
Uzo Blessing Chimezie: Department of Computer Science, Faculty of Physical Sciences, University of Nigeria, Nsukka
Atanda Aminat Oluchi: Department of Computer Science, Faculty of Physical Sciences, University of Nigeria, Nsukka
Levi Arinze Ugwu: James Cook University, Cairns, Australia

International Journal of Research and Scientific Innovation, 2025, vol. 12, issue 7, 1309-1320

Abstract: Query optimization is a fundamental aspect of database management systems (DBMS), crucial for enhancing query performance and resource utilization. Traditional methods for optimising queries can handle most cases, but they are inflexible in dealing with difficult or highly dynamic query workloads. New approaches in AI and ML are now available to help overcome these challenges, supporting more flexible optimization methods. This paper presents a comparative study of traditional and AI-driven query optimization approaches. Using synthetic data, we evaluate multiple machine learning models, including CatBoost, LightGBM, and ExtraTrees, against a traditional rule-based baseline that relies on indexing heuristics. The results show that AI-driven models, particularly CatBoost, achieved an accuracy of 59%, outperformed traditional methods (48%) in terms of accuracy, precision, recall, and F1-score, highlighting their ability to capture complex feature interactions and improve query execution efficiency. Despite the promising performance of AI models, the paper also discusses the trade-offs involved, including the interpretability challenges and computational overhead associated with AI-based approaches. This study demonstrates the potential of AI-driven optimizers as a valuable tool for modern DBMSs, particularly in dynamic and high-complexity environments.

Date: 2025
References: Add references at CitEc
Citations:

Downloads: (external link)
https://www.rsisinternational.org/journals/ijrsi/d ... ssue-7/1309-1320.pdf (application/pdf)
https://rsisinternational.org/journals/ijrsi/artic ... mization-techniques/ (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:bjc:journl:v:12:y:2025:i:67:p:1309-1320

Access Statistics for this article

International Journal of Research and Scientific Innovation is currently edited by Dr. Renu Malsaria

More articles in International Journal of Research and Scientific Innovation from International Journal of Research and Scientific Innovation (IJRSI)
Bibliographic data for series maintained by Dr. Renu Malsaria ().