English

Enabling Relational Database Analytical Processing in Bulk-Bitwise Processing-In-Memory

Hardware Architecture 2023-11-03 v2

Abstract

Bulk-bitwise processing-in-memory (PIM), an emerging computational paradigm utilizing memory arrays as computational units, has been shown to benefit database applications. This paper demonstrates how GROUP-BY and JOIN, database operations not supported by previous works, can be performed efficiently in bulk-bitwise PIM for relational database analytical processing. We extend the gem5 simulator and evaluated our hardware modifications on the Star Schema Benchmark. We show that compared to previous works, our modifications improve (on average) execution time by 1.83X, energy by 4.31X, and the system's lifetime by 3.21X. We also achieved a speedup of 4.65X over MonetDB, a modern state-of-the-art in-memory database.

Keywords

Cite

@article{arxiv.2302.01675,
  title  = {Enabling Relational Database Analytical Processing in Bulk-Bitwise Processing-In-Memory},
  author = {Ben Perach and Ronny Ronen and Shahar Kvatinsky},
  journal= {arXiv preprint arXiv:2302.01675},
  year   = {2023}
}

Comments

Included in conference proceedings of the 2023 IEEE 36th International System-on-Chip Conference (SOCC)