{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,12,29]],"date-time":"2022-12-29T05:20:58Z","timestamp":1672291258559},"reference-count":3,"publisher":"Association for Computing Machinery (ACM)","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2009,8]]},"abstract":"<jats:p>\n            Many enterprise environments have databases running on network-attached storage infrastructure (referred to as\n            <jats:italic>Storage Area Networks<\/jats:italic>\n            or\n            <jats:italic>SANs<\/jats:italic>\n            ). Both the database and the SAN are complex subsystems that are managed by separate teams of administrators. As often as not, database administrators have limited understanding of SAN configuration and behavior, and limited visibility into the SAN's run-time performance; and vice versa for the SAN administrators. Diagnosing the cause of performance problems is a challenging exercise in these environments. We propose to remedy the situation through a novel tool, called Diads, for database and SAN problem diagnosis. This demonstration proposal summarizes the technical innovations in Diads: (i) a powerful abstraction called\n            <jats:italic>Annotated Plan Graphs (APGs)<\/jats:italic>\n            that ties together the execution path of queries in the database and the SAN using low-overhead monitoring data, and (ii) a diagnosis workflow that combines domain-specific knowledge with machine-learning techniques. The scenarios presented in the demonstration are also described.\n          <\/jats:p>","DOI":"10.14778\/1687553.1687587","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1546-1549","source":"Crossref","is-referenced-by-count":1,"title":["DIADS"],"prefix":"10.14778","volume":"2","author":[{"given":"Nedyalko","family":"Borisov","sequence":"first","affiliation":[{"name":"Duke University"}]},{"given":"Shivnath","family":"Babu","sequence":"additional","affiliation":[{"name":"Duke University"}]},{"given":"Sandeep","family":"Uttamchandani","sequence":"additional","affiliation":[{"name":"IBM Almaden Research Center"}]},{"given":"Ramani","family":"Routray","sequence":"additional","affiliation":[{"name":"IBM Almaden Research Center"}]},{"given":"Aameek","family":"Singh","sequence":"additional","affiliation":[{"name":"IBM Almaden Research Center"}]}],"member":"320","published-online":{"date-parts":[[2009,8]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Proc. of Usenix Conf. on File and Storage Technologies (FAST)","author":"Babu S.","year":"2009","unstructured":"S. Babu , N. Borisov , S. Uttamchandani , R. Routray , and A. Singh . DIADS: Addressing the \"My-Problem-or-Yours\" Syndrome with Integrated SAN and Database Diagnosis . In Proc. of Usenix Conf. on File and Storage Technologies (FAST) , 2009 . S. Babu, N. Borisov, S. Uttamchandani, R. Routray, and A. Singh. DIADS: Addressing the \"My-Problem-or-Yours\" Syndrome with Integrated SAN and Database Diagnosis. In Proc. of Usenix Conf. on File and Storage Technologies (FAST), 2009."},{"key":"e_1_2_1_2_1","volume-title":"Proc. of Fourth Conf. on Innovative Data Systems Research (CIDR)","author":"Borisov N.","year":"2009","unstructured":"N. Borisov , S. Uttamchandani , R. Routray , and A. Singh . Why Did My Query Slow Down ? In Proc. of Fourth Conf. on Innovative Data Systems Research (CIDR) , 2009 . N. Borisov, S. Uttamchandani, R. Routray, and A. Singh. Why Did My Query Slow Down? In Proc. of Fourth Conf. on Innovative Data Systems Research (CIDR), 2009."},{"key":"e_1_2_1_3_1","unstructured":"IBM TotalStorage Productivity Center. http:\/\/www-306.ibm.com\/software\/tivoli\/products\/totalstorage-data\/.  IBM TotalStorage Productivity Center. http:\/\/www-306.ibm.com\/software\/tivoli\/products\/totalstorage-data\/."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1687553.1687587","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:55:36Z","timestamp":1672224936000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1687553.1687587"}},"subtitle":["a problem diagnosis tool for databases and storage area networks"],"short-title":[],"issued":{"date-parts":[[2009,8]]},"references-count":3,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2009,8]]}},"alternative-id":["10.14778\/1687553.1687587"],"URL":"https:\/\/doi.org\/10.14778\/1687553.1687587","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2009,8]]}}}