CoChat
Sign Up
Cited by 5Advanced Database Systems and QueriesData Management and AlgorithmsImpact of AI and Big Data on Business and Society

The DOI matches its Crossref record.

Impact of Artificial Intelligence and Machine Learning Techniques in Database Management System Components

Vijaya, J., Paul, Suvankar, Sharma, Rohan·2025·Advances in Computational Intelligence and Robotics
DOI 10.4018/979-8-3373-1210-1.ch003
Open this paper in CoChat — free account

Abstract

The integration of artificial intelligence (AI) and machine learning (ML) in database management systems (DBMS) is revolutionizing how data is managed and analyzed. This review highlights the role of AI/ML in enhancing DBMS functions such as intelligent transaction scheduling (e.g., conflict prediction in OLTP), adaptive query optimization (e.g., reinforcement learning for plan selection), and automated configuration tuning (e.g., workload-aware systems like RocksDB). Key components include data preprocessing (feature extraction, normalization), architectural integration (embedding ML into optimizers, use of federated learning), and evaluation using metrics such as query latency, throughput, and model accuracy. While these innovations offer greater efficiency and scalability, ethical considerations such as data privacy, bias, and system transparency are crucial. This paper emphasizes the need for responsible AI adoption in DBMS to support real-time analytics, operational efficiency, and intelligent data-driven applications.

Overview

Integrity signals

Registry

Crossref · 10.4018/979-8-3373-1210-1.ch003

Cites

Statistics

Recomputing p-values needs the paper’s full text.

Verification

Claims the paper makes

This paper’s full text isn’t openly available, so its claims and self-check weren’t run. The registry and citation checks still apply.

Claims other papers make about this one

Each is checked against this paper’s own text: does it say what the citing paper says it does?

Citations

Cites

No references could be resolved yet.

Research works printed but not linked: 42

  1. AbbasiM.BernardoM. V.VázP.SilvaJ.MartinsP. (2024). Adaptive and Scalable Database Management with Machine Learning Integration: A PostgreSQL Case Study.Information (Basel), 15(9), 574. · DOI
  2. 10.17509/ijost.v8i1.52709 · DOI
  3. BaiD. (2023, December). Design of Artificial Intelligence Information System Using NoSQL Database and Ajax Technology. In 2023 International Conference on Applied Physics and Computing (ICAPC) (pp. 678-683). IEEE. · DOI
  4. Cao, X., Ge, B., Li, M., Wang, H., & Ren, J. (2022, November). Database Protection Techniques for Electromagnetic Radiation Based on Machine Learning. In 2022 IEEE 10th Asia-Pacific Conference on Antennas and Propagation (APCAP) (pp. 1-2). IEEE. · DOI
  5. 10.12720/jait.11.3.135-142 · DOI
  6. ChaudhuriS. (1998). Data mining and database systems: Where is the intersection?IEEE Data Eng. Bull., 21(1), 4–8.
  7. DingB.DasS.MarcusR.WuW.ChaudhuriS.NarasayyaV. R. (2019, June). Ai meets ai: Leveraging query executions to improve index recommendations. In Proceedings of the 2019 International Conference on Management of Data (pp. 1241-1258). · DOI
  8. GaddeH. (2024). AI-Augmented Database Management Systems for Real-Time Data Analytics.Revista de Inteligencia Artificial en Medicina, 15(1), 616–649.
  9. HaoH. (2021, October). Database Mining Information System Based on Artificial Intelligence Algorithm. In 2021 IEEE International Conference on Data Science and Computer Application (ICDSCA) (pp. 181-185). IEEE.
  10. Huang, X., Gao, X., & Chen, G. (2024, January). Ditune: A reinforcement learning based framework for automated database index selection. In 2024 18th International Conference on Ubiquitous Information Management and Communication (IMCOM) (pp. 1-8). IEEE. · DOI
  11. KandoloW. (2024). Ensuring ai data access control in rdbms: A comprehensive review. In Proceedings of the IEEE/CVF Conference on Computer Vision and Pattern Recognition (pp. 8400-8407).
  12. KumarA.BoehmM.YangJ. (2017, May). Data management in machine learning: Challenges, techniques, and systems. In Proceedings of the 2017 ACM International Conference on Management of Data (pp. 1717-1722). · DOI
  13. LiG.ZhouX.CaoL. (2021, October). Machine learning for databases. In Proceedings of the First International Conference on AI-ML Systems (pp. 1-2).
  14. MaJ. (2022, July). Research on Intelligent Management System of Practical Courses Based on Artificial Intelligence Technology. In 2022 International Conference on Artificial Intelligence and Autonomous Robot Systems (AIARS) (pp. 315-318). IEEE.
  15. Miao, H., Li, A., Davis, L. S., & Deshpande, A. (2017, April). Towards unified data and lifecycle management for deep learning. In 2017 IEEE 33rd International Conference on Data Engineering (ICDE) (pp. 571-582). IEEE. · DOI
  16. Munappy, A., Bosch, J., Olsson, H. H., Arpteg, A., & Brinne, B. (2019, August). Data management challenges for deep learning. In 2019 45th Euromicro conference on software engineering and advanced applications (SEAA) (pp. 140-147). IEEE. · DOI
  17. Nanda, A., Bajaj, S. B., & Gupta, S. (2020, June). A Comprehensive Survey of Machine Learning in Scheduling of Transactions. In 2020 4th International Conference on Trends in Electronics and Informatics (ICOEI)(48184) (pp. 740-745). IEEE. · DOI
  18. NihalaniN.SilakariS.MotwaniM. (2009, July). Integration of artificial intelligence and database management system: an inventive approach for intelligent databases. In 2009 First International Conference on Computational Intelligence, Communication Systems and Networks (pp. 35-40). IEEE.
  19. NookalaG. (2021). Automated Data Warehouse Optimization Using Machine Learning Algorithms.Journal of Computational Innovation, 1, 1.
  20. OpenkoP. V.HohoniantsS. Y.StarkovaO. V.HerasymenkoK. V.YastrebovM. I.PrudchenkoA. O. (2019, December). Problem of choosing a dbms in modern information system. In 2019 IEEE International Conference on Advanced Trends in Information Theory (ATIT) (pp. 171-174). IEEE. · DOI
  21. 10.1109/TKDE.2023.3269592 · DOI
  22. PulivarthyP. (2024). Gen AI Impact on the Database Industry Innovations.International Journal of Advances in Engineering Research, 28(3), 1–10.
  23. RamakrishnanR.GehrkeJ. (2002). Database management systems. McGraw-Hill, Inc.
  24. 10.58346/JISIS.2024.I1.014 · DOI
  25. 10.1109/TKDE.2024.3384276 · DOI
  26. 10.1515/comp-2022-0251 · DOI
  27. Tsesmelis, D., & Simitsis, A. (2022, May). Database optimizers in the era of learning. In 2022 IEEE 38th International Conference on Data Engineering (ICDE) (pp. 3213-3216). IEEE. · DOI
  28. UnuriodeA.DurojaiyeO.YusufB.OkunadeL. (2023). The Integration of Artificial I Intelligence Into D Database Systems (Ai-Db Integration Review). Available at SSRN4744549.
  29. Van AkenD.PavloA.GordonG. J.ZhangB. (2017, May). Automatic database management system tuning through large-scale machine learning. In Proceedings of the 2017 ACM international conference on management of data (pp. 1009-1024). · DOI
  30. 10.1145/3003665.3003669 · DOI
  31. WangY.BourhisP.RouvoyR.RoyerP. (2024, October). Challenges & Opportunities in Automating DBMS: A Qualitative Study. In Proceedings of the 39th IEEE/ACM International Conference on Automated Software Engineering (pp. 2013-2023).
  32. Wannalai, N., & Mekruksavanich, S. (2019, January). The application of intelligent database for modern information management. In 2019 Joint International Conference on Digital Arts, Media and Technology with ECTI Northern Section Conference on Electrical, Electronics, Computer and Telecommunications Engineering (ECTI DAMT-NCON) (pp. 105-108). IEEE. · DOI
  33. LiJ.MiaoB.WangS.DongW.XuH.SiC.Hiplot Consortium. (2022). Hiplot: A comprehensive and easy-to-use web service for boosting publication-ready biomedical data visualization.Briefings in Bioinformatics, 23(4), bbac261.
  34. 10.1109/TKDE.2020.2994641 · DOI
  35. EnyejoL. A.AdewoyeM. B.UgochukwuU. N. (2024). Interpreting Federated Learning (FL) Models on Edge Devices by Enhancing Model Explainability with Computational Geometry and Advanced Database Architectures.International Journal of Scientific Research in Computer Science, Engineering and Information Technology, 10, 6.
  36. FahimaM. M. F.. (2024). Machine Learning for Database Management and Query Optimization.Elementaria: Journal of Educational Research, 2(1), 96–108.
  37. IslamS. (2024). Future Trends In SQL Databases And Big Data Analytics: Impact of Machine Learning and Artificial Intelligence. Available at SSRN5064781.
  38. 10.30574/wjarr.2025.25.2.0534 · DOI
  39. RafiqueS.. (2024). Analytical Study of OLTP Workload Management in Database Management System.Journal of Computing & Biomedical Informatics, 6(02), 384–401.
  40. 10.1145/3641832.3641836 · DOI
  41. WangZ.GanB.ShiW. (2024, May). Multimodal query suggestion with multi-agent reinforcement learning from human feedback. In Proceedings of the ACM Web Conference 2024 (pp. 1374-1385). · DOI
  42. Zhang, T., Tomasic, A., & Pavlo, A. (2024). Intelligent Transaction Scheduling via Conflict Prediction in OLTP DBMS. arXiv preprint arXiv:2409.01675. · arXiv

Cited by

Sorted by citations

Metadata

Authors
Vijaya, J., Paul, S., & Sharma, R.
Affiliations
International Institute of Information Technology (IN)
ORCID
Vijaya, J.
Venue
Advances in Computational Intelligence and Robotics
Publisher
IGI Global Scientific Publishing
Published
2025-06-04
Pages
43-82
ISSN
  • 2327-0411 (ISSN-L)
  • 2327-042X
DOI
10.4018/979-8-3373-1210-1.ch003
OpenAlex
W4411021483
Cited by
5
References
0
Citations by year
2026: 5
FWCI
14.15
Type
book chapter
Language
en
Open access
closed
Locations
Advances in computational intelligence and robotics book series (publishedVersion)
Topics
  • Physical Sciences › Computer Science › Information Systems › Advanced Database Systems and Queries
  • Physical Sciences › Computer Science › Information Systems › Data Management and Algorithms
  • Social Sciences › Decision Sciences › Management Science and Operations Research › Impact of AI and Big Data on Business and Society
Keywords
conflict prediction, online transaction processing, RocksDB, federated learning, data preprocessing, responsible AI, data privacy, algorithmic bias, real-time analytics

About these checks

Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.

Statistics and arithmetic are recomputed, not judged.

Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.

What counts as a claim ›How we measure confidence ›How we check this ›

Are you an author, or do you see a problem with this page? Request a review