Optimising group-by and aggregation on the coupled CPU-GPU architecture Online publication date: Mon, 11-Mar-2024
by Hua Luan; Yan Fu
International Journal of Computational Science and Engineering (IJCSE), Vol. 27, No. 2, 2024
Abstract: The coupled CPU-GPU architecture as an emerging heterogeneous environment has attracted much attention from researchers. On this kind of architecture, the GPU is built on the same chip as the CPU. Different from the discrete GPU, there is no data transfer via the PCIe bus between the CPU and the integrated GPU, and the two processors share the same memory. Grouping and aggregation is an important and time-consuming operator in a DBMS. Whether the coupled GPU could be used to increase its performance is an interesting problem. In this paper, we study how to optimise grouping and aggregation based on chained hashing on the coupled CPU-GPU architecture. Two flexible co-processing strategies are proposed to take advantage of the hybrid computing resources effectively. A thorough set of experiments are conducted and the results show that the coupled GPU could help obtain better performance for group-by and aggregation.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Computational Science and Engineering (IJCSE):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com
Our Blog 
Follow us on Twitter 
Visit us on Facebook