{"id":"https://openalex.org/W2265077477","doi":"https://doi.org/10.14778/2824032.2824044","title":"SQLite optimization with phase change memory for mobile applications","display_name":"SQLite optimization with phase change memory for mobile applications","publication_year":2015,"publication_date":"2015-08-01","ids":{"openalex":"https://openalex.org/W2265077477","doi":"https://doi.org/10.14778/2824032.2824044","mag":"2265077477"},"language":"en","primary_location":{"id":"doi:10.14778/2824032.2824044","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2824032.2824044","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5050816517","display_name":"Gihwan Oh","orcid":"https://orcid.org/0000-0002-3335-2841"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Gihwan Oh","raw_affiliation_strings":["Sungkyunkwan University, Suwon, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University, Suwon, Korea","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103696231","display_name":"Sang\u2010Chul Kim","orcid":null},"institutions":[{"id":"https://openalex.org/I139264467","display_name":"Seoul National University","ror":"https://ror.org/04h9pn542","country_code":"KR","type":"education","lineage":["https://openalex.org/I139264467"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Sangchul Kim","raw_affiliation_strings":["Seoul National University, Seoul, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Seoul National University, Seoul, Korea","institution_ids":["https://openalex.org/I139264467"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100360904","display_name":"Sang-Won Lee","orcid":"https://orcid.org/0000-0002-4206-3718"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Sang-Won Lee","raw_affiliation_strings":["Sungkyunkwan University, Suwon, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University, Suwon, Korea","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006334513","display_name":"Bongki Moon","orcid":"https://orcid.org/0000-0001-9382-8306"},"institutions":[{"id":"https://openalex.org/I139264467","display_name":"Seoul National University","ror":"https://ror.org/04h9pn542","country_code":"KR","type":"education","lineage":["https://openalex.org/I139264467"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Bongki Moon","raw_affiliation_strings":["Seoul National University, Seoul, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Seoul National University, Seoul, Korea","institution_ids":["https://openalex.org/I139264467"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":12.5244,"has_fulltext":false,"cited_by_count":77,"citation_normalized_percentile":{"value":0.98790966,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":"8","issue":"12","first_page":"1454","last_page":"1465"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11478","display_name":"Caching and Content Delivery","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.808556318283081},{"id":"https://openalex.org/keywords/phase-change-memory","display_name":"Phase-change memory","score":0.6645379662513733},{"id":"https://openalex.org/keywords/atomicity","display_name":"Atomicity","score":0.6035227179527283},{"id":"https://openalex.org/keywords/mobile-device","display_name":"Mobile device","score":0.4596009850502014},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.45849692821502686},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.3903859555721283},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.3364911675453186},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.29827016592025757},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.23249340057373047}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.808556318283081},{"id":"https://openalex.org/C64142963","wikidata":"https://www.wikidata.org/wiki/Q1153902","display_name":"Phase-change memory","level":3,"score":0.6645379662513733},{"id":"https://openalex.org/C188045909","wikidata":"https://www.wikidata.org/wiki/Q3306359","display_name":"Atomicity","level":3,"score":0.6035227179527283},{"id":"https://openalex.org/C186967261","wikidata":"https://www.wikidata.org/wiki/Q5082128","display_name":"Mobile device","level":2,"score":0.4596009850502014},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.45849692821502686},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.3903859555721283},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.3364911675453186},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.29827016592025757},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.23249340057373047},{"id":"https://openalex.org/C61696701","wikidata":"https://www.wikidata.org/wiki/Q770766","display_name":"Engineering physics","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C133256868","wikidata":"https://www.wikidata.org/wiki/Q7180940","display_name":"Phase change","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2824032.2824044","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2824032.2824044","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320322105","display_name":"Korea Institute of Science and Technology Information","ror":"https://ror.org/01k4yrm29"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W179608396","https://openalex.org/W1493976610","https://openalex.org/W1973735988","https://openalex.org/W1987426261","https://openalex.org/W1990946453","https://openalex.org/W1996031850","https://openalex.org/W2005203204","https://openalex.org/W2018763861","https://openalex.org/W2057567813","https://openalex.org/W2102449048","https://openalex.org/W2105271931","https://openalex.org/W2113637091","https://openalex.org/W2121636206","https://openalex.org/W2125812397","https://openalex.org/W2138433591","https://openalex.org/W2150662965","https://openalex.org/W2157808045","https://openalex.org/W2162288748","https://openalex.org/W2164999122","https://openalex.org/W2168968494","https://openalex.org/W2270211026","https://openalex.org/W2294111665","https://openalex.org/W2402486866","https://openalex.org/W2585220027","https://openalex.org/W2998915116"],"related_works":["https://openalex.org/W2383284615","https://openalex.org/W2998398829","https://openalex.org/W135928233","https://openalex.org/W2130966263","https://openalex.org/W2384193616","https://openalex.org/W2382986841","https://openalex.org/W2354060507","https://openalex.org/W2989908039","https://openalex.org/W2371792015","https://openalex.org/W2388417751"],"abstract_inverted_index":{"Given":[0],"its":[1],"pervasive":[2],"use":[3],"in":[4,49,56,68,111,133],"smart":[5],"mobile":[6,22,41,69,102,183],"platforms,":[7],"there":[8],"is":[9],"a":[10,92,124,134,149],"compelling":[11],"need":[12],"to":[13,44,86,141,156,167],"optimize":[14],"the":[15,50,64,72,108,142,157,180],"performance":[16,181],"of":[17,116,151,182,188],"sluggish":[18],"SQLite":[19,34],"databases.":[20,57],"Popular":[21],"applications":[23,42,184],"such":[24],"as":[25],"messenger,":[26],"email":[27],"and":[28,80,105,138,194],"social":[29],"network":[30],"services":[31],"rely":[32],"on":[33,63],"for":[35,53,101],"their":[36],"data":[37,103],"management":[38],"need.":[39],"Those":[40],"tend":[43],"execute":[45],"relatively":[46],"short":[47],"transactions":[48],"autocommit":[51],"mode":[52],"transactional":[54,192],"consistency":[55],"This":[58],"often":[59],"has":[60],"adverse":[61],"effect":[62],"flash":[65],"memory":[66,121,127],"storage":[67],"devices":[70],"because":[71],"small":[73],"random":[74],"updates":[75],"cause":[76],"high":[77,81],"write":[78,82],"amplification":[79],"latency.":[83],"In":[84],"order":[85,187],"address":[87],"this":[88],"problem,":[89],"we":[90],"propose":[91],"new":[93],"optimization":[94],"strategy,":[95],"called":[96],"per-page":[97],"logging":[98],"(PPL)":[99],",":[100],"management,":[104],"have":[106,173],"implemented":[107],"key":[109],"functions":[110],"SQLite/PPL.":[112],"The":[113],"hardware":[114],"component":[115],"SQLite/PPL":[117,146,176],"includes":[118],"phase":[119],"change":[120],"(PCM)":[122],"with":[123,161],"byte-addressable,":[125],"persistent":[126],"abstraction.":[128],"By":[129],"capturing":[130],"an":[131,186],"update":[132],"physiological":[135],"log":[136,144,164],"record":[137],"adding":[139],"it":[140],"PCM":[143,168],"sector,":[145],"can":[147],"replace":[148],"multitude":[150],"successive":[152],"page":[153,160],"writes":[154,165],"made":[155],"same":[158],"logical":[159],"much":[162,169],"smaller":[163],"done":[166],"more":[170],"efficiently.":[171],"We":[172],"observed":[174],"that":[175],"would":[177],"potentially":[178],"improve":[179],"by":[185],"magnitude":[189],"while":[190],"supporting":[191],"atomicity":[193],"durability.":[195]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":10},{"year":2019,"cited_by_count":10},{"year":2018,"cited_by_count":12},{"year":2017,"cited_by_count":17},{"year":2016,"cited_by_count":8}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}