{"id":"https://openalex.org/W4409326450","doi":"https://doi.org/10.1109/tkde.2025.3557049","title":"OpDiag: Unveiling Database Performance Anomalies Through Query Operator Attribution","display_name":"OpDiag: Unveiling Database Performance Anomalies Through Query Operator Attribution","publication_year":2025,"publication_date":"2025-04-10","ids":{"openalex":"https://openalex.org/W4409326450","doi":"https://doi.org/10.1109/tkde.2025.3557049"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2025.3557049","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2025.3557049","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","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/A5035837983","display_name":"Shiyue Huang","orcid":"https://orcid.org/0009-0009-3726-5858"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shiyue Huang","raw_affiliation_strings":["School of Computer Science, Peking University, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0009-3726-5858","affiliations":[{"raw_affiliation_string":"School of Computer Science, Peking University, Beijing, China","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100389385","display_name":"Ziwei Wang","orcid":"https://orcid.org/0000-0003-4135-3024"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ziwei Wang","raw_affiliation_strings":["Hong Kong University of Science and Technology, Guangzhou, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology, Guangzhou, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063073383","display_name":"Yinjun Wu","orcid":"https://orcid.org/0000-0002-9770-5765"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yinjun Wu","raw_affiliation_strings":["School of Computer Science, Peking University, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science, Peking University, Beijing, China","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034300662","display_name":"Yaofeng Tu","orcid":"https://orcid.org/0000-0002-2616-2273"},"institutions":[{"id":"https://openalex.org/I4210098582","display_name":"ZTE (China)","ror":"https://ror.org/00rjhhq63","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210098582"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yaofeng Tu","raw_affiliation_strings":["ZTE Corporation, Nanjing, China"],"raw_orcid":"https://orcid.org/0000-0002-2616-2273","affiliations":[{"raw_affiliation_string":"ZTE Corporation, Nanjing, China","institution_ids":["https://openalex.org/I4210098582"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087841894","display_name":"Jiankai Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210098582","display_name":"ZTE (China)","ror":"https://ror.org/00rjhhq63","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210098582"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jiankai Wang","raw_affiliation_strings":["ZTE Corporation, Nanjing, China"],"raw_orcid":"https://orcid.org/0009-0003-8568-8042","affiliations":[{"raw_affiliation_string":"ZTE Corporation, Nanjing, China","institution_ids":["https://openalex.org/I4210098582"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062357883","display_name":"Bin Cui","orcid":"https://orcid.org/0000-0003-1681-4677"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]},{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bin Cui","raw_affiliation_strings":["School of CS and Key Lab of High Confidence Software Technologies, Peking University, Beijing, China","School of CS and Key Lab of High Confidence Software Technologies (MOE), Peking University, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0003-1681-4677","affiliations":[{"raw_affiliation_string":"School of CS and Key Lab of High Confidence Software Technologies, Peking University, Beijing, China","institution_ids":["https://openalex.org/I20231570","https://openalex.org/I4210128818"]},{"raw_affiliation_string":"School of CS and Key Lab of High Confidence Software Technologies (MOE), Peking University, Beijing, China","institution_ids":["https://openalex.org/I20231570"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.2161,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.87570312,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":"37","issue":"6","first_page":"3613","last_page":"3626"},"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.9280999898910522,"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.9280999898910522,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8118330240249634},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.45622262358665466},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3479132652282715}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8118330240249634},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.45622262358665466},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3479132652282715}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2025.3557049","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2025.3557049","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1691401027","display_name":null,"funder_award_id":"U22B2037","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3648843532","display_name":null,"funder_award_id":"U23B2048","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4153579485","display_name":null,"funder_award_id":"SH-2024JK29","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":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":60,"referenced_works":["https://openalex.org/W60686164","https://openalex.org/W278377694","https://openalex.org/W1787224781","https://openalex.org/W1987358714","https://openalex.org/W2112474496","https://openalex.org/W2118793888","https://openalex.org/W2240667924","https://openalex.org/W2439673131","https://openalex.org/W2508071492","https://openalex.org/W2613206411","https://openalex.org/W2760770811","https://openalex.org/W2911464154","https://openalex.org/W2948513753","https://openalex.org/W2970148517","https://openalex.org/W2970851599","https://openalex.org/W2998249308","https://openalex.org/W3007086929","https://openalex.org/W3025775630","https://openalex.org/W3037027022","https://openalex.org/W3083560262","https://openalex.org/W3086099593","https://openalex.org/W3095166039","https://openalex.org/W3154834090","https://openalex.org/W3165842875","https://openalex.org/W3174394491","https://openalex.org/W3174969457","https://openalex.org/W3175573075","https://openalex.org/W4221062824","https://openalex.org/W4221142004","https://openalex.org/W4281753793","https://openalex.org/W4281754544","https://openalex.org/W4281787155","https://openalex.org/W4283326127","https://openalex.org/W4288057686","https://openalex.org/W4316136118","https://openalex.org/W4380433153","https://openalex.org/W4380433196","https://openalex.org/W4381329289","https://openalex.org/W4389146665","https://openalex.org/W4391032878","https://openalex.org/W4399398143","https://openalex.org/W4400762160","https://openalex.org/W4401352024","https://openalex.org/W4403782366","https://openalex.org/W4405034479","https://openalex.org/W6633680793","https://openalex.org/W6685133223","https://openalex.org/W6704488215","https://openalex.org/W6721743441","https://openalex.org/W6734194636","https://openalex.org/W6736518430","https://openalex.org/W6737947904","https://openalex.org/W6738631160","https://openalex.org/W6748218292","https://openalex.org/W6753577402","https://openalex.org/W6763127212","https://openalex.org/W6784822222","https://openalex.org/W6794905673","https://openalex.org/W6840829141","https://openalex.org/W6854715278"],"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":{"How":[0],"to":[1,57,90,101,146,165],"effectively":[2,137],"diagnose":[3],"and":[4,29,110,119,123,142,149,169,186,194],"mitigate":[5],"database":[6,15,40,73,87,196],"performance":[7,47,88,108,197],"anomalies":[8,24,89],"remains":[9],"a":[10,26,82],"significant":[11],"concern":[12],"for":[13,71,156],"modern":[14],"systems.":[16],"Manually":[17],"identifying":[18],"the":[19,23,55,103],"root":[20],"causes":[21],"of":[22],"is":[25],"labor-intensive":[27],"process":[28],"significantly":[30],"relies":[31],"on":[32,38,44,129],"professional":[33],"experience.":[34],"Meanwhile,":[35],"existing":[36],"work":[37],"automatic":[39],"diagnosis":[41,83],"mainly":[42],"focuses":[43],"detecting":[45],"anomalous":[46,140,184],"metrics":[48,141],"or":[49,65],"system":[50],"log.":[51],"These":[52,112],"solutions":[53],"lack":[54],"power":[56],"pinpoint":[58],"detailed":[59],"issues":[60],"such":[61],"as":[62],"bad":[63],"queries":[64,122,148,185],"problematic":[66],"operators,":[67,107,187],"which":[68],"are":[69],"indispensable":[70],"most":[72],"troubleshooting":[74],"processes.":[75],"In":[76,93],"this":[77,94],"paper,":[78],"we":[79,96],"propose":[80],"OpDiag,":[81],"framework":[84],"that":[85,179],"attributes":[86],"query":[91,106,116],"operators.":[92,150],"framework,":[95],"first":[97],"construct":[98],"models":[99,113,131],"offline":[100],"represent":[102],"relationship":[104],"between":[105],"metrics,":[109],"anomalies.":[111,198],"can":[114,136,152,181],"capture":[115],"plan":[117],"features":[118],"support":[120],"ad-hoc":[121],"schemas.":[124],"Then,":[125],"through":[126],"feature":[127],"attribution":[128],"these":[130],"during":[132],"online":[133],"diagnosis,":[134],"OpDiag":[135,164,180],"identify":[138],"critical":[139],"further":[143],"trace":[144],"back":[145],"suspicious":[147],"This":[151],"provide":[153],"concrete":[154],"guidance":[155],"subsequent":[157],"steps":[158],"in":[159,192],"anomaly":[160],"mitigation.":[161],"We":[162],"applied":[163],"both":[166],"synthetic":[167],"benchmark":[168],"real":[170],"industry":[171],"cases":[172],"from":[173],"ZTE":[174],"Corporation.":[175],"Empirical":[176],"studies":[177],"prove":[178],"accurately":[182],"localize":[183],"thus":[188],"reducing":[189],"human":[190],"efforts":[191],"diagnosing":[193],"mitigating":[195]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}