{"id":"https://openalex.org/W2490268344","doi":"https://doi.org/10.1145/2897073.2897093","title":"On the IO characteristics of the SQLite transactions","display_name":"On the IO characteristics of the SQLite transactions","publication_year":2016,"publication_date":"2016-05-14","ids":{"openalex":"https://openalex.org/W2490268344","doi":"https://doi.org/10.1145/2897073.2897093","mag":"2490268344"},"language":"en","primary_location":{"id":"doi:10.1145/2897073.2897093","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2897073.2897093","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the International Conference on Mobile Software Engineering and Systems","raw_type":"proceedings-article"},"type":"conference-paper","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/A5066819168","display_name":"Dam Quang Tuan","orcid":null},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Dam Quang Tuan","raw_affiliation_strings":["Hanyang University, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hanyang University, Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012300973","display_name":"Seungyong Cheon","orcid":null},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Seungyong Cheon","raw_affiliation_strings":["Hanyang University, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hanyang University, Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110391759","display_name":"Youjip Won","orcid":"https://orcid.org/0000-0001-7178-5245"},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Youjip Won","raw_affiliation_strings":["Hanyang University, Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hanyang University, Korea","institution_ids":["https://openalex.org/I4575257"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4575257"],"apc_list":null,"apc_paid":null,"fwci":2.7775,"has_fulltext":false,"cited_by_count":21,"citation_normalized_percentile":{"value":0.91578686,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"214","last_page":"224"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","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"}},"topics":[{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","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"}},{"id":"https://openalex.org/T11478","display_name":"Caching and Content Delivery","score":0.9961000084877014,"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/T10273","display_name":"IoT and Edge/Fog Computing","score":0.987500011920929,"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.7701163291931152},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.746940553188324},{"id":"https://openalex.org/keywords/journaling-file-system","display_name":"Journaling file system","score":0.6922353506088257},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.5826712250709534},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.43731796741485596},{"id":"https://openalex.org/keywords/transaction-log","display_name":"Transaction log","score":0.4164941608905792}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7701163291931152},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.746940553188324},{"id":"https://openalex.org/C2225880","wikidata":"https://www.wikidata.org/wiki/Q579047","display_name":"Journaling file system","level":3,"score":0.6922353506088257},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.5826712250709534},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43731796741485596},{"id":"https://openalex.org/C2212953","wikidata":"https://www.wikidata.org/wiki/Q948454","display_name":"Transaction log","level":3,"score":0.4164941608905792},{"id":"https://openalex.org/C171730128","wikidata":"https://www.wikidata.org/wiki/Q5227290","display_name":"Data file","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2897073.2897093","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2897073.2897093","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the International Conference on Mobile Software Engineering and Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W179608396","https://openalex.org/W1278391197","https://openalex.org/W1520248310","https://openalex.org/W1940267184","https://openalex.org/W1987426261","https://openalex.org/W2004743445","https://openalex.org/W2023034913","https://openalex.org/W2047213919","https://openalex.org/W2055385473","https://openalex.org/W2084383859","https://openalex.org/W2084845471","https://openalex.org/W2098579796","https://openalex.org/W2102067558","https://openalex.org/W2129492214","https://openalex.org/W2129542763","https://openalex.org/W2132929952","https://openalex.org/W2138433591","https://openalex.org/W2161694911","https://openalex.org/W2265077477","https://openalex.org/W2322632975","https://openalex.org/W2395940218"],"related_works":["https://openalex.org/W2373786169","https://openalex.org/W1986934249","https://openalex.org/W2119843648","https://openalex.org/W2598532752","https://openalex.org/W2431281584","https://openalex.org/W2057123981","https://openalex.org/W2154958021","https://openalex.org/W1886762453","https://openalex.org/W3124826666","https://openalex.org/W2086086249"],"abstract_inverted_index":{"This":[0],"work":[1],"is":[2,48,88],"dedicated":[3],"to":[4,36,132,166,172,192,195],"study":[5,189],"the":[6,17,38,43,62,67,72,96,110,118,121,125,129,145,167,174,178,184,197],"IO":[7,20,45,54,112,200],"characteristics":[8],"of":[9,53,109,124,143,164,176],"SQLite":[10,40,86,94,99,130,146,159,198],"transaction":[11,87,131,160],"in":[12,114,140,151,187],"Android":[13],"platform.":[14],"We":[15,26,77,154,181],"collect":[16],"block":[18],"level":[19],"trace":[21],"from":[22,42,56,66],"for":[23,98,106],"six":[24],"months.":[25],"develop":[27],"an":[28,50,93,133],"elaborate":[29],"pattern":[30],"matching":[31],"algorithm.":[32],"It":[33,169],"allows":[34],"us":[35],"identify":[37],"individual":[39],"transactions":[41,147],"raw":[44],"trace,":[46],"which":[47],"essentially":[49],"interleaved":[51],"mixture":[52],"requests":[55],"concurrently":[57],"running":[58],"smartphone":[59,126],"applications.":[60],"Among":[61],"various":[63,193],"observations":[64],"obtained":[65,186],"study,":[68],"we":[69],"can":[70,127],"summarize":[71],"key":[73],"findings":[74,185],"as":[75],"follows.":[76],"carefully":[78],"believe":[79],"that":[80,156,183],"these":[81],"deserve":[82],"special":[83],"attention.":[84],"First,":[85],"under":[89],"extreme":[90,134],"inefficiency.":[91],"In":[92],"transaction,":[95],"IO's":[97],"journaling":[100,104],"and":[101,120,203],"EXT4":[102],"filesystem":[103],"account":[105],"over":[107],"75%":[108],"entire":[111],"volume":[113],"a":[115,136,157],"transaction.":[116],"Second,":[117],"suspend":[119],"wakeup":[122],"feature":[123],"leave":[128],"delay,":[135],"few":[137],"minutes.":[138],"Third,":[139],"fair":[141],"number":[142],"occasions,":[144],"are":[148,190],"being":[149],"used":[150],"inconsiderate":[152],"manner.":[153],"find":[155],"single":[158],"inserts":[161],"17.5":[162],"MByte":[163],"data":[165],"database.":[168,180],"turns":[170],"out":[171],"be":[173],"operation":[175],"initializing":[177],"map":[179],"hope":[182],"this":[188],"bifurcated":[191],"efforts":[194],"makes":[196],"related":[199],"more":[201],"efficient":[202],"effective.":[204]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3}],"updated_date":"2026-08-15T07:11:24.734988","created_date":"2025-10-10T00:00:00"}