{"id":"https://openalex.org/W4396571425","doi":"https://doi.org/10.14778/3641204.3641205","title":"Eraser: Eliminating Performance Regression on Learned Query Optimizer","display_name":"Eraser: Eliminating Performance Regression on Learned Query Optimizer","publication_year":2024,"publication_date":"2024-01-01","ids":{"openalex":"https://openalex.org/W4396571425","doi":"https://doi.org/10.14778/3641204.3641205"},"language":"en","primary_location":{"id":"doi:10.14778/3641204.3641205","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3641204.3641205","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/A5008729556","display_name":"Lianggui Weng","orcid":"https://orcid.org/0009-0005-8274-7881"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Lianggui Weng","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001264074","display_name":"Rong Zhu","orcid":"https://orcid.org/0000-0001-9976-9490"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Rong Zhu","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022267948","display_name":"Di Wu","orcid":"https://orcid.org/0000-0001-7419-9903"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Di Wu","raw_affiliation_strings":["Alibaba Group, HUST, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group, HUST, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040297543","display_name":"Bolin Ding","orcid":"https://orcid.org/0000-0003-1535-9692"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bolin Ding","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031485610","display_name":"Bolong Zheng","orcid":"https://orcid.org/0000-0001-8639-4570"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bolong Zheng","raw_affiliation_strings":["HUST, Wuhan, China"],"affiliations":[{"raw_affiliation_string":"HUST, Wuhan, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110928734","display_name":"Jingren Zhou","orcid":null},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jingren Zhou","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5008729556"],"corresponding_institution_ids":["https://openalex.org/I45928872"],"apc_list":null,"apc_paid":null,"fwci":6.224,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.96752756,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"17","issue":"5","first_page":"926","last_page":"938"},"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9983999729156494,"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.9983000159263611,"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/regression","display_name":"Regression","score":0.5997095108032227},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.585739254951477},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.47532203793525696},{"id":"https://openalex.org/keywords/regression-analysis","display_name":"Regression analysis","score":0.4449731409549713},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3790788948535919},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.34451407194137573},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.31875181198120117},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.3049297332763672},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2548224925994873}],"concepts":[{"id":"https://openalex.org/C83546350","wikidata":"https://www.wikidata.org/wiki/Q1139051","display_name":"Regression","level":2,"score":0.5997095108032227},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.585739254951477},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.47532203793525696},{"id":"https://openalex.org/C152877465","wikidata":"https://www.wikidata.org/wiki/Q208042","display_name":"Regression analysis","level":2,"score":0.4449731409549713},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3790788948535919},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.34451407194137573},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.31875181198120117},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.3049297332763672},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2548224925994873}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3641204.3641205","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3641204.3641205","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":27,"referenced_works":["https://openalex.org/W2101743436","https://openalex.org/W2147100375","https://openalex.org/W2147419309","https://openalex.org/W2153329411","https://openalex.org/W2187089797","https://openalex.org/W2189465200","https://openalex.org/W2282866165","https://openalex.org/W2396309311","https://openalex.org/W2396635388","https://openalex.org/W2799237774","https://openalex.org/W2944240329","https://openalex.org/W2948163032","https://openalex.org/W2966185412","https://openalex.org/W2970851599","https://openalex.org/W3007086929","https://openalex.org/W3013555795","https://openalex.org/W3024860837","https://openalex.org/W3104631761","https://openalex.org/W4221142004","https://openalex.org/W4226086155","https://openalex.org/W4282546806","https://openalex.org/W4289706945","https://openalex.org/W4317641620","https://openalex.org/W4366492480","https://openalex.org/W4380433150","https://openalex.org/W6687322159","https://openalex.org/W6849687452"],"related_works":["https://openalex.org/W31220157","https://openalex.org/W2312753042","https://openalex.org/W4289356671","https://openalex.org/W2389155397","https://openalex.org/W2165884543","https://openalex.org/W3186837933","https://openalex.org/W2368989808","https://openalex.org/W2034959125","https://openalex.org/W2355687852","https://openalex.org/W2621086889"],"abstract_inverted_index":{"Efficient":[0],"query":[1,17,41,47,119,170,190,224,237],"optimization":[2],"is":[3,241],"crucial":[4],"for":[5,51,61,111,145,172],"database":[6,251],"management":[7],"systems.":[8,252],"Recently,":[9],"machine":[10],"learning":[11],"models":[12],"have":[13],"been":[14],"applied":[15],"in":[16,70,154],"optimizers":[18,171],"to":[19,65,81,106,164,243,249],"generate":[20],"better":[21,231],"plans,":[22],"but":[23],"the":[24,45,108,117,146,165,174,210,219,235],"unpredictable":[25],"performance":[26,57,89,96,221],"regressions":[27,90,211],"prevent":[28],"them":[29],"from":[30],"being":[31],"truly":[32],"applicable.":[33],"To":[34,98],"be":[35,180],"more":[36,122,156],"specific,":[37],"while":[38,91,212],"a":[39,52,77,103,130,155,183],"learned":[40,118,169,189,223],"optimizer":[42,48,120],"commonly":[43],"outperforms":[44],"traditional":[46,236],"on":[49,185,199,218],"average":[50],"workload":[53],"of":[54,168,187,209,222],"queries,":[55],"its":[56,197],"regression":[58],"seems":[59],"inevitable":[60],"some":[62],"queries":[63],"due":[64],"model":[66,109],"under-fitting":[67],"and":[68,115,159,195,201,246],"difficulty":[69],"generalization.":[71],"In":[72,203],"this":[73,83,99],"paper,":[74],"we":[75],"propose":[76],"system":[78],"called":[79],"Eraser":[80,85,101,178,194,206],"resolve":[82],"problem.":[84],"aims":[86],"at":[87],"eliminating":[88],"still":[92],"attaining":[93],"considerable":[94],"overall":[95,220],"improvement.":[97],"end,":[100],"applies":[102],"two-stage":[104],"strategy":[105],"estimate":[107],"accuracy":[110],"each":[112,161],"candidate":[113],"plan,":[114],"helps":[116],"select":[121],"reliable":[123],"plans.":[124],"The":[125,149],"first":[126,147],"stage":[127,151],"serves":[128],"as":[129,182],"coarse-grained":[131],"filter":[132],"that":[133,142],"removes":[134],"all":[135],"highly":[136],"risky":[137],"plans":[138,153],"with":[139],"feature":[140],"values":[141],"are":[143],"seen":[144],"time.":[148],"second":[150],"clusters":[152],"fine-grained":[157],"manner":[158],"evaluates":[160],"cluster":[162],"according":[163],"prediction":[166],"quality":[167],"selecting":[173],"final":[175],"execution":[176],"plan.":[177],"can":[179],"deployed":[181],"plugin":[184],"top":[186],"any":[188],"optimizer.":[191,238],"We":[192],"implement":[193],"demonstrate":[196],"superiority":[198],"PostgreSQL":[200],"Spark.":[202],"our":[204],"experiments,":[205],"eliminates":[207],"most":[208],"bringing":[213],"very":[214],"little":[215],"negative":[216],"impact":[217],"optimizers,":[225],"no":[226],"matter":[227],"whether":[228],"they":[229],"perform":[230],"or":[232],"worse":[233],"than":[234],"Meanwhile,":[239],"it":[240],"adaptive":[242],"dynamic":[244],"settings":[245],"generally":[247],"applicable":[248],"different":[250]},"counts_by_year":[{"year":2025,"cited_by_count":12},{"year":2024,"cited_by_count":5}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2025-10-10T00:00:00"}