On-demand Hypercube Synthesis for Real-time Data Drilldown

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing data analysis systems, such as OLAP systems, face challenges in efficiently processing and analyzing large volumes of data in real-time due to resource-intensive requirements and the need for pre-built cubes, which can be costly and impractical for smaller organizations, limiting their ability to perform cross-business analysis and reporting.

Innovation Solution

The system employs on-the-fly incremental view building using a multi-dimensional pivotal analysis tool that synthesizes smaller hypercubes dynamically, allowing users to interactively explore data across multiple dimensions without pre-determining them, reducing the need for extensive computing resources and enabling real-time data analysis.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If pre-built large hypercubes are used for multi-dimensional data analysis, then comprehensive analysis capability is improved, but computing resource requirements and cost increase significantly

Engineering Contradiction:

Improvecomprehensive analysis capabilityVSAvoidcomputing resource requirements

Core Design Contradiction:

Adaptability or versatilityVSUse of energy by moving object

Solution Approach 1:

The patent divides a large hypercube into multiple smaller hypercubes that can be independently built and queried. Instead of pre-building one comprehensive large hypercube that consumes excessive resources, the system segments the data space and allows dynamic assembly of smaller hypercubes based on specific analysis needs, reducing overall computing resource requirements while maintaining comprehensive analysis capability.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent implements dynamic hypercube building where hypercubes are constructed on-demand rather than pre-built. The system dynamically determines which hypercubes to build based on user queries and analysis requirements, allowing the computing resources to be allocated flexibly and efficiently, thus reducing wasted resources on pre-building all possible hypercubes.

Inventive Principle:

Principle #15Dynamics

2Adaptability or versatility

If pre-built large hypercubes are used for multi-dimensional data analysis, then comprehensive analysis capability is improved, but implementation cost increases

Engineering Contradiction:

Improvecomprehensive analysis capabilityVSAvoidimplementation cost

Core Design Contradiction:

Adaptability or versatilityVSEase of manufacture

Solution Approach 1:

The patent segments the comprehensive analysis capability into multiple smaller, independently buildable hypercubes. This segmentation reduces implementation cost because organizations can start with smaller hypercubes and expand gradually, rather than requiring the substantial upfront investment needed for a complete largehypercube system.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent allows organizations to build only the portion of thehypercube system that is currently needed for specific analysis tasks. Instead of requiring complete pre-building of all possiblehypercubes, the system enables partial implementation where only relevant hypercubes are constructed, reducing initial implementation cost while maintaining the option to expand later.

Inventive Principle:

Principle #16Partial or excessive action

3Measurement precision

If pre-built largehypercubes are used for multi-dimensional data analysis, then data analysis capability is improved, but data update frequency decreases

Engineering Contradiction:

Improvedata analysis capabilityVSAvoiddata update frequency

Core Design Contradiction:

Measurement precisionVSDuration of action of stationary object

Solution Approach 1:

The patent implements dynamic hypercube building that allows the system to respond to data updates efficiently. When underlying data changes, only the specifichypercubes affected by those changes need to be rebuilt, rather than requiring a complete rebuild of a large pre-builthypercube. This dynamic approach enables more frequent data updates while maintaining high data analysis capability.

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The patent enables selective rebuilding ofhypercubes based on data change patterns. When data is updated, the system identifies and rebuilds only the affectedhypercubes, discarding outdated portions and recovering computational efficiency. This approach maintains data analysis capability while supporting more frequent updates compared to static pre-built largehypercubes.

Inventive Principle:

Principle #34Discarding and recovering

Data Source

PatentUS10896205B2Interactive on-demand hypercube synthesis based multi-dimensional drilldown and a pivotal analysis tool and methods of use

Publication Date: 2021.01.19 PELATRO PTE LTD

AI summary

A method for facilitating the improvement and simplification of on the fly drilldown across any subset of dimensions for very large volumes of data in real time by utilizing interactive on-demand hypercube synthesis based multi-dimensional drilldown and a pivotal analysis tool. A computer system to improve, simplify, and facilitate on the fly drilldown across any subset of dimensions for very large volumes of data in real time via interactive on-demand hypercube synthesis based multi-dimensional drilldown and a pivotal analysis tool.