{"id":"https://openalex.org/W2883007307","doi":"https://doi.org/10.1109/tcad.2018.2855179","title":"An Efficient LSM-Tree-Based SQLite-Like Database Engine for Mobile Devices","display_name":"An Efficient LSM-Tree-Based SQLite-Like Database Engine for Mobile Devices","publication_year":2018,"publication_date":"2018-07-16","ids":{"openalex":"https://openalex.org/W2883007307","doi":"https://doi.org/10.1109/tcad.2018.2855179","mag":"2883007307"},"language":"en","primary_location":{"id":"doi:10.1109/tcad.2018.2855179","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcad.2018.2855179","pdf_url":null,"source":{"id":"https://openalex.org/S100835903","display_name":"IEEE Transactions on Computer-Aided Design of Integrated Circuits and Systems","issn_l":"0278-0070","issn":["0278-0070","1937-4151"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Computer-Aided Design of Integrated Circuits and Systems","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/A5032600760","display_name":"Zhaoyan Shen","orcid":"https://orcid.org/0000-0001-9526-6634"},"institutions":[{"id":"https://openalex.org/I80143920","display_name":"Shandong University of Science and Technology","ror":"https://ror.org/04gtjhw98","country_code":"CN","type":"education","lineage":["https://openalex.org/I80143920"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Zhaoyan Shen","raw_affiliation_strings":["School of Computer Science and Technology, Shandong University, Jinan, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Shandong University, Jinan, China","institution_ids":["https://openalex.org/I80143920"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052921635","display_name":"Yuanjing Shi","orcid":null},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Yuanjing Shi","raw_affiliation_strings":["Department of Computing, Hong Kong Polytechnic University, Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computing, Hong Kong Polytechnic University, Hong Kong","institution_ids":["https://openalex.org/I14243506"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101639532","display_name":"Zili Shao","orcid":"https://orcid.org/0000-0002-2173-2847"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"CN","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zili Shao","raw_affiliation_strings":["Department of Computer Science and Engineering, Chinese University of Hong Kong, Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Chinese University of Hong Kong, Hong Kong","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5087366755","display_name":"Yong Guan","orcid":"https://orcid.org/0000-0002-2373-2779"},"institutions":[{"id":"https://openalex.org/I96852419","display_name":"Capital Normal University","ror":"https://ror.org/005edt527","country_code":"CN","type":"education","lineage":["https://openalex.org/I96852419"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yong Guan","raw_affiliation_strings":["Beijing Advanced Innovation Center for Imaging Technology, College of Computer and Information Management, Capital Normal University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Beijing Advanced Innovation Center for Imaging Technology, College of Computer and Information Management, Capital Normal University, Beijing, China","institution_ids":["https://openalex.org/I96852419"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5032600760"],"corresponding_institution_ids":["https://openalex.org/I80143920"],"apc_list":null,"apc_paid":null,"fwci":1.4763,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.84192338,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"38","issue":"9","first_page":"1635","last_page":"1647"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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/T11478","display_name":"Caching and Content Delivery","score":0.9993000030517578,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9986000061035156,"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.8426417708396912},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.6445533037185669},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5976663827896118},{"id":"https://openalex.org/keywords/front-and-back-ends","display_name":"Front and back ends","score":0.5368144512176514},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5244355797767639},{"id":"https://openalex.org/keywords/interface","display_name":"Interface (matter)","score":0.5137253999710083},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.48922133445739746},{"id":"https://openalex.org/keywords/window","display_name":"Window (computing)","score":0.46981528401374817},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.4364721477031708},{"id":"https://openalex.org/keywords/compiler","display_name":"Compiler","score":0.4178673326969147},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.40958651900291443},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3840504586696625}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8426417708396912},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.6445533037185669},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5976663827896118},{"id":"https://openalex.org/C53016008","wikidata":"https://www.wikidata.org/wiki/Q620167","display_name":"Front and back ends","level":2,"score":0.5368144512176514},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5244355797767639},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.5137253999710083},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.48922133445739746},{"id":"https://openalex.org/C2778751112","wikidata":"https://www.wikidata.org/wiki/Q835016","display_name":"Window (computing)","level":2,"score":0.46981528401374817},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.4364721477031708},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.4178673326969147},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.40958651900291443},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3840504586696625},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0},{"id":"https://openalex.org/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tcad.2018.2855179","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcad.2018.2855179","pdf_url":null,"source":{"id":"https://openalex.org/S100835903","display_name":"IEEE Transactions on Computer-Aided Design of Integrated Circuits and Systems","issn_l":"0278-0070","issn":["0278-0070","1937-4151"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Computer-Aided Design of Integrated Circuits and Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G700390332","display_name":null,"funder_award_id":"61272103","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":58,"referenced_works":["https://openalex.org/W135447215","https://openalex.org/W179608396","https://openalex.org/W1172733195","https://openalex.org/W1478753081","https://openalex.org/W1533567700","https://openalex.org/W1599861493","https://openalex.org/W1785664926","https://openalex.org/W1934801153","https://openalex.org/W1940267184","https://openalex.org/W1981420413","https://openalex.org/W1985229168","https://openalex.org/W1987299420","https://openalex.org/W1987426261","https://openalex.org/W1993369399","https://openalex.org/W2019540883","https://openalex.org/W2026205964","https://openalex.org/W2026682066","https://openalex.org/W2035735180","https://openalex.org/W2050807719","https://openalex.org/W2068739275","https://openalex.org/W2075743842","https://openalex.org/W2077850713","https://openalex.org/W2098579796","https://openalex.org/W2102594690","https://openalex.org/W2110423232","https://openalex.org/W2116436884","https://openalex.org/W2125901106","https://openalex.org/W2129492214","https://openalex.org/W2132929952","https://openalex.org/W2135557119","https://openalex.org/W2135754559","https://openalex.org/W2138433591","https://openalex.org/W2149509741","https://openalex.org/W2265077477","https://openalex.org/W2295860325","https://openalex.org/W2324329793","https://openalex.org/W2342690825","https://openalex.org/W2342743900","https://openalex.org/W2489860691","https://openalex.org/W2532873393","https://openalex.org/W2585220027","https://openalex.org/W2588274597","https://openalex.org/W2605269223","https://openalex.org/W2613457965","https://openalex.org/W2998553639","https://openalex.org/W6605550973","https://openalex.org/W6607267220","https://openalex.org/W6627708365","https://openalex.org/W6628421564","https://openalex.org/W6637998620","https://openalex.org/W6640563032","https://openalex.org/W6640663727","https://openalex.org/W6657084543","https://openalex.org/W6680250025","https://openalex.org/W6697418491","https://openalex.org/W6722908262","https://openalex.org/W6736143371","https://openalex.org/W6983205581"],"related_works":["https://openalex.org/W2365800529","https://openalex.org/W2348772280","https://openalex.org/W1602178951","https://openalex.org/W2237659646","https://openalex.org/W2610252293","https://openalex.org/W1992246567","https://openalex.org/W2023492342","https://openalex.org/W2374954631","https://openalex.org/W139491433","https://openalex.org/W2365545255"],"abstract_inverted_index":{"SQLite":[0,33,67,72,154,203],"has":[1],"been":[2],"deployed":[3,186],"in":[4],"millions":[5],"of":[6,149],"mobile":[7,16],"devices":[8],"from":[9],"Web":[10],"to":[11,21,110,177,205],"smartphone":[12],"applications":[13,80],"on":[14,188],"various":[15,197],"operating":[17],"systems.":[18],"However,":[19],"due":[20],"the":[22,27,47,60,66,97,102,112,147,161,179],"uncoordinated":[23],"IO":[24],"interactions":[25],"with":[26,37,88,133,196],"underlying":[28],"file":[29],"system":[30],"(e.g.,":[31],"ext4),":[32],"is":[34],"not":[35],"efficient":[36],"low":[38],"transactions":[39],"per":[40],"second.":[41],"In":[42,101,160],"this":[43],"paper,":[44],"we":[45,104,163],"for":[46],"first":[48],"time":[49],"propose":[50,171],"a":[51,106,128,172,189],"new":[52],"SQLite-like":[53],"database":[54,168],"engine,":[55,169],"called":[56],"SQLiteKV,":[57],"which":[58],"adopts":[59],"LSM-tree-based":[61,90,166],"data":[62,91,150,158],"structure":[63],"but":[64],"retains":[65],"operation":[68],"interfaces.":[69],"With":[70],"its":[71,89],"interface,":[73],"SQLiteKV":[74,95,144,187,201],"can":[75,118,139],"be":[76,119,140],"utilized":[77],"by":[78,145],"existing":[79],"without":[81],"any":[82],"modification,":[83],"while":[84],"providing":[85],"high":[86],"performance":[87],"structure.":[92],"We":[93,125,182],"separate":[94],"into":[96,122],"front-end":[98,153],"and":[99,156,170,185],"back-end.":[100],"front-end,":[103],"develop":[105],"light-weight":[107],"SQLite-to-KV":[108],"compiler":[109],"solve":[111],"semantic":[113],"mismatch,":[114],"so":[115,136],"SQL":[116],"statements":[117,155],"efficiently":[120],"translated":[121],"KV":[123],"operations.":[124],"also":[126],"design":[127],"novel":[129],"coordination":[130],"caching":[131],"mechanism":[132],"memory":[134,180],"defragmentation":[135],"query":[137],"results":[138,195],"effectively":[141],"cached":[142],"inside":[143],"alleviating":[146],"discrepancy":[148],"management":[151,175],"between":[152],"back-end":[157],"organization.":[159],"back-end,":[162],"adopt":[164],"an":[165],"key-value":[167],"lightweight":[173],"metadata":[174],"scheme":[176],"mitigate":[178],"requirement.":[181],"have":[183],"implemented":[184],"Google":[190],"Nexus":[191],"6P":[192],"smartphone.":[193],"Experimental":[194],"workloads":[198],"show":[199],"that":[200],"outperforms":[202],"up":[204],"six":[206],"times.":[207]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}