{"id":"https://openalex.org/W7162469688","doi":"https://doi.org/10.1145/3788853.3803087","title":"Learned Root-Cause SQL Prioritization and Diagnosis for Complex Database Performance Issues","display_name":"Learned Root-Cause SQL Prioritization and Diagnosis for Complex Database Performance Issues","publication_year":2026,"publication_date":"2026-05-26","ids":{"openalex":"https://openalex.org/W7162469688","doi":"https://doi.org/10.1145/3788853.3803087"},"language":null,"primary_location":{"id":"doi:10.1145/3788853.3803087","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803087","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3788853.3803087","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111347842","display_name":"Kecheng Luo","orcid":null},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Kecheng Luo","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0008-6890-4352","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100698031","display_name":"Sijia Li","orcid":"https://orcid.org/0000-0001-6119-0440"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Sijia Li","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0007-4756-3635","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137067403","display_name":"Miaodong Shen","orcid":"https://orcid.org/0009-0003-6782-5496"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Miaodong Shen","raw_affiliation_strings":["Meituan, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0003-6782-5496","affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000372022","display_name":"Yiqi Shen","orcid":"https://orcid.org/0009-0008-5195-5129"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yiqi Shen","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0004-2008-9222","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136995336","display_name":"Pinshan Cao","orcid":"https://orcid.org/0009-0005-2362-6537"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Pinshan Cao","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0005-2362-6537","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137075983","display_name":"Peng Cai","orcid":"https://orcid.org/0009-0006-7468-7695"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Peng Cai","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0006-7468-7695","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137063623","display_name":"Xiang Wu","orcid":"https://orcid.org/0009-0005-7218-2311"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xiang Wu","raw_affiliation_strings":["Meituan, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0005-7218-2311","affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136997325","display_name":"Kai Li","orcid":"https://orcid.org/0009-0009-5885-3114"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kai Li","raw_affiliation_strings":["Meituan, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0009-5885-3114","affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101545294","display_name":"Jinlong Cai","orcid":"https://orcid.org/0009-0003-5669-1808"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jinlong Cai","raw_affiliation_strings":["Meituan, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0007-4761-0665","affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5124112984","display_name":"Weiyuan Xu","orcid":null},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Weiyuan Xu","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0009-4335-5681","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":10,"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.85219139,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"413","last_page":"425"},"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.8853999972343445,"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.8853999972343445,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.014100000262260437,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.012500000186264515,"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/sql","display_name":"SQL","score":0.517799973487854},{"id":"https://openalex.org/keywords/prioritization","display_name":"Prioritization","score":0.48330000042915344},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.36480000615119934},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.336899995803833},{"id":"https://openalex.org/keywords/database-application","display_name":"Database application","score":0.2822999954223633}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.713699996471405},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.517799973487854},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.483599990606308},{"id":"https://openalex.org/C2777615720","wikidata":"https://www.wikidata.org/wiki/Q11888847","display_name":"Prioritization","level":2,"score":0.48330000042915344},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.36480000615119934},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3603000044822693},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.336899995803833},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2831999957561493},{"id":"https://openalex.org/C2778625365","wikidata":"https://www.wikidata.org/wiki/Q5227393","display_name":"Database application","level":2,"score":0.2822999954223633},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.2816999852657318},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.2815999984741211}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3788853.3803087","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803087","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3788853.3803087","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803087","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W2047287351","https://openalex.org/W2105059961","https://openalex.org/W2108862644","https://openalex.org/W2143331230","https://openalex.org/W2171828861","https://openalex.org/W2278797086","https://openalex.org/W2295598076","https://openalex.org/W2439673131","https://openalex.org/W2440730883","https://openalex.org/W2921369950","https://openalex.org/W2970512455","https://openalex.org/W3020616315","https://openalex.org/W3083560262","https://openalex.org/W3154834090","https://openalex.org/W4224316432","https://openalex.org/W4254182148","https://openalex.org/W4289533899","https://openalex.org/W4312357089","https://openalex.org/W4380433153","https://openalex.org/W4380433196","https://openalex.org/W4395022713","https://openalex.org/W4399256348","https://openalex.org/W4404131920","https://openalex.org/W4404386304","https://openalex.org/W4414266961"],"related_works":[],"abstract_inverted_index":{"Database":[0],"performance":[1,115,168,182],"diagnosis":[2],"is":[3,169],"persistently":[4],"hindered":[5],"by":[6,175],"a":[7,42,68,78,134,154],"deluge":[8],"of":[9,57],"Symptom":[10],"SQL":[11,21],"Templates":[12,22],"(SSTs)\u2014''victim''":[13],"queries":[14],"that":[15,128],"obscure":[16],"the":[17,32,55,86,139],"relatively":[18],"few":[19],"Root-cause":[20],"(RSTs).":[23],"This":[24,38],"conflation":[25],"substantially":[26],"increases":[27],"operational":[28],"costs":[29],"and":[30,66,108,157],"prolongs":[31],"Mean":[33],"Time":[34],"To":[35],"Resolution":[36],"(MTTR).":[37],"paper":[39],"proposes":[40],"LESSON,":[41],"diagnostic":[43,59,81,140,181],"system":[44],"deployed":[45],"in":[46],"Meituan's":[47],"production":[48,147],"environment.":[49],"Its":[50],"three-stage":[51],"pipeline":[52],"systematically":[53],"overcomes":[54],"limitations":[56],"existing":[58],"approaches:":[60],"First,":[61],"to":[62,84,112],"mitigate":[63],"KPI":[64],"noise":[65],"inconsistencies,":[67],"novel":[69],"multi-sequence":[70],"clustered":[71],"change":[72],"point":[73],"detection":[74],"algorithm":[75],"robustly":[76],"identifies":[77],"unified,":[79],"precise":[80],"interval.":[82],"Second,":[83],"solve":[85],"causal":[87],"attribution":[88],"problem\u2014distinguishing":[89],"''victim''":[90],"SSTs":[91],"with":[92,98],"drastic":[93],"fluctuations":[94],"from":[95],"''culprit''":[96],"RSTs":[97],"subtle":[99],"signatures\u2014a":[100],"two-stage":[101],"Learning-to-Rank":[102],"(LTR)":[103],"framework":[104],"performs":[105],"coarse":[106],"filtering":[107],"fine":[109],"ranking.":[110],"Finally,":[111],"ensure":[113],"continuous":[114],"improvement":[116,160],"against":[117],"emerging":[118],"fault":[119],"patterns,":[120],"we":[121],"integrate":[122],"Large":[123],"Language":[124],"Model":[125],"(LLM)":[126],"agents":[127,178],"automatically":[129,173],"annotate":[130],"new":[131],"cases,":[132],"creating":[133],"high-quality":[135],"data":[136,172],"stream":[137],"for":[138],"models.":[141],"Empirical":[142],"results":[143],"on":[144],"two":[145],"real-world":[146],"datasets":[148],"demonstrate":[149],"LESSON's":[150,186],"high":[151],"precision,":[152],"achieving":[153],"17.0%":[155],"Hit@1":[156],"64.7%":[158],"MAP@3":[159],"over":[161,183],"SOTA":[162],"methods.":[163],"We":[164],"further":[165],"prove":[166],"this":[167],"not":[170],"static:":[171],"annotated":[174],"our":[176],"LLM":[177],"steadily":[179],"enhances":[180],"time,":[184],"enabling":[185],"long-term":[187],"adaptability.":[188]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-05-27T00:00:00"}