IMPROVING THE OPERATION OF THE INFORMATION SYSTEM THROUGH DATABASE OPTIMIZATION
Keywords:
optimization, SQL, query analysisAbstract
Optimal database performance contributes to better resource utilization, ensuring that hardware and infrastructure investments are maximized. This means cost savings and a higher return on investment. Furthermore, simplified database operations free up valuable computing resources, allowing businesses to focus on innovation, product development and gaining a competitive advantage. In this paper, we will go over ways to improve database performance. By applying these techniques, businesses can speed up their applications, reduce downtime, and provide their users with an unparalleled experience that fosters loyalty and drives success in today's highly competitive marketplace.Downloads
References
1. Duan, S., Thummala, V., Babu, S. (2009) Tuning database configuration parameters with iTuned. Proceedings of the VLDB Endowment, 2(1): 1246- 1257
2. Gyo ro di, C., Gyo ro di, R., Pecherle, G., Olah, A. (2015) A comparative study: MongoDB vs. MySQL. u: 2015 13th International Conference on Engineering of Modern Electric Systems (EMES), IEEE, 1-6
3. Janjua, J.I., Khan, T.A., Zulfiqar, S., Usman, M.Q. (2022) An Architecture of MySQL Storage Engines to Increase the Resource Utilization. u: 2022 International Balkan Conference on Communications and Networking (Balkan Com), IEEE, 68-72
4. Maesaroh, S., Gunawan, H., Lestari, A., Tsaurie, M.S.A., Fauji, M. (2022) Query Optimization In MySQL Database Using Index. International Journal of Cyber and IT Service Management, 2(2): 104-110
5. Marathe, A.P., Lin, S., Yu, W., El, G.K., Larson, P.A ., Sun, C. (2022) Integrating the Orca Optimizer into MySQL. u: EDBT, 2-511
6. Patil, M.M., Hanni, A., Tejeshwar, C.H., Patil, P.M. (2017) A qualitative analysis of the performance of MongoDB vs MySQL database based on insertion and retriewal operations using a Web/android application to explore load balancing: Sharding in MongoDB and its advantages. u: 2017 International Conference on ISMAC (IoT in Social, Mobile, Analytics and Cloud) (ISMAC), IEEE, 325-330
7. Rautmare, S., Bhalerao, D.M. (2016) MySQL and NoSQL database comparison for IoT application. u: 2016 IEEE international conference on advances in computer applications (ICACA), IEEE, 235-238
8. Stjepanovic , D., Savic , M., Jokic , J., Maric , S. (2015) Performance measurements of some aspects of multithreaded access to key-value stores. u: 2015 23rd Telecommunications Forum Telfor (TELFOR), IEEE, 831-834
9. Tahaghoghi, S.M., Williams, H.E. (2006) Learning MySQL: Get a Handle on Your Data. O'Reilly Media, Inc
10. Wahyudi, J., Asbari, M., Sasono, I., Pramono, T., Novitasari, D. (2022) Database Management Education in MYSQL. Edumaspul: Jurnal Pendidikan, 6(2): 2413-2417
11. Wang, B., Dai, L., Liao, B. (2023) System Architecture Design of a Multimedia Platform to Increase Awareness of Cultural Heritage: A Case Study of Sustainable Cultural Heritage. Sustainability, 15(3): 2504
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Nikola Milenković, Miloš Radosavljević (Author)
This work is licensed under a Creative Commons Attribution 4.0 International License.
