{"id":"https://openalex.org/W4411374404","doi":"https://doi.org/10.1145/3722212.3725080","title":"A <scp>ndromeda</scp> : Debugging Database Performance Issues with Retrieval-Augmented Large Language Models","display_name":"A <scp>ndromeda</scp> : Debugging Database Performance Issues with Retrieval-Augmented Large Language Models","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4411374404","doi":"https://doi.org/10.1145/3722212.3725080"},"language":"en","primary_location":{"id":"doi:10.1145/3722212.3725080","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3722212.3725080","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-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/A5055853609","display_name":"P. Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Pengyi Wang","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008989299","display_name":"Sibei Chen","orcid":"https://orcid.org/0009-0001-5331-5829"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Sibei Chen","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100739546","display_name":"Ju Fan","orcid":"https://orcid.org/0000-0003-4729-9903"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ju Fan","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007360737","display_name":"Bin Wu","orcid":"https://orcid.org/0000-0002-4743-1006"},"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":"Bin Wu","raw_affiliation_strings":["Alibaba Cloud Computing, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101824160","display_name":"Nan Tang","orcid":"https://orcid.org/0000-0003-2832-0295"},"institutions":[{"id":"https://openalex.org/I889458895","display_name":"University of Hong Kong","ror":"https://ror.org/02zhqgq86","country_code":"HK","type":"education","lineage":["https://openalex.org/I889458895"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Nan Tang","raw_affiliation_strings":["HKUST (GZ) / HKUST, Guangzhou, China"],"affiliations":[{"raw_affiliation_string":"HKUST (GZ) / HKUST, Guangzhou, China","institution_ids":["https://openalex.org/I889458895"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101812238","display_name":"Jian Tan","orcid":"https://orcid.org/0000-0002-1080-9300"},"institutions":[{"id":"https://openalex.org/I4210095624","display_name":"Alibaba Group (United States)","ror":"https://ror.org/00rn0m335","country_code":"US","type":"company","lineage":["https://openalex.org/I4210095624","https://openalex.org/I45928872"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jian Tan","raw_affiliation_strings":["Alibaba Cloud Computing, Sunnyvale, CA, USA"],"affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, Sunnyvale, CA, USA","institution_ids":["https://openalex.org/I4210095624"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5055853609"],"corresponding_institution_ids":["https://openalex.org/I78988378"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.07473597,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"243","last_page":"246"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9668999910354614,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9668999910354614,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9415000081062317,"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/T10028","display_name":"Topic Modeling","score":0.9229000210762024,"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.8294436931610107},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.8240206241607666},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.47506970167160034},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41664087772369385},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3287573456764221}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8294436931610107},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.8240206241607666},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.47506970167160034},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41664087772369385},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3287573456764221}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3722212.3725080","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3722212.3725080","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.4000000059604645}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W4281972940","https://openalex.org/W4401352024","https://openalex.org/W4407357344"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W4321442002","https://openalex.org/W2015265939","https://openalex.org/W2284072287","https://openalex.org/W2611067230","https://openalex.org/W2480201319","https://openalex.org/W2387706296","https://openalex.org/W2061417947"],"abstract_inverted_index":{"Debugging":[0],"performance":[1,58,75,97,109,180],"issues":[2,42,110,158],"in":[3,74,176],"a":[4,49,78,90,167],"database":[5,16],"management":[6],"system":[7,93],"(DBMS)":[8],"is":[9],"tedious":[10],"and":[11,43,77,111,114,138,156,172],"challenging,":[12],"even":[13,36],"for":[14,46,56,94,117,170],"experienced":[15],"administrators":[17],"(DBAs).":[18],"Thus,":[19],"with":[20],"the":[21,161],"rapid":[22],"advancement":[23],"of":[24,81],"large":[25],"language":[26,105],"models":[27],"(LLMs),":[28],"developing":[29],"an":[30,149],"LLM-powered":[31,92],"co-pilot":[32],"to":[33,102,147,154],"assist":[34],"or":[35,64],"replace":[37],"DBAs":[38],"by":[39],"automatically":[40],"diagnosing":[41],"generating":[44],"recommendations":[45,116],"resolution":[47],"presents":[48],"promising":[50],"direction.":[51],"However,":[52],"directly":[53],"prompting":[54],"LLMs":[55,68],"DBMS":[57,82,96,135,179],"debugging":[59,76,177],"often":[60],"yields":[61],"either":[62],"generic":[63],"irrelevant":[65],"responses,":[66],"as":[67],"may":[69],"lack":[70],"both":[71],"domain":[72],"knowledge":[73],"deep":[79],"understanding":[80],"internals.":[83],"In":[84],"this":[85],"paper,":[86],"we":[87],"introduce":[88],"Andromeda,":[89],"retrieval-augmented,":[91],"automatic":[95],"debugging.":[98],"Andromeda":[99,122,171],"enables":[100],"users":[101],"pose":[103],"natural":[104],"questions":[106],"about":[107],"various":[108],"provides":[112],"context-aware":[113],"actionable":[115],"resolution.":[118],"To":[119],"achieve":[120],"this,":[121],"first":[123],"retrieves":[124],"relevant":[125],"evidence":[126],"from":[127],"multiple":[128],"sources,":[129],"including":[130],"historical":[131],"questions,":[132],"troubleshooting":[133],"manuals,":[134],"telemetry":[136],"data,":[137],"execution":[139],"logs.":[140],"It":[141],"then":[142],"leverages":[143],"effective":[144],"training":[145],"strategies":[146],"adapt":[148],"open-source":[150],"LLM,":[151],"empowering":[152],"it":[153],"diagnose":[155],"resolve":[157],"based":[159],"on":[160],"retrieved":[162],"evidence.":[163],"We":[164],"have":[165],"developed":[166],"web":[168],"application":[169],"demonstrated":[173],"its":[174],"effectiveness":[175],"real-world":[178],"issues.":[181]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}