Database Provisioning Resource Pre-allocation via Template Grouping

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

The process of provisioning databases in private clouds is laborious and time-consuming, often taking weeks or months, due to the difficulty in quantifying and qualifying new architectures, leading to 'Paralysis by Analysis' and inefficiencies in resource allocation.

Innovation Solution

A method of pre-allocating resources in a private cloud by determining database characteristics, grouping them into templates, and pre-allocating resources based on these templates, allowing for rapid provisioning of databases by selecting a template and customizing parameters, thereby reducing the time required for provisioning from weeks to minutes.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If traditional database provisioning processes are used, then resource allocation can be customized for each database, but the provisioning time becomes excessively long (weeks or months)

Engineering Contradiction:
Improveprovisioning speedVSAvoidprovisioning time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent applies preliminary action by pre-defining database templates with standardized configurations, resource allocations, and compatibility specifications before actual provisioning requests. This allows the system to skip time-consuming analysis and configuration steps during actual provisioning, reducing the time from weeks/months to minutes while maintaining customization through template selection.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent changes parameters by transforming individual database specifications into standardized template parameters. By categorizing databases into templates with predefined resource allocations, software requirements, and compatibility rules, the system enables rapid provisioning through parameter selection rather than time-consuming parameter analysis and configuration.

Inventive Principle:
Principle #35Parameter changes

2Reliability

If detailed analysis is performed to ensure compatibility and correctness of database provisioning, then reliability improves, but the process becomes paralyzed by analysis

Engineering Contradiction:
Improveprovisioning correctnessVSAvoidprocess complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent applies segmentation by dividing the complex provisioning process into distinct phases: template definition phase (where compatibility rules and resource requirements are pre-analyzed) and provisioning execution phase (where pre-validating templates are simply instantiated). This segmentation eliminates paralysis by analysis during execution while maintaining reliability through pre-established validation rules.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent performs compatibility analysis, resource allocation validation, and configuration verification in advance when creating database templates. This preliminary validation ensures provisioning correctness is established before actual deployment, eliminating the need for time-consuming analysis during the provisioning process itself.

Inventive Principle:
Principle #10Preliminary action

3Productivity

If resources are allocated dynamically based on individual database requirements, then resource utilization efficiency improves, but the provisioning process becomes laborious and time-consuming

Engineering Contradiction:
Improveprovisioning efficiencyVSAvoidprovisioning effort
Core Design Contradiction:
ProductivityVSEase of operation

Solution Approach 1:

The patent uses copying by creating reusable database templates that encapsulate proven resource allocation configurations. Instead of analyzing and allocating resources from scratch for each database, the system copies validated templates and instantiates them with specific parameters, dramatically reducing provisioning effort while maintaining resource allocation efficiency through template-based customization.

Inventive Principle:
Principle #26Copying

Data Source

PatentUS11036696B2Resource allocation for database provisioning
Publication Date: 2021.06.15 ORACLE INT CORP
  • US11036696B2 patent drawing
  • US11036696B2 patent drawing
  • US11036696B2 patent drawing

AI summary

A method of pre-allocating resources for database provisioning in a private cloud may include determining characteristics of a plurality of databases in a customer's database system. The method may also include grouping the characteristics of the plurality of databases to generate a plurality of database templates that are descriptive of the plurality of databases. The method may additionally include causing resources to be pre-allocated in the private cloud based on at least some of the plurality of database templates. The method may further include receiving a selection of a database template from the plurality of database templates as part of a provisioning request. The method may also include causing a database described at least in part by the database template to be provisioned in the private cloud.