Live Visualization of Database Behavior for Large Software Landscapes: The RACCOON Approach

Zirkelbach, Christian and Hasselbring, Wilhelm (2019) Live Visualization of Database Behavior for Large Software Landscapes: The RACCOON Approach Technical Reports by Department of Computer Science, 1901 . Department of Computer Science, Kiel University, Germany. DOI 10.13140/RG.2.2.33162.72642.

TR_1901.pdf - Published Version

Download (1087Kb) | Preview

Supplementary data:


Databases are essential components within large software landscapes, since
they are employed in almost every information system. Based on the growing
complexity of software systems and a steadily increasing amount of data
which is collected, processed, and stored in databases, it is difficult to obtain
a live overview of these software landscapes. This often leads to an insufficient
knowledge of the actual internal structure and behavior of employed
databases. Furthermore, databases are often involved in performance issues
within information systems.

A solution to these problems is employing live visualizations of databases
and related communication from applications within the software landscape.
These visualizations allow operators to understand their databases in detail
and to analyze database queries performed by applications. Based on
established visualization concepts like the entity relationship diagrams and
the 3D city metaphor, operators can be supported in the task of database
comprehension. Established monitoring techniques, like dynamic and static
analysis, can be used to capture necessary information from applications and

In this paper, we present our live visualization approach of databases and
associated communication for large software landscapes. Our visualization
offers two different views – a landscape-level and a database-level perspective.
The landscape-level perspective provides an overview of monitored applications
and related databases. The database-level perspective reveals database
schemas within a database, shows contained tables and relationships, and
allows for the inspection of executed queries based on the monitoring information
collected at runtime.

Document Type: Report (Research Report)
Keywords: Live Visualization of Database Behavior Database Behavior Database Usage Visualization Database Architecture Visualization Database Comprehension Software Landscape Dynamic Analysis 3D city metaphor ERD
Research affiliation: Kiel University > Software Engineering
DOI etc.: 10.13140/RG.2.2.33162.72642
ISSN: 2192-6247
Projects: ExplorViz
Date Deposited: 20 Feb 2019 14:02
Last Modified: 12 May 2019 20:40

Actions (login required)

View Item View Item

Document Downloads

More statistics for this item...