TY - CHAP U1 - Konferenzveröffentlichung A1 - Petrov, Ilia A1 - Gottstein, Robert A1 - Hardock, Sergej T1 - DBMS on modern storage hardware T2 - IEEE 31st International Conference on Data Engineering (ICDE), 2015 ; 13. - 17. April 2015, Seoul, Korea N2 - In the present tutorial we perform a cross-cut analysis of database systems from the perspective of modern storage technology, namely Flash memory. We argue that neither the design of modern DBMS, nor the architecture of flash storage technologies are aligned with each other. The result is needlessly suboptimal DBMS performance and inefficient flash utilisation as well as low flash storage endurance and reliability. We showcase new DBMS approaches with improved algorithms and leaner architectures, designed to leverage the properties of modern storage technologies. We cover the area of transaction management and multi-versioning, putting a special emphasis on: (i) version organisation models and invalidation mechanisms in multi-versioning DBMS; (ii) Flash storage management especially on append-based storage in tuple granularity; (iii) Flash-friendly buffer management; as well as (iv) improvements in the searching and indexing models. Furthermore, we present our NoFTL approach to native Flash access that integrates parts of the flash-management functionality into the DBMS yielding significant performance increase and simplification of the I/O stack. In addition, we cover the basics of building large Flash storage for DBMS and revisit some of the RAID techniques and principles. Y1 - 2015 SN - 978-1-4799-7964-6 SB - 978-1-4799-7964-6 U6 - https://doi.org/10.1109/ICDE.2015.7113423 DO - https://doi.org/10.1109/ICDE.2015.7113423 SP - 1545 EP - 1548 S1 - 4 PB - IEEE CY - Piscataway, NJ ER -