Adaptive Query Compilation with Processing-in-Memory

The challenge of today’s DBMS is to integrate modern hardware properly in order to provide efficiency and performance. While emerging technologies like Processing-in-Memory (PIM) reduce the bottleneck when accessing memory by offloading computation, DBMSs must adapt to the new characteristics and the provided processing models in order to make use of it efficiently. The Single Program Multiple Data (SPMD) models require a special precompiled program for PIM-enabled chips in the UPMEM architecture. Integrating this model into the query processing of a DBMS can improve the overall performance by efficiently exploiting the underlying characteristic of high parallel execution directly on memory. To address this, we propose an approach to integrate this programming model directly into the query processing by leveraging adaptive query compilation. The experiment results show an improvement in the execution times compared to the execution on non-PIM hardware.