Interactive Hierarchical Bar Chart for Complex Data Visualization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current technologies face challenges in efficiently visualizing and managing complex hierarchical data stored in databases, making it difficult to represent and understand large volumes of interconnected information.

Innovation Solution

An interactive system that includes a time range selector and an interactive bar chart, allowing users to drill down into hierarchical data within the same view, with features like grippers for time selection, heat maps for urgency indication, and in-place drill-down capabilities, enabling efficient data exploration and management.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If hierarchical data is stored in database format with multiple fields and values, then data structure simplicity and processing speed are improved, but visual representation and context identification become difficult

Engineering Contradiction:
Improveprocessing speedVSAvoidvisual representation
Core Design Contradiction:
ProductivityVSEase of operation

Solution Approach 1:

The patent creates visual copies of hierarchical data in the form of bar charts that represent database records. Each bar corresponds to a record and can be interacted with to reveal detailed field values, transforming abstract data into tangible visual representations that are easier to comprehend while maintaining the underlying data structure.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The patent adds a visual dimension to hierarchical data by mapping database records to graphical bar elements. This transformation from tabular data to spatial visualization allows users to perceive data relationships, magnitudes, and patterns that are not apparent in traditional database formats, thereby improving visual representation without sacrificing processing efficiency.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

2Quantity of substance

If thousands or millions of records are stored in database, then data storage capacity is improved, but data exploration and context identification become impractical

Engineering Contradiction:
Improvedata storage capacityVSAvoiddata exploration
Core Design Contradiction:
Quantity of substanceVSEase of operation

Solution Approach 1:

The patent segments large volumes of hierarchical data into individual visual units (bars) that can be independently examined. Each bar represents a manageable portion of the data set, and users can interact with specific bars to explore detailed information without being overwhelmed by the total volume of data, making data exploration practical even with millions of records.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

By transforming tabular data into a visual dimension through bar charts, the patent enables users to perceive data distributions, identify outliers, and understand contextual relationships at a glance. This visual mapping allows efficient exploration of large data sets by converting numerical comparisons into spatial and visual assessments.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

3Adaptability or versatility

If interactive visual components are added to user interface, then user interaction and data exploration capability are improved, but interface complexity increases

Engineering Contradiction:
Improveuser interaction capabilityVSAvoidinterface complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements visual components that serve multiple functions: bars display aggregated data visually, respond to user selection by revealing detailed records, and maintain contextual relationships with the underlying database structure. This multi-functionality reduces the need for separate controls and interfaces for different data exploration tasks, thereby managing complexity while enhancing interaction capability.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The interactive bar chart automatically responds to user actions by dynamically displaying relevant information. When a user selects a bar, the system automatically retrieves and displays the corresponding detailed record without requiring additional navigation steps or complex interface manipulations, making the system appear simpler while providing rich interaction capabilities.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS10467782B2Interactive hierarchical bar chart
Publication Date: 2019.11.05 SAP SE
  • US10467782B2 patent drawing
  • US10467782B2 patent drawing
  • US10467782B2 patent drawing

AI summary

Provided are systems and methods for displaying visual components that can be manipulated via a user interface. In one example, a method includes one or more of displaying, via a user interface, an interactive bar chart comprising a plurality of bars representing a plurality of items, respectively, the plurality of bars being arranged along a horizontal axis of the user interface, detecting a selection of a bar from among the plurality of bars corresponding to an item from among the plurality of items, and in response to the bar being selected, collapsing a horizontal display of remaining bars from among the plurality bars corresponding to unselected items from among the plurality of items, and launching an internal bar chart visually associated with the selected bar and comprising a plurality of additional bars representing a plurality of hierarchical attributes of the corresponding item, respectively.