Publications

Publications of the research group since 2016. For earlier publications, please visit Fabian Beck's Google Scholar or DBLP profile.

Visual Monitoring of Process Runs: An Application Study for Stored Procedures

Type of Publication: Article in Collected Edition

Visual Monitoring of Process Runs: An Application Study for Stored Procedures

Author(s):
Meyer, Matthias; Beck, Fabian; Lohmann, Steffen
Title of Anthology:
Proceedings of the IEEE Pacific Visualization Symposium
pages:
160-167
Publisher:
IEEE
Publication Date:
2016
Digital Object Identifier (DOI):
doi:10.1109/PACIFICVIS.2016.7465264
Fulltext:
Visual Monitoring of Process Runs: An Application Study for Stored Procedures (0.99 MB)
Citation:
Download BibTeX

Abstract

Stored procedures are used in database systems to process and aggregate data. Hundreds of stored procedures often form a complex process network with documented and hidden dependencies that is difficult to understand, maintain, and debug. This paper introduces a novel approach to support such tasks by visually comparing a specific process run to other runs of the same process. The visualization is based on a force-directed node-link diagram arranged on a timeline. Color coding, histograms, and trend charts are used to highlight temporal deviations. The approach has been implemented as an interactive web application and used by professional database developers for solving realistic maintenance and debugging tasks. The feedback of these expert users confirms the usefulness and practical relevance of the approach.