neoDBMS: in-situ snapshots for multi-version DBMS on native computational storage
- Multi-versioning and MVCC are the foundations of many modern DBMSs. Under mixed workloads and large datasets, the creation of the transactional snapshot can become very expensive, as long-running analytical transactions may request old versions, residing on cold storage, for reasons of transactional consistency. Furthermore, analytical queries operate on cold data, stored on slow persistent storage. Due to the poor data locality, snapshot creation may cause massive data transfers and thus lower performance. Given the current trend towards computational storage and near-data processing, it has become viable to perform such operations in-storage to reduce data transfers and improve scalability. neoDBMS is a DBMS designed for near-data processing and computational storage. In this paper, we demonstrate how neoDBMS performs snapshot computation in-situ. We showcase different interactive scenarios, where neoDBMS outperforms PostgreSQL 12 by up to 5×.
Author of HS Reutlingen | Bernhardt, Arthur; Knödler, Christian; Vinçon, Tobias; Petrov, Ilia |
---|---|
DOI: | https://doi.org/10.1109/ICDE53745.2022.00290 |
Erschienen in: | 2022 IEEE 38th International Conference on Data Engineering Workshops : ICDEW 2022, 9-11 May 2022, virtual event, proceedings |
Publisher: | IEEE |
Place of publication: | Piscataway, NJ |
Document Type: | Conference proceeding |
Language: | English |
Publication year: | 2022 |
Tag: | disaggregated memory; ndp; smart storage |
Page Number: | 4 |
First Page: | 3170 |
Last Page: | 3173 |
DDC classes: | 004 Informatik |
Open access?: | Nein |
Licence (German): | ![]() |