{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,15]],"date-time":"2026-07-15T07:13:00Z","timestamp":1784099580108,"version":"3.55.0"},"reference-count":83,"publisher":"Association for Computing Machinery (ACM)","issue":"1","license":[{"start":{"date-parts":[[2025,2,10]],"date-time":"2025-02-10T00:00:00Z","timestamp":1739145600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"funder":[{"name":"The National Research Foundation of Korea (NRF) grant funded by the Korea governmen","award":["No.2022R1A2C2008225, No.RS-2023-00251665"],"award-info":[{"award-number":["No.2022R1A2C2008225, No.RS-2023-00251665"]}]},{"name":"The Institute of Information & Communications Technology Planning & Evaluation(IITP) grant funded by the Korea governmen","award":["IITP-2024-RS-2020-II20181, No.RS-2024-00454666"],"award-info":[{"award-number":["IITP-2024-RS-2020-II20181, No.RS-2024-00454666"]}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. ACM Manag. Data"],"published-print":{"date-parts":[[2025,2,10]]},"abstract":"<jats:p>\n                    When running OLTP workloads on flash SSDs, relational DBMSs still face the write durability overhead, severely limiting their performance. To address this challenge, we propose NV-PPL, a novel database architecture that leverages NVDIMM as a\n                    <jats:italic toggle=\"yes\">durable log cache.<\/jats:italic>\n                    <jats:italic toggle=\"yes\">NV-PPL<\/jats:italic>\n                    captures per-page redo logs and retains them on NVDIMM to absorb writes from DRAM to SSD. Our\n                    <jats:italic toggle=\"yes\">NV-PPL<\/jats:italic>\n                    prototype, deployed on an actual NVDIMM device, demonstrates superior transaction throughput, surpassing the\n                    <jats:italic toggle=\"yes\">same-priced<\/jats:italic>\n                    Vanilla MySQL by at least 6.9\u00d7 and NV-SQL, a page-grained NVDIMM caching scheme, by up to 1.5\u00d7. Beyond write reduction, the page-wise logs in NVDIMM enable novel approaches such as redo-less recovery and redo-based multi-versioning. Compared to Vanilla MySQL, redo-less recovery reduces recovery time by one-third, while redo-based multi-versioning enhances the latency of long-lived transactions in HTAP workloads by 3\u00d7 to 18\u00d7.\n                  <\/jats:p>","DOI":"10.1145\/3709667","type":"journal-article","created":{"date-parts":[[2025,2,11]],"date-time":"2025-02-11T15:45:06Z","timestamp":1739288706000},"page":"1-28","source":"Crossref","is-referenced-by-count":3,"title":["Boosting OLTP Performance with Per-Page Logging on NVDIMM"],"prefix":"10.1145","volume":"3","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-8128-6164","authenticated-orcid":false,"given":"Bohyun","family":"Lee","sequence":"first","affiliation":[{"name":"Technical University of Munich, Munich, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0000-1564-9417","authenticated-orcid":false,"given":"Seongjae","family":"Moon","sequence":"additional","affiliation":[{"name":"Sungkyunkwan University, Suwon, Republic of Korea"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8296-7781","authenticated-orcid":false,"given":"Jonghyeok","family":"Park","sequence":"additional","affiliation":[{"name":"Korea University, Seoul, Republic of Korea"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-4206-3718","authenticated-orcid":false,"given":"Sang-Won","family":"Lee","sequence":"additional","affiliation":[{"name":"Seoul National University, Seoul, Republic of Korea"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2025,2,11]]},"reference":[{"key":"e_1_2_2_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/3583140.3583157"},{"key":"e_1_2_2_2_1","volume-title":"High Availability, and Efficient Database Maintenance","author":"Ahmed Ibrar","unstructured":"Ibrar Ahmed, Gregory Smith, and Enrico Pirozzi. 2018. PostgreSQL 10 High Performance: Expert Techniques for Query Optimization, High Availability, and Efficient Database Maintenance. Packt Publishing."},{"key":"e_1_2_2_3_1","doi-asserted-by":"publisher","DOI":"10.14778\/3538598.3538612"},{"key":"e_1_2_2_4_1","doi-asserted-by":"publisher","DOI":"10.14778\/3583140.3583159"},{"key":"e_1_2_2_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526126"},{"key":"e_1_2_2_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3314047"},{"key":"e_1_2_2_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352131"},{"key":"e_1_2_2_8_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352131"},{"key":"e_1_2_2_9_1","first-page":"11","article-title":"The Five-Minute Rule 30 Years Later and Its Impact on the Storage","volume":"62","author":"Appuswamy Raja","year":"2019","unstructured":"Raja Appuswamy, Goetz Graefe, Renata Borovica-Gajic, and Anastasia Ailamaki. 2019. The Five-Minute Rule 30 Years Later and Its Impact on the Storage Hierarchy. Commun. ACM, Vol. 62, 11 (oct 2019), 114--120.","journal-title":"Hierarchy. Commun. ACM"},{"key":"e_1_2_2_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465296"},{"key":"e_1_2_2_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2749441"},{"key":"e_1_2_2_12_1","doi-asserted-by":"publisher","DOI":"10.14778\/3025111.3025116"},{"key":"e_1_2_2_13_1","unstructured":"Jens Axboe. [n. d.]. FIO (Flexible IO Tester). https:\/\/github.com\/axboe\/fio."},{"key":"e_1_2_2_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/3461535.3461543"},{"key":"e_1_2_2_15_1","volume-title":"O'Neil","author":"Berenson Hal","year":"1995","unstructured":"Hal Berenson, Philip A. Bernstein, Jim Gray, Jim Melton, Elizabeth J. O'Neil, and Patrick E. O'Neil. 1995. A Critique of ANSI SQL Isolation Levels. In Proceedings of ACM SIGMOD. 1--10."},{"key":"e_1_2_2_16_1","volume-title":"Carey","author":"Bober Paul M.","year":"1992","unstructured":"Paul M. Bober and Michael J. Carey. 1992. On Mixing Queries and Transactions via Multiversion Locking. In Proceedings of ICDE. 535--545."},{"key":"e_1_2_2_17_1","doi-asserted-by":"publisher","DOI":"10.14778\/3364324.3364328"},{"key":"e_1_2_2_18_1","volume-title":"Proceedings of the Linux Symposium. Citeseer, 119--130","author":"Boyd-Wickizer Silas","year":"2012","unstructured":"Silas Boyd-Wickizer, M Frans Kaashoek, Robert Morris, and Nickolai Zeldovich. 2012. Non-scalable locks are dangerous. In Proceedings of the Linux Symposium. Citeseer, 119--130."},{"key":"e_1_2_2_19_1","volume-title":"Proceedings of the 2013 USENIX Conference on Annual Technical Conference (USENIX ATC'13). 49--60","author":"Bronson Nathan","year":"2013","unstructured":"Nathan Bronson, Zach Amsden, George Cabrera, Prasad Chakka, Peter Dimov, Hui Ding, Jack Ferris, Anthony Giardullo, Sachin Kulkarni, Harry Li, Mark Marchukov, Dmitri Petrov, Lovro Puzar, Yee Jiun Song, and Venkat Venkataramani. 2013. TAO: Facebook's Distributed Data Store for the Social Graph. In Proceedings of the 2013 USENIX Conference on Annual Technical Conference (USENIX ATC'13). 49--60."},{"key":"e_1_2_2_20_1","volume-title":"Ries","author":"Chan Arvola","year":"1982","unstructured":"Arvola Chan, Stephen Fox, Wen-Te K. Lin, Anil Nori, and Daniel R. Ries. 1982. The Implementation of an Integrated Concurrency Control and Recovery Scheme. In Proceedings of ACM SIGMOD. 184--191."},{"key":"e_1_2_2_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/1942776.1942778"},{"key":"e_1_2_2_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/3373376.3378515"},{"key":"e_1_2_2_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/2517349.2522724"},{"key":"e_1_2_2_24_1","unstructured":"Dell. 2023. Dell EMC NVDIMM-N Persistent Memory. https:\/\/dl.dell.com\/topicspdf\/nvdimm_n_user_guide_en-us.pdf."},{"key":"e_1_2_2_25_1","volume-title":"Persistent Memory Research in the Post-Optane Era (DIMES '23)","author":"Desnoyers Peter","unstructured":"Peter Desnoyers, Ian Adams, Tyler Estro, Anshul Gandhi, Geoff Kuenning, Mike Mesnier, Carl Waldspurger, Avani Wildani, and Erez Zadok. 2023. Persistent Memory Research in the Post-Optane Era (DIMES '23). Association for Computing Machinery, New York, NY, USA, 23--30."},{"key":"e_1_2_2_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/38713.38755"},{"key":"e_1_2_2_27_1","doi-asserted-by":"publisher","DOI":"10.14778\/3598581.3598584"},{"key":"e_1_2_2_28_1","doi-asserted-by":"crossref","unstructured":"Stavros Harizopoulos Daniel J Abadi Samuel Madden and Michael Stonebraker. 2018. OLTP through the looking glass and what we found there. In Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker. 409--439.","DOI":"10.1145\/3226595.3226635"},{"key":"e_1_2_2_29_1","doi-asserted-by":"crossref","unstructured":"Michael Haubenschild Caetano Sauer Thomas Neumann and Viktor Leis. 2020. Rethinking Logging Checkpoints and Recovery for High-Performance Storage Engines. 877--892.","DOI":"10.1145\/3318464.3389716"},{"key":"e_1_2_2_30_1","unstructured":"HPE. 2016. HPE 8GB NVDIMM User Guide for HPE ProLiant Gen9 Servers. https:\/\/www.hpe.com\/psnow\/doc\/c05351006."},{"key":"e_1_2_2_31_1","doi-asserted-by":"publisher","DOI":"10.1147\/sj.422.0347"},{"key":"e_1_2_2_32_1","doi-asserted-by":"publisher","DOI":"10.1007\/s13222-015-0204-3"},{"key":"e_1_2_2_33_1","unstructured":"Intel Corp. 2016. Intel 3D XPoint. https:\/\/www.intel.com\/content\/www\/us\/en\/architecture-and-technology\/intel-micron-3d-xpoint-webcast.html."},{"key":"e_1_2_2_34_1","unstructured":"Intel Corporation. 2023. Intel Memory Latency Checker v3.9. https:\/\/www.intel.com\/content\/www\/us\/en\/developer\/articles\/tool\/intelr-memory-latency-checker.html."},{"key":"e_1_2_2_35_1","unstructured":"Ken Jacobs. 1995. Concurrency Control Transaction Isolation and Serializability in SQL92 and Oracle7. Oracle White Paper."},{"key":"e_1_2_2_36_1","doi-asserted-by":"publisher","DOI":"10.5555\/2696578.2696591"},{"key":"e_1_2_2_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595632"},{"key":"e_1_2_2_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3389714"},{"key":"e_1_2_2_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526135"},{"key":"e_1_2_2_40_1","doi-asserted-by":"publisher","DOI":"10.14778\/3402755.3402771"},{"key":"e_1_2_2_41_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2746480"},{"key":"e_1_2_2_42_1","unstructured":"Alexey Kopytov. 2018. SysBench. https:\/\/github.com\/akopytov\/sysbench."},{"key":"e_1_2_2_43_1","doi-asserted-by":"publisher","DOI":"10.14778\/3598581.3598605"},{"key":"e_1_2_2_44_1","doi-asserted-by":"publisher","DOI":"10.1109\/ACCESS.2023.3267084"},{"key":"e_1_2_2_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2903734"},{"key":"e_1_2_2_46_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526188"},{"key":"e_1_2_2_47_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247488"},{"key":"e_1_2_2_48_1","volume-title":"Proceedings of the 14th USENIX Conference on Operating Systems Design and Implementation. USENIX Association, 425--441","author":"Lepers Baptiste","year":"2020","unstructured":"Baptiste Lepers, Oana Balmau, Karan Gupta, and Willy Zwaenepoel. 2020. KVell: Snapshot Isolation without Snapshots. In Proceedings of the 14th USENIX Conference on Operating Systems Design and Implementation. USENIX Association, 425--441."},{"key":"e_1_2_2_49_1","volume-title":"Proceedings of the 1993 International Conference on Management of Data (SIGMOD '93)","author":"Scott","unstructured":"Scott T. Leutenegger and Daniel Dias. 1993. A Modeling Study of the TPC-C Benchmark. In Proceedings of the 1993 International Conference on Management of Data (SIGMOD '93). 22--31."},{"key":"e_1_2_2_50_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4302-3955-0"},{"key":"e_1_2_2_51_1","doi-asserted-by":"publisher","DOI":"10.1109\/ISCA.1998.694761"},{"key":"e_1_2_2_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526043"},{"key":"e_1_2_2_53_1","unstructured":"Bertrand Matthelie. 2023. MySQL cloud services cost comparison: who provides the best value? https:\/\/blogs.oracle.com\/mysql\/post\/mysql-cloud-services-cost-comparison-who-provides-the-best-value."},{"key":"e_1_2_2_54_1","unstructured":"Micron. 2017. Micron Advances Persistent Memory with 32GB NVDIMM. https:\/\/investors.micron.com\/news-releases\/news-release-details\/micron-advances-persistent-memory-32gb-nvdimm."},{"key":"e_1_2_2_55_1","unstructured":"Microsoft. 2023. About log shipping (SQL Server). https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/log-shipping\/about-log-shipping-sql-server?view=sql-server-ver16."},{"key":"e_1_2_2_56_1","volume-title":"Proceedings of VLDB. 368--379","author":"Mohan C.","year":"1993","unstructured":"C. Mohan. 1993. A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure. In Proceedings of VLDB. 368--379."},{"key":"e_1_2_2_57_1","doi-asserted-by":"publisher","DOI":"10.1145\/128765.128770"},{"key":"e_1_2_2_58_1","unstructured":"MySQL Community. 2023. InnoDB Recovery. https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/innodb-recovery.html."},{"key":"e_1_2_2_59_1","unstructured":"MySQL Team (Oracle Corp.). 2021a. MySQL 5.7 Reference Manual. https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/."},{"key":"e_1_2_2_60_1","unstructured":"MySQL Team (Oracle Corp.). 2021b. MySQL Server (GitHub repository). https:\/\/github.com\/mysql\/mysql-server."},{"key":"e_1_2_2_61_1","unstructured":"MySQL Team (Oracle Corp.). 2024. The InnoDB Multi-Versioning. https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/innodb-multi-versioning.html."},{"key":"e_1_2_2_62_1","unstructured":"Netlist. 2019. Netlist NVvault DDR4 NVDIMM-N. https:\/\/www.storagenewsletter.com\/2019\/11\/13\/netlist-nvme-ssds-and-nvvault-ddr4-nvdimm-n-validated-on-2nd-gen-amd-epyc-processors\/."},{"key":"e_1_2_2_63_1","unstructured":"Oracle Corp. 2021. Oracle Redo Log buffer. https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/tgdba\/database-memory-allocation.html."},{"key":"e_1_2_2_64_1","unstructured":"Oracle (MySQL Team). 2024. rw_lock_t Struct Reference. https:\/\/dev.mysql.com\/doc\/dev\/mysql-server\/latest\/structrw__lock__t.html."},{"key":"e_1_2_2_65_1","doi-asserted-by":"publisher","DOI":"10.1145\/2619228.2619236"},{"key":"e_1_2_2_66_1","unstructured":"Percona. 2018. tpcc-mysql. https:\/\/github.com\/Percona-Lab\/tpcc-mysql."},{"key":"e_1_2_2_67_1","unstructured":"pmem.io. 2022. Persistent Memory Development Kit. https:\/\/pmem.io\/pmdk\/."},{"key":"e_1_2_2_68_1","unstructured":"PostgreSQL Global Development Group. 2023. PostgreSQL 16.1 Documentation. https:\/\/www.postgresql.org\/docs\/16\/index.html."},{"key":"e_1_2_2_69_1","doi-asserted-by":"publisher","DOI":"10.1145\/357353.357355"},{"key":"e_1_2_2_70_1","unstructured":"Chris Ruemmler and John Wilkes. 1993. A trace-driven analysis of disk working set sizes. Technical Report HPL--OSR--93--23. Hewlett-Packard Laboratories Palo Alto CA USA."},{"key":"e_1_2_2_71_1","unstructured":"Samsung. 2016. Samsung DDR4 Memory. https:\/\/semiconductor.samsung.com\/dram\/module\/rdimm\/m393a2g40db0-cpb\/."},{"key":"e_1_2_2_72_1","unstructured":"Samsung. 2017. Samsung 960 PRO 1TB. https:\/\/www.samsung.com\/us\/computing\/memory-storage\/solid-state-drives\/ssd-960-pro-m-2--1tb-mz-v6p1t0bw\/."},{"key":"e_1_2_2_73_1","unstructured":"Samsung Electronics Corp. 2023. Memory Semantic SSD (Persistent Mode). https:\/\/semiconductor.samsung.com\/us\/news-events\/tech-blog\/webinar-memory-semantic-ssd\/."},{"key":"e_1_2_2_74_1","volume-title":"Proceedings of the VLDB Endowment","volume":"11","author":"Graefe Caetano","year":"2018","unstructured":"Sauer, Caetano and Graefe, Goetz and H\u00e4rder, Theo. 2018. FineLine: Log-Structured Transactional Storage and Recovery. Proceedings of the VLDB Endowment, Vol. 11, 13 (2018)."},{"key":"e_1_2_2_75_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196897"},{"key":"e_1_2_2_76_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196897"},{"key":"e_1_2_2_77_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-020-00622--9"},{"key":"e_1_2_2_78_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"key":"e_1_2_2_79_1","doi-asserted-by":"publisher","DOI":"10.1145\/3589785"},{"key":"e_1_2_2_80_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732951.2732960"},{"key":"e_1_2_2_81_1","volume-title":"Proceedings of USENIX conference on File and Storage Technologies (FAST'20)","author":"Yang Jianhua","year":"2020","unstructured":"Jianhua Yang, Juno Kim, Morteza Hoseinzadeh, Joseph Izraelevitz, and Steven Swanson. 2020a. An Empirical Guide to the Behavior and Use of Scalable Persistent Memory. In Proceedings of USENIX conference on File and Storage Technologies (FAST'20)."},{"key":"e_1_2_2_82_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415553"},{"key":"e_1_2_2_83_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3452819"}],"container-title":["Proceedings of the ACM on Management of Data"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3709667","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3709667","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,3,31]],"date-time":"2026-03-31T18:18:14Z","timestamp":1774981094000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3709667"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,2,10]]},"references-count":83,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2025,2,10]]}},"alternative-id":["10.1145\/3709667"],"URL":"https:\/\/doi.org\/10.1145\/3709667","relation":{},"ISSN":["2836-6573"],"issn-type":[{"value":"2836-6573","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,2,10]]}}}