Data Preparation Interface with Stage Navigation and Selection Controls

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Efficiently and accurately preparing data sets for analysis is challenging due to the lack of intuitive control over data preparation processes, leading to potential inefficiencies and inaccuracies.

Innovation Solution

A user interface with multiple components providing various views and controls allows for fine-grained and intuitive data preparation, including selection and navigation controls that enable users to select data portions, view data at different stages, and undo changes, facilitating efficient and accurate data preparation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If traditional data preparation methods are used, then data can be processed, but the process lacks intuitive control and is prone to errors

Engineering Contradiction:
Improveintuitive control over data preparationVSAvoidaccuracy of data preparation
Core Design Contradiction:
Ease of operationVSReliability

Solution Approach 1:

The patent implements feedback mechanisms by displaying multiple views of the data set at different preparation stages simultaneously. The navigation control allows users to review previous stages, and the selection control provides immediate visual feedback when data portions are selected, enabling users to verify their actions and correct errors before they propagate.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The patent introduces an intermediary user interface layer between the raw data and the analysis tools. This interface includes multiple view components (grid view, summary view, etc.) and control components that mediate the data preparation process, making it more intuitive while maintaining accuracy through structured controls and navigation.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Ease of operation

If comprehensive data preparation controls are implemented, then control over data preparation is enhanced, but the interface complexity increases

Engineering Contradiction:
Improvefine-grained control over data preparationVSAvoiduser interface complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent segments the user interface into multiple independent view components (grid view, summary view, histogram view, etc.) and control components. Each component has a specific function and can be independently controlled. The navigation control is divided into stage indicators and undo/redo buttons, allowing users to manage complexity through modular, organized interfaces rather than a monolithic complex interface.

Inventive Principle:
Principle #1Segmentation

3Productivity

If multiple views and controls are provided for data preparation, then efficiency and accuracy improve, but the time to learn and use the system increases

Engineering Contradiction:
Improvedata preparation efficiencyVSAvoidtime to master the system
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent provides preliminary action through default views and pre-configured controls that are immediately available when the interface is opened. The navigation control pre-loads stage information, and the selection control is ready to respond to user input without requiring configuration. This reduces the time needed to become productive while maintaining the full functionality of multiple views and controls.

Inventive Principle:
Principle #10Preliminary action

4Reliability

If the ability to undo and navigate preparation stages is added, then error correction is improved, but the system complexity increases

Engineering Contradiction:
Improveability to correct data preparation errorsVSAvoidnavigation and control structure
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The navigation control implements preliminary action by pre-calculation and display of all preparation stages before the user needs to navigate them. The system maintains a history of all transformation steps and makes them immediately accessible through the stage indicators, eliminating the need for complex undo/redo algorithms during user interaction.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS10628397B2Navigation of data set preparation
Publication Date: 2020.04.21 MICROSOFT TECHNOLOGY LICENSING LLC
  • US10628397B2 patent drawing
  • US10628397B2 patent drawing
  • US10628397B2 patent drawing

AI summary

A user interface having components that each provide a view on underlying data, and controls for preparing the data. This allows the user to have a wide variety of views on the data set, and corresponding controls appropriate for that view. The level of control over data preparation is even further enhanced by a selection control and navigation control. The selection control allows a portion of the view to be selected, which would in turn affect the view(s) displayed in one or more other user interface components. The navigation control causes the user interface components to display views on the data set as that data set existed at various prior stages in data preparation. The selection control remains active even when viewing prior stages of the data set.