{"id":"https://openalex.org/W4411403519","doi":"https://doi.org/10.1145/3725283","title":"Debunking the Myth of Join Ordering: Toward Robust SQL Analytics","display_name":"Debunking the Myth of Join Ordering: Toward Robust SQL Analytics","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4411403519","doi":"https://doi.org/10.1145/3725283"},"language":"en","primary_location":{"id":"doi:10.1145/3725283","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3725283","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1145/3725283","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101603454","display_name":"Junyi Zhao","orcid":"https://orcid.org/0009-0001-1799-1985"},"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":"Junyi Zhao","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041537964","display_name":"Kai Su","orcid":"https://orcid.org/0009-0003-7622-7201"},"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":"Kai Su","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030820902","display_name":"Yifei Yang","orcid":"https://orcid.org/0000-0002-7481-1979"},"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":"Yifei Yang","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, USA"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100734491","display_name":"Xiangyao Yu","orcid":"https://orcid.org/0009-0001-0785-2519"},"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":"Xiangyao Yu","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, USA"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040506752","display_name":"Paraschos Koutris","orcid":"https://orcid.org/0000-0001-6309-1702"},"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":"Paraschos Koutris","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, USA"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048293406","display_name":"Huanchen Zhang","orcid":"https://orcid.org/0009-0001-4821-1558"},"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":"Huanchen Zhang","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5101603454"],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":7.7289,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.97221397,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"3","issue":"3","first_page":"1","last_page":"28"},"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.9994000196456909,"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.9994000196456909,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9876000285148621,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.7570754289627075},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6982850432395935},{"id":"https://openalex.org/keywords/robustness","display_name":"Robustness (evolution)","score":0.624273419380188},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6233909726142883},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.47448328137397766},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.46922218799591064},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.46401533484458923},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3890259861946106},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.36706531047821045},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3120986819267273},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.19701051712036133},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1537783443927765},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.0808764100074768}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7570754289627075},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6982850432395935},{"id":"https://openalex.org/C63479239","wikidata":"https://www.wikidata.org/wiki/Q7353546","display_name":"Robustness (evolution)","level":3,"score":0.624273419380188},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6233909726142883},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.47448328137397766},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.46922218799591064},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.46401533484458923},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3890259861946106},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.36706531047821045},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3120986819267273},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19701051712036133},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1537783443927765},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0808764100074768},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3725283","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3725283","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3725283","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3725283","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":85,"referenced_works":["https://openalex.org/W291029741","https://openalex.org/W1536741282","https://openalex.org/W1808497822","https://openalex.org/W1971963766","https://openalex.org/W1973898816","https://openalex.org/W1975731516","https://openalex.org/W2007069074","https://openalex.org/W2008865455","https://openalex.org/W2021651899","https://openalex.org/W2026966899","https://openalex.org/W2029448190","https://openalex.org/W2035463408","https://openalex.org/W2041563709","https://openalex.org/W2050882124","https://openalex.org/W2074013691","https://openalex.org/W2076138883","https://openalex.org/W2125484876","https://openalex.org/W2143452574","https://openalex.org/W2153180521","https://openalex.org/W2153329411","https://openalex.org/W2153485419","https://openalex.org/W2154921032","https://openalex.org/W2159738186","https://openalex.org/W2161956202","https://openalex.org/W2169998163","https://openalex.org/W2171361281","https://openalex.org/W2176659866","https://openalex.org/W2199153319","https://openalex.org/W2340222647","https://openalex.org/W2396309311","https://openalex.org/W2585424461","https://openalex.org/W2613226836","https://openalex.org/W2786851308","https://openalex.org/W2790840297","https://openalex.org/W2794997248","https://openalex.org/W2888876958","https://openalex.org/W2890276152","https://openalex.org/W2906910993","https://openalex.org/W2915063781","https://openalex.org/W2922302645","https://openalex.org/W2942141510","https://openalex.org/W2949054050","https://openalex.org/W2949595278","https://openalex.org/W2952585724","https://openalex.org/W2952873958","https://openalex.org/W2955798121","https://openalex.org/W2962945867","https://openalex.org/W2970204999","https://openalex.org/W2991530444","https://openalex.org/W3030994385","https://openalex.org/W3094660140","https://openalex.org/W3100077023","https://openalex.org/W3102944959","https://openalex.org/W3111141572","https://openalex.org/W3116457585","https://openalex.org/W3119448165","https://openalex.org/W3173622057","https://openalex.org/W3183953540","https://openalex.org/W3198024709","https://openalex.org/W4233762723","https://openalex.org/W4245831780","https://openalex.org/W4251334431","https://openalex.org/W4251445346","https://openalex.org/W4292957491","https://openalex.org/W4318347883","https://openalex.org/W4375956844","https://openalex.org/W4384344690","https://openalex.org/W4384347374","https://openalex.org/W4385436451","https://openalex.org/W4391591855","https://openalex.org/W4396601687","https://openalex.org/W4396892722","https://openalex.org/W4399163950","https://openalex.org/W4402042382","https://openalex.org/W4407355492","https://openalex.org/W4407696038","https://openalex.org/W4409966620","https://openalex.org/W4411403270","https://openalex.org/W4411403519","https://openalex.org/W6633642779","https://openalex.org/W6679742010","https://openalex.org/W6769112791","https://openalex.org/W6779929467","https://openalex.org/W6862360952","https://openalex.org/W7060931793"],"related_works":["https://openalex.org/W2556786504","https://openalex.org/W2152149667","https://openalex.org/W4244527061","https://openalex.org/W2469357693","https://openalex.org/W3125756434","https://openalex.org/W1977383094","https://openalex.org/W2572349046","https://openalex.org/W1779612025","https://openalex.org/W2413368787","https://openalex.org/W1515213763"],"abstract_inverted_index":{"Join":[0],"order":[1],"optimization":[2],"is":[3,82,156,161],"critical":[4],"in":[5,110],"achieving":[6],"good":[7],"query":[8,17,37,48,155,176],"performance.":[9,49],"Despite":[10],"decades":[11],"of":[12,28,64,89,128,147],"research":[13,34],"and":[14,72,74,104,114,142],"practice,":[15],"modern":[16],"optimizers":[18],"could":[19],"still":[20],"generate":[21],"inferior":[22],"join":[23,87,149,194],"plans":[24],"that":[25,81,121,185],"are":[26],"orders":[27,88,127,150],"magnitude":[29,129],"slower":[30],"than":[31],"optimal.":[32],"Existing":[33],"on":[35,43,190],"robust":[36,84],"processing":[38],"often":[39],"lacks":[40],"theoretical":[41],"guarantees":[42],"join-order":[44,124],"robustness":[45,62,125],"while":[46],"sacrificing":[47],"In":[50],"this":[51,186],"paper,":[52],"we":[53],"rediscover":[54],"the":[55,108,132,136,140,174,192],"recent":[56],"Predicate":[57,78,96],"Transfer":[58,79,97],"technique":[59],"from":[60],"a":[61,100,152],"point":[63],"view.":[65],"We":[66,93,183],"introduce":[67],"two":[68],"new":[69],"algorithms,":[70],"LargestRoot":[71],"SafeSubjoin,":[73],"then":[75],"propose":[76],"Robust":[77,95],"(RPT)":[80],"provably":[83],"against":[85,106],"arbitrary":[86],"an":[90],"acyclic":[91,154],"query.":[92],"integrated":[94],"with":[98],"DuckDB,":[99],"state-of-the-art":[101],"analytical":[102],"database,":[103],"evaluated":[105,167],"all":[107],"queries":[109],"TPC-H,":[111],"JOB,":[112],"TPC-DS,":[113],"DSB":[115],"benchmarks.":[116],"Our":[117],"experimental":[118],"results":[119],"show":[120],"RPT":[122,171],"improves":[123,173],"by":[126,178],"compared":[130],"to":[131,163],"baseline.":[133],"With":[134],"RPT,":[135],"largest":[137],"ratio":[138,160],"between":[139],"maximum":[141],"minimum":[143],"execution":[144],"time":[145],"out":[146],"random":[148],"for":[151,165],"single":[153],"only":[157],"1.6x":[158],"(the":[159],"close":[162],"1":[164],"most":[166],"queries).":[168],"Meanwhile,":[169],"applying":[170],"also":[172],"end-to-end":[175],"performance":[177],"\u22481.5x":[179],"(per-query":[180],"geometric":[181],"mean).":[182],"hope":[184],"work":[187],"sheds":[188],"light":[189],"solving":[191],"practical":[193],"ordering":[195],"problem.":[196]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}