{"id":"https://openalex.org/W4403582373","doi":"https://doi.org/10.1145/3627673.3679771","title":"A Cause-Focused Query Optimizer Alert System","display_name":"A Cause-Focused Query Optimizer Alert System","publication_year":2024,"publication_date":"2024-10-20","ids":{"openalex":"https://openalex.org/W4403582373","doi":"https://doi.org/10.1145/3627673.3679771"},"language":"en","primary_location":{"id":"doi:10.1145/3627673.3679771","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3627673.3679771","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3627673.3679771","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 33rd ACM International Conference on Information and Knowledge Management","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3627673.3679771","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5114195821","display_name":"Runfan Ye","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Runfan Ye","raw_affiliation_strings":["Shenzhen Institute for Advanced Study, University of Electronic Science and Technology of China, Shenzhen, China"],"raw_orcid":"https://orcid.org/0009-0005-8936-4533","affiliations":[{"raw_affiliation_string":"Shenzhen Institute for Advanced Study, University of Electronic Science and Technology of China, Shenzhen, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5095025993","display_name":"Zibo Liang","orcid":"https://orcid.org/0000-0003-2203-5506"},"institutions":[{"id":"https://openalex.org/I150229711","display_name":"University of Electronic Science and Technology of China","ror":"https://ror.org/04qr3zq92","country_code":"CN","type":"education","lineage":["https://openalex.org/I150229711"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zibo Liang","raw_affiliation_strings":["School of Computer Science and Engineering, University of Electronic Science and Technology of China, Chengdu, China"],"raw_orcid":"https://orcid.org/0000-0003-2203-5506","affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, University of Electronic Science and Technology of China, Chengdu, China","institution_ids":["https://openalex.org/I150229711"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106406834","display_name":"Xu Chen","orcid":"https://orcid.org/0009-0004-3909-4021"},"institutions":[{"id":"https://openalex.org/I150229711","display_name":"University of Electronic Science and Technology of China","ror":"https://ror.org/04qr3zq92","country_code":"CN","type":"education","lineage":["https://openalex.org/I150229711"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xu Chen","raw_affiliation_strings":["School of Computer Science and Engineering, University of Electronic Science and Technology of China, Chengdu, China"],"raw_orcid":"https://orcid.org/0009-0004-3909-4021","affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, University of Electronic Science and Technology of China, Chengdu, China","institution_ids":["https://openalex.org/I150229711"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066308099","display_name":"Shuncheng Liu","orcid":"https://orcid.org/0000-0003-3557-6598"},"institutions":[{"id":"https://openalex.org/I150229711","display_name":"University of Electronic Science and Technology of China","ror":"https://ror.org/04qr3zq92","country_code":"CN","type":"education","lineage":["https://openalex.org/I150229711"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shuncheng Liu","raw_affiliation_strings":["School of Computer Science and Engineering, University of Electronic Science and Technology of China, Chengdu, China"],"raw_orcid":"https://orcid.org/0000-0003-3557-6598","affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, University of Electronic Science and Technology of China, Chengdu, China","institution_ids":["https://openalex.org/I150229711"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100603979","display_name":"Kai Zheng","orcid":"https://orcid.org/0000-0002-0217-3998"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kai Zheng","raw_affiliation_strings":["Shenzhen Institute for Advanced Study, University of Electronic Science and Technology of China, Shenzhen, China"],"raw_orcid":"https://orcid.org/0000-0002-0217-3998","affiliations":[{"raw_affiliation_string":"Shenzhen Institute for Advanced Study, University of Electronic Science and Technology of China, Shenzhen, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.1537192,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"2981","last_page":"2990"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9966999888420105,"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"}},"topics":[{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9966999888420105,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9941999912261963,"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/T11512","display_name":"Anomaly Detection Techniques and Applications","score":0.9936000108718872,"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.7546392679214478},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6696395874023438},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.4650581479072571},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4370279312133789},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.362702876329422},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3165130615234375},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.14671266078948975}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7546392679214478},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6696395874023438},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4650581479072571},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4370279312133789},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.362702876329422},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3165130615234375},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.14671266078948975}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3627673.3679771","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3627673.3679771","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3627673.3679771","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 33rd ACM International Conference on Information and Knowledge Management","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3627673.3679771","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3627673.3679771","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3627673.3679771","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 33rd ACM International Conference on Information and Knowledge Management","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.5199999809265137,"id":"https://metadata.un.org/sdg/13","display_name":"Climate action"}],"awards":[{"id":"https://openalex.org/G3561341673","display_name":"\u9762\u5411\u9886\u57df\u5927\u6570\u636e\u7684\u4e8b\u4ef6\u77e5\u8bc6\u56fe\u8c31\u6784\u5efa\u7814\u7a76","funder_award_id":"61836007","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3634295602","display_name":null,"funder_award_id":"61832017","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G964926443","display_name":"\u7a7a\u95f4\u4f17\u5305\u4e2d\u7684\u4efb\u52a1\u9884\u6d4b\u4e0e\u5206\u914d\u6280\u672f\u7814\u7a76","funder_award_id":"61972069","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4403582373.pdf","grobid_xml":"https://content.openalex.org/works/W4403582373.grobid-xml"},"referenced_works_count":30,"referenced_works":["https://openalex.org/W1977570286","https://openalex.org/W2010890196","https://openalex.org/W2071009745","https://openalex.org/W2112056262","https://openalex.org/W2123083497","https://openalex.org/W2396309311","https://openalex.org/W2396635388","https://openalex.org/W2788862220","https://openalex.org/W2790625403","https://openalex.org/W2955798121","https://openalex.org/W2970148517","https://openalex.org/W2991530444","https://openalex.org/W2998249308","https://openalex.org/W3037027022","https://openalex.org/W3037492894","https://openalex.org/W3099158806","https://openalex.org/W3099273181","https://openalex.org/W3124277639","https://openalex.org/W3168288096","https://openalex.org/W3176153696","https://openalex.org/W3198024709","https://openalex.org/W3208345284","https://openalex.org/W4214582717","https://openalex.org/W4221142004","https://openalex.org/W4281724148","https://openalex.org/W4282546806","https://openalex.org/W4366502978","https://openalex.org/W4380433215","https://openalex.org/W4381621940","https://openalex.org/W4383749444"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W3125756434","https://openalex.org/W2184296057","https://openalex.org/W2538384344","https://openalex.org/W2901901036","https://openalex.org/W2146885082","https://openalex.org/W2572349046","https://openalex.org/W3049728138","https://openalex.org/W2026738364","https://openalex.org/W2392799717"],"abstract_inverted_index":{"A":[0],"series":[1],"of":[2,41,50,56,58,62,86,109,116,133,148,169,180,183],"studies":[3],"apply":[4],"machine":[5,43],"learning":[6,44],"to":[7,18,46,82,103,125,163],"assist":[8],"cost-based":[9],"query":[10,74,104,149],"optimizers":[11],"in":[12,27,97,119],"DBMS,":[13],"emphasizing":[14],"incorporating":[15],"uncertainty":[16,100,120],"predictions":[17],"guide":[19],"decision-making.":[20],"While":[21],"these":[22,117],"approaches":[23],"have":[24],"demonstrated":[25],"advancement":[26],"some":[28],"benchmarks,":[29],"their":[30],"drawbacks,":[31],"such":[32],"as":[33],"unstable":[34],"performance,":[35],"stem":[36],"from":[37],"the":[38,48,54,59,84,98,107,114,146,154,167,174,181],"inherent":[39],"challenges":[40],"using":[42],"models":[45,81],"predict":[47],"cost":[49,80,143],"execution":[51,110,128,158],"plans":[52,129],"and":[53,106,121],"lack":[55],"exploration":[57],"intrinsic":[60],"characteristics":[61],"suboptimal":[63],"plans.":[64,88,111],"In":[65,151],"this":[66],"paper,":[67],"we":[68],"introduce":[69],"an":[70],"alert":[71,136,175],"system":[72,137,155,176],"for":[73],"optimization,":[75],"which":[76],"is":[77,92,177],"built":[78],"upon":[79],"reduce":[83],"selection":[85],"regressed":[87,184],"The":[89,135],"key":[90],"insight":[91],"that":[93,101],"there":[94],"are":[95],"differences":[96,118],"predictive":[99],"lead":[102],"optimization":[105],"regression":[108],"We":[112],"investigate":[113],"causes":[115],"design":[122],"a":[123],"discriminator":[124],"filter":[126],"out":[127],"with":[130,141],"higher":[131],"risks":[132],"regression.":[134],"can":[138],"be":[139],"integrated":[140],"various":[142],"models,":[144],"enhancing":[145],"robustness":[147],"optimizers.":[150,165],"our":[152],"experiments,":[153],"further":[156],"reduces":[157],"time":[159],"by":[160,173],"20%":[161],"compared":[162],"learned":[164],"Meanwhile,":[166],"proportion":[168,182],"optimized":[170],"queries":[171,185],"reduced":[172],"just":[178],"15%":[179],"diminished.":[186]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}