{"id":"https://openalex.org/W4386768437","doi":"https://doi.org/10.14778/3611540.3611629","title":"Demonstrating ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement Learning","display_name":"Demonstrating ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement Learning","publication_year":2023,"publication_date":"2023-08-01","ids":{"openalex":"https://openalex.org/W4386768437","doi":"https://doi.org/10.14778/3611540.3611629"},"language":"en","primary_location":{"id":"doi:10.14778/3611540.3611629","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611629","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/A5050681387","display_name":"Junxiong Wang","orcid":"https://orcid.org/0000-0001-6998-0711"},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Junxiong Wang","raw_affiliation_strings":["Cornell University, Ithaca, NY, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cornell University, Ithaca, NY, USA","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113001667","display_name":"Mitchell Gray","orcid":null},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mitchell Gray","raw_affiliation_strings":["Cornell University, Ithaca, NY, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cornell University, Ithaca, NY, USA","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087259526","display_name":"Immanuel Trummer","orcid":"https://orcid.org/0000-0002-7203-2349"},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Immanuel Trummer","raw_affiliation_strings":["Cornell University, Ithaca, NY, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cornell University, Ithaca, NY, USA","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083237962","display_name":"Ahmet Kara","orcid":"https://orcid.org/0000-0002-1590-0023"},"institutions":[{"id":"https://openalex.org/I202697423","display_name":"University of Zurich","ror":"https://ror.org/02crff812","country_code":"CH","type":"education","lineage":["https://openalex.org/I202697423"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Ahmet Kara","raw_affiliation_strings":["University of Zurich, Zurich, Switzerland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I202697423"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035180920","display_name":"Dan Olteanu","orcid":"https://orcid.org/0000-0002-4682-7068"},"institutions":[{"id":"https://openalex.org/I202697423","display_name":"University of Zurich","ror":"https://ror.org/02crff812","country_code":"CH","type":"education","lineage":["https://openalex.org/I202697423"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Dan Olteanu","raw_affiliation_strings":["University of Zurich, Zurich, Switzerland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I202697423"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.1586,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.53344295,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"16","issue":"12","first_page":"4094","last_page":"4097"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.998199999332428,"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"}},"topics":[{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.998199999332428,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9970999956130981,"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.9970999956130981,"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.8779675960540771},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.834544837474823},{"id":"https://openalex.org/keywords/reinforcement-learning","display_name":"Reinforcement learning","score":0.6736910343170166},{"id":"https://openalex.org/keywords/skew","display_name":"Skew","score":0.6304498910903931},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6048751473426819},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.5143402814865112},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4642544388771057},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3498823642730713},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.3196960985660553},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08215001225471497}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8779675960540771},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.834544837474823},{"id":"https://openalex.org/C97541855","wikidata":"https://www.wikidata.org/wiki/Q830687","display_name":"Reinforcement learning","level":2,"score":0.6736910343170166},{"id":"https://openalex.org/C43711488","wikidata":"https://www.wikidata.org/wiki/Q7534783","display_name":"Skew","level":2,"score":0.6304498910903931},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6048751473426819},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.5143402814865112},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4642544388771057},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3498823642730713},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.3196960985660553},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08215001225471497},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/3611540.3611629","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611629","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"},{"id":"pmh:doi:10.5167/uzh-255533","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4406922384","display_name":"Open MIND","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7099999785423279,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1625390266","https://openalex.org/W1987238352","https://openalex.org/W2008865455","https://openalex.org/W2072627547","https://openalex.org/W2232813226","https://openalex.org/W2401576518","https://openalex.org/W2755385361","https://openalex.org/W3203329898"],"related_works":["https://openalex.org/W2141636073","https://openalex.org/W2088799466","https://openalex.org/W1608248699","https://openalex.org/W2185115783","https://openalex.org/W2592917304","https://openalex.org/W2159860101","https://openalex.org/W2949447338","https://openalex.org/W4283709512","https://openalex.org/W1969186495","https://openalex.org/W575918167"],"abstract_inverted_index":{"Performance":[0],"of":[1,34,44,86,105],"worst-case":[2,64,151],"optimal":[3,65,152],"join":[4,13,66,153],"algorithms":[5],"depends":[6],"on":[7,84],"the":[8,12,30,106,127,134],"order":[9],"in":[10,42],"which":[11,75,102],"attributes":[14],"are":[15,79,160],"processed.":[16],"It":[17,117],"is":[18],"challenging":[19],"to":[20,25,29,110,121,136,162],"identify":[21],"suitable":[22],"orders":[23,36,78,120,132],"prior":[24],"query":[26,55,60,70],"execution":[27,39,71],"due":[28],"huge":[31],"search":[32],"space":[33],"possible":[35],"and":[37,147],"unreliable":[38],"cost":[40],"estimates":[41],"case":[43],"data":[45,48,100,109],"skew":[46],"or":[47],"correlation.":[49],"We":[50],"demonstrate":[51],"ADOPT,":[52],"a":[53,63,98],"novel":[54],"engine":[56],"that":[57,159],"integrates":[58],"adaptive":[59],"processing":[61],"with":[62,133],"algorithm.":[67],"ADOPT":[68,90,96,142],"divides":[69],"into":[72],"episodes,":[73],"during":[74],"different":[76,87,115],"attribute":[77,88,119],"invoked.":[80],"With":[81],"runtime":[82],"feedback":[83],"performance":[85],"orders,":[89],"rapidly":[91],"approaches":[92],"near-optimal":[93],"orders.":[94,139],"Moreover,":[95],"uses":[97],"unique":[99],"structure":[101],"keeps":[103],"track":[104],"processed":[107],"input":[108],"prevent":[111],"redundant":[112],"work":[113],"across":[114],"episodes.":[116],"selects":[118],"try":[122],"via":[123],"reinforcement":[124],"learning,":[125],"balancing":[126],"need":[128],"for":[129,156],"exploring":[130],"new":[131],"desire":[135],"exploit":[137],"promising":[138],"In":[140],"experiments,":[141],"outperforms":[143],"baselines,":[144],"including":[145],"commercial":[146],"open-source":[148],"systems":[149],"utilizing":[150],"algorithms,":[154],"particularly":[155],"complex":[157],"queries":[158],"difficult":[161],"optimize.":[163]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}