Performance Tuning: AI Analyse Historical Performance Data, Identify Patterns, And Predict Future Resource Needs

Padmaja Pulivarthy

Vol. 8, Issue 1, Jan-Dec 2022

Page Number: 139 - 155

Abstract:

Database sizes are increasing, according to recent trends; therefore, larger databases that can be expanded for improvements in the future without sacrificing performance are required. The way SQL queries are structured has a significant impact on how well they execute. A set of formatting guidelines is presented in this document to optimise SQL queries. As part of our methodology, we determine whether the query requiring filtration requires indexing particular columns. Our suggested methodology seeks to optimise user SQL queries and reduce query execution time by minimising excessive use of data and columns. This study covers the importance of query optimisation and popular approaches and thoroughly reviews SQL optimisation strategies to improve database query efficiency.

References

• Jingbo Shao et al., “Database Performance Optimization for SQL Server Based on Hierarchical Queuing Network Model,” International Journal of Database Theory and Application, vol. 8, no. 1, pp. 187–196, 2015. [CrossRef] [Google Scholar] [Publisher Link]
• Khaled Saleh Maabreh, “Optimizing Database Query Performance Using Table Partitioning Techniques,” International Arab Conference on Information Technology, pp. 1-4, 2018. [CrossRef] [Google Scholar] [Publisher Link]
• Jiangang Zhang, “Research on Database Application Performance Optimization Method,” Proceedings of the 2016 6th International Conference on Machinery, Materials, Environment, Biotechnology and Computer, 2016. [CrossRef] [Google Scholar] [Publisher Link]
• Structure of Database Management System – Geeks for Geeks, 2020. [Online]. Available: https://www.geeksforgeeks.org/structure-of-databasemanagement-system/
• Manoj Muniswamaiah, Dr. Tilak Agerwala, and Dr. Charles Tappert, “Query Performance Optimization in Databases for Big Data,” 9th International Conference on Computer Science, Engineering and Applications, pp. 85-90, 2019. [CrossRef] [Publisher Link]
• John Klein et al., “Performance Evaluation of NoSQL Databases: A Case Study,” Proceedings of the 1st Workshop on Performance Analysis of Big Data Systems, pp. 5-10, 2015. [CrossRef] [Google Scholar] [Publisher Link]
• María Murazzo et al., “Database NewSQL Performance Evaluation for Big Data in the Public Cloud,” Communications in Computer and Information Science, vol. 1050, pp. 110–121, 2019. [CrossRef] [Google Scholar] [Publisher Link]
• Vamsi Krishna Myalapalli, Thirumala Padmakumar Totakura, and Sunitha Geloth, “Augmenting Database Performance via SQL Tuning,” International Conference on Energy Systems and Applications, pp. 13-18, 2015. [CrossRef] [Google Scholar] [Publisher Link]
• Abdullah Talha Kabakus, and Resul Kara, “A Performance Evaluation of In-Memory Databases,” Journal of King Saud University - Computer and Information Sciences, vol. 29, no. 4, pp. 520–525, 2017. [CrossRef] [Google Scholar] [Publisher Link]
• Sadhana J. Kamatkar et al., “Database Performance Tuning and Query Optimization,” Data Mining and Big Data, pp. 3–11, 2018. [CrossRef] [Google Scholar] [Publisher Link]
• Xiaoxiao Sun, Bing Jiang, and Xianda He, “Database Query Optimization Based on Distributed Photovoltaic Power Generation,” 2nd IEEE Advanced Information Management, Communicates, Electronic and Automation Control Conference, pp. 2382-2386, 2018. [CrossRef] [Google Scholar] [Publisher Link]
• Mohammad Reza Hoseiny Farahabady et al., “Enhancing Disk Input Output Performance in Consolidated Virtualized Cloud Platforms using a Randomized Approximation Scheme,” Concurrency and Computation: Practice and Experience, vol. 34, no. 2, 2022. [CrossRef] [Google Scholar] [Publisher Link]
• Le Gruenwald, and Margaret H. Eich, “Selecting a Database Partitioning Technique,” Journal of Database Management, vol. 4, no. 3, pp. 27–39, 1993. [CrossRef] [Google Scholar] [Publisher Link]
• Neha Mendjoge, Abhijit R. Joshi, and Meera Narvekar, “Intelligent Tutoring System for Database Normalization,” International Conference on Computing Communication Control and Automation, pp. 1-6, 2016. [CrossRef] [Google Scholar] [Publisher Link]
• Prasanna Bagade, Ashish Chandra, and Aditya B. Dhende, “Designing Performance Monitoring Tool for NoSQL Cassandra Distributed Database,” International Conference on Education and ELearning Innovations, pp. 1-5, 2012. [CrossRef] [Google Scholar] [Publisher Link]
• Maria Carla Calzarossa, Luisa Massari, and Daniele Tessera, “Performance Monitoring Guidelines,” Companion of the ACM/SPEC International Conference on Performance Engineering, pp. 109-114, 2021. [CrossRef] [Publisher Link]

Back Download