{"id":"https://openalex.org/W4409231175","doi":"https://doi.org/10.14778/3712221.3712248","title":"RankPQO: Learning-to-Rank for Parametric Query Optimization","display_name":"RankPQO: Learning-to-Rank for Parametric Query Optimization","publication_year":2024,"publication_date":"2024-11-01","ids":{"openalex":"https://openalex.org/W4409231175","doi":"https://doi.org/10.14778/3712221.3712248"},"language":"en","primary_location":{"id":"doi:10.14778/3712221.3712248","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3712221.3712248","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/A5069761590","display_name":"Songsong Mo","orcid":"https://orcid.org/0000-0003-0011-0640"},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Songsong Mo","raw_affiliation_strings":["Nanyang Technological University, Singapore"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore","institution_ids":["https://openalex.org/I172675005"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101769297","display_name":"Yue Zhao","orcid":"https://orcid.org/0009-0000-7161-1421"},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Yue Zhao","raw_affiliation_strings":["Nanyang Technological University, Singapore"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore","institution_ids":["https://openalex.org/I172675005"]}]},{"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/I82951845","display_name":"RMIT University","ror":"https://ror.org/04ttjf776","country_code":"AU","type":"education","lineage":["https://openalex.org/I82951845"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Zhifeng Bao","raw_affiliation_strings":["RMIT University, Melbourne, Australia"],"affiliations":[{"raw_affiliation_string":"RMIT University, Melbourne, Australia","institution_ids":["https://openalex.org/I82951845"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074979952","display_name":"Quanqing Xu","orcid":"https://orcid.org/0000-0001-8989-9662"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Quanqing Xu","raw_affiliation_strings":["OceanBase, Ant Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"OceanBase, Ant Group, Hangzhou, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086810340","display_name":"Chuanhui Yang","orcid":"https://orcid.org/0009-0009-3530-6476"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chuanhui Yang","raw_affiliation_strings":["OceanBase, Ant Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"OceanBase, Ant Group, Hangzhou, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045198704","display_name":"Gao Cong","orcid":"https://orcid.org/0000-0002-4430-6373"},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Gao Cong","raw_affiliation_strings":["Nanyang Technological University, Singapore"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University, Singapore","institution_ids":["https://openalex.org/I172675005"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5069761590"],"corresponding_institution_ids":["https://openalex.org/I172675005"],"apc_list":null,"apc_paid":null,"fwci":0.7128,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.75562106,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":"18","issue":"3","first_page":"863","last_page":"875"},"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.9997000098228455,"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.9997000098228455,"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.9995999932289124,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9962000250816345,"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/rank","display_name":"Rank (graph theory)","score":0.6051812171936035},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.581432580947876},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5412009358406067},{"id":"https://openalex.org/keywords/parametric-statistics","display_name":"Parametric statistics","score":0.4332547187805176},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.36425113677978516},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.31941717863082886},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3000912070274353},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.18862122297286987},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.14679187536239624}],"concepts":[{"id":"https://openalex.org/C164226766","wikidata":"https://www.wikidata.org/wiki/Q7293202","display_name":"Rank (graph theory)","level":2,"score":0.6051812171936035},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.581432580947876},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5412009358406067},{"id":"https://openalex.org/C117251300","wikidata":"https://www.wikidata.org/wiki/Q1849855","display_name":"Parametric statistics","level":2,"score":0.4332547187805176},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.36425113677978516},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.31941717863082886},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3000912070274353},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.18862122297286987},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.14679187536239624}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3712221.3712248","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3712221.3712248","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":22,"referenced_works":["https://openalex.org/W1519039476","https://openalex.org/W1536741282","https://openalex.org/W1987645871","https://openalex.org/W2097363087","https://openalex.org/W2282866165","https://openalex.org/W2396309311","https://openalex.org/W2970148517","https://openalex.org/W2998249308","https://openalex.org/W3094317675","https://openalex.org/W3099273181","https://openalex.org/W3207801254","https://openalex.org/W4206830372","https://openalex.org/W4210689632","https://openalex.org/W4221142004","https://openalex.org/W4226086155","https://openalex.org/W4283326127","https://openalex.org/W4298468057","https://openalex.org/W4312357089","https://openalex.org/W4312943126","https://openalex.org/W4317641620","https://openalex.org/W4366492480","https://openalex.org/W4392454229"],"related_works":["https://openalex.org/W2006459955","https://openalex.org/W1819934925","https://openalex.org/W4386051213","https://openalex.org/W2112835755","https://openalex.org/W4291951920","https://openalex.org/W2349674371","https://openalex.org/W2097495471","https://openalex.org/W1696545756","https://openalex.org/W2952827811","https://openalex.org/W2056202066"],"abstract_inverted_index":{"Parametric":[0],"Query":[1],"Optimization":[2],"(PQO)":[3],"is":[4],"crucial":[5],"for":[6],"efficiently":[7],"handling":[8],"parametrized":[9],"queries":[10],"(PQ)":[11],"in":[12,22,48,110,154],"many":[13],"database":[14],"applications.":[15],"This":[16],"paper":[17],"addresses":[18],"two":[19],"key":[20],"challenges":[21],"existing":[23,39,177],"PQO":[24],"techniques,":[25],"focusing":[26],"on":[27,42,86,148],"plan":[28,33,36,68,81,117],"set":[29,37],"generation":[30],"and":[31,50,76,157,173],"best":[32,80,176],"selection.":[34],"Regarding":[35,79],"generation,":[38],"methods":[40,84],"rely":[41,85],"modifying":[43],"sub-plan":[44],"cardinalities,":[45],"often":[46],"resulting":[47],"inefficiency":[49],"sub-optimal":[51],"performance":[52,138],"due":[53],"to":[54,90,125,161,171,181],"unclear":[55],"extents":[56],"of":[57],"modifications":[58],"needed.":[59],"To":[60,119],"overcome":[61,120],"this":[62,121],"issue,":[63,122],"we":[64,123],"propose":[65,124],"a":[66,127,135],"hybrid":[67],"enumeration":[69],"algorithm":[70],"that":[71],"adeptly":[72],"adjusts":[73],"both":[74,155],"cardinality":[75],"join":[77],"order.":[78],"selection,":[82],"recent":[83],"machine":[87],"learning":[88],"models":[89],"choose":[91],"plans":[92],"with":[93,100],"minimum":[94],"predicted":[95],"latency,":[96],"but":[97],"they":[98],"struggle":[99],"accurate":[101],"predictions":[102],"when":[103],"parameter":[104],"bindings":[105],"vary.":[106],"Even":[107],"minor":[108],"variations":[109],"parameters":[111],"can":[112],"significantly":[113],"impact":[114],"cardinality,":[115],"affecting":[116],"optimality.":[118],"utilize":[126],"learning-to-rank":[128],"model,":[129],"which":[130],"uses":[131],"relative":[132],"rankings":[133],"as":[134,159],"more":[136],"reliable":[137],"indicator.":[139],"Our":[140],"approach,":[141],"integrated":[142],"into":[143],"PostgreSQL,":[144],"undergoes":[145],"extensive":[146],"experiments":[147],"real":[149],"datasets,":[150],"showcasing":[151],"significant":[152],"improvements":[153],"efficiency":[156],"accuracy,":[158],"compared":[160],"baselines.":[162],"Specifically,":[163],"it":[164],"accelerates":[165],"the":[166,175],"PostgreSQL":[167],"optimizer":[168],"by":[169,179],"up":[170,180],"2.57\u00d7":[172],"surpasses":[174],"baseline":[178],"1.36\u00d7.":[182]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}