Issue |
BIO Web Conf.
Volume 113, 2024
XVII International Scientific and Practical Conference “State and Development Prospects of Agribusiness” (INTERAGROMASH 2024)
|
|
---|---|---|
Article Number | 04010 | |
Number of page(s) | 10 | |
Section | Soil Monitoring, GIS, and Agroecology | |
DOI | https://doi.org/10.1051/bioconf/202411304010 | |
Published online | 18 June 2024 |
Enhancing database performance through SQL optimization, parallel processing and GPU integration
1 Kazan National Research Technical University named after A. N. Tupolev – KAI, Kazan, Russia
2 Kazan State Power Engineering University, Kazan, Russia
3 Kazan National Research Technological University, Kazan, Russia
* Corresponding author: marat_nu1@mail.ru
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.
© The Authors, published by EDP Sciences, 2024
This is an Open Access article distributed under the terms of the Creative Commons Attribution License 4.0, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Current usage metrics show cumulative count of Article Views (full-text article views including HTML views, PDF and ePub downloads, according to the available data) and Abstracts Views on Vision4Press platform.
Data correspond to usage on the plateform after 2015. The current usage metrics is available 48-96 hours after online publication and is updated daily on week days.
Initial download of the metrics may take a while.