{"id":"https://openalex.org/W3174134120","doi":"https://doi.org/10.1145/3448016.3457288","title":"Building Advanced SQL Analytics From Low-Level Plan Operators","display_name":"Building Advanced SQL Analytics From Low-Level Plan Operators","publication_year":2021,"publication_date":"2021-06-09","ids":{"openalex":"https://openalex.org/W3174134120","doi":"https://doi.org/10.1145/3448016.3457288","mag":"3174134120"},"language":"en","primary_location":{"id":"doi:10.1145/3448016.3457288","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3448016.3457288","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-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/A5074757063","display_name":"Andr\u00e9 Kohn","orcid":null},"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":"Andr\u00e9 Kohn","raw_affiliation_strings":["Technische Universit\u00e4t M\u00fcnchen, 80333 M\u00fcnchen, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen, 80333 M\u00fcnchen, 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-Universit\u00e4t Jena, Jena, Germany"],"affiliations":[{"raw_affiliation_string":"Friedrich-Schiller-Universit\u00e4t Jena, 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":["Technische Universit\u00e4t M\u00fcnchen, 80333 M\u00fcnchen, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen, 80333 M\u00fcnchen, Germany","institution_ids":["https://openalex.org/I62916508"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5074757063"],"corresponding_institution_ids":["https://openalex.org/I62916508"],"apc_list":null,"apc_paid":null,"fwci":1.6008,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.84098346,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1001","last_page":"1013"},"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.9998999834060669,"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.9998999834060669,"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.9993000030517578,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9901000261306763,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8150070309638977},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6919630169868469},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.62876296043396},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.5710350871086121},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.5578504800796509},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.4981498718261719},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.45408371090888977},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.4278390407562256},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.4242990016937256},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3807661533355713},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35393834114074707},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34247148036956787},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3157159984111786},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23937836289405823},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1447165310382843},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.10221728682518005}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8150070309638977},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6919630169868469},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.62876296043396},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.5710350871086121},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.5578504800796509},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4981498718261719},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.45408371090888977},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.4278390407562256},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.4242990016937256},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3807661533355713},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35393834114074707},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34247148036956787},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3157159984111786},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23937836289405823},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1447165310382843},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.10221728682518005},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","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/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"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/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3448016.3457288","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3448016.3457288","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3815905970","display_name":null,"funder_award_id":"725286","funder_id":"https://openalex.org/F4320334678","funder_display_name":"European Research Council"},{"id":"https://openalex.org/G4956428346","display_name":null,"funder_award_id":"Horizon 2020 research and innovatio","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G5036817778","display_name":null,"funder_award_id":"European Union's Horizon 2020 research and innov","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G5399556803","display_name":null,"funder_award_id":"This project has received funding from the Europea","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G8318064016","display_name":null,"funder_award_id":"Horizon","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"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/G8633428685","display_name":null,"funder_award_id":"European Union's Horizon 2020 research and innovat","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"},{"id":"https://openalex.org/F4320334678","display_name":"European Research Council","ror":"https://ror.org/0472cxd90"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W42901544","https://openalex.org/W1701312224","https://openalex.org/W1967601791","https://openalex.org/W1995302096","https://openalex.org/W2003515726","https://openalex.org/W2014332937","https://openalex.org/W2021651899","https://openalex.org/W2033368934","https://openalex.org/W2067089961","https://openalex.org/W2072541977","https://openalex.org/W2097880677","https://openalex.org/W2099035968","https://openalex.org/W2103201239","https://openalex.org/W2106771621","https://openalex.org/W2110839100","https://openalex.org/W2146620757","https://openalex.org/W2152149667","https://openalex.org/W2153329411","https://openalex.org/W2166955231","https://openalex.org/W2260671045","https://openalex.org/W2292693431","https://openalex.org/W2339303436","https://openalex.org/W2396309311","https://openalex.org/W2401974969","https://openalex.org/W2419855244","https://openalex.org/W2440477515","https://openalex.org/W2542351397","https://openalex.org/W2548100623","https://openalex.org/W2752640170","https://openalex.org/W2912064140","https://openalex.org/W3013316555","https://openalex.org/W3013725215","https://openalex.org/W3094660140","https://openalex.org/W3170874851","https://openalex.org/W3176391989","https://openalex.org/W4230983477"],"related_works":["https://openalex.org/W2120447654","https://openalex.org/W2977179488","https://openalex.org/W2144453115","https://openalex.org/W2128223750","https://openalex.org/W4238532390","https://openalex.org/W4379390408","https://openalex.org/W4382704603","https://openalex.org/W3006296337","https://openalex.org/W2026893489","https://openalex.org/W4312382508"],"abstract_inverted_index":{"Analytical":[0],"queries":[1],"virtually":[2],"always":[3],"involve":[4],"aggregation":[5,64],"and":[6,28,66,82,101],"statistics.":[7],"SQL":[8,48],"offers":[9],"a":[10,36],"wide":[11],"range":[12],"of":[13,46],"functionalities":[14],"to":[15],"summarize":[16],"data":[17],"such":[18],"as":[19],"associative":[20],"aggregates,":[21,23,25],"distinct":[22],"ordered-set":[24],"grouping":[26],"sets,":[27],"window":[29],"functions.":[30],"In":[31],"this":[32],"work,":[33],"we":[34,105],"propose":[35],"unified":[37],"framework":[38,78],"for":[39],"advanced":[40],"statistics":[41],"that":[42,104],"composes":[43],"all":[44],"flavors":[45],"complex":[47,69,107],"aggregates":[49,88,108],"from":[50],"low-level":[51],"plan":[52],"operators.":[53],"These":[54],"operators":[55],"can":[56],"reuse":[57],"materialized":[58],"intermediate":[59],"results,":[60],"which":[61],"decouples":[62],"monolithic":[63],"logic":[65],"speeds":[67],"up":[68],"multi-expression":[70],"queries.":[71],"The":[72],"contribution":[73],"is":[74],"therefore":[75],"twofold:":[76],"our":[77,93],"modularizes":[79],"aggregate":[80],"implementations,":[81],"outperforms":[83],"traditional":[84],"systems":[85],"whenever":[86],"multiple":[87],"are":[89],"combined.":[90],"We":[91],"integrated":[92],"approach":[94],"into":[95],"the":[96,111],"high-performance":[97],"database":[98],"system":[99],"Umbra":[100],"experimentally":[102],"show":[103],"compute":[106],"faster":[109],"than":[110],"state-of-the-art":[112],"HyPer":[113],"system.":[114]},"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":3},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":1}],"updated_date":"2026-04-13T07:58:08.660418","created_date":"2025-10-10T00:00:00"}