{"id":"https://openalex.org/W4407696038","doi":"https://doi.org/10.14778/3704965.3704971","title":"PARQO: Penalty-Aware Robust Plan Selection in Query Optimization","display_name":"PARQO: Penalty-Aware Robust Plan Selection in Query Optimization","publication_year":2024,"publication_date":"2024-09-01","ids":{"openalex":"https://openalex.org/W4407696038","doi":"https://doi.org/10.14778/3704965.3704971"},"language":"en","primary_location":{"id":"doi:10.14778/3704965.3704971","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3704965.3704971","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/A5056700877","display_name":"Haibo Xiu","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Haibo Xiu","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065442772","display_name":"Pankaj K. Agarwal","orcid":"https://orcid.org/0000-0003-4861-1911"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pankaj K. Agarwal","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101801967","display_name":"Jun Yang","orcid":"https://orcid.org/0000-0001-7888-2187"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jun Yang","raw_affiliation_strings":["Duke University, Durham, NC, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University, Durham, NC, USA","institution_ids":["https://openalex.org/I170897317"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I170897317"],"apc_list":null,"apc_paid":null,"fwci":2.2727,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.89396908,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"17","issue":"13","first_page":"4627","last_page":"4640"},"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/T12072","display_name":"Machine Learning and Algorithms","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/T11106","display_name":"Data Management and Algorithms","score":0.9959999918937683,"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.7274196743965149},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.7043812274932861},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6836482286453247},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.554015040397644},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.3492489755153656},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23230096697807312},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21601060032844543},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10622939467430115}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7274196743965149},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.7043812274932861},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6836482286453247},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.554015040397644},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.3492489755153656},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23230096697807312},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21601060032844543},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10622939467430115},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3704965.3704971","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3704965.3704971","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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":38,"referenced_works":["https://openalex.org/W999207820","https://openalex.org/W1587011656","https://openalex.org/W1987645871","https://openalex.org/W1992560344","https://openalex.org/W1994341124","https://openalex.org/W1999689297","https://openalex.org/W2025550567","https://openalex.org/W2026966899","https://openalex.org/W2061146920","https://openalex.org/W2066580100","https://openalex.org/W2087550141","https://openalex.org/W2091638851","https://openalex.org/W2101589741","https://openalex.org/W2143452574","https://openalex.org/W2154921032","https://openalex.org/W2170476109","https://openalex.org/W2170741459","https://openalex.org/W2199153319","https://openalex.org/W2293690186","https://openalex.org/W2396309311","https://openalex.org/W2607970166","https://openalex.org/W2798710412","https://openalex.org/W2888876958","https://openalex.org/W2898003532","https://openalex.org/W2949595278","https://openalex.org/W2963625110","https://openalex.org/W3173932439","https://openalex.org/W3176153696","https://openalex.org/W3203329898","https://openalex.org/W3207801254","https://openalex.org/W4210689632","https://openalex.org/W4234171470","https://openalex.org/W4250631613","https://openalex.org/W4281728098","https://openalex.org/W4312382508","https://openalex.org/W4380433188","https://openalex.org/W4380433215","https://openalex.org/W4386128208"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"The":[0,13],"effectiveness":[1],"of":[2,10,65],"a":[3,50,66],"query":[4],"optimizer":[5,19],"relies":[6],"on":[7,101,104],"the":[8,18,62,98],"accuracy":[9],"selectivity":[11,76,95],"estimates.":[12,31,77],"execution":[14],"plan":[15,67],"generated":[16],"by":[17],"can":[20,55],"be":[21],"extremely":[22],"poor":[23],"in":[24,29,45],"reality":[25],"due":[26],"to":[27,70,82,92],"uncertainty":[28],"these":[30],"This":[32],"paper":[33],"presents":[34],"PARQO":[35,78,109],"(":[36],"P":[37],"enalty-":[38],"A":[39],"ware":[40],"R":[41],"obust":[42],"Plan":[43],"Selection":[44],"Q":[46],"uery":[47],"O":[48],"ptimization),":[49],"novel":[51],"system":[52],"where":[53],"users":[54],"define":[56],"powerful":[57],"robustness":[58],"metrics":[59],"that":[60,108],"assess":[61],"expected":[63],"penalty":[64],"with":[68,97],"respect":[69],"true":[71],"optimal":[72],"plans":[73],"under":[74],"uncertain":[75],"uses":[79],"workload-informed":[80],"profiling":[81],"build":[83],"error":[84],"models,":[85],"and":[86,114,117],"employs":[87],"principled":[88],"sensitivity":[89],"analysis":[90],"techniques":[91],"identify":[93],"human-interpretable":[94],"dimensions":[96],"largest":[99],"impact":[100],"penalty.":[102],"Experiments":[103],"three":[105],"benchmarks":[106],"demonstrate":[107],"finds":[110],"robust,":[111],"performant":[112],"plans,":[113],"enables":[115],"efficient":[116],"effective":[118],"parametric":[119],"optimization.":[120]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":6}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}