Perfopticon: Visual Query Analysis for Distributed Databases. Moritz, D., Halperin, D., Howe, B., & Heer, J. Computer Graphics Forum, 34(3):71–80, June, 2015. ![Perfopticon: Visual Query Analysis for Distributed Databases [link]](https://bibbase.org/img/filetypes/link.svg "link")
Paper doi abstract bibtex Distributed 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.
@article{moritz_perfopticon:_2015,
title = {Perfopticon: {Visual} {Query} {Analysis} for {Distributed} {Databases}},
volume = {34},
issn = {01677055},
shorttitle = {Perfopticon},
url = {http://search.ebscohost.com/login.aspx?direct=true&AuthType=sso&db=bth&AN=108442264&site=ehost-live&authtype=sso&custid=s5409946},
doi = {10.1111/cgf.12619},
abstract = {Distributed 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.},
number = {3},
urldate = {2019-12-05},
journal = {Computer Graphics Forum},
author = {Moritz, Dominik and Halperin, Daniel and Howe, Bill and Heer, Jeffrey},
month = jun,
year = {2015},
keywords = {WHY - Evaluation of Tools and Systems, HOW - Pattern Analysis, Type of Work: Empirical Study, WHEN - Retrospective Analyses, Type of Work: Technique \& Algorithm, WHY - Explain ML Model / Debug Algorithm / Query Plan},
pages = {71--80},
file = {EBSCO Full Text:C\:\\Users\\conny\\Zotero\\storage\\IJMQELBR\\Moritz et al. - 2015 - Perfopticon Visual Query Analysis for Distributed.pdf:application/pdf}
}
Downloads: 0
{"_id":"yiMBj2iJTq47kzS7Y","bibbaseid":"moritz-halperin-howe-heer-perfopticonvisualqueryanalysisfordistributeddatabases-2015","authorIDs":[],"author_short":["Moritz, D.","Halperin, D.","Howe, B.","Heer, J."],"bibdata":{"bibtype":"article","type":"article","title":"Perfopticon: Visual Query Analysis for Distributed Databases","volume":"34","issn":"01677055","shorttitle":"Perfopticon","url":"http://search.ebscohost.com/login.aspx?direct=true&AuthType=sso&db=bth&AN=108442264&site=ehost-live&authtype=sso&custid=s5409946","doi":"10.1111/cgf.12619","abstract":"Distributed 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.","number":"3","urldate":"2019-12-05","journal":"Computer Graphics Forum","author":[{"propositions":[],"lastnames":["Moritz"],"firstnames":["Dominik"],"suffixes":[]},{"propositions":[],"lastnames":["Halperin"],"firstnames":["Daniel"],"suffixes":[]},{"propositions":[],"lastnames":["Howe"],"firstnames":["Bill"],"suffixes":[]},{"propositions":[],"lastnames":["Heer"],"firstnames":["Jeffrey"],"suffixes":[]}],"month":"June","year":"2015","keywords":"WHY - Evaluation of Tools and Systems, HOW - Pattern Analysis, Type of Work: Empirical Study, WHEN - Retrospective Analyses, Type of Work: Technique & Algorithm, WHY - Explain ML Model / Debug Algorithm / Query Plan","pages":"71–80","file":"EBSCO Full Text:C\\:\\\\Users\\o̧nny\\\\Zotero\\\\storage\\\\IJMQELBR\\\\Moritz et al. - 2015 - Perfopticon Visual Query Analysis for Distributed.pdf:application/pdf","bibtex":"@article{moritz_perfopticon:_2015,\n\ttitle = {Perfopticon: {Visual} {Query} {Analysis} for {Distributed} {Databases}},\n\tvolume = {34},\n\tissn = {01677055},\n\tshorttitle = {Perfopticon},\n\turl = {http://search.ebscohost.com/login.aspx?direct=true&AuthType=sso&db=bth&AN=108442264&site=ehost-live&authtype=sso&custid=s5409946},\n\tdoi = {10.1111/cgf.12619},\n\tabstract = {Distributed 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.},\n\tnumber = {3},\n\turldate = {2019-12-05},\n\tjournal = {Computer Graphics Forum},\n\tauthor = {Moritz, Dominik and Halperin, Daniel and Howe, Bill and Heer, Jeffrey},\n\tmonth = jun,\n\tyear = {2015},\n\tkeywords = {WHY - Evaluation of Tools and Systems, HOW - Pattern Analysis, Type of Work: Empirical Study, WHEN - Retrospective Analyses, Type of Work: Technique \\& Algorithm, WHY - Explain ML Model / Debug Algorithm / Query Plan},\n\tpages = {71--80},\n\tfile = {EBSCO Full Text:C\\:\\\\Users\\\\conny\\\\Zotero\\\\storage\\\\IJMQELBR\\\\Moritz et al. - 2015 - Perfopticon Visual Query Analysis for Distributed.pdf:application/pdf}\n}\n\n","author_short":["Moritz, D.","Halperin, D.","Howe, B.","Heer, J."],"key":"moritz_perfopticon:_2015","id":"moritz_perfopticon:_2015","bibbaseid":"moritz-halperin-howe-heer-perfopticonvisualqueryanalysisfordistributeddatabases-2015","role":"author","urls":{"Paper":"http://search.ebscohost.com/login.aspx?direct=true&AuthType=sso&db=bth&AN=108442264&site=ehost-live&authtype=sso&custid=s5409946"},"keyword":["WHY - Evaluation of Tools and Systems","HOW - Pattern Analysis","Type of Work: Empirical Study","WHEN - Retrospective Analyses","Type of Work: Technique & Algorithm","WHY - Explain ML Model / Debug Algorithm / Query Plan"],"downloads":0},"bibtype":"article","biburl":"https://raw.githubusercontent.com/JKU-ICG/provenance-survey/master/assets/data/main.bib?token=AFMAFPFPO73YUVEBH3EL22C6YQDJU","creationDate":"2020-05-12T16:18:24.850Z","downloads":0,"keywords":["why - evaluation of tools and systems","how - pattern analysis","type of work: empirical study","when - retrospective analyses","type of work: technique & algorithm","why - explain ml model / debug algorithm / query plan"],"search_terms":["perfopticon","visual","query","analysis","distributed","databases","moritz","halperin","howe","heer"],"title":"Perfopticon: Visual Query Analysis for Distributed Databases","year":2015,"dataSources":["iLdxLZjd62Nd3rAFg"]}