{"id":"https://openalex.org/W4386148280","doi":"https://doi.org/10.14778/3611479.3611501","title":"Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis","display_name":"Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis","publication_year":2023,"publication_date":"2023-07-01","ids":{"openalex":"https://openalex.org/W4386148280","doi":"https://doi.org/10.14778/3611479.3611501"},"language":"en","primary_location":{"id":"doi:10.14778/3611479.3611501","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611479.3611501","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","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/20.500.11850/636553","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5010380683","display_name":"Yunjia Zhang","orcid":"https://orcid.org/0009-0001-7157-156X"},"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":true,"raw_author_name":"Yunjia Zhang","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035128721","display_name":"Yannis Chronis","orcid":null},"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":"Yannis Chronis","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jignesh M. Patel","raw_affiliation_strings":["Carnegie Mellon University"],"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002060759","display_name":"Theodoros Rekatsinas","orcid":"https://orcid.org/0000-0001-6148-1854"},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Theodoros Rekatsinas","raw_affiliation_strings":["ETH Zurich"],"affiliations":[{"raw_affiliation_string":"ETH Zurich","institution_ids":["https://openalex.org/I35440088"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5010380683"],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":2.6309,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.90411795,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"16","issue":"11","first_page":"2962","last_page":"2975"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9983999729156494,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.992900013923645,"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.8412584662437439},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.6177793145179749},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5686661005020142},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.5331736207008362},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5155712962150574},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.44638630747795105},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34743309020996094},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.34135541319847107},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3208996653556824}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8412584662437439},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.6177793145179749},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5686661005020142},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5331736207008362},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5155712962150574},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.44638630747795105},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34743309020996094},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.34135541319847107},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3208996653556824},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"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/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","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}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/3611479.3611501","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611479.3611501","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:oai:www.research-collection.ethz.ch:20.500.11850/636553","is_oa":true,"landing_page_url":"http://hdl.handle.net/20.500.11850/636553","pdf_url":null,"source":{"id":"https://openalex.org/S4306402302","display_name":"Repository for Publications and Research Data (ETH Zurich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I35440088","host_organization_name":"ETH Zurich","host_organization_lineage":["https://openalex.org/I35440088"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the VLDB Endowment, 16 (11)","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"doi:10.3929/ethz-b-000636553","is_oa":true,"landing_page_url":"https://doi.org/10.3929/ethz-b-000636553","pdf_url":null,"source":{"id":"https://openalex.org/S7407051236","display_name":"ETH Z\u00fcrich Research Collection","issn_l":null,"issn":[],"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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"pmh:oai:www.research-collection.ethz.ch:20.500.11850/636553","is_oa":true,"landing_page_url":"http://hdl.handle.net/20.500.11850/636553","pdf_url":null,"source":{"id":"https://openalex.org/S4306402302","display_name":"Repository for Publications and Research Data (ETH Zurich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I35440088","host_organization_name":"ETH Zurich","host_organization_lineage":["https://openalex.org/I35440088"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the VLDB Endowment, 16 (11)","raw_type":"info:eu-repo/semantics/publishedVersion"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G171229425","display_name":"Collaborative Research: SHF: Medium: A hardware-software co-design approach for high-performance in-memory analytic data processing","funder_award_id":"2312739","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7538461470","display_name":"Elements: Software: Towards Efficient Embedded Data Processing","funder_award_id":"1835446","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8014211846","display_name":null,"funder_award_id":"HR001122S0005","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306555","display_name":"Wisconsin Alumni Research Foundation","ror":"https://ror.org/00hwxbz16"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W52840101","https://openalex.org/W1513730131","https://openalex.org/W1684311429","https://openalex.org/W1964111545","https://openalex.org/W1970196737","https://openalex.org/W1975731516","https://openalex.org/W1987645871","https://openalex.org/W2064616681","https://openalex.org/W2071009745","https://openalex.org/W2097363087","https://openalex.org/W2101207848","https://openalex.org/W2120415542","https://openalex.org/W2123845384","https://openalex.org/W2131413649","https://openalex.org/W2138793904","https://openalex.org/W2146709231","https://openalex.org/W2153329411","https://openalex.org/W2153485419","https://openalex.org/W2158237121","https://openalex.org/W2164433331","https://openalex.org/W2168362821","https://openalex.org/W2171438172","https://openalex.org/W2212047990","https://openalex.org/W2396309311","https://openalex.org/W2613226836","https://openalex.org/W2790625403","https://openalex.org/W2948177721","https://openalex.org/W2955798121","https://openalex.org/W2981155241","https://openalex.org/W2992496917","https://openalex.org/W3013555795","https://openalex.org/W3028610005","https://openalex.org/W3099158806","https://openalex.org/W3129744650","https://openalex.org/W4206606839","https://openalex.org/W4233762723","https://openalex.org/W4235245586","https://openalex.org/W4245765815","https://openalex.org/W4248080722","https://openalex.org/W4281754544","https://openalex.org/W4312924702","https://openalex.org/W6602175484"],"related_works":["https://openalex.org/W3214148052","https://openalex.org/W2151692181","https://openalex.org/W794462722","https://openalex.org/W2029625042","https://openalex.org/W4248476017","https://openalex.org/W2807741550","https://openalex.org/W2970426051","https://openalex.org/W1525319740","https://openalex.org/W4247864646","https://openalex.org/W1484210779"],"abstract_inverted_index":{"There":[0],"have":[1],"been":[2],"many":[3],"decades":[4],"of":[5,161],"work":[6],"on":[7],"optimizing":[8],"query":[9,35,93,105,175,228],"processing":[10,94,106,176],"in":[11,111,150,188],"database":[12],"management":[13],"systems.":[14],"Recently,":[15],"modern":[16],"machine":[17],"learning":[18,23],"(ML),":[19],"and":[20,108,121,129,210],"specifically":[21],"reinforcement":[22],"(RL),":[24],"has":[25],"gained":[26],"increased":[27],"attention":[28],"as":[29,68,70],"a":[30,34,43,79,89,124,130,143,159],"means":[31],"to":[32,54,88,134,157,182,216],"develop":[33],"optimizer":[36],"(QO).":[37],"In":[38],"this":[39,98,172],"work,":[40],"we":[41,77,100,169],"take":[42],"closer":[44],"look":[45],"at":[46,73],"two":[47,102],"recent":[48],"state-of-the-art":[49],"(SOTA)":[50],"RL-based":[51,63,85,185,193,218,231],"QO":[52,219,232],"methods":[53,64,233],"better":[55],"understand":[56],"their":[57],"behavior.":[58],"We":[59],"find":[60,170],"that":[61,171,230],"these":[62],"do":[65,83],"not":[66,179,204],"generalize":[67],"well":[69],"it":[71,202,211],"seems":[72],"first":[74,114],"glance.":[75],"Thus,":[76],"ask":[78],"simple":[80,103,173],"question:":[81],"How":[82],"SOTA":[84,184],"QOs":[86],"compare":[87],"simple,":[90],"modern,":[91],"adaptive":[92,104,152,174,196,223],"approach?":[95],"To":[96,166],"answer":[97],"question,":[99],"choose":[101],"techniques":[107,154],"implemented":[109],"them":[110],"PostgreSQL.":[112],"The":[113,140,195],"adapts":[115],"an":[116,206],"individual":[117],"join":[118,137,162],"operation":[119],"on-the-fly":[120],"switches":[122],"between":[123],"Nested":[125],"Loop":[126],"Join":[127,132],"algorithm":[128,133,138],"Hash":[131],"avoid":[135],"sub-optimal":[136],"decisions.":[139],"second":[141],"is":[142,178,198,212],"technique":[144],"called":[145],"Lookahead":[146],"Information":[147],"Passing":[148],"(LIP),":[149],"which":[151],"semijoin":[153],"are":[155],"used":[156],"make":[158],"pipeline":[160],"operations":[163],"execute":[164],"efficiently.":[165],"our":[167],"surprise,":[168],"approach":[177,197],"only":[180],"competitive":[181],"the":[183,192,217,222],"approaches":[186],"but,":[187],"some":[189],"cases,":[190],"outperforms":[191],"approaches.":[194,220],"also":[199],"appealing":[200],"because":[201],"does":[203],"require":[205],"expensive":[207],"training":[208],"step,":[209],"fully":[213],"interpretable":[214],"compared":[215],"Further,":[221],"method":[224],"works":[225],"across":[226],"complex":[227],"constructs":[229],"currently":[234],"cannot":[235],"optimize.":[236]},"counts_by_year":[{"year":2025,"cited_by_count":10},{"year":2024,"cited_by_count":3}],"updated_date":"2026-03-18T14:38:29.013473","created_date":"2025-10-10T00:00:00"}