{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,13]],"date-time":"2026-10-13T18:34:01Z","timestamp":1791916441117,"version":"4.3.4"},"reference-count":43,"publisher":"Association for Computing Machinery (ACM)","issue":"3","license":[{"start":{"date-parts":[[2024,5,29]],"date-time":"2024-05-29T00:00:00Z","timestamp":1716940800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100006374","name":"NSF","doi-asserted-by":"publisher","award":["2337806"],"award-info":[{"award-number":["2337806"]}],"id":[{"id":"10.13039\/501100006374","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. ACM Manag. Data"],"published-print":{"date-parts":[[2024,5,29]]},"abstract":"<jats:p>Storage-compute disaggregation has recently emerged as a novel architecture in modern data centers, particularly in the cloud. By decoupling compute from storage, this new architecture enables independent and elastic scaling of compute and storage resources, potentially increasing resource utilization and reducing overall costs. To best leverage the disaggregated architecture, a new breed of database systems termed storage-disaggregated databases has recently been developed, such as Amazon Aurora, Microsoft Socrates, Google AlloyDB, Alibaba PolarDB, and Huawei Taurus. However, little is known about the effectiveness of the design principles in these databases since they are typically developed by industry giants, and only the overall performance results are presented without detailing the impact of individual design principles. As a result, many critical research questions remain unclear, such as the performance impact of storage-disaggregation, the log-as-the-database design, shared-storage, and various log-replay methods.<\/jats:p>\n          <jats:p>In this paper, we investigate the performance implications of the design principles that are widely adopted in storage-disaggregated databases for the first time. As these databases were usually not open-sourced, we have made a significant effort to implement a storage-disaggregated database prototype based on PostgreSQL v13.0. By fully controlling and instrumenting the codebase, we are able to selectively enable and disable individual optimizations and techniques to evaluate their impact on performance in various scenarios. Furthermore, we open-source our storage-disaggregated database prototype for use by the broader database research community, fostering collaboration and innovation in this field.<\/jats:p>","DOI":"10.1145\/3654983","type":"journal-article","created":{"date-parts":[[2024,5,30]],"date-time":"2024-05-30T09:44:53Z","timestamp":1717062293000},"page":"1-26","source":"Crossref","is-referenced-by-count":21,"title":["Understanding the Performance Implications of the Design Principles in Storage-Disaggregated Databases"],"prefix":"10.1145","volume":"2","author":[{"ORCID":"https:\/\/orcid.org\/0009-0009-4342-0033","authenticated-orcid":false,"given":"Xi","family":"Pang","sequence":"first","affiliation":[{"name":"Purdue University, West Lafayette, IN, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3039-1175","authenticated-orcid":false,"given":"Jianguo","family":"Wang","sequence":"additional","affiliation":[{"name":"Purdue University, West Lafayette, IN, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2024,5,30]]},"reference":[{"key":"e_1_2_2_1_1","unstructured":"[n.d.]. AlloyDB for PostgreSQL https:\/\/cloud.google.com\/alloydb."},{"key":"e_1_2_2_2_1","unstructured":"[n.d.]. Choose between SSD and HDD Storage https:\/\/cloud.google.com\/sql\/docs\/mysql\/choosing-ssd-hdd."},{"key":"e_1_2_2_3_1","unstructured":"[n.d.]. Full Page Writes in PostgreSQL https:\/\/wiki.postgresql.org\/wiki\/Full_page_writes."},{"key":"e_1_2_2_4_1","unstructured":"[n.d.]. Neon https:\/\/github.com\/neondatabase\/neon."},{"key":"e_1_2_2_5_1","unstructured":"[n.d.]. PolarDB for PostgreSQL https:\/\/github.com\/ApsaraDB\/PolarDB-for-PostgreSQL."},{"key":"e_1_2_2_6_1","unstructured":"[n.d.]. PostgreSQL Database Page Layout https:\/\/www.postgresql.org\/docs\/current\/storage-page-layout.html."},{"key":"e_1_2_2_7_1","unstructured":"[n.d.]. SysBench Manual https:\/\/imysql.com\/wp-content\/uploads\/2014\/10\/sysbench-manual.pdf."},{"key":"e_1_2_2_8_1","unstructured":"[n.d.]. TPC-C is an On-Line Transaction Processing Benchmark https:\/\/www.tpc.org\/tpcc\/."},{"key":"e_1_2_2_9_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415545"},{"key":"e_1_2_2_10_1","first-page":"1","article-title":"Enabling CXL Memory Expansion for In-Memory Database Management Systems","volume":"8","author":"Ahn Minseon","year":"2022","unstructured":"Minseon Ahn, Andrew Chang, Donghun Lee, Jongmin Gim, Jungmin Kim, Jaemin Jung, Oliver Rebholz, Vincent Pham, Krishna T. Malladi, and Yang-Seok Ki. 2022. Enabling CXL Memory Expansion for In-Memory Database Management Systems. In DaMoN. 8:1--8:5.","journal-title":"DaMoN."},{"key":"e_1_2_2_11_1","doi-asserted-by":"crossref","unstructured":"Panagiotis Antonopoulos Alex Budovski Cristian Diaconu Alejandro Hernandez Saenz Jack Hu Hanuma Kodavalla Donald Kossmann Sandeep Lingam Umar Farooq Minhas Naveen Prakash Vijendra Purohit Hugh Qu Chaitanya Sreenivas Ravella Krystyna Reisteter Sheetal Shrotri Dixin Tang and Vikram Wakade. 2019. Socrates: The New SQL Server in the Cloud. In SIGMOD. 1743--1756.","DOI":"10.1145\/3299869.3314047"},{"key":"e_1_2_2_12_1","doi-asserted-by":"crossref","unstructured":"Nikos Armenatzoglou Sanuj Basu Naga Bhanoori Mengchu Cai Naresh Chainani Kiran Chinta Venkatraman Govindaraju Todd J. Green Monish Gupta Sebastian Hillig Eric Hotinger Yan Leshinksy Jintian Liang Michael McCreedy Fabian Nagel Ippokratis Pandis Panos Parchas Rahul Pathak Orestis Polychroniou Foyzur Rahman Gaurav Saxena Gokul Soundararajan Sriram Subramanian and Doug Terry. 2022. Amazon Redshift Re-invented. In SIGMOD. 2205--2217.","DOI":"10.1145\/3514221.3526045"},{"key":"e_1_2_2_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/3373376.3378504"},{"key":"e_1_2_2_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/3229863.3229872"},{"key":"e_1_2_2_15_1","doi-asserted-by":"crossref","unstructured":"Wei Cao Yingqiang Zhang Xinjun Yang Feifei Li Sheng Wang Qingda Hu Xuntao Cheng Zongzhi Chen Zhenjun Liu Jing Fang Bo Wang Yuhui Wang Haiqing Sun Ze Yang Zhushi Cheng Sen Chen Jian Wu Wei Hu Jianwei Zhao Yusong Gao Songlu Cai Yunyang Zhang and Jiawang Tong. 2021. PolarDB Serverless: A Cloud Native Database for Disaggregated Data Centers. In SIGMOD. 2477--2489.","DOI":"10.1145\/3448016.3457560"},{"key":"e_1_2_2_16_1","doi-asserted-by":"crossref","unstructured":"Beno\u00eet Dageville Thierry Cruanes Marcin Zukowski Vadim Antonov Artin Avanes Jon Bock Jonathan Claybaugh Daniel Engovatov Martin Hentschel Jiansheng Huang Allison W. Lee Ashish Motivala Abdul Q. Munir Steven Pelley Peter Povinec Greg Rahn Spyridon Triantafyllis and Philipp Unterbrunner. 2016. The Snowflake Elastic Data Warehouse. In SIGMOD. 215--226.","DOI":"10.1145\/2882903.2903741"},{"key":"e_1_2_2_17_1","volume-title":"Taurus Database: How to be Fast, Available, and Frugal in the Cloud. In SIGMOD. 1463--1478.","author":"Depoutovitch Alex","year":"2020","unstructured":"Alex Depoutovitch, Chong Chen, Jin Chen, Paul Larson, Shu Lin, Jack Ng, Wenlin Cui, Qiang Liu, Wei Huang, Yong Xiao, and Yongjun He. 2020. Taurus Database: How to be Fast, Available, and Frugal in the Cloud. In SIGMOD. 1463--1478."},{"key":"e_1_2_2_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/3589772"},{"key":"e_1_2_2_19_1","unstructured":"Donghyun Gouk Sangwon Lee Miryeong Kwon and Myoungsoo Jung. 2022. Direct Access High-Performance Memory Disaggregation with DirectCXL. In USENIX ATC. 287--294."},{"key":"e_1_2_2_20_1","unstructured":"Gabriel Haas Michael Haubenschild and Viktor Leis. 2020. Exploiting Directly-Attached NVMe Arrays in DBMS. In CIDR."},{"key":"e_1_2_2_21_1","volume-title":"Farview: Disaggregated Memory with Operator Off-loading for Database Engines. In CIDR.","author":"Korolija Dario","year":"2022","unstructured":"Dario Korolija, Dimitrios Koutsoukos, Kimberly Keeton, Konstantin Taranov, Dejan S. Milojicic, and Gustavo Alonso. 2022. Farview: Disaggregated Memory with Operator Off-loading for Database Engines. In CIDR."},{"key":"e_1_2_2_22_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415568"},{"key":"e_1_2_2_23_1","volume-title":"Principles of Distributed Database Systems","author":"Tamer \u00d6zsu M.","unstructured":"M. Tamer \u00d6zsu and Patrick Valduriez. 2020. Principles of Distributed Database Systems, 4th Edition. Springer.","edition":"4"},{"key":"e_1_2_2_24_1","doi-asserted-by":"publisher","DOI":"10.14778\/3476311.3476391"},{"key":"e_1_2_2_25_1","unstructured":"Avi Silberschatz Henry F. Korth and S. Sudarshan. 2020. Database System Concepts Seventh Edition. McGraw-Hill Book Company."},{"key":"e_1_2_2_26_1","first-page":"4","article-title":"The Case for Shared Nothing","volume":"9","author":"Stonebraker Michael","year":"1986","unstructured":"Michael Stonebraker. 1986. The Case for Shared Nothing. IEEE Data Engineering Bulletin 9, 1 (1986), 4--9.","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_2_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196938"},{"key":"e_1_2_2_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"key":"e_1_2_2_29_1","unstructured":"Midhul Vuppalapati Justin Miron Rachit Agarwal Dan Truong Ashish Motivala and Thierry Cruanes. 2020. Building An Elastic Query Engine on Disaggregated Storage. In NSDI. 449--462."},{"key":"e_1_2_2_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457550"},{"key":"e_1_2_2_31_1","doi-asserted-by":"crossref","unstructured":"Jianguo Wang and Qizhen Zhang. 2023. Disaggregated Database Systems. In SIGMOD. 37--44.","DOI":"10.1145\/3555041.3589403"},{"key":"e_1_2_2_32_1","volume-title":"Sherman: A Write-Optimized Distributed BTree Index on Disaggregated Memory. In SIGMOD. 1033--1048.","author":"Wang Qing","year":"2022","unstructured":"Qing Wang, Youyou Lu, and Jiwu Shu. 2022. Sherman: A Write-Optimized Distributed BTree Index on Disaggregated Memory. In SIGMOD. 1033--1048."},{"key":"e_1_2_2_33_1","volume-title":"Aref","author":"Wang Ruihong","year":"2024","unstructured":"Ruihong Wang, Chuqing Gao, Jianguo Wang, Prishita Kadam, M. Tamer \u00d6zsu, and Walid G. Aref. 2024. Optimizing LSM-based Indexes for Disaggregated Memory. VLDB Journal (2024)."},{"key":"e_1_2_2_34_1","doi-asserted-by":"publisher","DOI":"10.14778\/3561261.3561263"},{"key":"e_1_2_2_35_1","volume-title":"Aref","author":"Wang Ruihong","year":"2023","unstructured":"Ruihong Wang, Jianguo Wang, Prishita Kadam, M. Tamer \u00d6zsu, and Walid G. Aref. 2023. dLSM: An LSM-Based Index for Memory Disaggregation. In ICDE. 2835--2849."},{"key":"e_1_2_2_36_1","unstructured":"Sebastian Wong. 2019. Disaggregated Graph Database with Rich Read Semantics https:\/\/atscaleconference.com\/videos\/scale-2019-disaggregated-graph-database-with-rich-read-semantics\/."},{"key":"e_1_2_2_37_1","first-page":"1","article-title":"Performance Analysis of NVMe SSDs and Their Implication on Real World Databases","volume":"6","author":"Xu Qiumin","year":"2015","unstructured":"Qiumin Xu, Huzefa Siyamwala, Mrinmoy Ghosh, Tameesh Suri, Manu Awasthi, Zvika Guz, Anahita Shayesteh, and Vijay Balakrishnan. 2015. Performance Analysis of NVMe SSDs and Their Implication on Real World Databases. In SYSTOR. 6:1--6:11.","journal-title":"SYSTOR."},{"key":"e_1_2_2_38_1","doi-asserted-by":"publisher","DOI":"10.14778\/3476249.3476265"},{"key":"e_1_2_2_39_1","unstructured":"Qiaolin Yu Chang Guo Jay Zhuang Viraj Thakkar Jianguo Wang and Zhichao Cao. 2024. CaaS-LSM: Compaction-as-a-Service for LSM-based Key-Value Stores in Storage Disaggregated Infrastructure. In SIGMOD."},{"key":"e_1_2_2_40_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352124"},{"key":"e_1_2_2_41_1","unstructured":"Qizhen Zhang Yifan Cai Sebastian Angel Vincent Liu Ang Chen and Boon Thau Loo. 2020. Rethinking Data Management Systems for Disaggregated Data Centers. In CIDR."},{"key":"e_1_2_2_42_1","doi-asserted-by":"publisher","DOI":"10.14778\/3467861.3467877"},{"key":"e_1_2_2_43_1","doi-asserted-by":"publisher","DOI":"10.1145\/3589276"}],"container-title":["Proceedings of the ACM on Management of Data"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3654983","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3654983","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,8,21]],"date-time":"2025-08-21T14:39:09Z","timestamp":1755787149000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3654983"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,5,29]]},"references-count":43,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2024,5,29]]}},"alternative-id":["10.1145\/3654983"],"URL":"https:\/\/doi.org\/10.1145\/3654983","relation":{},"ISSN":["2836-6573"],"issn-type":[{"value":"2836-6573","type":"electronic"}],"subject":[],"published":{"date-parts":[[2024,5,29]]}}}