Accelerating Large Table Scan Using Processing-In-Memory Technology
Open Access
- 10 October 2023
- journal article
- schwerpunktbeitrag
- Published by Springer Nature in Datenbank-Spektrum
- Vol. 23 (3) , 199-209
Abstract
Today’s systems are capable of storing large amounts of data in main memory. Particularly, in-memory DBMSs benefit from this development. However, the processing of data from the main memory necessarily has to run via the CPU. This creates a bottleneck, which affects the possible performance of the DBMS. Processing-In-Memory (PIM) is a paradigm to overcome this problem, which was not available in commercial systems for a long time. With the availability of UPMEM, a commercial product is finally available that provides PIM technology in hardware. In this work, we focus on the acceleration of the table scan, a fundamental database query operation. We show and investigate an approach that can be used to optimize this operation by using PIM. We evaluate the PIM scan in terms of parallelism and execution time in benchmarks with different table sizes and compare it to a traditional CPU-based table scan. The result is a PIM table scan that outperforms the CPU-based scan significantly.Keywords
Funding Information
- Deutsche Forschungsgemeinschaft (SA 782/28-2)
- Deutsche Forschungsgemeinschaft (SA 782/31)
- Technische Universität Ilmenau
This publication has 21 references indexed in Scilit:
- Improving In-Memory Database Operations with Acceleration DIMM (AxDIMM)2022
- Benchmarking a New Paradigm: Experimental Analysis and Characterization of a Real Processing-in-Memory SystemIEEE Access, 2022
- Adaptive Query Compilation in Graph Databases2021
- A Classification of Memory-Centric ComputingACM Journal on Emerging Technologies in Computing Systems, 2020
- LazyPIM: An Efficient Cache Coherence Mechanism for Processing-in-MemoryIEEE Computer Architecture Letters, 2016
- TOP-PIM2014
- Morsel-driven parallelism2014
- The architecture of the DIVA processing-in-memory chip2002
- Intelligent RAM (IRAM): the industrial setting, applications, and architectures1997
- Hitting the memory wallACM SIGARCH Computer Architecture News, 1995