Treemap Visualization for Database Time Analysis
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database management systems face challenges in effectively displaying and prioritizing large amounts of data related to database performance, leading to inefficient use of administrator time due to scalability limitations in conventional lists and bar charts, requiring repeated user interactions to identify important systems or aspects.
Innovation Solution
The use of a treemap visualization, where database time values are correlated to cell sizes, allowing for the simultaneous display of multiple dimensions and easy identification of problem areas, facilitated by an Automatic Database Diagnostic Monitor (ADDM) that generates a treemap based on database time measurements, enabling administrators to quickly determine performance issues.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If conventional lists or bar charts are used to display database performance data, then the data can be organized in a structured format, but the scalability is severely constrained and requires repeated user interactions to view all information
Solution Approach 1:
The patent transforms the traditional one-dimensional list or bar chart into a two-dimensional treemap visualization. Each rectangle's area represents a database system's performance metric, allowing administrators to view hundreds of systems simultaneously on a single screen without scrolling. This dimensional transformation enables all data to be visible at once, eliminating the need for repeated user interactions and significantly reducing time loss.
2Loss of information
If the entire collection of databases is displayed, then complete information is provided, but it becomes difficult to identify the most important systems among hundreds or thousands of systems
Solution Approach 1:
The treemap visualization applies local quality by varying the area of each rectangle according to the performance metric of individual database systems. Larger rectangles represent systems with higher resource consumption or performance issues, making them visually prominent and easy to identify. This differential representation allows administrators to quickly detect and prioritize important systems while maintaining complete information about all databases in the collection.
3Measurement precision
If detailed performance aspects are displayed for a single database system, then comprehensive analysis is possible, but the scalability to display multiple systems simultaneously is constrained
Solution Approach 1:
The patent segments the overall database performance analysis into individual rectangular representations for each database system. Each segment (rectangle) can represent a different system with its own performance characteristics, allowing simultaneous display of multiple systems. The segmentation enables administrators to review many systems at once while maintaining the ability to analyze detailed performance aspects of any individual system by selecting it for further examination.
Data Source
AI summary
Particular embodiments generally relate to displaying database time using a treemap. A set of database time values is determined for a set of dimensions. The database time values measure performance of one or more databases by the time the database takes to respond to a request. The set of database time values is correlated to a set of cells in the treemap. A size of the cell is determined based on the database time value associated with it. For example, the database time value is correlated to an area of the cell. A layout of the set of cells is determined and the treemap is displayed using the layout. For example, the largest values of database time may be shown with the largest sized cells. This makes it easier for an administrator to review and analyze the database performance across multiple dimensions and determine problem areas affecting the performance of the one or more databases.