Back to search

University of South Florida

Fast Computation on Processing Data Warehousing Queries on GPU Devices

Abstract

dc:description

Current database management systems use Graphic Processing Units (GPUs) as dedicated accelerators to process each individual query, which results in underutilization of GPU. When a single query data warehousing workload was run on an open source GPU query engine, the utilization of main GPU resources was found to be less than 25%. The low utilization then leads to low system throughput. To resolve this problem, this paper suggests a way to transfer all of the desired data into the global memory of GPU and keep it until all queries are executed as one batch. The PCIe transfer time from CPU to GPU is minimized, which results in better performance in less time of overall query processing. The execution time was improved by up to 40% when running multiple queries, compared to dedicated processing.

Degree

thesis:*
Name thesis:degree_name
MS in Computer Science (M.S.C.S.)
Level thesis:degree_level
Thesis
Discipline thesis:degree_discipline
Computer Science and Engineering
Grantor
University of South Florida
Year dc:date
2016

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Cyrus, Sam
Contributors dc:contributor
  • Yicheng Tu, Ph.D.
  • Srinivas Katkoori, Ph.D.
  • Swaroop Ghosh, Ph.D.

Subjects

dc:subject × 6

Identifiers

dc:identifier.*
Repository record dc:identifier
https://digitalcommons.usf.edu/etd/6214

Chain of custody

source
Harvested from
University of South Florida
Base URL
digitalcommons.usf.edu/do/oai/
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
citation

Cyrus, Sam. Fast Computation on Processing Data Warehousing Queries on GPU Devices. Thesis thesis, University of South Florida, 2016. https://digitalcommons.usf.edu/etd/6214