{"id":"https://openalex.org/W4312924702","doi":"https://doi.org/10.14778/3554821.3554842","title":"SQLite","display_name":"SQLite","publication_year":2022,"publication_date":"2022-08-01","ids":{"openalex":"https://openalex.org/W4312924702","doi":"https://doi.org/10.14778/3554821.3554842"},"language":"en","primary_location":{"id":"doi:10.14778/3554821.3554842","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3554821.3554842","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/A5055306573","display_name":"Kevin P. Gaffney","orcid":null},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Kevin P. Gaffney","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021820528","display_name":"Martin Prammer","orcid":"https://orcid.org/0009-0000-4348-236X"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Martin Prammer","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084064875","display_name":"Larry Brasfield","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Larry Brasfield","raw_affiliation_strings":["SQLite"],"affiliations":[{"raw_affiliation_string":"SQLite","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010740983","display_name":"D. Richard Hipp","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"D. Richard Hipp","raw_affiliation_strings":["SQLite"],"affiliations":[{"raw_affiliation_string":"SQLite","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112436847","display_name":"Dan W. Kennedy","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dan Kennedy","raw_affiliation_strings":["SQLite"],"affiliations":[{"raw_affiliation_string":"SQLite","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jignesh M. Patel","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5055306573"],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":19.0896,"has_fulltext":false,"cited_by_count":66,"citation_normalized_percentile":{"value":0.9937256,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"15","issue":"12","first_page":"3535","last_page":"3547"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9977999925613403,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9958000183105469,"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/online-analytical-processing","display_name":"Online analytical processing","score":0.8031076192855835},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7784658074378967},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.740847647190094},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.5516796112060547},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.519627034664154},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4944639205932617},{"id":"https://openalex.org/keywords/remote-direct-memory-access","display_name":"Remote direct memory access","score":0.49163347482681274},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.4604417085647583},{"id":"https://openalex.org/keywords/suite","display_name":"Suite","score":0.45396173000335693},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.44584548473358154},{"id":"https://openalex.org/keywords/enhanced-data-rates-for-gsm-evolution","display_name":"Enhanced Data Rates for GSM Evolution","score":0.44155213236808777},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.3920840322971344},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.3020172119140625},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.1766398549079895}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8031076192855835},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7784658074378967},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.740847647190094},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.5516796112060547},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.519627034664154},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4944639205932617},{"id":"https://openalex.org/C130795937","wikidata":"https://www.wikidata.org/wiki/Q2561570","display_name":"Remote direct memory access","level":2,"score":0.49163347482681274},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4604417085647583},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.45396173000335693},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.44584548473358154},{"id":"https://openalex.org/C162307627","wikidata":"https://www.wikidata.org/wiki/Q204833","display_name":"Enhanced Data Rates for GSM Evolution","level":2,"score":0.44155213236808777},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.3920840322971344},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.3020172119140625},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.1766398549079895},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3554821.3554842","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3554821.3554842","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":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.49000000953674316}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1521148341","https://openalex.org/W1527457771","https://openalex.org/W1969877208","https://openalex.org/W2067883080","https://openalex.org/W2069944651","https://openalex.org/W2110816960","https://openalex.org/W2123845384","https://openalex.org/W2292693431","https://openalex.org/W2342249984","https://openalex.org/W2416799949","https://openalex.org/W2613226836","https://openalex.org/W2794610196","https://openalex.org/W2949054050","https://openalex.org/W3013136440","https://openalex.org/W3028610005"],"related_works":["https://openalex.org/W2804682780","https://openalex.org/W2102729946","https://openalex.org/W3166336118","https://openalex.org/W2188262136","https://openalex.org/W2997368697","https://openalex.org/W2382554682","https://openalex.org/W4235259909","https://openalex.org/W871343079","https://openalex.org/W3093617208","https://openalex.org/W2937922288"],"abstract_inverted_index":{"In":[0,152],"the":[1,11,81,159,176,185,241],"two":[2],"decades":[3],"following":[4],"its":[5,39,42,172],"initial":[6],"release,":[7],"SQLite":[8,20,60,107,130,157,169,189,229],"has":[9,110,119],"become":[10],"most":[12],"widely":[13],"deployed":[14],"database":[15,103,178],"engine":[16,104,179],"in":[17,23,158],"existence.":[18],"Today,":[19],"is":[21,61,90,127,181,230],"found":[22],"nearly":[24],"every":[25],"smartphone,":[26],"computer,":[27],"web":[28],"browser,":[29],"television,":[30],"and":[31,50,73,86,205,219,254],"automobile.":[32],"Several":[33],"factors":[34],"are":[35,134],"likely":[36],"responsible":[37],"for":[38,64,94,108,145],"ubiquity,":[40],"including":[41,202],"in-process":[43,96,199],"design,":[44],"standalone":[45],"codebase,":[46],"extensive":[47],"test":[48],"suite,":[49],"cross-platform":[51],"file":[52],"format.":[53,77],"While":[54,117],"it":[55,126,180,247],"supports":[56],"complex":[57],"analytical":[58,98,211],"queries,":[59],"primarily":[62],"designed":[63],"fast":[65],"online":[66,97],"transaction":[67],"processing":[68,99,213],"(OLTP),":[69],"employing":[70],"row-oriented":[71],"execution":[72],"a":[74,91,102,195,224],"B-tree":[75],"storage":[76],"However,":[78],"fueled":[79],"by":[80],"rise":[82],"of":[83,136,161,187,198,226,243],"edge":[84],"computing":[85],"data":[87,200,212],"science,":[88],"there":[89],"growing":[92],"need":[93],"efficient":[95],"(OLAP).":[100],"DuckDB,":[101],"nicknamed":[105],"\"the":[106],"analytics\",":[109],"recently":[111],"emerged":[112],"to":[113,141,175,233,250],"meet":[114,251],"this":[115,153,162],"demand.":[116],"DuckDB":[118],"shown":[120],"strong":[121],"performance":[122,147,186],"on":[123,149,190,214,236],"OLAP":[124,150],"benchmarks,":[125,192],"unclear":[128],"how":[129,168,246],"compares.":[131],"Furthermore,":[132],"we":[133,155,239],"aware":[135],"no":[137],"work":[138],"that":[139],"attempts":[140],"identify":[142],"root":[143],"causes":[144],"SQLite's":[146],"behavior":[148],"workloads.":[151],"paper,":[154],"discuss":[156,240],"context":[160],"changing":[163],"workload":[164],"landscape.":[165],"We":[166,183,208],"describe":[167],"evolved":[170],"from":[171],"humble":[173],"beginnings":[174],"full-featured":[177],"today.":[182],"evaluate":[184],"modern":[188],"three":[191],"each":[193],"representing":[194],"different":[196],"flavor":[197],"management,":[201],"transactional,":[203],"analytical,":[204],"blob":[206],"processing.":[207],"delve":[209],"into":[210],"SQLite,":[215,244],"identifying":[216],"key":[217],"bottlenecks":[218],"weighing":[220],"potential":[221],"solutions.":[222],"As":[223],"result":[225],"our":[227],"optimizations,":[228],"now":[231],"up":[232],"4.2X":[234],"faster":[235],"SSB.":[237],"Finally,":[238],"future":[242],"envisioning":[245],"will":[248],"evolve":[249],"new":[252],"demands":[253],"challenges.":[255]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":28},{"year":2024,"cited_by_count":25},{"year":2023,"cited_by_count":10}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2023-01-05T00:00:00"}