Proceedings of the International Conference on Recent Advancements and Modernisations in Sustainable Intelligent Technologies and Applications (RAMSITA 2025)

Relational Database Performance Optimization Techniques

Authors
Sakshi Sakshi1, *, Ankit Sharma1
1Apex Institute of Technology, Chandigarh University, Mohali, Punjab, India
*Corresponding author. Email: Sakshigill12@gmail.com
Corresponding Author
Sakshi Sakshi
Available Online 26 May 2025.
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.

Download article (PDF)

Volume Title
Proceedings of the International Conference on Recent Advancements and Modernisations in Sustainable Intelligent Technologies and Applications (RAMSITA 2025)
Series
Advances in Intelligent Systems Research
Publication Date
26 May 2025
ISBN
978-94-6463-716-8
ISSN
1951-6851
DOI
10.2991/978-94-6463-716-8_10How to use a DOI?
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  -