arrow
Return

Accelerating relational database operations using both CPU and GPU co-processor

delete2017-01-01
delete8
PRE
AI
E
Esraa Shehab
A
Alsayed Algergawy *
A
Amany Sarhan
DOI:10.1016/j.compeleceng.2016.12.014delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Data is evolving and the number of existing data sources is vastly growing. Therefore, there is a compelling need for effective techniques to store, retrieve and process such massive data. Significant speed-ups at a small cost can be achieved by deploying co-processors such as GPUs. To this end, in this paper, we propose a new hybrid query processing technique that makes use of the capabilities of CPUs and GPUs. The proposed approach breaks down each SQL statement into smaller parts during the parsing process. It then automatically manages the distribution of different query parts to be executed either on the CPU or parallel on the GPU and CPU. To achieve this, we developed and implemented the proposed approach on a SQL server database using the Net framework instead of working under the Linux environment. The performance of the proposed approach is validated using different workloads and the results demonstrate that the proposed GPU-based query processor achieved speedup up to 39 as fast as multi-core CPUs. (C) 2016 Elsevier Ltd. All rights reserved.
Keywords:
GPU
Query processing
CPU co-processor
CUDA
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

C
Computers and Electrical Engineering
IF:
4.9
Papers:
6.7K
Citations:
1.3W

Organization

F
Friedrich Schiller University of Jena
Scholars:
1.9W
Papers: 1.5W
Citations: 25
E
egyptian knowledge bank (ekb)
Scholars:
11.6W
Papers: 9.3W
Citations: 84
Cited Papers

Cited Papers

Glycine modulation of the phencyclidine binding site in mammalian brain
err1988-03-01
err0
PREAI
errJohn W. Thomas; William F. Hood; Joseph B. Monahan; Patricia C. Contreras; Thomas L. O'Donohue
errShare
errSave
GPUs as Storage System Accelerators
err2013-08-01
err6
errOAAI
errAl-Kiswany, Samer; Gharaibeh, Abdullah; Ripeanu, Matei
errShare
errSave
Medical image processing on the GPU - Past, present and future
err2013-12-01
err329
errOAAI
errEklund, Anders; Dufort, Paul; Forsberg, Daniel; LaConte, Stephen M.
errShare
errSave
GPU computing
err2008-05-01
err1.4K
PREAI
errOwens, John D.; Houston, Mike; Luebke, David; Green, Simon; Stone, John E.; Phillips, James C.
errShare
errSave
Efficient co-processor utilization in database query processing
err2013-11-01
err28
PREAI
errBress, Sebastian; Beier, Felix; Rauhe, Hannes; Sattler, Kai-Uwe; Schallehn, Eike; Saake, Gunter
errShare
errSave
CEACAM1 regulates TIM-3-mediated tolerance and exhaustion
err2014-10-26
err0
errOAAI
errYu-Hwa Huang; Chen Zhu; Yasuyuki Kondo; Ana C. Anderson; Amit Gandhi; Andrew Russell; Stephanie K. Dougan; Britt-Sabina Petersen; Espen Melum; Thomas Pertel; Kiera L. Clayton; Monika Raab; Qiang Chen; Nicole Beauchemin; Paul J. Yazaki; Michal Pyzik; Mario A. Ostrowski; Jonathan N. Glickman; Christopher E. Rudd; Hidde L. Ploegh; Andre Franke; Gregory A. Petsko; Vijay K. Kuchroo; Richard S. Blumberg
errShare
errSave
no more