Overview
- Helps system designers better choose SSDs and shape database workloads to match their performance characteristics
- Explores the emerging research field focused on the co-design of database management systems and SSDs
- Reviews DBMS/SSD co-design via more seamless database and storage integration and SSDs adapted to database computation
Part of the book series: Synthesis Lectures on Data Management (SLDM)
Access this book
Tax calculation will be finalised at checkout
Other ways to access
About this book
This book offers a comprehensive resource on Solid-State Drives (SSD) as the field undergoes a radical evolution characterized by the incredible variety of SSD forms and their rapid diversification. It proposes a new classification system to help readers navigate the SSD landscape. For years, the evolution of SSDs was obscured by the unchanging abstractions of block devices and POSIX I/O, but it is apparent that these abstractions have become a problematic hinderance to performance and also fail to reduce software complexity. The book explores how such a state of affairs impacts the database community in at least two ways. First, it considers how using SSDs through legacy interfaces that hide internal mechanisms invariably results in erratic performance. While the blame often goes to the notoriously expensive garbage collection of SSDs, the authors argue that in truth, several other complex processes result in nonlinear effects on latency and bandwidth. The book describes these processes and how they are implemented in modern devices, knowledge that will help system designers better choose SSDs and shape database workloads to match their performance characteristics. Second, the book explores how the inadequacy of the traditional I/O abstractions opens up an entire research field focused on the co-design of database management systems and SSD. Such research aims at devising mechanisms and policies coupling the storage manager of database and SSD internals, e.g., placing an SSD FTL under the control of database, changing SSD sub-systems in response to the workload, or executing logic within an SSD on a database’s behalf. The book introduces these principles of DBMS/SSD co-design and argues that a more seamless integration of databases and storage solutions as well as the study of SSD variations adapted to database computations are central to the development of the next generation of database systems.
Similar content being viewed by others
Keywords
Table of contents (7 chapters)
Authors and Affiliations
About the authors
Alberto Lerner has a mixed profile of industrial and academic work with over thirty years of experience. He worked as research or software technical staff at numerous tech companies, such as IBM, Google, and MongoDB and as a consultant at many database start-ups. His interest revolves around high-scale, high-performance distributed systems, particularly using heterogeneous hardware to support them. He has participated in designing and implementing several such systems, including, more recently, the X-SSD device and ongoing efforts to create more easily programmable co-designed devices. Alberto has been a Senior Researcher at the Computer Science Department of the University of Fribourg in Switzerland since 2018. He has been on several Program Committees for the Database and Systems communities, including SIGMOD, VLDB, CIDR, EDBT, ICDE, and Usenix ATC.
Philippe Bonnet is an experimental computer scientist with a background in database systems. For thirty years, Philippe has explored the design, implementation, and evaluation of database systems in the context of successive generations of computer classes, including wireless sensor networks, computer clusters, and most recently disaggregated heterogeneous computers. Philippe is an expert on storage system software. He contributed to the uFlip Benchmark, the Linux multiqueue block layer, the Linux framework for Open-Channel SSDs, the OX architecture for computational storage, the xNVMe library, and Delilah, a prototype for eBPF offload on computational storage. Philippe has been a professor in the department of Computer Science at the IT University of Copenhagen since 2016. He is a trustee of the VLDB Endowment and currently chairs the ACM EIG on Reproducibility and Replicability.
Philippe Bonnet is an experimental computer scientist with a background in database systems. For thirty years, Philippe has explored the design, implementation, and evaluation of database systems in the context of successive generations of computer classes, including wireless sensor networks, computer clusters, and most recently disaggregated heterogeneous computers. Philippe is an expert on storage system software. He contributed to the uFlip Benchmark, the Linux multiqueue block layer, the Linux framework for Open-Channel SSDs, the OX architecture for computational storage, the xNVMe library, and Delilah, a prototype for eBPF offload on computational storage. Philippe has been a professor in the department of Computer Science at the IT University of Copenhagen since 2016. He is a trustee of the VLDB Endowment and currently chairs the ACM EIG on Reproducibility and Replicability.
Accessibility Information
PDF accessibility summary
This PDF does not fully comply with PDF/UA standards, but does feature limited screen reader support, described non-text content (images, graphs), bookmarks for easy navigation and searchable, selectable text. Users of assistive technologies may experience difficulty navigating or interpreting content in this document. We recognize the importance of accessibility, and we welcome queries about accessibility for any of our products. If you have a question or an access need, please get in touch with us at accessibilitysupport@springernature.com.
EPUB accessibility summary
This ebook is designed with accessibility in mind, aiming to meet the ePub Accessibility 1.0 AA and WCAG 2.0 Level AA standards. Its features include described images and other non-text content, screenreader-friendly navigation and accessible math. Math is represented either as MathML, LaTeX or in images. If math is represented as image, Alt Text might not be present. We recognize the importance of accessibility, and we welcome queries about accessibility for any of our products. If you have a question or an access need, please get in touch with us at accessibilitysupport@springernature.com.
Bibliographic Information
Book Title: Principles of Database and Solid-State Drive Co-Design
Authors: Alberto Lerner, Philippe Bonnet
Series Title: Synthesis Lectures on Data Management
DOI: https://doi.org/10.1007/978-3-031-57877-9
Publisher: Springer Cham
eBook Packages: Synthesis Collection of Technology (R0)
Copyright Information: The Editor(s) (if applicable) and The Author(s), under exclusive license to Springer Nature Switzerland AG 2025
Hardcover ISBN: 978-3-031-57876-2Published: 07 December 2024
eBook ISBN: 978-3-031-57877-9Published: 06 December 2024
Series ISSN: 2153-5418
Series E-ISSN: 2153-5426
Edition Number: 1
Number of Pages: XV, 135
Number of Illustrations: 16 b/w illustrations, 49 illustrations in colour
Topics: Database Management, Information Storage and Retrieval, Data Storage Representation, Data Structures and Information Theory, Artificial Intelligence, Computer Hardware