Resource allocation for database provisioning

Patent metadata

Field	Value
Publication number	US-11036696-B2
Application number	US-201615175213-A
Country	US
Kind code	B2
Filing date	Jun 7, 2016
Priority date	Jun 7, 2016
Publication date	Jun 15, 2021
Grant date	Jun 15, 2021

Abstract

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.

First claim

What is claimed is:

1. A method of pre-allocating resources for database provisioning in a cloud, the method comprising:
determining characteristics of a plurality of databases operating and provisioned in a customer's database system outside of the cloud that are storing and providing the customer's data;
grouping the characteristics of the plurality of databases based at least in part on customer usage of the plurality of databases to generate a plurality of database templates specific to the customer's database system that are descriptive of the plurality of databases, wherein a database template in the plurality of database templates comprises one or more variable parameters that are not uniform across a group of the plurality of databases on which the database template is based;
creating a plurality of service levels that correspond to increasing performance requirements;
for each of the plurality of service levels, assigning a template from the plurality of templates to the service level that provides a level of performance that matches the performance requirement of the service level;
causing resources to be pre-allocated in the cloud, including installing database and operating system combinations that are not pre-installed in the cloud based on at least some of the plurality of database templates prior to receiving a provisioning request from the customer's database system;
receiving the provisioning request comprising a selection of a first service level in the plurality of service levels, wherein the plurality of service levels are provided as available options for the provisioning request;
determining that the database template is assigned to the first service level;
receiving values with the provisioning request for the one or more variable parameters of the database template to complete the database template; and
causing a database described at least in part by the database template to be provisioned in the cloud using at least one of the database and operating system combinations that were pre-installed prior to receiving the provisioning request.

2. The method of claim 1 , wherein the characteristics of the plurality of databases comprise an operating system type and version.

3. The method of claim 1 , wherein the characteristics of the plurality of databases comprise a database type and version.

4. The method of claim 1 , wherein the characteristics of the plurality of databases comprise a database memory size.

5. The method of claim 1 , wherein the characteristics of the plurality of databases comprise processor usage.

6. The method of claim 1 , wherein the characteristics of the plurality of databases are determined by one or more software agents installed on the customer's database system that transmit the characteristics through a gateway to a cloud support platform.

7. The method of claim 6 , wherein the cloud support platform generates real-time reports of the characteristics of the plurality of databases.

8. A non-transitory, computer-readable medium comprising instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
determining characteristics of a plurality of databases operating and provisioned in a customer's database system outside of a cloud that are storing and providing the customer's data;
grouping the characteristics of the plurality of databases based at least in part on customer usage of the plurality of databases to generate a plurality of database templates specific to the customer's database system that are descriptive of the plurality of databases, wherein a database template in the plurality of database templates comprises one or more variable parameters that are not uniform across a group of the plurality of databases on which the database template is based;
creating a plurality of service levels that correspond to increasing performance requirements;
for each of the plurality of service levels, assigning a template from the plurality of templates to the service level that provides a level of performance that matches the performance requirement of the service level;
causing resources to be pre-allocated in the cloud, including installing database and operating system combinations that are not pre-installed in the cloud based on at least some of the plurality of database templates prior to receiving a provisioning request from the customer's database system;
receiving the provisioning request comprising a selection of a first service level in the plurality of service levels, wherein the plurality of service levels are provided as available options for the provisioning request;
determining that the database template is assigned to the first service level;
receiving values with the provisioning request for the one or more variable parameters of the database template to complete the database template; and
causing a database described at least in part by the database template to be provisioned in the cloud using at least one of the database and operating system combinations that were pre-installed prior to receiving the provisioning request.

9. The non-transitory, computer-readable medium of claim 8 wherein grouping the characteristics of the plurality of databases to generate the plurality of database templates comprises:
dividing the characteristics into at least a first group of characteristics and a second group of characteristics, wherein:
the first group of characteristics comprises characteristics that are shared between two or more of the plurality of databases; and
the second group of characteristics comprises characteristics that are unique to at least one of the two or more of the plurality of databases.

10. The non-transitory, computer-readable medium of claim 9 wherein the first group of characteristics comprises an operating system, a database version number, and a database type.

11. The non-transitory, computer-readable medium of claim 9 wherein the second group of characteristics comprises a database memory size, a listener port, and a home directory path.

12. The non-transitory, computer-readable medium of claim 9 , comprising additional instructions that cause the one or more processors to perform additional operations comprising:
creating, after receiving the selection of the database template, a transient template that includes the first group of characteristics from the database template;
receiving input comprising values for the second group of characteristics; and
assigning the values for the second group of characteristics to the transient template.

13. The non-transitory, computer-readable medium of claim 12 , comprising additional instructions that cause the one or more processors to perform additional operations comprising:
maintaining the transient template in a library of templates while the database described at least in part by the database template is active in the cloud; and
deleting the transient template from the library of templates after the database described at least in part by the database template is no longer active in the cloud.

14. The non-transitory, computer-readable medium according to claim 13 , comprising additional instructions that cause the one or more processors to perform additional operations comprising:
querying, by a cloud support platform, the cloud to determine when the database described at least in part by the database template is no longer active in the cloud.

15. A system comprising:
one or more hardware processors; and
one or more hardware memory devices comprising instructions that, when executed by the one or mor

Assignees

• Oracle Int Corp

Inventors

• Higginson Antony Stephen
• Brandt Michael James
• Cremonini James Antony William
• Balch Nick
• Masterson John
• Hughes Paul

Classifications

• G06Q10/06 Primary

  Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling · CPC title

• G06F16/9535

  Search customisation based on user profiles and personalisation · CPC title

• G06F9/5061

  Partitioning or combining of resources · CPC title

• G06F16/285

  Clustering or classification · CPC title

• G06F16/212 Primary

  with details for data modelling support · CPC title