Workload-Based Performance Tuning in Database Management Systems through Integration of Artificial Intelligence


Authors : Vamsi Kalyan Jupudi; Nanda Kishore Mysuru; Ritheesh Mekala

Volume/Issue : Volume 9 - 2024, Issue 6 - June


Google Scholar : https://tinyurl.com/5x77ztk5

Scribd : https://tinyurl.com/jtpbthr7

DOI : https://doi.org/10.38124/ijisrt/IJISRT24JUN1908

Note : A published paper may take 4-5 working days from the publication date to appear in PlumX Metrics, Semantic Scholar, and ResearchGate.


Abstract : Traditional methods of performance tuning in Database Management Systems (DBMS) are facing significant challenges in adapting to the dynamic nature of modern workloads. Reactive approaches and static configurations often lead to performance bottlenecks and inefficient resource utilization. In response, this paper proposes a novel approach for workload-based performance tuning through the integration of Artificial Intelligence (AI). By leveraging AI techniques such as machine learning and predictive modeling, the proposed methodology aims to automate the analysis of workload patterns, predict future trends, and dynamically adjust DBMS configurations for optimal performance. The paper discusses the key components of the proposed methodology, including workload characterization, predictive modeling, and adaptive configuration management. A hypothetical case study in an e-commerce database environment illustrates the implementation and potential performance improvements achieved through AI-powered tuning. Furthermore, the paper explores real-world applications, future research directions, challenges, and best practices for implementing workload-based tuning with AI integration. Overall, this paper presents a comprehensive framework for leveraging AI to enhance DBMS performance, scalability, and efficiency in dynamic environments.

Keywords : Component, Formatting, Style, Styling, Insert (Key Words).

References :

  1. N. Nihalani, S. Silakari and M. Motwani, "Integration of Artificial Intelligence and Database Management System: An Inventive Approach for Intelligent Databases," 2009.
  2. Z. Yan, J. Lu, N. Chainani and C. Lin, "Workload-Aware Performance Tuning for Autonomous DBMSs," 2021 IEEE 37th International Conference on Data Engineering (ICDE), Chania, Greece, 2021
  3. M. Zhang, P. Martin, W. Powley and J. Chen, "Workload Management in Database Management System: A Taxonomy (Extended Abstract)," 2018 IEEE 34th International Conference on Data Engineering (ICDE), Paris, France, 2018
  4. S. F. Rodd and U. P. Kulkarni, "Adaptive Self-Tuning Techniques for Performance Tuning of Database Systems: A Fuzzy-Based Approach," 2013
  5. Zongmin Ma, "Intelligent Databases: Technologies and Applications", IGI publishing, 320 pages, 2007
  6. Bertino, E., B. Catania, et al., "Intelligent database systems", Reading, Addsion WesleyProfessional, 2001.
  7. Mattos, N.M., "An approach to knowledge base management", Berlin, Spring-Verlag, 1991.
  8. A. Pavlo, G. Angulo, J. Arulraj, H. Lin, J. Lin, L. Ma, et al., "Self-Driving DatabasemManagement Systems", CIDR, 2017.
  9. L. Liu and M. T. Özsu, Encyclopedia of Database Systems, New York:Springer, 2018.
  10. M. Vogt, A. Stiemer and H. Schuldt, "Icarus: Towards a Multistore Database System" in Big Data, IEEE, pp. 2490-2499, 2017.
  11. T. J. Wasserman, P. Martin, D. B. Skillicorn and H. Rizvi, "Developing A Characterization of Business Intelligence Workloads for Sizing New Database Systems" in DOLAP, ACM, pp. 7-13, 2004.
  12. S. Singh, "A Neural Network based Attendance Monitoring and Database Management System using Fingerprint Recognition and Matching," 2019 IEEE International Conference on Electronics, Computing and Communication Technologies (CONECCT), Bangalore, India, 2019
  13. R. Zhang, "Optimal Allocation of Power Grid Human Resources Based on Artificial Intelligence Technology and Fuzzy Neural Network," 2023 5th International Conference on Artificial Intelligence and Computer Applications (ICAICA), Dalian, China, 2023
  14. S. Singh, "A Neural Network based Attendance Monitoring and Database Management System using Fingerprint Recognition and Matching," 2019 IEEE International Conference on Electronics, Computing and Communication Technologies (CONECCT), Bangalore, India, 2019
  15. A. Talun, P. Drozda, S. Yelmanov, Y. Romanyshyn and O. Tehlivets, "Convolutional Neural Network Assessment of Image Quality Based on the TID2013 Database," 2023 IEEE 12th International Conference on Intelligent Data Acquisition and Advanced Computing Systems: Technology and Applications (IDAACS), Dortmund, Germany, 2023
  16. X. Lin, S. Zhang, F. Hu and L. Wu, "Research on Security Audit Technology of Smart Grid Database Based on Neural Networks," 2023 8th International Conference on Computer and Communication Systems (ICCCS), Guangzhou, China, 2023

Traditional methods of performance tuning in Database Management Systems (DBMS) are facing significant challenges in adapting to the dynamic nature of modern workloads. Reactive approaches and static configurations often lead to performance bottlenecks and inefficient resource utilization. In response, this paper proposes a novel approach for workload-based performance tuning through the integration of Artificial Intelligence (AI). By leveraging AI techniques such as machine learning and predictive modeling, the proposed methodology aims to automate the analysis of workload patterns, predict future trends, and dynamically adjust DBMS configurations for optimal performance. The paper discusses the key components of the proposed methodology, including workload characterization, predictive modeling, and adaptive configuration management. A hypothetical case study in an e-commerce database environment illustrates the implementation and potential performance improvements achieved through AI-powered tuning. Furthermore, the paper explores real-world applications, future research directions, challenges, and best practices for implementing workload-based tuning with AI integration. Overall, this paper presents a comprehensive framework for leveraging AI to enhance DBMS performance, scalability, and efficiency in dynamic environments.

Keywords : Component, Formatting, Style, Styling, Insert (Key Words).

Never miss an update from Papermashup

Get notified about the latest tutorials and downloads.

Subscribe by Email

Get alerts directly into your inbox after each post and stay updated.
Subscribe
OR

Subscribe by RSS

Add our RSS to your feedreader to get regular updates from us.
Subscribe