JOIV : International Journal on Informatics Visualization
Vol 9, No 4 (2025)

Enhancing Relational Database Efficiency through Algorithmic Query Tuning in Virtual Memory Systems

Yulis, Nurlina (Unknown)
Ilham, Amil Ahmad (Unknown)
Achmad, Andani (Unknown)
Samman, Faizal Arya (Unknown)



Article Info

Publish Date
30 Jul 2025

Abstract

The rapid evolution of virtual memory-based relational database systems has significantly advanced data processing capabilities. However, the efficiency of these systems largely depends on query execution optimization, which can be enhanced through algorithmic query tuning techniques. This study investigates the impact of these techniques on enhancing query performance in virtual memory-based relational databases. Various algorithmic methods were analyzed to optimize query execution plans, with a focus on key performance indicators such as execution time, CPU and memory usage, disk I/O, and cache hit ratio. The systematic application of these methods revealed effective strategies for performance enhancement. Results show substantial improvements in execution time, resource utilization, and scalability. This work offers valuable insights for database administrators and system architects, highlighting the role of algorithmic query tuning in managing the growing demands for data processing. Future research endeavors should explore the realm of AI-driven automation, with a particular focus on enhancing query optimization techniques. Additionally, there is a pressing need to investigate advanced security measures that safeguard data integrity within expansive, large-scale systems. By adopting innovative approaches, we can ensure robust protection and efficient performance in an increasingly data-driven world.

Copyrights © 2025






Journal Info

Abbrev

joiv

Publisher

Subject

Computer Science & IT

Description

JOIV : International Journal on Informatics Visualization is an international peer-reviewed journal dedicated to interchange for the results of high quality research in all aspect of Computer Science, Computer Engineering, Information Technology and Visualization. The journal publishes state-of-art ...