{"id":"https://openalex.org/W2792118325","doi":"https://doi.org/10.1145/3186728.3164146","title":"SQL statement logging for making SQLite truly lite","display_name":"SQL statement logging for making SQLite truly lite","publication_year":2017,"publication_date":"2017-12-01","ids":{"openalex":"https://openalex.org/W2792118325","doi":"https://doi.org/10.1145/3186728.3164146","mag":"2792118325"},"language":"en","primary_location":{"id":"doi:10.1145/3186728.3164146","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3186728.3164146","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/A5101898807","display_name":"Jong-Hyeok Park","orcid":"https://orcid.org/0000-0001-8296-7781"},"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":true,"raw_author_name":"Jong-Hyeok Park","raw_affiliation_strings":["Sungkyunkwan University, Suwon, Korea"],"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University, Suwon, Korea","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"middle","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"],"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University, Suwon, Korea","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"last","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"],"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University, Suwon, Korea","institution_ids":["https://openalex.org/I848706"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5101898807"],"corresponding_institution_ids":["https://openalex.org/I848706"],"apc_list":null,"apc_paid":null,"fwci":1.036,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.81232042,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"11","issue":"4","first_page":"513","last_page":"525"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998999834060669,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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.9994999766349792,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8144413828849792},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5621612668037415},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.5443548560142517},{"id":"https://openalex.org/keywords/login","display_name":"Login","score":0.5353949666023254},{"id":"https://openalex.org/keywords/undo","display_name":"Undo","score":0.5271539092063904},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.34299972653388977},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.329401433467865}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8144413828849792},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5621612668037415},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.5443548560142517},{"id":"https://openalex.org/C113324615","wikidata":"https://www.wikidata.org/wiki/Q472302","display_name":"Login","level":2,"score":0.5353949666023254},{"id":"https://openalex.org/C2780154230","wikidata":"https://www.wikidata.org/wiki/Q513420","display_name":"Undo","level":2,"score":0.5271539092063904},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.34299972653388977},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.329401433467865}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3186728.3164146","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3186728.3164146","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":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1515932031","https://openalex.org/W1545155892","https://openalex.org/W1973735988","https://openalex.org/W1987426261","https://openalex.org/W1988852271","https://openalex.org/W1996031850","https://openalex.org/W2005203204","https://openalex.org/W2010042648","https://openalex.org/W2031032746","https://openalex.org/W2071414195","https://openalex.org/W2102449048","https://openalex.org/W2105271931","https://openalex.org/W2138433591","https://openalex.org/W2162288748","https://openalex.org/W2168968494","https://openalex.org/W2172126130","https://openalex.org/W2265077477","https://openalex.org/W2324329793","https://openalex.org/W2430913148","https://openalex.org/W2490268344","https://openalex.org/W2492576631","https://openalex.org/W6668293787","https://openalex.org/W6723072248"],"related_works":["https://openalex.org/W2115968517","https://openalex.org/W79743612","https://openalex.org/W2575202322","https://openalex.org/W2158967736","https://openalex.org/W1038420441","https://openalex.org/W2114343912","https://openalex.org/W2081448291","https://openalex.org/W2170927537","https://openalex.org/W2395284788","https://openalex.org/W1886762453"],"abstract_inverted_index":{"The":[0],"lightweight":[1,56],"codebase":[2],"of":[3,69,99,111,197,234,273],"SQLite":[4,53,64,163,215],"was":[5],"helpful":[6],"in":[7,15,41,52,67,161,172,190,271],"making":[8],"it":[9,25,201],"become":[10,144],"the":[11,21,48,73,123,157,182,194,264],"de-facto":[12],"standard":[13],"database":[14],"most":[16],"mobile":[17,126,152],"devices,":[18],"but,":[19],"at":[20,57,108],"same":[22],"time,":[23],"forced":[24],"to":[26,62,118,129,203,259],"take":[27],"less-complicated":[28],"transactional":[29,74,112],"schemes,":[30],"such":[31],"as":[32,164,246],"physical":[33],"page":[34],"logging,":[35],"journaling,":[36],"and":[37,105,132,147,221,226,236,261],"force":[38],"commit,":[39],"which":[40,169],"turn":[42],"cause":[43],"excessive":[44],"write":[45,49],"amplification.":[46],"Thus,":[47],"IO":[50,70,274],"cost":[51],"is":[54,117,170,244],"not":[55],"all.":[58],"In":[59,177],"this":[60],"paper,":[61],"make":[63],"truly":[65],"lite":[66],"terms":[68,272],"efficiency":[71],"for":[72,150,181],"support,":[75],"we":[76,155,179],"propose":[77],"SQLite/SSL":[78,90,211,250],",":[79,137],"a":[80,87,165,217,222,232,240],"per-transaction":[81],"SQL":[82,97],"statement":[83],"logging":[84,139,175,199],"scheme:":[85],"when":[86],"transaction":[88],"commits,":[89],"ensures":[91],"its":[92,229,247],"durability":[93],"by":[94,212,257,268],"storing":[95],"only":[96],"statements":[98],"small":[100],"size,":[101],"thus":[102],"writing":[103],"less":[104],"performing":[106],"faster":[107],"no":[109],"compromise":[110],"solidity.":[113],"Our":[114],"main":[115],"contribution":[116],"show":[119,180],"that,":[120],"based":[121],"on":[122],"observation":[124],"that":[125,185],"transactions":[127],"tend":[128],"be":[130],"short":[131],"exhibit":[133],"strong":[134],"update":[135],"locality":[136],"logical":[138,174,198],"can,":[140],"though":[141],"long":[142],"discarded,":[143],"an":[145],"elegant":[146],"perfect":[148],"fit":[149],"SQLite-based":[151],"applications.":[153],"Further,":[154],"leverage":[156],"WAL":[158,255],"journal":[159],"mode":[160,256],"vanilla":[162,214,253],"transaction-consistent":[166,218],"checkpoint":[167,219],"mechanism":[168,220],"indispensable":[171],"any":[173],"scheme.":[176],"addition,":[178],"first":[183],"time":[184],"byte-addressable":[186],"NVM":[187,242],"(non-volatile":[188],"memory)":[189],"host-side":[191],"can":[192,251],"realize":[193],"full":[195],"potential":[196],"because":[200],"allows":[202],"store":[204],"fine-grained":[205],"logs":[206],"quickly.":[207],"We":[208],"have":[209,227],"prototyped":[210],"augmenting":[213],"with":[216],"redo-only":[223],"recovery":[224],"logic,":[225],"evaluated":[228],"performance":[230],"using":[231],"set":[233],"synthetic":[235],"real":[237,241],"workloads.":[238],"When":[239],"board":[243],"used":[245],"log":[248],"device,":[249],"outperform":[252,263],"SQLite's":[254],"up":[258],"300x":[260],"also":[262],"state-of-the-arts":[265],"SQLite/PPL":[266],"scheme":[267],"several":[269],"folds":[270],"time.":[275]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}