Optimization of OLAP In-Memory Database Management Systems with Processing-In-Memory Architecture
Hosseinzadeh S, Parvaresh A, Fey D (2023)
Publication Type: Conference contribution
Publication year: 2023
Journal
Publisher: Springer Science and Business Media Deutschland GmbH
Book Volume: 13949 LNCS
Pages Range: 264-278
Conference Proceedings Title: Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Event location: Athens, GRC
ISBN: 9783031427848
DOI: 10.1007/978-3-031-42785-5_18
Abstract
With the growing popularity of Processing-In-Memory (PIM) technology, many sectors of the industry are willing to take advantage of this new technology. However, the state-of-the-art applications are not optimized to fully utilize the PIM capabilities. In this paper, an in-memory database is analyzed and its functions whose executions cause the majority of CPU clock cycles are identified. Factors such as running time and cache locality are studied and processes causing long running times are accelerated with the PIM technology. The results show that by utilizing the proposed optimization methods, there is an overall speedup of 110.94% in the selected functionalities in the database management system. Furthermore, a deep analysis of the results is provided, summarizing key observations and programming recommendations for the in-memory database developers, and providing guidelines on where to take advantage of this new memory technology, and where to avoid it.
Authors with CRIS profile
Shima Hosseinzadeh Foroushani
Lehrstuhl für Informatik 3 (Rechnerarchitektur)
Dietmar Fey
Lehrstuhl für Informatik 3 (Rechnerarchitektur)
Involved external institutions
Germany (DE)How to cite
APA:
Hosseinzadeh, S., Parvaresh, A., & Fey, D. (2023). Optimization of OLAP In-Memory Database Management Systems with Processing-In-Memory Architecture. In Georgios Goumas, Sven Tomforde, Jürgen Brehm, Stefan Wildermann, Thilo Pionteck (Eds.), Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (pp. 264-278). Athens, GRC: Springer Science and Business Media Deutschland GmbH.
MLA:
Hosseinzadeh, Shima, Amirhossein Parvaresh, and Dietmar Fey. "Optimization of OLAP In-Memory Database Management Systems with Processing-In-Memory Architecture." Proceedings of the 36th International Conference on Architecture of Computing Systems, ARCS 2023, Athens, GRC Ed. Georgios Goumas, Sven Tomforde, Jürgen Brehm, Stefan Wildermann, Thilo Pionteck, Springer Science and Business Media Deutschland GmbH, 2023. 264-278.
BibTeX: Download