Database Migration Framework Parallel Execution

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current database migration processes between on-premise and cloud-based deployments are complex and performance-impacting, often requiring sequential and synchronous operations, leading to significant infrastructure strain and prolonged migration periods.

Innovation Solution

A migration framework that includes a migration status data store, a migration manager, and a status update component, which monitors and updates the migration status of databases, allowing for the invocation of migration scripts and scheduling of steps in parallel or sequentially, enhancing scalability and management.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Device complexity

If sequential and synchronous migration operations are used, then migration complexity is reduced, but migration duration and infrastructure performance impact increase significantly

Engineering Contradiction:

Improvemigration process complexityVSAvoidmigration duration

Core Design Contradiction:

Device complexityVSLoss of time

Solution Approach 1:

The migration process is segmented into discrete migration steps that can be independently executed and tracked. Each database migration is broken down into manageable steps with individual status tracking, allowing parallel execution of multiple migration steps across different databases while maintaining control over complexity through structured segmentation.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The migration framework dynamically adjusts execution based on real-time status monitoring. The system can switch between sequential and parallel execution modes, pause and resume migrations, and adapt the migration pace based on infrastructure performance, thereby reducing overall migration duration while managing complexity through dynamic control.

Inventive Principle:

Principle #15Dynamics

2Loss of time

If parallel migration execution is implemented, then migration duration is reduced, but system complexity and management difficulty increase

Engineering Contradiction:

Improvemigration durationVSAvoidmigration framework complexity

Core Design Contradiction:

Loss of timeVSDevice complexity

Solution Approach 1:

The framework implements continuous feedback through status monitoring of each migration step. The status store maintains real-time information about migration progress, successes, and failures, enabling the system to automatically adjust parallel execution, handle errors, and manage complexity through informed decision-making based on actual migration state.

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

A central status store and migration manager act as intermediaries between multiple parallel migration processes. This intermediary layer coordinates the parallel executions, tracks their status, and manages the overall migration workflow, thereby enabling parallel execution while containing system complexity through a centralized coordination mechanism.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Productivity

If multiple sites are migrated simultaneously, then overall migration speed increases, but performance impact on infrastructure worsens

Engineering Contradiction:

Improvemigration speedVSAvoidinfrastructure performance impact

Core Design Contradiction:

ProductivityVSObject-affected harmful factors

Solution Approach 1:

The framework dynamically controls the number of concurrent migration operations based on infrastructure performance feedback. It can adjust the degree of parallelization, pause migrations when performance degradation is detected, and resume when resources are available, thereby maintaining high productivity while minimizing harmful performance impact through adaptive resource management.

Inventive Principle:

Principle #15Dynamics

4Ease of operation

If synchronous migration operations are used, then ease of management is improved, but migration duration increases significantly

Engineering Contradiction:

Improvemigration management easeVSAvoidmigration duration

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The migration process is segmented into independent steps that can be executed in parallel while maintaining manageable complexity through structured organization. Each segmented migration step can be independently monitored and controlled, enabling parallel execution to reduce duration while preserving ease of management through the segmented structure.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

Real-time status feedback enables the system to manage parallel asynchronous migrations effectively. The status monitoring and reporting mechanisms provide visibility into migration progress, allowing operators to manage the process easily despite parallel execution, thereby reducing migration duration without sacrificing ease of operation.

Inventive Principle:

Principle #23Feedback

Data Source

PatentUS9633055B2Database migration

Publication Date: 2017.04.25 MICROSOFT TECHNOLOGY LICENSING LLC

AI summary

A migration framework includes a migration status data store that stores the migration status of a variety of different databases that are being migrated. A migration manager monitors the migration status of the different databases and invokes migration scripts to perform migration steps on the various databases, based upon their migration status. As the migration steps are completed, a status update component updates the migration status of the various databases that are being migrated.