Data Migration System with Retry and Undo Managers

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Data migration in cloud computing environments often results in errors and unforeseen impacts on other processes or applications, due to the complexity of transferring data between different formats and systems, which existing technologies fail to manage effectively.

Innovation Solution

A data migration system that facilitates user-configurable data migration by generating and storing mappings between source and destination data formats, utilizing a multi-threaded process for task execution, a retry manager for failed tasks, and an undo manager to reverse changes if failure thresholds are exceeded, ensuring data integrity and reliability.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If automated data migration is performed to free up human resources, then productivity is improved, but errors and unforeseen impacts increase due to complexity

Engineering Contradiction:
Improvedata migration efficiencyVSAvoiddata migration accuracy
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

The data migration process is divided into multiple independent tasks that can be executed in parallel. Each task handles a specific subset of data or a specific migration operation, allowing the system to manage complexity through modular processing while maintaining overall automation and improving both productivity and reliability.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system continuously monitors task execution and uses feedback mechanisms to detect and handle errors. When failures are detected, the system can retry failed tasks or stop the migration process to prevent propagation of errors, thus maintaining data integrity while proceeding with automated migration.

Inventive Principle:
Principle #23Feedback

2Productivity

If multi-threaded process is used for task execution, then productivity is improved through parallel processing, but device complexity increases

Engineering Contradiction:
Improvemigration speedVSAvoidsystem architecture complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The system divides the data migration workload into independent tasks that can be distributed across multiple threads. Each thread handles specific tasks without interfering with others, enabling parallel processing to improve speed while managing complexity through clear task separation and independent execution.

Inventive Principle:
Principle #1Segmentation

3Reliability

If retry manager is implemented for failed tasks, then reliability is improved through automatic retries, but device complexity increases

Engineering Contradiction:
Improvetask completion success rateVSAvoiderror handling complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The retry manager automatically detects failed tasks and initiates retry operations without requiring manual intervention. The system monitors task status, identifies failures, and executes retries based on predefined policies, enabling the system to self-correct errors and improve reliability while keeping the complexity manageable through automated decision-making.

Inventive Principle:
Principle #25Self-service

4Reliability

If undo manager is implemented to reverse changes, then reliability is improved by preventing permanent errors, but device complexity increases

Engineering Contradiction:
Improvedata integrity protectionVSAvoidtransaction management complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The undo manager maintains the ability to reverse migration changes if failures are detected or if rollback is needed. By preparing undo mechanisms in advance and maintaining transaction logs, the system can quickly revert to previous states without permanent damage, protecting data integrity while managing complexity through structured transaction management.

Inventive Principle:
Principle #11Beforehand cushioning (Prior cushioning)

Data Source

PatentUS10768818B2Data migration system
Publication Date: 2020.09.08 SALESFORCE INC
  • US10768818B2 patent drawing
  • US10768818B2 patent drawing
  • US10768818B2 patent drawing

AI summary

Disclosed are some implementations of systems, apparatus, methods and computer program products for facilitating data migration. Data migration is customizable according to user-specified data formats. A data migration system monitors the data migration process and automatically retries data migration tasks that have failed. In addition, the results of data migration are reversed according to detected threshold conditions.