{"id":"https://openalex.org/W7151217164","doi":"https://doi.org/10.1145/3788254","title":"Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking","display_name":"Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking","publication_year":2026,"publication_date":"2026-04-02","ids":{"openalex":"https://openalex.org/W7151217164","doi":"https://doi.org/10.1145/3788254"},"language":"en","primary_location":{"id":"doi:10.1145/3788254","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788254","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/3788254","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100772752","display_name":"Hai Lan","orcid":"https://orcid.org/0009-0007-4433-9232"},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"The University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Hai Lan","raw_affiliation_strings":["School of Electrical Engineering and Computer Science, The University of Queensland, Brisbane, Queensland, Australia"],"raw_orcid":"https://orcid.org/0009-0007-4433-9232","affiliations":[{"raw_affiliation_string":"School of Electrical Engineering and Computer Science, The University of Queensland, Brisbane, Queensland, Australia","institution_ids":["https://openalex.org/I165143802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133131009","display_name":"Yang Yu","orcid":null},"institutions":[{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yang Yu","raw_affiliation_strings":["School of Computer Science, Wuhan University, Wuhan, Hubei, China"],"raw_orcid":"https://orcid.org/0009-0007-4342-6713","affiliations":[{"raw_affiliation_string":"School of Computer Science, Wuhan University, Wuhan, Hubei, China","institution_ids":["https://openalex.org/I37461747"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080660416","display_name":"Zhifeng Bao","orcid":"https://orcid.org/0000-0003-2477-381X"},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"The University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Zhifeng Bao","raw_affiliation_strings":["School of Electrical Engineering and Computer Science, The University of Queensland, Brisbane, Queensland, Australia"],"raw_orcid":"https://orcid.org/0000-0003-2477-381X","affiliations":[{"raw_affiliation_string":"School of Electrical Engineering and Computer Science, The University of Queensland, Brisbane, Queensland, Australia","institution_ids":["https://openalex.org/I165143802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078170935","display_name":"Zi Huang","orcid":"https://orcid.org/0000-0002-9738-4949"},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"The University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Zi Huang","raw_affiliation_strings":["School of Electrical Engineering and Computer Science, The University of Queensland, Brisbane, Queensland, Australia"],"raw_orcid":"https://orcid.org/0000-0002-9738-4949","affiliations":[{"raw_affiliation_string":"School of Electrical Engineering and Computer Science, The University of Queensland, Brisbane, Queensland, Australia","institution_ids":["https://openalex.org/I165143802"]}]},{"author_position":"last","author":{"id":null,"display_name":"Yuwei Peng","orcid":"https://orcid.org/0000-0002-6860-1342"},"institutions":[{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuwei Peng","raw_affiliation_strings":["School of Computer Science, Wuhan University, Wuhan, Hubei, China"],"raw_orcid":"https://orcid.org/0000-0002-6860-1342","affiliations":[{"raw_affiliation_string":"School of Computer Science, Wuhan University, Wuhan, Hubei, China","institution_ids":["https://openalex.org/I37461747"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.39475338,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"4","issue":"1","first_page":"1","last_page":"26"},"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.6798999905586243,"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.6798999905586243,"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.08990000188350677,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.0860000029206276,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.6991000175476074},{"id":"https://openalex.org/keywords/parameterized-complexity","display_name":"Parameterized complexity","score":0.6942999958992004},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.6395999789237976},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5138000249862671},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.484499990940094},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4740000069141388},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.44269999861717224},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.42250001430511475},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.4153999984264374}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8395000100135803},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.6991000175476074},{"id":"https://openalex.org/C165464430","wikidata":"https://www.wikidata.org/wiki/Q1570441","display_name":"Parameterized complexity","level":2,"score":0.6942999958992004},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.6395999789237976},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5138000249862671},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.484499990940094},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4740000069141388},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.44269999861717224},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.42250001430511475},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41999998688697815},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.4153999984264374},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.39419999718666077},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35190001130104065},{"id":"https://openalex.org/C188198153","wikidata":"https://www.wikidata.org/wiki/Q1613840","display_name":"Limiting","level":2,"score":0.3212999999523163},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.32109999656677246},{"id":"https://openalex.org/C2164484","wikidata":"https://www.wikidata.org/wiki/Q5170150","display_name":"Core (optical fiber)","level":2,"score":0.3188000023365021},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3100000023841858},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.29580000042915344},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.2888999879360199},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.287200003862381},{"id":"https://openalex.org/C4969071","wikidata":"https://www.wikidata.org/wiki/Q7316353","display_name":"Result set","level":3,"score":0.2863999903202057},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.2849999964237213},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.25940001010894775},{"id":"https://openalex.org/C68781425","wikidata":"https://www.wikidata.org/wiki/Q2052203","display_name":"Multi-objective optimization","level":2,"score":0.25699999928474426},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.25519999861717224},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2517000138759613},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.2515000104904175}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3788254","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788254","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/3788254","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788254","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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W2097363087","https://openalex.org/W2149427297","https://openalex.org/W2282866165","https://openalex.org/W2396309311","https://openalex.org/W2607970166","https://openalex.org/W2889503624","https://openalex.org/W2911464154","https://openalex.org/W2970148517","https://openalex.org/W2991530444","https://openalex.org/W2998249308","https://openalex.org/W3006419569","https://openalex.org/W3013555795","https://openalex.org/W3028301204","https://openalex.org/W3029535034","https://openalex.org/W3032560301","https://openalex.org/W3097225903","https://openalex.org/W3111141572","https://openalex.org/W3129744650","https://openalex.org/W3173622057","https://openalex.org/W3176434378","https://openalex.org/W3197977787","https://openalex.org/W4205381461","https://openalex.org/W4206064074","https://openalex.org/W4210689632","https://openalex.org/W4221142004","https://openalex.org/W4226086155","https://openalex.org/W4282550406","https://openalex.org/W4285338532","https://openalex.org/W4289706945","https://openalex.org/W4309505005","https://openalex.org/W4366492480","https://openalex.org/W4366502978","https://openalex.org/W4380433215","https://openalex.org/W4386128230","https://openalex.org/W4392453910","https://openalex.org/W4393180046","https://openalex.org/W4402041923","https://openalex.org/W4407355910","https://openalex.org/W4407385475","https://openalex.org/W4409231176"],"related_works":[],"abstract_inverted_index":{"Modern":[0],"analytical":[1],"workloads,":[2],"particularly":[3],"those":[4],"powering":[5],"business":[6],"intelligence":[7],"dashboards,":[8],"are":[9,21,58],"dominated":[10],"by":[11,111],"parameterized":[12,71],"queries,":[13],"where":[14],"a":[15,74,99,116,127,156,167,173,181,186],"small":[16],"number":[17],"of":[18,70,129,151,177,223],"query":[19,63,219],"templates":[20],"executed":[22],"repeatedly":[23],"with":[24,202],"varying":[25],"predicate":[26],"values.":[27],"Classical":[28],"cost-based":[29],"optimizers":[30,53],"frequently":[31],"fail":[32],"to":[33,42,88,171,191,225,231],"produce":[34],"efficient":[35],"execution":[36,131],"plans":[37],"in":[38],"this":[39,163],"setting":[40],"due":[41],"inaccurate":[43],"cardinality":[44],"estimation":[45],"and":[46,65,133,154,185,229],"unstable":[47],"plan":[48,178,183,196],"choices.":[49],"Although":[50],"numerous":[51],"learning-based":[52],"have":[54],"been":[55],"proposed,":[56],"most":[57,141],"designed":[59],"for":[60,104,158],"general,":[61],"ad-hoc":[62],"optimization":[64],"overlook":[66],"the":[67,140,147,194,206],"repetitive":[68],"structure":[69],"workloads.":[72],"As":[73],"result,":[75],"they":[76],"often":[77],"incur":[78],"high":[79],"training":[80],"or":[81,84],"serving":[82],"overheads":[83],"require":[85],"substantial":[86],"modifications":[87],"existing":[89,113,234],"database":[90],"systems,":[91],"limiting":[92],"their":[93],"practical":[94,100],"adoption.":[95],"We":[96,109],"propose":[97],"PLARQ,":[98],"learned":[101,235],"optimizer":[102,207],"tailored":[103],"Parameterized":[105],"Query":[106],"Optimization":[107],"(PQO).":[108],"begin":[110],"analyzing":[112],"approaches":[114],"through":[115],"unified":[117],"two-stage":[118],"framework:":[119],"(1)":[120],"Plan":[121,135],"Candidate":[122],"Generation":[123],"(PCG),":[124],"which":[125,138],"forms":[126],"set":[128,176],"plausible":[130],"plans,":[132],"(2)":[134],"Ranking":[136],"(PR),":[137],"selects":[139],"promising":[142],"one.":[143],"This":[144],"abstraction":[145],"captures":[146],"core":[148],"design":[149],"principles":[150],"prior":[152],"work":[153],"provides":[155],"foundation":[157],"systematic":[159],"comparison.":[160],"Building":[161],"on":[162],"framework,":[164],"PLARQ":[165,199,216],"employs":[166],"similarity-based":[168],"PCG":[169],"approach":[170],"retrieve":[172],"compact,":[174],"high-quality":[175],"candidates":[179],"from":[180],"precomputed":[182],"pool,":[184],"list-wise,":[187],"attention-based":[188],"ranking":[189],"model":[190],"effectively":[192],"identify":[193],"optimal":[195],"among":[197],"them.":[198],"integrates":[200],"seamlessly":[201],"PostgreSQL":[203,228],"without":[204],"modifying":[205],"internals.":[208],"Extensive":[209],"experiments":[210],"across":[211],"five":[212],"benchmarks":[213],"demonstrate":[214],"that":[215],"improves":[217],"end-to-end":[218],"performance,":[220],"achieving":[221],"speedups":[222],"up":[224,230],"420.31x":[226],"over":[227,233],"2x":[232],"methods.":[236]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2026-04-08T00:00:00"}