{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,11]],"date-time":"2026-07-11T02:46:29Z","timestamp":1783737989795,"version":"3.55.0"},"reference-count":76,"publisher":"Association for Computing Machinery (ACM)","issue":"9","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2021,5]]},"abstract":"<jats:p>Every database engine runs on top of an operating system in the host, strictly separated with the storage. This more-than-half-century-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.<\/jats:p>","DOI":"10.14778\/3461535.3461538","type":"journal-article","created":{"date-parts":[[2021,10,22]],"date-time":"2021-10-22T22:22:49Z","timestamp":1634941369000},"page":"1481-1488","source":"Crossref","is-referenced-by-count":11,"title":["SaS"],"prefix":"10.14778","volume":"14","author":[{"given":"Jong-Hyeok","family":"Park","sequence":"first","affiliation":[{"name":"Sungkyunkwan University Suwon, Korea"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Soyee","family":"Choi","sequence":"additional","affiliation":[{"name":"Samsung Electronics Co. Hwasung, Korea"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Gihwan","family":"Oh","sequence":"additional","affiliation":[{"name":"Sungkyunkwan University Suwon, Korea"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Sang-Won","family":"Lee","sequence":"additional","affiliation":[{"name":"Sungkyunkwan University Suwon, Korea"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2021,10,22]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/3385658.3385668"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.5555\/3277355.3277444"},{"key":"e_1_2_1_3_1","unstructured":"Amazon Web Services 2020. How Aurora Serverless Works. https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/aurora-serverless.how-it-works.html.  Amazon Web Services 2020. How Aurora Serverless Works. https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/aurora-serverless.how-it-works.html."},{"key":"e_1_2_1_4_1","unstructured":"AndroBench 2011. AndroBench (SQLite Benchmark). http:\/\/www.androbench.org\/wiki\/AndroBench.  AndroBench 2011. AndroBench (SQLite Benchmark). http:\/\/www.androbench.org\/wiki\/AndroBench."},{"key":"e_1_2_1_5_1","unstructured":"apavlo 2011. py-tpcc. https:\/\/github.com\/apavlo\/py-tpcc.git.  apavlo 2011. py-tpcc. https:\/\/github.com\/apavlo\/py-tpcc.git."},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2749441"},{"key":"e_1_2_1_7_1","unstructured":"Jens Axboe. 2019. Efficient IO with io_uring. https:\/\/kernel.dk\/io_uring.pdf?source=techstories.org.  Jens Axboe. 2019. Efficient IO with io_uring. https:\/\/kernel.dk\/io_uring.pdf?source=techstories.org."},{"key":"e_1_2_1_8_1","volume-title":"Proceedings of the 11th Conference on Innovative Data Systems Research (CIDR '21)","author":"Barbalace Antonio","year":"2021"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.2200\/S00516ED2V01Y201306CAC024"},{"key":"e_1_2_1_10_1","volume-title":"Proceedings of International Workshop on Database Machines.","author":"Boral H."},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.5555\/3386691.3386695"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/2248487.2151017"},{"key":"e_1_2_1_13_1","volume-title":"NVMe-oF Ethernet SSD. Storage Developer Conference (SNIA India).","author":"Chawdhary Swati","year":"2019"},{"key":"e_1_2_1_14_1","unstructured":"Rakesh Cheerla. 2019. Computational SSDs. https:\/\/www.snia.org\/sites\/default\/files\/SDCEMEA\/2019\/Presentations\/Computational_SSDs_Final.pdf.  Rakesh Cheerla. 2019. Computational SSDs. https:\/\/www.snia.org\/sites\/default\/files\/SDCEMEA\/2019\/Presentations\/Computational_SSDs_Final.pdf."},{"key":"e_1_2_1_15_1","unstructured":"CRZ Technology 2020. Daisy OpenSSD. http:\/\/www.mangoboard.com\/main\/view.asp?idx=1061&pageNo=1&cate1=9&cate2=150&cate3=181.  CRZ Technology 2020. Daisy OpenSSD. http:\/\/www.mangoboard.com\/main\/view.asp?idx=1061&pageNo=1&cate1=9&cate2=150&cate3=181."},{"key":"e_1_2_1_16_1","unstructured":"debiman 2020. nvme-io-passtru man page. https:\/\/manpages.debian.org\/testing\/nvme-cli\/nvme-io-passthru.1.en.html.  debiman 2020. nvme-io-passtru man page. https:\/\/manpages.debian.org\/testing\/nvme-cli\/nvme-io-passthru.1.en.html."},{"key":"e_1_2_1_17_1","unstructured":"Samsung Memory Division. 2020. SmartSSD: Computational Storage Drive. https:\/\/samsungsemiconductor-us.com\/smartssd\/.  Samsung Memory Division. 2020. SmartSSD: Computational Storage Drive. https:\/\/samsungsemiconductor-us.com\/smartssd\/."},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465295"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/3286588"},{"key":"e_1_2_1_21_1","volume-title":"2016 IEEE International Conference on Big Data (Big Data).","author":"Giannakouris V."},{"key":"e_1_2_1_22_1","volume-title":"Data Centric Computing. In Usenix Conference on File and Storage Technology (Keynote) (USENIX FAST '02)","author":"Gray Jim","year":"2002"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/3007787.3001154"},{"key":"e_1_2_1_24_1","volume-title":"Proceedings of the 10th Conference on Innovative Data Systems Research (CIDR '20)","author":"Mohsen Ewaida Kaan Kara David Cock","year":"2020"},{"key":"e_1_2_1_25_1","volume-title":"Proceedings of the 10th Conference on Innovative Data Systems Research (CIDR '20)","author":"Haas Gabriel","year":"2020"},{"key":"e_1_2_1_26_1","volume-title":"Proceedings of the 10th Conference on Innovative Data Systems Research (CIDR","author":"Haas Gabriel","year":"2020"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.2991\/eeeis-16.2017.24"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3314041"},{"key":"e_1_2_1_29_1","unstructured":"INTEL. 2020. Storage Performance Development Kit. https:\/\/spdk.io\/.  INTEL. 2020. Storage Performance Development Kit. https:\/\/spdk.io\/."},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.14778\/2994509.2994512"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.14778\/3372716.3372724"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1109\/TPDS.2019.2959305"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.5555\/2696578.2696591"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595632"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465326"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/290593.290602"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.5555\/3026852.3026861"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.5555\/3129633.3129664"},{"key":"e_1_2_1_39_1","unstructured":"Kim Kangnyeon and Johnson Ryan and Pandis Ippokratis. 2019. BionicDB: Fast and Power-Efficient OLTP on FPGA.. In EDBT. 301--312.  Kim Kangnyeon and Johnson Ryan and Pandis Ippokratis. 2019. BionicDB: Fast and Power-Efficient OLTP on FPGA.. In EDBT. 301--312."},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/3385073"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352141"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882949"},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732967.2732972"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.5555\/3129633.3129666"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.5555\/2813767.2813784"},{"key":"e_1_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.1145\/3376900"},{"key":"e_1_2_1_47_1","unstructured":"nvme-user 2013. NVM-Express user utilites and test program. http:\/\/git.infradead.org\/users\/kbusch\/nvme-user.git.  nvme-user 2013. NVM-Express user utilites and test program. http:\/\/git.infradead.org\/users\/kbusch\/nvme-user.git."},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882910"},{"key":"e_1_2_1_49_1","volume-title":"TEAM","author":"OPENSSD","year":"2019"},{"key":"e_1_2_1_50_1","unstructured":"Microsoft(White Paper). 2020. Azure SQL Edge: A data engine optimized for IoT workloads on edge devices. https:\/\/azure.microsoft.com\/mediahandler\/files\/resourcefiles\/azure-sql-edge-whitepaper\/White_Paper_AzureSQLEdge_2019.pdf.  Microsoft(White Paper). 2020. Azure SQL Edge: A data engine optimized for IoT workloads on edge devices. https:\/\/azure.microsoft.com\/mediahandler\/files\/resourcefiles\/azure-sql-edge-whitepaper\/White_Paper_AzureSQLEdge_2019.pdf."},{"key":"e_1_2_1_51_1","unstructured":"Oracle (White Paper). 2019. Oracle Shariding Database 12c Release - Oracle Sharding. https:\/\/www.oracle.com\/a\/tech\/docs\/sharding-wp-12c.pdf.  Oracle (White Paper). 2019. Oracle Shariding Database 12c Release - Oracle Sharding. https:\/\/www.oracle.com\/a\/tech\/docs\/sharding-wp-12c.pdf."},{"key":"e_1_2_1_52_1","unstructured":"WikipediaMicrosoft(White Paper). 2021. Shard (database architecture). https:\/\/en.wikipedia.org\/wiki\/Shard_(database_architecture).  WikipediaMicrosoft(White Paper). 2021. Shard (database architecture). https:\/\/en.wikipedia.org\/wiki\/Shard_(database_architecture)."},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/3186728.3164146"},{"key":"e_1_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.5555\/3386691.3386721"},{"key":"e_1_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.1109\/2.928624"},{"key":"e_1_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.14778\/2095686.2095688"},{"key":"e_1_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.1145\/2933349.2933359"},{"key":"e_1_2_1_58_1","unstructured":"SQLite 2017. Well-Known Users of SQLite. http:\/\/www.sqlite.org\/famous.html.  SQLite 2017. Well-Known Users of SQLite. http:\/\/www.sqlite.org\/famous.html."},{"key":"e_1_2_1_59_1","unstructured":"SQLite 2020. Dynamic Memory Allocation in SQLite. https:\/\/www.sqlite.org\/malloc.html.  SQLite 2020. Dynamic Memory Allocation in SQLite. https:\/\/www.sqlite.org\/malloc.html."},{"key":"e_1_2_1_60_1","unstructured":"SQLite 2020. The SQLite OS Interface or \"VFS\". https:\/\/sqlite.org\/vfs.html.  SQLite 2020. The SQLite OS Interface or \"VFS\". https:\/\/sqlite.org\/vfs.html."},{"key":"e_1_2_1_61_1","first-page":"38","article-title":"Crail: A High-Performance I\/O Architecture for Distributed Data Processing","volume":"40","author":"Stuedi Patrick","year":"2017","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_62_1","doi-asserted-by":"publisher","DOI":"10.1109\/MC.2013.222"},{"key":"e_1_2_1_63_1","volume-title":"Blakeley","author":"Szalay Alexander S.","year":"2009"},{"key":"e_1_2_1_64_1","doi-asserted-by":"publisher","DOI":"10.1109\/ISCA.2018.00041"},{"key":"e_1_2_1_65_1","doi-asserted-by":"publisher","DOI":"10.5555\/2591272.2591286"},{"key":"e_1_2_1_66_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196897"},{"key":"e_1_2_1_67_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-020-00622-9"},{"key":"e_1_2_1_68_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"key":"e_1_2_1_69_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415504"},{"key":"e_1_2_1_71_1","doi-asserted-by":"publisher","DOI":"10.1145\/640990.640999"},{"key":"e_1_2_1_72_1","doi-asserted-by":"publisher","DOI":"10.5555\/2208461.2208464"},{"key":"e_1_2_1_73_1","doi-asserted-by":"publisher","DOI":"10.1145\/3162614"},{"key":"e_1_2_1_74_1","unstructured":"Chen Yu. 2018. Horizontally scaling a MySQL database backend with Cloud SQL and ProxySQL. https:\/\/cloud.google.com\/community\/tutorials\/horizontally-scale-mysql-database-backend-with-google-cloud-sql-and-proxysql.  Chen Yu. 2018. Horizontally scaling a MySQL database backend with Cloud SQL and ProxySQL. https:\/\/cloud.google.com\/community\/tutorials\/horizontally-scale-mysql-database-backend-with-google-cloud-sql-and-proxysql."},{"key":"e_1_2_1_75_1","volume-title":"IEEE 36th International Conference on Data Engineering (ICDE '20). 1802","author":"Yu X.","year":"1805"},{"key":"e_1_2_1_76_1","doi-asserted-by":"publisher","DOI":"10.1145\/3357223.3365870"},{"key":"e_1_2_1_77_1","unstructured":"Lei Zeng. 2020. Sharding with Amazon Relational Database Service. https:\/\/aws.amazon.com\/ko\/blogs\/database\/sharding-with-amazon-relational-database-service\/.  Lei Zeng. 2020. Sharding with Amazon Relational Database Service. https:\/\/aws.amazon.com\/ko\/blogs\/database\/sharding-with-amazon-relational-database-service\/."},{"key":"e_1_2_1_78_1","doi-asserted-by":"publisher","DOI":"10.14778\/3397230.3397249"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3461535.3461538","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:45:39Z","timestamp":1672220739000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3461535.3461538"}},"subtitle":["SSD as SQL database system"],"short-title":[],"issued":{"date-parts":[[2021,5]]},"references-count":76,"journal-issue":{"issue":"9","published-print":{"date-parts":[[2021,5]]}},"alternative-id":["10.14778\/3461535.3461538"],"URL":"https:\/\/doi.org\/10.14778\/3461535.3461538","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2021,5]]}}}