Relational Database Performance Optimization Techniques
- DOI
- 10.2991/978-94-6463-716-8_10How to use a DOI?
- Keywords
- Relational Databases; Performance Optimization; Indexing; Query Optimization; Cost-Based Optimization; Materialized Views; Database Partitioning; Hardware-Aware Optimization
- Abstract
Over time, relational databases remain an important part of today’s statistics management notwithstanding the need to maximize efficiency in order to improve its rate of data retrieval. This review looks at ten influential papers that explore various aspects to do with performance enhancements. We discuss structures that take into account hardware characteristics, ask about optimization methods, and consider the indexing algorithms to minimize processing time and resource utilization. The impact of value-based overall optimization, database segmentation, and materialized view selection on the query executing performance is also examined. This brief review delivers a systematic evaluation of Relational database overall performance optimization approach of the current literature, focusing on the set of techniques that may well enhance database scalability and reaction time in numerous applications.
- Copyright
- © 2025 The Author(s)
- Open Access
- Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.
Cite this article
TY - CONF AU - Sakshi Sakshi AU - Ankit Sharma PY - 2025 DA - 2025/05/26 TI - Relational Database Performance Optimization Techniques BT - Proceedings of the International Conference on Recent Advancements and Modernisations in Sustainable Intelligent Technologies and Applications (RAMSITA 2025) PB - Atlantis Press SP - 112 EP - 124 SN - 1951-6851 UR - https://doi.org/10.2991/978-94-6463-716-8_10 DO - 10.2991/978-94-6463-716-8_10 ID - Sakshi2025 ER -