SaS: SSD as SQL Database System
Jong-Hyeok Park, Soyee Choi, Gihwan Oh, Sang Won Lee
Abstract
Every database engine runs on top of an operating system in the host, strictly separated with the storage. This more-than-halfcentury-old IHDE (In-Host-Database-Engine) architecture, however, reveals its limitations when run on fast flash memory SSDs. In particular, the IO stacks incur significant run-time overhead and also hinder vertical optimizations between database engines and SSDs. In this paper, we envisage a new database architecture, called SaS (SSD as SQL database engine), where a full-blown SQL database engine runs inside SSD, tightly integrated with SSD architecture without intervening kernel stacks. As IO stacks are removed, SaS is free from their run-time overhead and further can explore numerous vertical optimizations between database engine and SSD. SaS evolves SSD from dummy block device to database server with SQL as its primary interface. The benefit of SaS will be more outstanding in the data centers where the distance between database engine and the storage is ever widening because of virtualization, storage disaggregation, and open software stacks. The advent of computational SSDs with more compute resource will enable SaS to be more viable and attractive database architecture.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext 10cac901-de16-430b-80fb-01b68b3ec4e5Builds on4
- POLARDB Meets Computational Storage: Efficiently Support Analytical Workloads in Cloud-Native Relational DatabaseWei Cao, Yang Liu, Zhushi Cheng, Ning Zheng et al.FAST 2020 · 140 citations
- Understanding the Effect of Data Center Resource Disaggregation on Production DBMSsQizhen Zhang, Yifan Cai, Xinyi Chen, Sebastian Angel et al.VLDB 2020 · 64 citations
- Hybrid Data Reliability for Emerging Key-Value Storage DevicesRekha Pitchumani, Yang-Suk KeeFAST 2020 · 19 citations
- Optimizing Databases by Learning Hidden Parameters of Solid State DrivesAarati Kakaraparthy, Jignesh M. Patel, Kwanghyun Park, Brian KrothVLDB 2020 · 13 citations
Related papers
- ASSASIN: Architecture Support for Stream Computing to Accelerate Computational StorageChen Zou, Andrew A. ChienMICRO 2022 · 17 citations
- Latte: A Native Table Engine On Nvme StorageJiajia Chu, Yunshan Tu, Yao Zhang, Chuliang WengICDE 2020 · 11 citations
- λ-IO: A Unified IO Stack for Computational StorageZhe Yang, Youyou Lu, Xiaojian Liao, Youmin Chen et al.FAST 2023 · 54 citations
- IceClave: A Trusted Execution Environment for In-Storage ComputingLuyi Kang, Yuqi Xue, Weiwei Jia, Xiaohao Wang et al.MICRO 2021 · 22 citations
- DDS: DPU-optimized Disaggregated StorageQizhen Zhang, Philip A. Bernstein, Badrish Chandramouli, Jason Hu et al.VLDB 2024 · 12 citations
