Custom Analysis Module GUI for Dynamic Data Mining

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data mining techniques are limited by pre-defined hierarchical relationships and rely on pre-existing measures, leading to inefficiencies and increased costs, as analysts must manually represent new relationships and often use multiple tools and interfaces, resulting in time lags and lost opportunities.

Innovation Solution

A generic graphical user interface (GUI) analysis tool allows users to define custom analysis modules by inputting schema and segment relationships, analysis types, and user-defined measures, which are then processed to create a customized analysis module that can be executed against a data store, providing interactive graphic results and enabling seamless integration of features within a single tool.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If pre-defined hierarchical relationships are used for data mining, then the system structure is simple and easy to maintain, but the system cannot discover or represent new relationships dynamically

Engineering Contradiction:
Improveability to represent new relationshipsVSAvoidsystem structure complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements dynamic relationship definitions where analysts can create and modify segment relationships on-the-fly without being constrained by pre-defined hierarchies. The system allows relationships to be defined dynamically through a user interface, enabling the data mining process to adapt to newly discovered relationships as analysis progresses.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The patent creates a universal relationship definition mechanism that works across different analysis types and data structures. The same interface and processes can define various types of relationships (hierarchical, associative, temporal) without requiring separate systems, making the tool versatile for representing any relationship type discovered during analysis.

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

2Adaptability or versatility

If custom measures are developed by developers, then the needed measures can be produced, but this results in lost time and increased enterprise expenses

Engineering Contradiction:
Improveability to create custom measuresVSAvoidtime to produce measures
Core Design Contradiction:
Adaptability or versatilityVSProductivity

Solution Approach 1:

The patent enables analysts to independently define and create custom measures using a user-friendly interface without requiring developer intervention. Analysts can specify measure calculations, parameters, and logic directly in the system, allowing them to self-serve their analytical needs and eliminate the time lag associated with developer production cycles.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent introduces an intermediary layer between the analyst's requirements and the database system. This intermediary interface translates analyst-defined measure specifications into executable queries and calculations, bridging the gap between analytical needs and system capabilities without requiring direct developer involvement for each custom measure.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Ease of operation

If multiple tools and interfaces are used for data mining tasks, then each tool can be optimized for its specific function, but the analyst must become fluent in multiple tools and interfaces

Engineering Contradiction:
Improveease of useVSAvoidnumber of tools and interfaces
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent merges multiple previously separate functions (relationship definition, measure creation, segment analysis, and result visualization) into a single integrated tool. The unified interface allows analysts to perform all data mining tasks within one system, eliminating the need to switch between multiple tools and reducing the learning curve associated with mastering multiple interfaces.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The patent creates a universal data mining platform that performs multiple functions through a consistent interface. The same tool can define relationships, create measures, execute analysis, and visualize results, providing multi-functionality that reduces the number of separate tools needed while maintaining ease of operation through a unified user experience.

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

4Speed

If manual representation of new relationships is required, then the database structure remains stable and predictable, but newly discovered relationships cannot be explored until manually represented

Engineering Contradiction:
Improvespeed to explore new relationshipsVSAvoidtime to manually represent relationships
Core Design Contradiction:
SpeedVSLoss of time

Solution Approach 1:

The patent implements preliminary relationship definition capabilities where analysts can define relationships and measures in advance of executing analysis. This allows the system to be prepared with the necessary analytical framework before data mining begins, eliminating delays that would occur if relationships needed to be defined during the analysis process itself.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent enables dynamic relationship definitions that can be created and modified during the analysis process without requiring manual database schema changes. Analysts can discover relationships during exploration and immediately represent them in the system, allowing the analytical model to evolve dynamically alongside the analysis itself.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS8032566B2Tools for defining and using custom analysis modules
Publication Date: 2011.10.04 TERADATA US INC
  • US8032566B2 patent drawing
  • US8032566B2 patent drawing
  • US8032566B2 patent drawing

AI summary

Tools for defining and using custom analysis modules are presented. A generic graphical user interface (GUI) custom analysis tool is presented to a user. The generic GUI custom analysis tool is adapted to receive selections and inputs from the user that define many-to-many relationships in a data store and that include user-defined measures. The inputs are used to generate an instance of a custom analysis module that is capable of being processed against the data store. The instance of the custom analysis module may be stored, recalled, executed, and/or modified from the generic GUI custom analysis tool.