{"id":"https://openalex.org/W4396601687","doi":"https://doi.org/10.14778/3648160.3648175","title":"POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance","display_name":"POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance","publication_year":2024,"publication_date":"2024-02-01","ids":{"openalex":"https://openalex.org/W4396601687","doi":"https://doi.org/10.14778/3648160.3648175"},"language":"en","primary_location":{"id":"doi:10.14778/3648160.3648175","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3648160.3648175","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/A5096327283","display_name":"David Justen","orcid":null},"institutions":[{"id":"https://openalex.org/I4577782","display_name":"Technische Universit\u00e4t Berlin","ror":"https://ror.org/03v4gjf40","country_code":"DE","type":"education","lineage":["https://openalex.org/I4577782"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"David Justen","raw_affiliation_strings":["TU Berlin"],"affiliations":[{"raw_affiliation_string":"TU Berlin","institution_ids":["https://openalex.org/I4577782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072651266","display_name":"Daniel P. Ritter","orcid":"https://orcid.org/0009-0009-3266-9917"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Daniel Ritter","raw_affiliation_strings":["SAP"],"affiliations":[{"raw_affiliation_string":"SAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023294162","display_name":"Campbell Fraser","orcid":"https://orcid.org/0009-0005-2035-4409"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Campbell Fraser","raw_affiliation_strings":["Google"],"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072722765","display_name":"Andrew Lamb","orcid":"https://orcid.org/0009-0004-5687-5276"},"institutions":[{"id":"https://openalex.org/I4210137206","display_name":"Influx (United States)","ror":"https://ror.org/041yzwn62","country_code":"US","type":"company","lineage":["https://openalex.org/I4210137206"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andrew Lamb","raw_affiliation_strings":["Nga Tran, InfluxData"],"affiliations":[{"raw_affiliation_string":"Nga Tran, InfluxData","institution_ids":["https://openalex.org/I4210137206"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003788481","display_name":"Allison Lee","orcid":"https://orcid.org/0000-0002-1385-1512"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Allison Lee","raw_affiliation_strings":["Snowflake"],"affiliations":[{"raw_affiliation_string":"Snowflake","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007681905","display_name":"Thomas Bodner","orcid":"https://orcid.org/0000-0002-7822-2098"},"institutions":[{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]},{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Thomas Bodner","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam"],"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109712018","display_name":"Mhd Yamen Haddad","orcid":null},"institutions":[{"id":"https://openalex.org/I142476485","display_name":"\u00c9cole Polytechnique","ror":"https://ror.org/05hy3tk52","country_code":"FR","type":"education","lineage":["https://openalex.org/I142476485","https://openalex.org/I4210145102"]},{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en informatique et en automatique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1326498283"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Mhd Yamen Haddad","raw_affiliation_strings":["INRIA, Ecole Polytechnique"],"affiliations":[{"raw_affiliation_string":"INRIA, Ecole Polytechnique","institution_ids":["https://openalex.org/I142476485","https://openalex.org/I1326498283"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051995830","display_name":"Steffen Zeuch","orcid":"https://orcid.org/0000-0002-4082-7788"},"institutions":[{"id":"https://openalex.org/I4577782","display_name":"Technische Universit\u00e4t Berlin","ror":"https://ror.org/03v4gjf40","country_code":"DE","type":"education","lineage":["https://openalex.org/I4577782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Steffen Zeuch","raw_affiliation_strings":["TU Berlin"],"affiliations":[{"raw_affiliation_string":"TU Berlin","institution_ids":["https://openalex.org/I4577782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002413906","display_name":"Volker Markl","orcid":"https://orcid.org/0009-0009-0964-026X"},"institutions":[{"id":"https://openalex.org/I4577782","display_name":"Technische Universit\u00e4t Berlin","ror":"https://ror.org/03v4gjf40","country_code":"DE","type":"education","lineage":["https://openalex.org/I4577782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Volker Markl","raw_affiliation_strings":["TU Berlin"],"affiliations":[{"raw_affiliation_string":"TU Berlin","institution_ids":["https://openalex.org/I4577782"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5053153176","display_name":"Matthias B\u00f6ehm","orcid":"https://orcid.org/0000-0003-1344-3663"},"institutions":[{"id":"https://openalex.org/I4577782","display_name":"Technische Universit\u00e4t Berlin","ror":"https://ror.org/03v4gjf40","country_code":"DE","type":"education","lineage":["https://openalex.org/I4577782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Matthias Boehm","raw_affiliation_strings":["TU Berlin"],"affiliations":[{"raw_affiliation_string":"TU Berlin","institution_ids":["https://openalex.org/I4577782"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":10,"corresponding_author_ids":["https://openalex.org/A5096327283"],"corresponding_institution_ids":["https://openalex.org/I4577782"],"apc_list":null,"apc_paid":null,"fwci":3.2474,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.92584176,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"17","issue":"6","first_page":"1350","last_page":"1363"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9945999979972839,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9945999979972839,"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.9939000010490417,"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/T10908","display_name":"Analytical Chemistry and Chromatography","score":0.9743000268936157,"subfield":{"id":"https://openalex.org/subfields/1607","display_name":"Spectroscopy"},"field":{"id":"https://openalex.org/fields/16","display_name":"Chemistry"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7237396240234375},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6842790842056274},{"id":"https://openalex.org/keywords/resistance","display_name":"Resistance (ecology)","score":0.589026927947998},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.5547178387641907},{"id":"https://openalex.org/keywords/polar","display_name":"Polar","score":0.5135281682014465},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.46526503562927246},{"id":"https://openalex.org/keywords/nonlinear-system","display_name":"Nonlinear system","score":0.41802671551704407},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.2536141872406006},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.23164615035057068},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.22872650623321533},{"id":"https://openalex.org/keywords/physics","display_name":"Physics","score":0.1520344316959381},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.1382119357585907},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.09263172745704651},{"id":"https://openalex.org/keywords/ecology","display_name":"Ecology","score":0.08748307824134827}],"concepts":[{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7237396240234375},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6842790842056274},{"id":"https://openalex.org/C57473165","wikidata":"https://www.wikidata.org/wiki/Q7315604","display_name":"Resistance (ecology)","level":2,"score":0.589026927947998},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.5547178387641907},{"id":"https://openalex.org/C29705727","wikidata":"https://www.wikidata.org/wiki/Q294562","display_name":"Polar","level":2,"score":0.5135281682014465},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.46526503562927246},{"id":"https://openalex.org/C158622935","wikidata":"https://www.wikidata.org/wiki/Q660848","display_name":"Nonlinear system","level":2,"score":0.41802671551704407},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.2536141872406006},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.23164615035057068},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.22872650623321533},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.1520344316959381},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.1382119357585907},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.09263172745704651},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.08748307824134827},{"id":"https://openalex.org/C1276947","wikidata":"https://www.wikidata.org/wiki/Q333","display_name":"Astronomy","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3648160.3648175","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3648160.3648175","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":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":81,"referenced_works":["https://openalex.org/W247055860","https://openalex.org/W1510252230","https://openalex.org/W1967091776","https://openalex.org/W1975731516","https://openalex.org/W1976821017","https://openalex.org/W1992363839","https://openalex.org/W1992560344","https://openalex.org/W2005142245","https://openalex.org/W2005294557","https://openalex.org/W2007069074","https://openalex.org/W2008503861","https://openalex.org/W2019270771","https://openalex.org/W2029036662","https://openalex.org/W2036971997","https://openalex.org/W2041563709","https://openalex.org/W2060091058","https://openalex.org/W2079891094","https://openalex.org/W2093334386","https://openalex.org/W2097363087","https://openalex.org/W2098082683","https://openalex.org/W2101207848","https://openalex.org/W2102489964","https://openalex.org/W2115613157","https://openalex.org/W2121523964","https://openalex.org/W2121810937","https://openalex.org/W2125484876","https://openalex.org/W2126422268","https://openalex.org/W2130622824","https://openalex.org/W2132823934","https://openalex.org/W2138793904","https://openalex.org/W2139422440","https://openalex.org/W2143452574","https://openalex.org/W2149576945","https://openalex.org/W2153180521","https://openalex.org/W2153329411","https://openalex.org/W2154921032","https://openalex.org/W2155970976","https://openalex.org/W2158679027","https://openalex.org/W2160149182","https://openalex.org/W2164645353","https://openalex.org/W2247317079","https://openalex.org/W2272535669","https://openalex.org/W2275199784","https://openalex.org/W2395323716","https://openalex.org/W2396309311","https://openalex.org/W2430301697","https://openalex.org/W2547123334","https://openalex.org/W2613226836","https://openalex.org/W2622443349","https://openalex.org/W2783485345","https://openalex.org/W2889503624","https://openalex.org/W2949054050","https://openalex.org/W2955798121","https://openalex.org/W2962771342","https://openalex.org/W2963999972","https://openalex.org/W2970148517","https://openalex.org/W2991530444","https://openalex.org/W3028610005","https://openalex.org/W3030542966","https://openalex.org/W3085443750","https://openalex.org/W3099273181","https://openalex.org/W3100925961","https://openalex.org/W3124277639","https://openalex.org/W3176153696","https://openalex.org/W3177390287","https://openalex.org/W3203329898","https://openalex.org/W4205803619","https://openalex.org/W4206606839","https://openalex.org/W4232534713","https://openalex.org/W4233762723","https://openalex.org/W4237407586","https://openalex.org/W4313138291","https://openalex.org/W4321448315","https://openalex.org/W4361194359","https://openalex.org/W4380433183","https://openalex.org/W4380668112","https://openalex.org/W4386128208","https://openalex.org/W4412227024","https://openalex.org/W4412284929","https://openalex.org/W6892109440","https://openalex.org/W6944437697"],"related_works":["https://openalex.org/W4205996836","https://openalex.org/W2151692181","https://openalex.org/W4392498349","https://openalex.org/W2093960938","https://openalex.org/W3214148052","https://openalex.org/W4392216655","https://openalex.org/W2807741550","https://openalex.org/W794462722","https://openalex.org/W2029625042","https://openalex.org/W4256664196"],"abstract_inverted_index":{"Join":[0],"ordering":[1],"and":[2,45,75,77,81,133,139,160,181],"query":[3,8,20,40],"optimization":[4],"are":[5],"crucial":[6],"for":[7,23,38,107,186],"performance":[9,93],"but":[10],"remain":[11],"challenging":[12],"due":[13],"to":[14,50,91,131,179,197],"unknown":[15],"or":[16],"changing":[17],"characteristics":[18],"of":[19,36,111,136,144,163,177],"intermediates,":[21],"especially":[22],"complex":[24],"queries":[25],"with":[26,115,123,168],"many":[27],"joins.":[28],"Over":[29],"the":[30,69,142],"past":[31],"two":[32],"decades,":[33],"a":[34,101,108,161,169],"spectrum":[35],"techniques":[37,65],"adaptive":[39],"processing":[41],"(AQP)---including":[42],"inter-/intra-operator":[43],"adaptivity":[44],"tuple":[46,129,145],"routing---have":[47],"been":[48],"proposed":[49],"address":[51],"these":[52,148],"challenges.":[53],"However,":[54],"commercial":[55],"database":[56],"systems":[57,194],"in":[58,172],"practice":[59],"do":[60],"not":[61],"implement":[62],"holistic":[63],"AQP":[64,193],"because":[66],"they":[67],"increase":[68],"system":[70],"complexity":[71],"(e.g.,":[72],"intertwined":[73],"planning":[74],"execution)":[76],"thus,":[78],"complicate":[79],"debugging":[80],"testing.":[82],"Additionally,":[83],"existing":[84],"approaches":[85],"may":[86],"incur":[87],"large":[88],"overheads,":[89],"leading":[90],"problematic":[92],"regressions.":[94],"In":[95],"this":[96],"paper,":[97],"we":[98],"introduce":[99],"POLAR,":[100],"simple":[102],"yet":[103],"very":[104],"effective":[105],"technique":[106],"self-regulating":[109],"selection":[110,155],"alternative":[112,124],"join":[113,121,125,153],"orderings":[114],"bounded":[116],"overhead.":[117],"We":[118,150],"enhance":[119],"left-deep":[120],"pipelines":[122],"orders,":[126],"perform":[127],"regret-bounded":[128],"routing":[130,158],"find":[132],"validate":[134],"\"plans":[135],"least":[137],"resistance\",":[138],"then":[140],"process":[141],"majority":[143],"batches":[146],"through":[147],"plans.":[149],"study":[151],"different":[152,157],"order":[154],"techniques,":[156],"strategies,":[159],"variety":[162],"workload":[164],"characteristics.":[165],"Our":[166],"experiments":[167],"POLAR":[170],"prototype":[171],"DuckDB":[173],"show":[174],"runtime":[175],"improvements":[176],"up":[178,196],"9x":[180],"less":[182],"than":[183],"7%":[184],"overhead":[185],"all":[187],"benchmark":[188],"queries,":[189],"while":[190],"outperforming":[191],"state-of-the-art":[192],"by":[195],"15x.":[198]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}