Accelerating relational database operations using both CPU and GPU co-processor. (January 2017)

• Record Type: Journal Article
• Authors: Shehab, Esraa; Algergawy, Alsayed; Sarhan, Amany
• Is Part Of: Computers & electrical engineering. Volume 57(2017)
• Page Start: 69
• Page End: 80
• Publication Date: 2017-01
• Subjects: GPU -- Query processing -- CPU co-processor -- CUDA; Computer engineering -- Periodicals; Electrical engineering -- Periodicals; Electrical engineering -- Data processing -- Periodicals; Ordinateurs -- Conception et construction -- Périodiques; Électrotechnique -- Périodiques; Électrotechnique -- Informatique -- Périodiques; Computer engineering; Electrical engineering; Electrical engineering -- Data processing; Periodicals; Electronic journals; 621.302854
• DOI: 10.1016/j.compeleceng.2016.12.014
• Languages: English
• ISSNs: 0045-7906

Abstract

Abstract: 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.