Preserving Visual Indicators During Data Rollup Operations

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing data processing systems lose the ability to identify regions of interest when performing rollup operations, as conditions set at a lower level of abstraction are overridden due to data summation at a higher level, leading to a lack of visual indicators for summarized data.

Innovation Solution

A system and method that utilize Online Analytical Processing (OLAP) to generate a processed dataset with hierarchical abstraction levels, preserving rules defined at a lower level of abstraction by creating multi-layer graphical representations with Metagraphs, which maintain visual indicators for regions of interest even after rollup operations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If a rollup operation is performed to summarize data at a higher level of abstraction, then data aggregation is achieved, but visual indicators identifying regions of interest are lost

Engineering Contradiction:

Improvedata aggregation efficiencyVSAvoidloss of visual indicators

Core Design Contradiction:

ProductivityVSLoss of information

Solution Approach 1:

The patent implements a multi-layer graphical representation where lower-level graphical representations are nested within higher-level representations. When a rollup operation occurs, the system preserves the original graphical representation at the lower level and nests it within the new higher-level representation, allowing visual indicators to be maintained across abstraction levels.

Inventive Principle:

Principle #7Nested doll (Nesting)

Solution Approach 2:

The patent segments the graphical representation into multiple layers, each corresponding to a different level of abstraction. This segmentation allows the system to maintain separate visual indicators for each layer while performing rollup operations, preventing the loss of information at any single level.

Inventive Principle:

Principle #1Segmentation

2Measurement precision

If conditions are set at a lower level of abstraction to identify specific data points, then precise identification is achieved, but these conditions are overridden when data is summed at a higher level

Engineering Contradiction:

Improvedata point identification precisionVSAvoidrule preservation reliability

Core Design Contradiction:

Measurement precisionVSReliability

Solution Approach 1:

The patent applies preliminary action by establishing and preserving rules at lower levels of abstraction before rollup operations occur. The system pre-configures visual indicators and conditions at the detailed level, then maintains these indicators through the aggregation process by nesting the lower-level representation within the higher-level one, ensuring rules are not overridden.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces an intermediary mechanism in the form of a multi-layer graphical representation system that mediates between lower-level detailed data and higher-level aggregated data. This intermediary preserves the visual indicators from lower levels while allowing the rollup operation to create higher-level representations.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Adaptability or versatility

If data is aggregated from multiple sources to create a summarized view, then overall overview is improved, but the ability to identify specific regions of interest deteriorates

Engineering Contradiction:

Improvedata view adaptabilityVSAvoidregion of interest detection difficulty

Core Design Contradiction:

Adaptability or versatilityVSDifficulty of detecting and measuring

Solution Approach 1:

The patent adds a new dimension to the graphical representation by creating a multi-layer structure where each layer represents a different level of abstraction. This dimensional change allows users to navigate between detailed and summarized views, maintaining the ability to detect regions of interest at any level without compromising the overall overview.

Inventive Principle:

Principle #17Another dimension (Dimensionality change)

Data Source

PatentUS11144575B2Assisting a user to identify outliers and anomalies in a dataset

Publication Date: 2021.10.12 KYVOS INSIGHTS INC

AI summary

The present disclosure relates to system(s) and method(s) for data processing and visualization. The system is configured to enable processing and visually representing a dataset specified by a user. Initially, the system accepts a rule corresponding to at least one dimension associated with the dataset, wherein the rule is associated with a lower level of abstraction. When a rollup operation is performed along the specified dimension of the dataset for generating higher level graphical representation, the system is configured to preserve the rule associated with the dataset, regardless of any mathematical or logical cancellation of values due to the rollup operation and reflects the lower level details at a higher level of abstraction.