Actionable Task Structures for Data Transformation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Data scientists face challenges in identifying and applying appropriate transformations to complex data sets due to the complexity and inconsistency of data formats, leading to inefficiencies and resource wastage in data processing.

Innovation Solution

The development of unique interfaces that facilitate the identification and assembly of actionable task structures, which are composed of discrete tasks that can be selected and stored for concurrent or subsequent application to data sets, based on context, user annotations, and metadata correlations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If data scientists manually identify and apply transformation tasks to complex data sets, then data can be transformed into a unified form for analysis, but the process consumes significant time and computational resources

Engineering Contradiction:
Improvedata transformation efficiencyVSAvoidtime to identify and apply tasks
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The system performs preliminary analysis of the data set to automatically generate a sequence of transformation tasks before the user needs to apply them. The task recommendation engine pre-computes suggested transformations based on data characteristics, eliminating the need for users to manually identify each task from scratch.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent introduces an intermediary task recommendation engine that mediates between the raw data and the user. This intermediary component analyzes data characteristics and automatically generates recommended task sequences, reducing the direct cognitive burden on users while maintaining transformation quality.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Reliability

If data scientists iteratively apply different task combinations to determine compatibility, then appropriate transformations can be identified, but computing resources are wasted through redundant processing

Engineering Contradiction:
Improvetask compatibility assuranceVSAvoidcomputational resource wastage
Core Design Contradiction:
ReliabilityVSLoss of energy

Solution Approach 1:

The system performs preliminary compatibility analysis by evaluating task dependencies and potential conflicts before full execution. The task recommendation engine assesses whether suggested tasks are compatible with existing transformations, preventing redundant iterative testing of incompatible task combinations.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system implements feedback mechanisms that monitor the effects of applied transformations and use this information to refine subsequent task recommendations. This feedback loop prevents redundant processing by learning from previous transformation outcomes and adjusting future task suggestions accordingly.

Inventive Principle:
Principle #23Feedback

3Adaptability or versatility

If normalization transform is applied to merge tables with different data formats, then data compatibility is improved, but data content may be reduced to a lowest common denominator

Engineering Contradiction:
Improvedata format compatibilityVSAvoiddata content omission
Core Design Contradiction:
Adaptability or versatilityVSLoss of information

Solution Approach 1:

Instead of applying uniform normalization across all data, the system applies context-aware transformations that preserve local data qualities. The task recommendation engine identifies specific columns or data elements that require normalization while leaving other elements unchanged, thereby maintaining data compatibility without sacrificing valuable content.

Inventive Principle:
Principle #3Local quality

Solution Approach 2:

The system dynamically adjusts transformation parameters based on data characteristics and downstream analysis requirements. Rather than forcing all data into a single lowest common denominator format, the system modifies parameters selectively to achieve compatibility while preserving data richness where possible.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS10481766B2Interfaces and methods for generating and applying actionable task structures
Publication Date: 2019.11.19 MICROSOFT TECHNOLOGY LICENSING LLC
  • US10481766B2 patent drawing
  • US10481766B2 patent drawing
  • US10481766B2 patent drawing

AI summary

Actionable task structures comprised of a plurality of tasks are generated by systems and methods utilizing interfaces that suggest tasks for assembly into the actionable task structures based on contextual relevance to data set attributes, other tasks in the actionable task structures and user annotations. The Actionable task structures are stored and selectively applied to one or more different domains for transformation data in the corresponding data sets.