{"id":"https://openalex.org/W4410538768","doi":"https://doi.org/10.14778/3717755.3717774","title":"RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems","display_name":"RCRank: Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems","publication_year":2024,"publication_date":"2024-12-01","ids":{"openalex":"https://openalex.org/W4410538768","doi":"https://doi.org/10.14778/3717755.3717774"},"language":"en","primary_location":{"id":"doi:10.14778/3717755.3717774","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3717755.3717774","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":null,"display_name":"Biao Ouyang","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":true,"raw_author_name":"Biao Ouyang","raw_affiliation_strings":["East China Normal University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"East China Normal University, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020704767","display_name":"Y. Zhang","orcid":"https://orcid.org/0009-0005-1574-922X"},"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":"Yingying Zhang","raw_affiliation_strings":["Alibaba Cloud Computing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101355211","display_name":"Hanyin Cheng","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":"Hanyin Cheng","raw_affiliation_strings":["East China Normal University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"East China Normal University, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100565734","display_name":"Shu Yang","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":"Yang Shu","raw_affiliation_strings":["East China Normal University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"East China Normal University, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084021933","display_name":"Chenjuan Guo","orcid":"https://orcid.org/0000-0002-4516-4637"},"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":"Chenjuan Guo","raw_affiliation_strings":["East China Normal University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"East China Normal University, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072309548","display_name":"Bin Yang","orcid":"https://orcid.org/0000-0002-1658-1079"},"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":"Bin Yang","raw_affiliation_strings":["East China Normal University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"East China Normal University, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048346353","display_name":"Qingsong Wen","orcid":"https://orcid.org/0000-0003-4516-2524"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qingsong Wen","raw_affiliation_strings":["Squirrel Ai Learning, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Squirrel Ai Learning, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055024089","display_name":"Lunting Fan","orcid":"https://orcid.org/0009-0005-1865-6731"},"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":"Lunting Fan","raw_affiliation_strings":["Alibaba Cloud Computing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5030396604","display_name":"Christian S. Jensen","orcid":"https://orcid.org/0000-0002-9530-1919"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Christian S. Jensen","raw_affiliation_strings":["Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":9,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I66867065"],"apc_list":null,"apc_paid":null,"fwci":0.6269,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.7005095,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":"18","issue":"4","first_page":"1169","last_page":"1182"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9973999857902527,"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.9968000054359436,"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/ranking","display_name":"Ranking (information retrieval)","score":0.7037185430526733},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6575927734375},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6426771283149719},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.49157389998435974},{"id":"https://openalex.org/keywords/root","display_name":"Root (linguistics)","score":0.4895871579647064},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48822787404060364},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.06743249297142029}],"concepts":[{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.7037185430526733},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6575927734375},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6426771283149719},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.49157389998435974},{"id":"https://openalex.org/C171078966","wikidata":"https://www.wikidata.org/wiki/Q111029","display_name":"Root (linguistics)","level":2,"score":0.4895871579647064},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48822787404060364},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.06743249297142029},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/3717755.3717774","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3717755.3717774","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"},{"id":"pmh:oai:pure.atira.dk:publications/4412ee38-b2ca-4f0a-a066-e7602a46140e","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/4412ee38-b2ca-4f0a-a066-e7602a46140e","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Ouyang, B, Zhang, Y, Cheng, H, Shu, Y, Guo, C, Yang, B, Wen, Q, Fan, L & Jensen, C S 2025 'RCRank : Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems'.","raw_type":"workingPaper"},{"id":"pmh:oai:pure.atira.dk:publications/ec6a1edc-467a-4626-9daf-7d5b13d5e586","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/ec6a1edc-467a-4626-9daf-7d5b13d5e586","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Ouyang, B, Zhang, Y, Cheng, H, Shu, Y, Guo, C, Yang, B, Wen, Q, Fan, L & Jensen, C S 2024, 'RCRank : Multimodal Ranking of Root Causes of Slow Queries in Cloud Database Systems', Proceedings of the VLDB Endowment, vol. 18, no. 4, pp. 1169-1182. https://doi.org/10.14778/3717755.3717774","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W2170870260","https://openalex.org/W2396309311","https://openalex.org/W2439673131","https://openalex.org/W2613206411","https://openalex.org/W2790625403","https://openalex.org/W2918549777","https://openalex.org/W2921369950","https://openalex.org/W2950480046","https://openalex.org/W2970148517","https://openalex.org/W2992304145","https://openalex.org/W2998249308","https://openalex.org/W3038457469","https://openalex.org/W3083560262","https://openalex.org/W3093051361","https://openalex.org/W3099273181","https://openalex.org/W3099584179","https://openalex.org/W3126261584","https://openalex.org/W3128412859","https://openalex.org/W3170072081","https://openalex.org/W3187633063","https://openalex.org/W3196849431","https://openalex.org/W3197917898","https://openalex.org/W4221163935","https://openalex.org/W4281787155","https://openalex.org/W4283326127","https://openalex.org/W4287998865","https://openalex.org/W4366492480","https://openalex.org/W4385567711","https://openalex.org/W4385568016","https://openalex.org/W4386768622","https://openalex.org/W4392453192","https://openalex.org/W4392453352","https://openalex.org/W4400909559","https://openalex.org/W4401126726","https://openalex.org/W4401352024","https://openalex.org/W4401353384"],"related_works":["https://openalex.org/W2118564381","https://openalex.org/W2163901716","https://openalex.org/W2152204162","https://openalex.org/W2739821120","https://openalex.org/W2088097596","https://openalex.org/W2150136235","https://openalex.org/W2140661912","https://openalex.org/W2037724912","https://openalex.org/W2056806613","https://openalex.org/W2153069032"],"abstract_inverted_index":{"With":[0],"the":[1,10,70,88,92,147,164,199],"continued":[2],"migration":[3],"of":[4,12,43,95,157,196,212],"storage":[5],"to":[6,57,209],"cloud":[7],"database":[8],"systems,":[9],"impact":[11],"slow":[13,51,62,96],"queries":[14,52,97],"in":[15,31,73],"such":[16],"systems":[17],"on":[18,184,186],"services":[19],"and":[20,35,53,83,111,122,143,178,188,206],"user":[21],"experience":[22],"is":[23,194],"increasing.":[24],"Root-cause":[25],"diagnosis":[26],"plays":[27],"an":[28,172],"indispensable":[29],"role":[30],"facilitating":[32],"slow-query":[33,76],"detection":[34],"revision.":[36],"This":[37,64],"paper":[38],"proposes":[39],"a":[40,106,167,210],"method":[41],"capable":[42,195],"both":[44],"identifying":[45,177],"possible":[46],"root":[47,67,102,180,203],"cause":[48,103,204],"types":[49],"for":[50,60,91,176],"ranking":[54,179,207],"these":[55],"according":[56,208],"their":[58],"potential":[59],"accelerating":[61],"queries.":[63],"enables":[65],"prioritizing":[66],"causes":[68],"with":[69,160],"highest":[71],"impact,":[72],"turn":[74],"improving":[75],"revision":[77],"effectiveness.":[78],"To":[79,126],"enable":[80,154],"more":[81],"accurate":[82],"detailed":[84],"diagnoses,":[85],"we":[86],"propose":[87],"multimodal":[89,107,113,133,158],"Ranking":[90],"Root":[93],"Causes":[94],"(RCRank)":[98],"framework,":[99],"which":[100],"formulates":[101],"analysis":[104],"as":[105],"machine":[108],"learning":[109],"problem":[110],"leverages":[112],"information":[114],"from":[115,130],"query":[116],"statements,":[117],"execution":[118,120],"plans,":[119],"logs,":[121],"key":[123],"performance":[124],"indicators.":[125],"obtain":[127],"expressive":[128],"embeddings":[129],"its":[131],"heterogeneous":[132],"input,":[134],"RCRank":[135,193],"integrates":[136,149],"self-supervised":[137],"pre-training":[138],"that":[139,153,170,192],"enhances":[140],"cross-modal":[141],"alignment":[142],"task":[144],"relevance.":[145],"Next,":[146],"framework":[148,165],"root-cause-adaptive":[150],"cross":[151],"Transformers":[152],"adaptive":[155],"fusion":[156],"features":[159,171],"varying":[161],"characteristics.":[162],"Finally,":[163],"offers":[166],"unified":[168],"model":[169],"impact-aware":[173],"training":[174],"objective":[175],"causes.":[181],"We":[182],"report":[183],"experiments":[185],"real":[187],"synthetic":[189],"datasets,":[190],"finding":[191],"consistently":[197],"outperforming":[198],"state-of-the-art":[200],"methods":[201],"at":[202],"identification":[205],"range":[211],"metrics.":[213]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}