Cloud Database Migration Configuration Recommendation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing solutions for migrating on-premises database instances to the cloud are cumbersome and result in subpar customer satisfaction, leading to challenges in encouraging customers to migrate.

Innovation Solution

A statistically robust approach is used to recommend an optimal compute resource configuration for cloud-based resources by matching a customer's usage profile with similar cloud customers, ensuring recommendations are flexible and based on typical resource usage patterns.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If generic migration methods are used, then migration can be completed, but customer satisfaction is subpar and the process is cumbersome

Engineering Contradiction:
Improvemigration processVSAvoidcustomer satisfaction
Core Design Contradiction:
Ease of operationVSReliability

Solution Approach 1:

The system transforms migration recommendations from generic fixed configurations to personalized dynamic configurations by analyzing customer-specific usage patterns and transforming them into optimized resource allocations that adapt to individual workload characteristics

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The system enables customers to benefit from automated analysis of their own usage patterns, where the migration recommendation system independently evaluates their workload characteristics and generates personalized recommendations without requiring manual input or expertise from the customer

Inventive Principle:
Principle #25Self-service

2Reliability

If compute resources are allocated to ensure performance, then application throttling is reduced, but resource allocation and power consumption increase

Engineering Contradiction:
Improveapplication performanceVSAvoidpower consumption
Core Design Contradiction:
ReliabilityVSUse of energy by moving object

Solution Approach 1:

The system applies partial action by allocating compute resources dynamically based on actual usage patterns rather than providing full maximum capacity, ensuring sufficient resources are available during peak usage while avoiding unnecessary resource allocation during low-utilization periods

Inventive Principle:
Principle #16Partial or excessive action

Solution Approach 2:

The system implements dynamic resource allocation that adapts to changing workload conditions, allowing resource configuration to flex and adjust based on actual usage patterns rather than remaining static, thereby optimizing the balance between performance reliability and energy consumption

Inventive Principle:
Principle #15Dynamics

3Ease of operation

If migration solutions are simplified, then ease of migration improves, but customization and optimization for individual customers decrease

Engineering Contradiction:
Improvemigration processVSAvoidrecommendation customization
Core Design Contradiction:
Ease of operationVSAdaptability or versatility

Solution Approach 1:

The system automatically analyzes each customer's specific usage patterns and workload characteristics to generate personalized migration recommendations, eliminating the need for manual customization while maintaining high adaptability to individual customer needs

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system incorporates feedback from actual customer usage patterns and migration outcomes to continuously refine and personalize recommendations, creating a loop where each customer's specific data informs their customized migration strategy without requiring manual intervention

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS20250190280A1Cloud-based compute resource configuration recommendation and allocation for database migration
Publication Date: 2025.06.12 MICROSOFT TECHNOLOGY LICENSING LLC
  • US20250190280A1 patent drawing
  • US20250190280A1 patent drawing
  • US20250190280A1 patent drawing

AI summary

Methods, systems, apparatuses, and computer-readable storage mediums described herein are directed to determining and recommending an optimal compute resource configuration for a cloud-based resource (e.g., a server, a virtual machine, etc.) for migrating a customer to the cloud. The embodiments described herein utilize a statistically robust approach that makes recommendations that are more flexible (elastic) and account for the full distribution of the amount of resource usage. Such an approach is utilized to develop a personalized rank of relevant recommendations to a customer. To determine which compute resource configuration to recommend to the customer, the customer's usage profile is matched to a set of customers that have already migrated to the cloud. The compute resource configuration that reaches the performance most similar to the performance of the configurations utilized by customers in the matched set is recommended to the user.