{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,17]],"date-time":"2025-09-17T03:13:24Z","timestamp":1758078804304,"version":"3.44.0"},"reference-count":12,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,8]]},"abstract":"<jats:p>This demonstration introduces DBPecker, an integrated diagnostic platform tailored for distributed relational database systems. DBPecker leverages a graph-based anomaly modeling approach to capture inter-node dependencies and effectively localize compound anomalies, while a causality-aware metric prioritization module automatically isolates critical performance indicators. By unifying anomaly detection with a comprehensive root cause analysis pipeline, the system facilitates rapid and precise diagnosis in distributed database environments. Evaluated on a multi-node OceanBase cluster, DBPecker not only accelerates the identification of underlying anomalies but also substantially improves operational reliability, offering practical insights and actionable recommendations for real-world distributed database management.<\/jats:p>","DOI":"10.14778\/3750601.3750677","type":"journal-article","created":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:05Z","timestamp":1758029885000},"page":"5383-5386","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs"],"prefix":"10.14778","volume":"18","author":[{"given":"Qingliu","family":"Wu","sequence":"first","affiliation":[{"name":"Beijing University of Posts and Telecommunications"}]},{"given":"Qingfeng","family":"Xiang","sequence":"additional","affiliation":[{"name":"Beijing University of Posts and Telecommunications"}]},{"given":"Yingxia","family":"Shao","sequence":"additional","affiliation":[{"name":"Beijing University of Posts and Telecommunications"}]},{"given":"Qiyao","family":"Luo","sequence":"additional","affiliation":[{"name":"Independent Researcher"}]},{"given":"Quanqing","family":"Xu","sequence":"additional","affiliation":[{"name":"Independent Researcher"}]}],"member":"320","published-online":{"date-parts":[[2025,9,16]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Karl Dias et al. 2005. Automatic Performance Diagnosis and Tuning in Oracle.. In CIdR. 84\u201394."},{"key":"e_1_2_1_2_1","volume-title":"Proceedings of the ACM on Management of Data","author":"Shiyue","year":"2023","unstructured":"Shiyue Huang et al. 2023. DBPA: A Benchmark for Transactional Database Performance Anomalies. Proceedings of the ACM on Management of Data (2023), 1\u201326."},{"key":"e_1_2_1_3_1","article-title":"AI-based Database Performance Diagnosis","volume":"32","author":"Lianyuan Jin","year":"2021","unstructured":"Lianyuan Jin et al. 2021. AI-based Database Performance Diagnosis. Journal of Software 32, 3 (2021).","journal-title":"Journal of Software"},{"key":"e_1_2_1_4_1","doi-asserted-by":"crossref","first-page":"1176","DOI":"10.14778\/3389133.3389136","article-title":"Diagnosing root causes of intermittent slow queries in cloud databases","volume":"13","author":"Minghua Ma","year":"2020","unstructured":"Minghua Ma et al. 2020. Diagnosing root causes of intermittent slow queries in cloud databases. Proceedings of the VLDB Endowment 13, 8 (2020), 1176\u20131189.","journal-title":"Proceedings of the VLDB Endowment"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.5555\/1642718"},{"key":"e_1_2_1_6_1","first-page":"1022","article-title":"Distributed Database Diagnosis Method for Compound Anomalies","volume":"36","author":"Qingfeng Xiang","year":"2025","unstructured":"Qingfeng Xiang et al. 2025. Distributed Database Diagnosis Method for Compound Anomalies. Journal of Software 36, 3 (2025), 1022.","journal-title":"Journal of Software"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/3554821.3554830"},{"key":"e_1_2_1_8_1","volume-title":"Proceedings of the 2016 International Conference on Management of Data. 1599\u20131614","author":"Young Dong","unstructured":"Dong Young Yoon et al. 2016. DBSherlock: A Performance Diagnostic Tool for Transactional Databases. In Proceedings of the 2016 International Conference on Management of Data. 1599\u20131614."},{"key":"e_1_2_1_9_1","doi-asserted-by":"crossref","first-page":"172202","DOI":"10.1007\/s11704-022-1056-2","article-title":"Scalable and quantitative contention generation for performance evaluation on OLTP databases","volume":"17","author":"Chunxi Zhang","year":"2023","unstructured":"Chunxi Zhang et al. 2023. Scalable and quantitative contention generation for performance evaluation on OLTP databases. Frontiers of Computer Science 17, 2 (2023), 172202.","journal-title":"Frontiers of Computer Science"},{"key":"e_1_2_1_10_1","volume-title":"2023 IEEE 39th International Conference on Data Engineering (ICDE). IEEE, 1126\u20131139","author":"Guangyu","unstructured":"Guangyu Zhang et al. 2023. Dbcatcher: A cloud database online anomaly detection system based on indicator correlation. In 2023 IEEE 39th International Conference on Data Engineering (ICDE). IEEE, 1126\u20131139."},{"key":"e_1_2_1_11_1","doi-asserted-by":"crossref","first-page":"172205","DOI":"10.1007\/s11704-022-1357-5","article-title":"Scalable and adaptive log manager in distributed systems","volume":"17","author":"Huan Zhou","year":"2023","unstructured":"Huan Zhou et al. 2023. Scalable and adaptive log manager in distributed systems. Frontiers of Computer Science 17, 2 (2023), 172205.","journal-title":"Frontiers of Computer Science"},{"key":"e_1_2_1_12_1","doi-asserted-by":"crossref","first-page":"2514","DOI":"10.14778\/3675034.3675043","article-title":"D-Bot: Database Diagnosis System using Large Language Models","volume":"17","author":"Xuanhe Zhou","year":"2024","unstructured":"Xuanhe Zhou et al. 2024. D-Bot: Database Diagnosis System using Large Language Models. Proceedings of the VLDB Endowment 17, 10 (2024), 2514\u20132527.","journal-title":"Proceedings of the VLDB Endowment"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3750601.3750677","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:42:54Z","timestamp":1758030174000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3750601.3750677"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8]]},"references-count":12,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2025,8]]}},"alternative-id":["10.14778\/3750601.3750677"],"URL":"https:\/\/doi.org\/10.14778\/3750601.3750677","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,8]]},"assertion":[{"value":"2025-09-16","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}