{"id":"https://openalex.org/W3201007568","doi":"https://doi.org/10.26599/bdma.2021.9020009","title":"LotusSQL: SQL engine for high-performance big data systems","display_name":"LotusSQL: SQL engine for high-performance big data systems","publication_year":2021,"publication_date":"2021-08-26","ids":{"openalex":"https://openalex.org/W3201007568","doi":"https://doi.org/10.26599/bdma.2021.9020009","mag":"3201007568"},"language":"en","primary_location":{"id":"doi:10.26599/bdma.2021.9020009","is_oa":true,"landing_page_url":"https://doi.org/10.26599/bdma.2021.9020009","pdf_url":"https://ieeexplore.ieee.org/ielx7/8254253/9523493/09523499.pdf","source":{"id":"https://openalex.org/S4210209060","display_name":"Big Data Mining and Analytics","issn_l":"2096-0654","issn":["2096-0654"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311901","host_organization_name":"Tsinghua University Press","host_organization_lineage":["https://openalex.org/P4310311901"],"host_organization_lineage_names":["Tsinghua University Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data Mining and Analytics","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://ieeexplore.ieee.org/ielx7/8254253/9523493/09523499.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100644758","display_name":"Xiaohan Li","orcid":"https://orcid.org/0000-0003-3156-1989"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xiaohan Li","raw_affiliation_strings":["Department of Computer Science and Technology, Tsinghua University, China","Department of Computer Science and Technology, Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]},{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063948705","display_name":"Bowen Yu","orcid":"https://orcid.org/0000-0001-5537-8244"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bowen Yu","raw_affiliation_strings":["Department of Computer Science and Technology, Tsinghua University, China","Department of Computer Science and Technology, Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]},{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082732322","display_name":"Guanyu Feng","orcid":"https://orcid.org/0000-0002-7754-4693"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guanyu Feng","raw_affiliation_strings":["Department of Computer Science and Technology, Tsinghua University, China","Department of Computer Science and Technology, Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]},{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100735476","display_name":"Haojie Wang","orcid":"https://orcid.org/0000-0003-4605-148X"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haojie Wang","raw_affiliation_strings":["Department of Computer Science and Technology, Tsinghua University, China","Department of Computer Science and Technology, Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]},{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103141832","display_name":"Wenguang Chen","orcid":"https://orcid.org/0000-0002-4281-1018"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wenguang Chen","raw_affiliation_strings":["Department of Computer Science and Technology, Tsinghua University, China","Department of Computer Science and Technology, Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]},{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5100644758"],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":1.9279,"has_fulltext":true,"cited_by_count":8,"citation_normalized_percentile":{"value":0.88829579,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"4","issue":"4","first_page":"252","last_page":"265"},"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.9955000281333923,"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.9955000281333923,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9884999990463257,"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/T11106","display_name":"Data Management and Algorithms","score":0.9790999889373779,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.8775524497032166},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.7024694681167603},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6842386722564697},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.5772870779037476},{"id":"https://openalex.org/keywords/serialization","display_name":"Serialization","score":0.5377213358879089},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.495870441198349},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.4636562764644623},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4583752155303955},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.44253063201904297},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.43845245242118835},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4317706823348999},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4267958402633667},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4224204123020172},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.4218602180480957},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.41332799196243286},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.38405925035476685},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.21188926696777344},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.19342604279518127},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1328940987586975}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8775524497032166},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.7024694681167603},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6842386722564697},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.5772870779037476},{"id":"https://openalex.org/C52723943","wikidata":"https://www.wikidata.org/wiki/Q1127410","display_name":"Serialization","level":2,"score":0.5377213358879089},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.495870441198349},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.4636562764644623},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4583752155303955},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.44253063201904297},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.43845245242118835},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4317706823348999},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4267958402633667},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4224204123020172},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.4218602180480957},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.41332799196243286},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.38405925035476685},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21188926696777344},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.19342604279518127},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1328940987586975},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.26599/bdma.2021.9020009","is_oa":true,"landing_page_url":"https://doi.org/10.26599/bdma.2021.9020009","pdf_url":"https://ieeexplore.ieee.org/ielx7/8254253/9523493/09523499.pdf","source":{"id":"https://openalex.org/S4210209060","display_name":"Big Data Mining and Analytics","issn_l":"2096-0654","issn":["2096-0654"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311901","host_organization_name":"Tsinghua University Press","host_organization_lineage":["https://openalex.org/P4310311901"],"host_organization_lineage_names":["Tsinghua University Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data Mining and Analytics","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:cb6047f2b47644b58c926f8da2b81947","is_oa":true,"landing_page_url":"https://doaj.org/article/cb6047f2b47644b58c926f8da2b81947","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Big Data Mining and Analytics, Vol 4, Iss 4, Pp 252-265 (2021)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.26599/bdma.2021.9020009","is_oa":true,"landing_page_url":"https://doi.org/10.26599/bdma.2021.9020009","pdf_url":"https://ieeexplore.ieee.org/ielx7/8254253/9523493/09523499.pdf","source":{"id":"https://openalex.org/S4210209060","display_name":"Big Data Mining and Analytics","issn_l":"2096-0654","issn":["2096-0654"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311901","host_organization_name":"Tsinghua University Press","host_organization_lineage":["https://openalex.org/P4310311901"],"host_organization_lineage_names":["Tsinghua University Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data Mining and Analytics","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.5600000023841858,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3201007568.pdf","grobid_xml":"https://content.openalex.org/works/W3201007568.grobid-xml"},"referenced_works_count":17,"referenced_works":["https://openalex.org/W135863099","https://openalex.org/W1993892970","https://openalex.org/W2106771621","https://openalex.org/W2119738171","https://openalex.org/W2121810937","https://openalex.org/W2136195851","https://openalex.org/W2169724035","https://openalex.org/W2260553848","https://openalex.org/W2394680079","https://openalex.org/W2508838500","https://openalex.org/W2613579336","https://openalex.org/W2774053434","https://openalex.org/W2788561287","https://openalex.org/W2898896770","https://openalex.org/W2972135450","https://openalex.org/W4248659688","https://openalex.org/W4310651000"],"related_works":["https://openalex.org/W3209496184","https://openalex.org/W638381921","https://openalex.org/W2912795851","https://openalex.org/W2897196530","https://openalex.org/W2412047973","https://openalex.org/W2240099544","https://openalex.org/W1461606193","https://openalex.org/W2028703162","https://openalex.org/W2550810496","https://openalex.org/W3108275191"],"abstract_inverted_index":{"In":[0,104],"recent":[1],"years,":[2],"Apache":[3],"Spark":[4,25,48,194],"has":[5],"become":[6],"the":[7,45,55,91,98,144,150,157,175],"de":[8],"facto":[9],"standard":[10,198],"for":[11,21,116],"big":[12],"data":[13,34,57],"processing.":[14],"SparkSQL":[15,31,41],"is":[16],"a":[17,75,120,126,162,183,197],"module":[18],"offering":[19],"support":[20,115],"relational":[22],"analysis":[23],"on":[24,119,205],"with":[26,83,133,168,174],"Structured":[27],"Query":[28],"Language":[29],"(SQL).":[30],"provides":[32],"convenient":[33,127],"processing":[35,129],"interfaces.":[36],"Despite":[37],"its":[38],"efficient":[39],"optimizer,":[40],"still":[42],"suffers":[43],"from":[44,50,74],"inefficiency":[46],"of":[47,93,146,156,164,185],"resulting":[49],"Java":[51],"virtual":[52],"machine":[53],"and":[54,59,79,101,153,171,192],"unnecessary":[56],"serialization":[58],"deserialization.":[60],"Adopting":[61],"native":[62,94,121],"languages":[63,95],"such":[64,71],"as":[65],"C++":[66,84],"could":[67],"help":[68],"to":[69,112,131,142,187],"avoid":[70],"bottlenecks.":[72],"Benefiting":[73],"bare-metal":[76],"runtime":[77],"environment":[78],"template":[80],"usage,":[81],"systems":[82],"interfaces":[85],"usually":[86],"achieve":[87],"superior":[88],"performance.":[89],"However,":[90],"complexity":[92],"also":[96],"increases":[97],"required":[99],"programming":[100],"debugging":[102],"efforts.":[103],"this":[105],"work,":[106],"we":[107],"present":[108],"LotusSQL,":[109],"an":[110],"engine":[111],"provide":[113],"SQL":[114,128,195],"dataset":[117,166],"abstraction":[118],"backend":[122],"Lotus.":[123],"We":[124],"employ":[125],"framework":[130],"deal":[132],"frontend":[134],"jobs.":[135],"Advanced":[136],"query":[137,199],"optimization":[138],"technologies":[139],"are":[140],"added":[141],"improve":[143],"quality":[145],"execution":[147],"plans.":[148],"Above":[149],"storage":[151],"design":[152],"user":[154],"interface":[155],"compute":[158],"engine,":[159],"LotusSQL":[160,181],"implements":[161],"set":[163],"structured":[165],"operations":[167],"high":[169],"efficiency":[170],"integrates":[172],"them":[173],"frontend.":[176],"Evaluation":[177],"results":[178],"show":[179],"that":[180],"achieves":[182],"speedup":[184],"up":[186],"9\u00d7":[188],"in":[189,196],"certain":[190],"queries":[191],"outperforms":[193],"benchmark":[200],"by":[201],"more":[202],"than":[203],"2\u00d7":[204],"average.":[206]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}