{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,26]],"date-time":"2026-03-26T15:42:35Z","timestamp":1774539755579,"version":"3.50.1"},"reference-count":32,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2015,8]]},"abstract":"<jats:p>\n            Given its pervasive use in smart mobile platforms, there is a compelling need to optimize the performance of sluggish SQLite databases. Popular mobile applications such as messenger, email and social network services rely on SQLite for their data management need. Those mobile applications tend to execute relatively short transactions in the autocommit mode for transactional consistency in databases. This often has adverse effect on the flash memory storage in mobile devices because the small random updates cause high write amplification and high write latency. In order to address this problem, we propose a new optimization strategy, called\n            <jats:italic>per-page logging (PPL)<\/jats:italic>\n            , for mobile data management, and have implemented the key functions in\n            <jats:italic>SQLite\/PPL.<\/jats:italic>\n            The hardware component of\n            <jats:italic>SQLite\/PPL<\/jats:italic>\n            includes phase change memory (PCM) with a byte-addressable, persistent memory abstraction. By capturing an update in a physiological log record and adding it to the PCM log sector,\n            <jats:italic>SQLite\/PPL<\/jats:italic>\n            can replace a multitude of successive page writes made to the same logical page with much smaller log writes done to PCM much more efficiently. We have observed that\n            <jats:italic>SQLite\/PPL<\/jats:italic>\n            would potentially improve the performance of mobile applications by an order of magnitude while supporting transactional atomicity and durability.\n          <\/jats:p>","DOI":"10.14778\/2824032.2824044","type":"journal-article","created":{"date-parts":[[2015,9,16]],"date-time":"2015-09-16T12:18:17Z","timestamp":1442405897000},"page":"1454-1465","source":"Crossref","is-referenced-by-count":66,"title":["SQLite optimization with phase change memory for mobile applications"],"prefix":"10.14778","volume":"8","author":[{"given":"Gihwan","family":"Oh","sequence":"first","affiliation":[{"name":"Sungkyunkwan University, Suwon, Korea"}]},{"given":"Sangchul","family":"Kim","sequence":"additional","affiliation":[{"name":"Seoul National University, Seoul, Korea"}]},{"given":"Sang-Won","family":"Lee","sequence":"additional","affiliation":[{"name":"Sungkyunkwan University, Suwon, Korea"}]},{"given":"Bongki","family":"Moon","sequence":"additional","affiliation":[{"name":"Seoul National University, Seoul, Korea"}]}],"member":"320","published-online":{"date-parts":[[2015,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"AndroBench. http:\/\/www.androbench.org\/.  AndroBench. http:\/\/www.androbench.org\/."},{"key":"e_1_2_1_2_1","unstructured":"SQLite. http:\/\/www.sqlite.org\/.  SQLite. http:\/\/www.sqlite.org\/."},{"key":"e_1_2_1_3_1","volume-title":"April 4","author":"Ban A.","year":"1995","unstructured":"A. Ban . Flash file system , April 4 1995 . US Patent 5,404,485. A. Ban. Flash file system, April 4 1995. US Patent 5,404,485."},{"key":"e_1_2_1_4_1","first-page":"385","volume-title":"Non-volatile Memories. In MICRO '43","author":"Caulfield Adrian M.","year":"2010","unstructured":"Adrian M. Caulfield , Arup De , Joel Coburn , Todor I. Mollow , Rajesh K. Gupta , and Steven Swanson . Moneta : A High-Performance Storage Array Architecture for Next-Generation , Non-volatile Memories. In MICRO '43 , pages 385 -- 395 , 2010 . 10.1109\/MICRO.2010.33 Adrian M. Caulfield, Arup De, Joel Coburn, Todor I. Mollow, Rajesh K. Gupta, and Steven Swanson. Moneta: A High-Performance Storage Array Architecture for Next-Generation, Non-volatile Memories. In MICRO '43, pages 385--395, 2010. 10.1109\/MICRO.2010.33"},{"key":"e_1_2_1_5_1","first-page":"500","volume-title":"Proceedings of Solid-State Circuits Conference Digest of Technical Papers (ISSCC)","author":"Hoeju","year":"2011","unstructured":"Hoeju Chung et al. A 58nm 1.8V 1Gb PRAM with 6.4MB\/s program BW . In Proceedings of Solid-State Circuits Conference Digest of Technical Papers (ISSCC) , pages 500 -- 502 , 2011 . Hoeju Chung et al. A 58nm 1.8V 1Gb PRAM with 6.4MB\/s program BW. In Proceedings of Solid-State Circuits Conference Digest of Technical Papers (ISSCC), pages 500--502, 2011."},{"key":"e_1_2_1_6_1","first-page":"197","volume-title":"Solid-state Drives. In SOSP '13","author":"Coburn Joel","year":"2013","unstructured":"Joel Coburn , Trevor Bunker , Meir Schwarz , Rajesh Gupta , and Steven Swanson . From ARIES to MARS: Transaction Support for Next-generation , Solid-state Drives. In SOSP '13 , pages 197 -- 212 , 2013 . 10.1145\/2517349.2522724 Joel Coburn, Trevor Bunker, Meir Schwarz, Rajesh Gupta, and Steven Swanson. From ARIES to MARS: Transaction Support for Next-generation, Solid-state Drives. In SOSP '13, pages 197--212, 2013. 10.1145\/2517349.2522724"},{"key":"e_1_2_1_7_1","first-page":"105","volume-title":"Non-volatile Memories. In ASPLOS '11","author":"Coburn Joel","year":"2011","unstructured":"Joel Coburn , Adrian M. Caulfield , Ameen Akel , Laura M. Grupp , Rajesh K. Gupta , Ranjit Jhala , and Steven Swanson . NV-Heaps : Making Persistent Objects Fast and Safe with Next-generation , Non-volatile Memories. In ASPLOS '11 , pages 105 -- 118 , 2011 . 10.1145\/1961295.1950380 Joel Coburn, Adrian M. Caulfield, Ameen Akel, Laura M. Grupp, Rajesh K. Gupta, Ranjit Jhala, and Steven Swanson. NV-Heaps: Making Persistent Objects Fast and Safe with Next-generation, Non-volatile Memories. In ASPLOS '11, pages 105--118, 2011. 10.1145\/1961295.1950380"},{"key":"e_1_2_1_8_1","first-page":"133","volume-title":"Persistent Memory. In SOSP '09","author":"Condit Jeremy","year":"2009","unstructured":"Jeremy Condit , Edmund B. Nightingale , Christopher Frost , Engin Ipek , Benjamin Lee , Doug Burger , and Derrick Coetzee . Better I\/O Through Byte-addressable , Persistent Memory. In SOSP '09 , pages 133 -- 146 , 2009 . 10.1145\/1629575.1629589 Jeremy Condit, Edmund B. Nightingale, Christopher Frost, Engin Ipek, Benjamin Lee, Doug Burger, and Derrick Coetzee. Better I\/O Through Byte-addressable, Persistent Memory. In SOSP '09, pages 133--146, 2009. 10.1145\/1629575.1629589"},{"key":"e_1_2_1_9_1","volume-title":"Micron Has Phase Change Memory","author":"Perry Duglas","year":"2012","unstructured":"Duglas Perry . Micron Has Phase Change Memory in Volume Production. http:\/\/www.tomshardware.com\/-news\/micron-pcm-phase-change-memory, 16330 .html, July 2012 . Duglas Perry. Micron Has Phase Change Memory in Volume Production. http:\/\/www.tomshardware.com\/-news\/micron-pcm-phase-change-memory,16330.html, July 2012."},{"key":"e_1_2_1_10_1","first-page":"1221","volume-title":"Yun Wang. High Performance Database Logging Using Storage Class Memory. In ICDE '11","author":"Fang Ru","year":"2011","unstructured":"Ru Fang , Hui- I Hsiao , Bin He , C. Mohan , and Yun Wang. High Performance Database Logging Using Storage Class Memory. In ICDE '11 , pages 1221 -- 1231 , 2011 . 10.1109\/ICDE.2011.5767918 Ru Fang, Hui-I Hsiao, Bin He, C. Mohan, and Yun Wang. High Performance Database Logging Using Storage Class Memory. In ICDE '11, pages 1221--1231, 2011. 10.1109\/ICDE.2011.5767918"},{"key":"e_1_2_1_11_1","first-page":"2401","volume-title":"Haibo Hu. PCMLogging: Reducing Transaction Logging Overhead with PCM. In CIKM '11","author":"Gao Shen","year":"2011","unstructured":"Shen Gao , Jianliang Xu , Bingsheng He , Byron Choi , and Haibo Hu. PCMLogging: Reducing Transaction Logging Overhead with PCM. In CIKM '11 , pages 2401 -- 2404 , 2011 . 10.1145\/2063576.2063977 Shen Gao, Jianliang Xu, Bingsheng He, Byron Choi, and Haibo Hu. PCMLogging: Reducing Transaction Logging Overhead with PCM. In CIKM '11, pages 2401--2404, 2011. 10.1145\/2063576.2063977"},{"key":"e_1_2_1_12_1","unstructured":"Gartner Inc. Top 10 Strategic Technology Trends for 2015. http:\/\/www.gartner.com\/newsroom\/id\/2867917 October 2014.  Gartner Inc. Top 10 Strategic Technology Trends for 2015. http:\/\/www.gartner.com\/newsroom\/id\/2867917 October 2014."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735496.2735502"},{"key":"e_1_2_1_14_1","volume-title":"http:\/\/efutures.ac.uk\/sites\/-default\/files\/ITRS_2009.pdf","author":"International Technology ITRS.","year":"2009","unstructured":"ITRS. International Technology Roadmap for Semiconductors . http:\/\/efutures.ac.uk\/sites\/-default\/files\/ITRS_2009.pdf , 2009 . ITRS. International Technology Roadmap for Semiconductors. http:\/\/efutures.ac.uk\/sites\/-default\/files\/ITRS_2009.pdf, 2009."},{"key":"e_1_2_1_15_1","first-page":"309","volume-title":"Stack Optimization for Smartphones. In USENIX Annual Technical Conference '13","author":"Jeong Sooman","year":"2013","unstructured":"Sooman Jeong , Kisung Lee , Seongjin Lee , Seoungbum Son , and Youjip Won . I\/O Stack Optimization for Smartphones. In USENIX Annual Technical Conference '13 , pages 309 -- 320 , 2013 . Sooman Jeong, Kisung Lee, Seongjin Lee, Seoungbum Son, and Youjip Won. I\/O Stack Optimization for Smartphones. In USENIX Annual Technical Conference '13, pages 309--320, 2013."},{"key":"e_1_2_1_16_1","first-page":"97","volume-title":"Bongki Moon. X-FTL: Transactional FTL for SQLite Databases. In SIGMOD '13","author":"Kang Woon-Hak","year":"2013","unstructured":"Woon-Hak Kang , Sang-Won Lee , and Bongki Moon. X-FTL: Transactional FTL for SQLite Databases. In SIGMOD '13 , pages 97 -- 108 , 2013 . 10.1145\/2463676.2465326 Woon-Hak Kang, Sang-Won Lee, and Bongki Moon. X-FTL: Transactional FTL for SQLite Databases. In SIGMOD '13, pages 97--108, 2013. 10.1145\/2463676.2465326"},{"key":"e_1_2_1_17_1","first-page":"17","volume-title":"Cristian Ungureanu. Revisiting Storage for Smartphones. In USENIX FAST '12","author":"Kim Hyojun","year":"2012","unstructured":"Hyojun Kim , Nitin Agrawal , and Cristian Ungureanu. Revisiting Storage for Smartphones. In USENIX FAST '12 , pages 17 -- 29 , 2012 . Hyojun Kim, Nitin Agrawal, and Cristian Ungureanu. Revisiting Storage for Smartphones. In USENIX FAST '12, pages 17--29, 2012."},{"key":"e_1_2_1_18_1","first-page":"33","volume-title":"Lawrence Chiu. Evaluating Phase Change Memory for Enterprise Storage Systems: A Study of Caching and Tiering ApproachesRecovery. In USENIX FAST '14","author":"Kim Hyojun","year":"2014","unstructured":"Hyojun Kim , Sangeetha Seshadri , Clement L. Dickey , and Lawrence Chiu. Evaluating Phase Change Memory for Enterprise Storage Systems: A Study of Caching and Tiering ApproachesRecovery. In USENIX FAST '14 , pages 33 -- 45 , 2014 . Hyojun Kim, Sangeetha Seshadri, Clement L. Dickey, and Lawrence Chiu. Evaluating Phase Change Memory for Enterprise Storage Systems: A Study of Caching and Tiering ApproachesRecovery. In USENIX FAST '14, pages 33--45, 2014."},{"issue":"12","key":"e_1_2_1_19_1","doi-asserted-by":"crossref","first-page":"1363","DOI":"10.14778\/3402755.3402771","article-title":"In-Page Logging with PCRAM(demo paper)","volume":"4","author":"Kim Kangnyeon","year":"2011","unstructured":"Kangnyeon Kim , Sang-Won Lee , Bongki Moon , Chanik Park , and Joo-Young Hwang . IPL-P : In-Page Logging with PCRAM(demo paper) . Proceedings of the VLDB Endowment , 4 ( 12 ): 1363 -- 1366 , 2011 . Kangnyeon Kim, Sang-Won Lee, Bongki Moon, Chanik Park, and Joo-Young Hwang. IPL-P: In-Page Logging with PCRAM(demo paper). Proceedings of the VLDB Endowment, 4(12):1363--1366, 2011.","journal-title":"Proceedings of the VLDB Endowment"},{"key":"e_1_2_1_20_1","first-page":"273","volume-title":"USENIX FAST '14","author":"Kim Wook-Hee","year":"2014","unstructured":"Wook-Hee Kim , Beomseok Nam , Dongil Park , and Youjip Won . Resolving Journaling of Journal Anomaly in Android I\/O: Multi-version B-tree with Lazy Split . In USENIX FAST '14 , pages 273 -- 285 , 2014 . Wook-Hee Kim, Beomseok Nam, Dongil Park, and Youjip Won. Resolving Journaling of Journal Anomaly in Android I\/O: Multi-version B-tree with Lazy Split. In USENIX FAST '14, pages 273--285, 2014."},{"key":"e_1_2_1_21_1","first-page":"2","volume-title":"ISCA '09","author":"Lee Benjamin C.","year":"2009","unstructured":"Benjamin C. Lee , Engin Ipek , Onur Mutlu , and Doug Burger . Architecting Phase Change Memory As a Scalable Dram Alternative . In ISCA '09 , pages 2 -- 13 , 2009 . 10.1145\/1555815.1555758 Benjamin C. Lee, Engin Ipek, Onur Mutlu, and Doug Burger. Architecting Phase Change Memory As a Scalable Dram Alternative. In ISCA '09, pages 2--13, 2009. 10.1145\/1555815.1555758"},{"key":"e_1_2_1_22_1","first-page":"55","volume-title":"Lee and Bongki Moon. Design of Flash-Based DBMS: An In-Page Logging Approach. In SIGMOD '07","author":"Sang-Won","year":"2007","unstructured":"Sang-Won Lee and Bongki Moon. Design of Flash-Based DBMS: An In-Page Logging Approach. In SIGMOD '07 , pages 55 -- 66 , 2007 . 10.1145\/1247480.1247488 Sang-Won Lee and Bongki Moon. Design of Flash-Based DBMS: An In-Page Logging Approach. In SIGMOD '07, pages 55--66, 2007. 10.1145\/1247480.1247488"},{"key":"e_1_2_1_23_1","first-page":"876","volume-title":"Lee and Bongki Moon. Transactional In-Page Logging for Multiversion and Read Consistency and Recovery. In ICDE '11","author":"Sang-Won","year":"2011","unstructured":"Sang-Won Lee and Bongki Moon. Transactional In-Page Logging for Multiversion and Read Consistency and Recovery. In ICDE '11 , pages 876 -- 887 , 2011 . 10.1109\/ICDE.2011.5767889 Sang-Won Lee and Bongki Moon. Transactional In-Page Logging for Multiversion and Read Consistency and Recovery. In ICDE '11, pages 876--887, 2011. 10.1109\/ICDE.2011.5767889"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/1275986.1275990"},{"key":"e_1_2_1_25_1","first-page":"115","volume-title":"Rapid System Prototyping (RSP) '14","author":"Lee Taemin","year":"2014","unstructured":"Taemin Lee , Dongki Kim , Hyunsun Park , Sungjoo Yoo , and Sunggu Lee . FPGA-based Prototyping Systems for Emerging Memory Technologies(Invited Paper) . In Rapid System Prototyping (RSP) '14 , pages 115 -- 120 , 2014 . Taemin Lee, Dongki Kim, Hyunsun Park, Sungjoo Yoo, and Sunggu Lee. FPGA-based Prototyping Systems for Emerging Memory Technologies(Invited Paper). In Rapid System Prototyping (RSP) '14, pages 115--120, 2014."},{"key":"e_1_2_1_26_1","volume-title":"Omneo P8P 128-Mbit Parallel Phase Change Memory. Data Sheet","year":"2010","unstructured":"Numonyx. Omneo P8P 128-Mbit Parallel Phase Change Memory. Data Sheet 316144-06, Apr 2010 . Numonyx. Omneo P8P 128-Mbit Parallel Phase Change Memory. Data Sheet 316144-06, Apr 2010."},{"key":"e_1_2_1_27_1","first-page":"1","volume-title":"Thomas Willhalm. SOFORT: A Hybrid SCM-DRAM Storage Engine for Fast Data Recovery. In DaMoN '14","author":"Oukid Ismail","year":"2014","unstructured":"Ismail Oukid , Daniel Booss , Wolfgang Lehner , Peter Bumbulis , and Thomas Willhalm. SOFORT: A Hybrid SCM-DRAM Storage Engine for Fast Data Recovery. In DaMoN '14 , pages 8: 1 -- 8 :7, 2014 . 10.1145\/2619228.2619236 Ismail Oukid, Daniel Booss, Wolfgang Lehner, Peter Bumbulis, and Thomas Willhalm. SOFORT: A Hybrid SCM-DRAM Storage Engine for Fast Data Recovery. In DaMoN '14, pages 8:1--8:7, 2014. 10.1145\/2619228.2619236"},{"key":"e_1_2_1_28_1","first-page":"2015","author":"Research Portio","year":"2011","unstructured":"Portio Research . Mobile Data Usage Trends 2011 -- 2015 . http:\/\/www.portioresearch.com\/, 2011. Portio Research. Mobile Data Usage Trends 2011--2015. http:\/\/www.portioresearch.com\/, 2011.","journal-title":"Mobile Data Usage Trends"},{"key":"e_1_2_1_29_1","volume-title":"2G x 8 Bit NAND Flash Memory (K9F8G08U0M). Data sheet","author":"Electronics Samsung","year":"2007","unstructured":"Samsung Electronics . 2G x 8 Bit NAND Flash Memory (K9F8G08U0M). Data sheet , 2007 . Samsung Electronics. 2G x 8 Bit NAND Flash Memory (K9F8G08U0M). Data sheet, 2007."},{"key":"e_1_2_1_30_1","first-page":"1","volume-title":"HPCA-16","author":"Sun Guangyu","year":"2010","unstructured":"Guangyu Sun , Yongsoo Joo , Yibo Chen , Dimin Niu , Yuan Xie , Yiran Chen , and Hai Li . A Hybrid Solid-State Storage Architecture for the Performance, Energy Consumption, and Lifetime Improvement . In HPCA-16 , pages 1 -- 12 , 2010 . Guangyu Sun, Yongsoo Joo, Yibo Chen, Dimin Niu, Yuan Xie, Yiran Chen, and Hai Li. A Hybrid Solid-State Storage Architecture for the Performance, Energy Consumption, and Lifetime Improvement. In HPCA-16, pages 1--12, 2010."},{"key":"e_1_2_1_31_1","first-page":"91","volume-title":"Swift. Mnemosyne: Lightweight Persistent Memory. In ASPLOS '11","author":"Volos Haris","year":"2011","unstructured":"Haris Volos , Andres Jaan Tack , and Michael M . Swift. Mnemosyne: Lightweight Persistent Memory. In ASPLOS '11 , pages 91 -- 104 , 2011 . 10.1145\/1961295.1950379 Haris Volos, Andres Jaan Tack, and Michael M. Swift. Mnemosyne: Lightweight Persistent Memory. In ASPLOS '11, pages 91--104, 2011. 10.1145\/1961295.1950379"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732951.2732960"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2824032.2824044","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:16:44Z","timestamp":1672222604000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2824032.2824044"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2015,8]]},"references-count":32,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2015,8]]}},"alternative-id":["10.14778\/2824032.2824044"],"URL":"https:\/\/doi.org\/10.14778\/2824032.2824044","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2015,8]]}}}