Enhancing database performance through SQL optimization, parallel processing and GPU integration

¹ Kazan National Research Technical University named after A. N. Tupolev – KAI, Kazan, Russia
² Kazan State Power Engineering University, Kazan, Russia
³ Kazan National Research Technological University, Kazan, Russia

^* Corresponding author: marat_nu1@mail.ru

Abstract

This article delves into the cutting-edge methodologies revolutionizing database management systems (DBMS) through the lens of SQL query optimization, parallel processing, and the integration of graphics processing units (GPUs). As the digital world grapples with ever-increasing volumes of data, the efficiency, speed, and scalability of database systems have never been more critical. The first section of the article focuses on SQL query optimization, highlighting strategies to refine query performance and reduce resource consumption, thus enhancing application responsiveness and efficiency. The discourse then transitions to parallel processing in databases, an approach that leverages multiple processors or distributed systems to significantly boost data processing capabilities. This segment explores the advantages of parallelism in managing large datasets and complex operations, addressing the challenges and the impact on system scalability and fault tolerance. Furthermore, the article examines the innovative application of GPUs in database management, a development that offers profound speedups for analytical and machine learning tasks within DBMS. Despite the complexities and the initial investment required, the utilization of GPUs is portrayed as a game-changer in processing largescale data, thanks to their highly parallel architecture and computational prowess. Together, these advancements signify a transformative shift in database technologies, promising to address the challenges of modern data management with unprecedented efficiency and scalability. This article not only elucidates these sophisticated technologies but also provides a glimpse into the future of database systems, where optimization, parallel processing, and GPU integration play pivotal roles in navigating the data-driven demands of the contemporary digital landscape.