• Home
  • Search
  • Enhancing database performance through SQL optimization, parallel processing and GPU integration
  • Cite Icon1
  • https://doi.org/10.1051/bioconf/202411304010Copy DOI Icon

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

Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
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.

Similar Papers
  • Conference Article
  • Citations28

Remote GPU Virtualization: Is It Useful?

  • Mar 01, 2016
  • Federico Silla +3
  • Conference Article
  • Citations3

FlexGPU: A Flexible and Efficient Scheduler for GPU Sharing Systems

  • May 01, 2020
  • Qichen Chen +3
  • Conference Article
  • Citations3

SQL optimization in a parallel processing database system

  • May 01, 2013
  • Nayem Rahman
  • Conference Article
  • Citations24

Increasing the Performance of Data Centers by Combining Remote GPU Virtualization with Slurm

  • May 01, 2016
  • Sergio Iserte +3
  • Dissertation

On the Enhancement of Remote GPU Virtualization in High Performance Clusters

  • Jun 30, 2017
  • Carlos R Aguayo González
  • Research Article
  • Citations6

An automated and portable method for selecting an optimal GPU frequency

  • Jul 17, 2023
  • Future Generation Computer Systems
  • Ghazanfar Ali +4
  • Conference Article
  • Citations1

A Parallel Data Mining Algorithm for PageRank Computation

  • Nov 10, 2016
  • Massinissa Saoudi +4
  • Conference Article
  • Citations11

Markov Decision Process Parallel Value Iteration Algorithm On GPU

  • Jan 01, 2013
  • Peng Chen +1
  • Research Article

A Study of Modern Trends in Database and Data Repository Technologies as the Technological and Architectural Basis for the Creation of Software and Intelligent Systems by Means of Modern Programming Languages. Part 2

  • Jun 01, 2022
  • Scientific Bulletin of the National Academy of Statistics, Accounting and Audit
  • O Yershova +1
  • Research Article

A Study of Modern Trends in Database and Data Repository Technologies as the Technological and Architectural Basis for the Creation of Software and Intelligent Systems by Means of Modern Programming Languages. Part 1

  • Dec 21, 2021
  • Scientific Bulletin of the National Academy of Statistics, Accounting and Audit
  • O Yershova +1
  • Conference Article
  • Citations17

Accelerating sparse cholesky factorization on GPUs

  • Nov 16, 2014
  • Steven C Rennich +2
  • Research Article
  • Citations14

GPARS: Graph predictive algorithm for efficient resource scheduling in heterogeneous GPU clusters

  • Nov 02, 2023
  • Future Generation Computer Systems
  • Sheng Wang +2
  • PDF
  • Research Article
  • Citations2

High-Performance Homomorphic Matrix Completion on Multiple GPUs

  • Jan 01, 2020
  • IEEE Access
  • Tao Zhang +2
  • Research Article
  • Citations3

A Multi-GPU Program for Uncertainty-Aware Drainage Basin Delineation: Scalability benchmarking with country-wide data sets

  • Sep 01, 2016
  • IEEE Geoscience and Remote Sensing Magazine
  • Ville Makinen +3
  • PDF
  • Research Article

ACCELERATING ORE SINTERING MATHEMATICAL MODEL USING GPU

  • Mar 28, 2024
  • Computer systems and information technologies
  • Kyrylo Krasnikov
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.