{"id":"https://openalex.org/W3170874851","doi":"https://doi.org/10.1007/s00778-020-00643-4","title":"Tidy Tuples and Flying Start: fast compilation and fast execution of relational queries in Umbra","display_name":"Tidy Tuples and Flying Start: fast compilation and fast execution of relational queries in Umbra","publication_year":2021,"publication_date":"2021-06-02","ids":{"openalex":"https://openalex.org/W3170874851","doi":"https://doi.org/10.1007/s00778-020-00643-4","mag":"3170874851"},"language":"en","primary_location":{"id":"doi:10.1007/s00778-020-00643-4","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-020-00643-4","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-020-00643-4.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s00778-020-00643-4.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5053424313","display_name":"Timo Kersten","orcid":"https://orcid.org/0000-0002-0004-9686"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Timo Kersten","raw_affiliation_strings":["Technical University Munich, Arcisstr. 21, 80333, Munich, Germany"],"raw_orcid":"https://orcid.org/0000-0002-0004-9686","affiliations":[{"raw_affiliation_string":"Technical University Munich, Arcisstr. 21, 80333, Munich, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046213289","display_name":"Viktor Leis","orcid":"https://orcid.org/0000-0001-5676-8017"},"institutions":[{"id":"https://openalex.org/I76198965","display_name":"Friedrich Schiller University Jena","ror":"https://ror.org/05qpz1x62","country_code":"DE","type":"education","lineage":["https://openalex.org/I76198965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Viktor Leis","raw_affiliation_strings":["Friedrich Schiller University Jena, F\u00fcrstengraben 1, 07743, Jena, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Friedrich Schiller University Jena, F\u00fcrstengraben 1, 07743, Jena, Germany","institution_ids":["https://openalex.org/I76198965"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101880157","display_name":"Thomas Neumann","orcid":"https://orcid.org/0000-0001-5787-142X"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Thomas Neumann","raw_affiliation_strings":["Technical University Munich, Arcisstr. 21, 80333, Munich, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technical University Munich, Arcisstr. 21, 80333, Munich, Germany","institution_ids":["https://openalex.org/I62916508"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5053424313"],"corresponding_institution_ids":["https://openalex.org/I62916508"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":4.6464,"has_fulltext":true,"cited_by_count":33,"citation_normalized_percentile":{"value":0.9484127,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":99},"biblio":{"volume":"30","issue":"5","first_page":"883","last_page":"905"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991999864578247,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991999864578247,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9933000206947327,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9932000041007996,"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.8939197063446045},{"id":"https://openalex.org/keywords/compiler","display_name":"Compiler","score":0.6877199411392212},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6671842932701111},{"id":"https://openalex.org/keywords/code-generation","display_name":"Code generation","score":0.5587234497070312},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.5126146674156189},{"id":"https://openalex.org/keywords/bytecode","display_name":"Bytecode","score":0.5025010108947754},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.48541292548179626},{"id":"https://openalex.org/keywords/compile-time","display_name":"Compile time","score":0.46407368779182434},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.45258933305740356},{"id":"https://openalex.org/keywords/machine-code","display_name":"Machine code","score":0.4493730664253235},{"id":"https://openalex.org/keywords/just-in-time-compilation","display_name":"Just-in-time compilation","score":0.4203479290008545},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.36809974908828735},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.27137142419815063},{"id":"https://openalex.org/keywords/virtual-machine","display_name":"Virtual machine","score":0.15186619758605957},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.08806410431861877}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8939197063446045},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.6877199411392212},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6671842932701111},{"id":"https://openalex.org/C133162039","wikidata":"https://www.wikidata.org/wiki/Q1061077","display_name":"Code generation","level":3,"score":0.5587234497070312},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5126146674156189},{"id":"https://openalex.org/C2779818221","wikidata":"https://www.wikidata.org/wiki/Q837330","display_name":"Bytecode","level":3,"score":0.5025010108947754},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.48541292548179626},{"id":"https://openalex.org/C200833197","wikidata":"https://www.wikidata.org/wiki/Q333707","display_name":"Compile time","level":3,"score":0.46407368779182434},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.45258933305740356},{"id":"https://openalex.org/C115168132","wikidata":"https://www.wikidata.org/wiki/Q55813","display_name":"Machine code","level":3,"score":0.4493730664253235},{"id":"https://openalex.org/C76782552","wikidata":"https://www.wikidata.org/wiki/Q110546","display_name":"Just-in-time compilation","level":3,"score":0.4203479290008545},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.36809974908828735},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.27137142419815063},{"id":"https://openalex.org/C25344961","wikidata":"https://www.wikidata.org/wiki/Q192726","display_name":"Virtual machine","level":2,"score":0.15186619758605957},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.08806410431861877},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1007/s00778-020-00643-4","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-020-00643-4","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-020-00643-4.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},{"id":"pmh:oai:zenodo.org:5770190","is_oa":true,"landing_page_url":"https://zenodo.org/record/5770190","pdf_url":"https://zenodo.org/record/5770190","source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:mediatum.ub.tum.de:node/1638236","is_oa":true,"landing_page_url":"https://mediatum.ub.tum.de/1638236","pdf_url":null,"source":{"id":"https://openalex.org/S4377196330","display_name":"mediaTUM  (Technical University of Munich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I62916508","host_organization_name":"Technical University of Munich","host_organization_lineage":["https://openalex.org/I62916508"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"article"},{"id":"pmh:oai:www.db-thueringen.de:dbt_mods_00056318","is_oa":true,"landing_page_url":"https://nbn-resolving.org/urn:nbn:de:gbv:27-dbt-20230325-044311-003","pdf_url":null,"source":{"id":"https://openalex.org/S4306400120","display_name":"Common Library Network (Der Gemeinsame Bibliotheksverbund)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210149878","host_organization_name":"Verbundzentrale des GBV","host_organization_lineage":["https://openalex.org/I4210149878"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1007/s00778-020-00643-4","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-020-00643-4","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-020-00643-4.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.4300000071525574,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[{"id":"https://openalex.org/G8590641107","display_name":"The Computational Database for Real World Awareness","funder_award_id":"725286","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G899700953","display_name":"The Computational Database for Real World Awareness","funder_award_id":"725286","funder_id":"https://openalex.org/F4320338335","funder_display_name":"H2020 European Research Council"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"},{"id":"https://openalex.org/F4320338335","display_name":"H2020 European Research Council","ror":"https://ror.org/0472cxd90"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3170874851.pdf","grobid_xml":"https://content.openalex.org/works/W3170874851.grobid-xml"},"referenced_works_count":45,"referenced_works":["https://openalex.org/W1967091776","https://openalex.org/W1987238352","https://openalex.org/W2000504947","https://openalex.org/W2014977566","https://openalex.org/W2017351599","https://openalex.org/W2064514251","https://openalex.org/W2074489032","https://openalex.org/W2099035968","https://openalex.org/W2105079611","https://openalex.org/W2106771621","https://openalex.org/W2116094274","https://openalex.org/W2124851765","https://openalex.org/W2140191557","https://openalex.org/W2141706154","https://openalex.org/W2151892596","https://openalex.org/W2153185479","https://openalex.org/W2156000708","https://openalex.org/W2266823300","https://openalex.org/W2340838390","https://openalex.org/W2401029678","https://openalex.org/W2401974969","https://openalex.org/W2406543354","https://openalex.org/W2548100623","https://openalex.org/W2585388895","https://openalex.org/W2593976316","https://openalex.org/W2765206444","https://openalex.org/W2794632349","https://openalex.org/W2797202077","https://openalex.org/W2798416929","https://openalex.org/W2798607736","https://openalex.org/W2806056912","https://openalex.org/W2807799957","https://openalex.org/W2888177241","https://openalex.org/W2889073286","https://openalex.org/W2897173745","https://openalex.org/W2911811856","https://openalex.org/W2949054050","https://openalex.org/W2952451116","https://openalex.org/W2962773216","https://openalex.org/W2996811965","https://openalex.org/W3013316555","https://openalex.org/W3013816586","https://openalex.org/W3033677858","https://openalex.org/W3139669840","https://openalex.org/W4242572423"],"related_works":["https://openalex.org/W4243842509","https://openalex.org/W2003917319","https://openalex.org/W2087647198","https://openalex.org/W4232002707","https://openalex.org/W2011153745","https://openalex.org/W4245102070","https://openalex.org/W2099268876","https://openalex.org/W2133094499","https://openalex.org/W49417684","https://openalex.org/W3011728381"],"abstract_inverted_index":{"Abstract":[0],"Although":[1],"compiling":[2,68,229],"queries":[3],"to":[4,75,112,134,161,178,184],"efficient":[5],"machine":[6],"code":[7,37,89,106,117,137],"has":[8],"become":[9],"a":[10,16,45,85,93,105,119,126,144],"common":[11],"approach":[12],"for":[13,48,51,151],"query":[14,69,196],"execution,":[15],"number":[17],"of":[18,36,67,87],"newly":[19],"created":[20],"database":[21,175],"system":[22,176,230],"projects":[23],"still":[24],"refrain":[25],"from":[26,84],"using":[27],"compilation.":[28,140],"It":[29],"is":[30,56,149,182,203,223],"sometimes":[31],"claimed":[32],"that":[33,95,109,148,180],"the":[34,81,214,227],"intricacies":[35],"generation":[38,107,138],"make":[39],"compilation-based":[40],"engines":[41,71,208],"too":[42],"complex.":[43],"Also,":[44],"major":[46],"barrier":[47],"adoption,":[49],"especially":[50],"interactive":[52],"ad":[53],"hoc":[54],"queries,":[55],"long":[57],"compilation":[58,77,187],"time.":[59],"In":[60],"this":[61],"paper,":[62],"we":[63,103,124,142],"examine":[64],"all":[65],"stages":[66],"execution":[70,159],"and":[72,98,139,155,188,211],"show":[73,179],"how":[74],"reduce":[76],"overhead.":[78],"We":[79,169],"incorporate":[80],"lessons":[82],"learned":[83],"decade":[86],"generating":[88],"in":[90,118,173],"HyPer":[91],"into":[92],"design":[94],"manages":[96],"complexity":[97],"yields":[99,157],"high":[100],"speed.":[101],"First,":[102],"introduce":[104,143],"framework":[108],"establishes":[110],"abstractions":[111],"manage":[113],"complexity,":[114],"yet":[115],"generates":[116],"single":[120],"fast":[121,136,186,189],"pass.":[122],"Second,":[123],"present":[125],"program":[127],"representation":[128],"whose":[129],"data":[130,200,219],"structures":[131],"are":[132],"tuned":[133],"support":[135],"Third,":[141],"new":[145],"compiler":[146],"backend":[147],"optimized":[150],"minimal":[152],"compile":[153],"time,":[154,216],"simultaneously,":[156],"superior":[158],"performance":[160],"competing":[162],"approaches,":[163],"e.g.,":[164],"Volcano-style":[165],"or":[166],"bytecode":[167],"interpretation.":[168],"implemented":[170],"these":[171],"optimizations":[172],"our":[174],"Umbra":[177,192],"it":[181,202],"possible":[183],"unite":[185],"execution.":[190],"Indeed,":[191],"achieves":[193],"unprecedentedly":[194],"low":[195],"latencies.":[197],"On":[198],"small":[199],"sets,":[201,220],"even":[204],"faster":[205],"than":[206],"interpreter":[207],"like":[209],"DuckDB":[210],"PostgreSQL.":[212],"At":[213],"same":[215],"on":[217,224],"large":[218],"its":[221],"throughput":[222],"par":[225],"with":[226],"state-of-the-art":[228],"HyPer.":[231]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":9},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":8}],"updated_date":"2026-05-23T08:51:43.019350","created_date":"2025-10-10T00:00:00"}