Perfopticon: Visual Query Analysis for Distributed Databases

Simple item page
dc.contributor.authorMoritz, Dominiken_US
dc.contributor.authorHalperin, Danielen_US
dc.contributor.authorHowe, Billen_US
dc.contributor.authorHeer, Jeffreyen_US
dc.contributor.editorH. Carr, K.-L. Ma, and G. Santuccien_US
dc.date.accessioned2015-05-22T12:50:55Z
dc.date.available2015-05-22T12:50:55Z
dc.date.issued2015en_US
dc.description.abstractDistributed database performance is often unpredictable due to issues such as system complexity, network congestion, or imbalanced data distribution. These issues are difficult for users to assess in part due to the opaque mapping between declaratively specified queries and actual physical execution plans. Database developers currently must expend significant time and effort scanning log files to isolate and debug the root causes of performance issues. In response, we present Perfopticon, an interactive query profiling tool that enables rapid insight into common problems such as performance bottlenecks and data skew. Perfopticon combines interactive visualizations of (1) query plans, (2) overall query execution, (3) data flow among servers, and (4) execution traces. These views coordinate multiple levels of abstraction to enable detection, isolation, and understanding of performance issues. We evaluate our design choices through engagements with system developers, scientists, and students. We demonstrate that Perfopticon enables performance debugging for real-world tasks.en_US
dc.description.number3en_US
dc.description.sectionheadersText & Humanitiesen_US
dc.description.seriesinformationComputer Graphics Forumen_US
dc.description.volume34en_US
dc.identifier.doi10.1111/cgf.12619en_US
dc.identifier.pages071-080en_US
dc.identifier.urihttps://doi.org/10.1111/cgf.12619en_US
dc.publisherThe Eurographics Association and John Wiley & Sons Ltd.en_US
dc.titlePerfopticon: Visual Query Analysis for Distributed Databasesen_US
Files
Collections
34-Issue 3
EuroVis15: Eurographics Conference on Visualization