Resequencing Actionable Task Structures for Data Transformation Pipelines

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Data scientists face challenges in identifying and addressing compatibility issues when modifying transformation pipelines, leading to unintended consequences and wastage of time and computational resources due to trial and error methods.

Innovation Solution

A system that configures an existing transformation pipeline as a stored actionable task structure, allowing users to resequence tasks while providing visual indicators for compatibility issues and suggesting modifications based on task and data set attribute comparisons.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If data scientists manually resequence tasks in transformation pipelines through trial and error, then they can eventually find a working sequence, but this process wastes significant time and computational resources

Engineering Contradiction:
Improvetransformation pipeline compatibilityVSAvoidtime to identify compatibility issues
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system performs preliminary analysis of task compatibility attributes before actual pipeline execution. When a user resequences tasks, the system proactively checks for compatibility issues by comparing task attributes (input data types, output data types, dependencies) against the proposed new sequence, identifying problems before they manifest during data processing.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system provides immediate feedback to data scientists about compatibility issues in resequenced pipelines. Visual indicators are displayed to show whether tasks are compatible or incompatible in their new sequence, allowing data scientists to adjust the pipeline configuration based on system feedback rather than waiting for execution failures.

Inventive Principle:
Principle #23Feedback

2Reliability

If data scientists execute multiple alternate variations of transformation pipelines to verify compatibility, then they can ensure proper configuration, but this consumes significant computational resources

Engineering Contradiction:
Improvetransformation pipeline compatibilityVSAvoidcomputational resources
Core Design Contradiction:
ReliabilityVSUse of energy by moving object

Solution Approach 1:

The system performs preliminary attribute comparison analysis when tasks are added, removed, or resequenced. By checking task attributes (input requirements, effect attributes, data type compatibility) in advance, the system identifies compatibility issues without executing the full pipeline, avoiding waste of computational resources on incompatible configurations.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system introduces an intermediary compatibility checking layer between pipeline configuration and execution. This intermediary layer analyzes task attributes and predicts compatibility issues before actual data processing occurs, acting as a mediator that prevents resource-intensive execution of flawed pipelines.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Productivity

If data scientists resequence tasks without systematic verification, then pipeline modification is quick, but unintended consequences and incompatibility issues arise

Engineering Contradiction:
Improvepipeline modification speedVSAvoidtask compatibility
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

The system performs automatic preliminary compatibility verification when tasks are resequenced. By comparing task attributes (input data types, output data types, dependencies) against the new sequence, the system quickly identifies compatibility issues without requiring manual verification, maintaining fast modification speed while ensuring reliability.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The transformation pipeline system performs self-verification of task compatibility through automated attribute comparison. The system checks whether resequenced tasks are compatible with each other and with the target data set without external intervention, enabling quick modifications with built-in quality assurance.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS10514827B2Resequencing actionable task structures for transforming data
Publication Date: 2019.12.24 MICROSOFT TECHNOLOGY LICENSING LLC
  • US10514827B2 patent drawing
  • US10514827B2 patent drawing
  • US10514827B2 patent drawing

AI summary

Methods, systems and computer program products that are provided for resequencing actionable task structures include features for detecting and reflecting compatibility issues of discrete tasks in the actionable task structures. After receiving input for resequencing an actionable task structure, attributes associated with the resequenced tasks are accessed and analyzed. Compatibility is determined and reflected in the display of the task identifiers, with one or more visual identifiers. The visual indicators can also be used to reflect suggested changes to the actionable task structure, based on a comparison of the task attributes.