Provisioning of pluggable databases using a central repository

• US 10,606,578 B2
• Filed: 09/15/2016
• Issued: 03/31/2020
• Est. Priority Date: 10/23/2015
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Kruglikov, Andre, Rajamani, Kumar, Chatterjee, Debaditya
• Primary Examiner(s): Pham, Khanh B
• Application Number:
  US15/266,902
• Publication Number:
  US 20180075044A1
• Time in Patent Office: 1,293 Days
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 8/62 Uninstallation
• CPC Class Codes: G06F 8/63 Image based installation; Cloning; Build to order

Abstract

Techniques herein use rules automation and template pluggable databases to facilitate deployment into container databases. In an embodiment, a system of computers loads rules into a rules engine. Each rule associates a predicate with suitable container databases. The system receives a request to install a target pluggable database. The rules engine detects satisfied rules whose predicates match the request. Based on the suitable container databases of the satisfied rules, the rules engine selects a particular container database. The system installs the target pluggable database into the particular container database. In an embodiment, a system of computers stores a plurality of template pluggable databases in a repository. The repository receives an installation request. Based on the installation request, the system selects a particular template pluggable database. The system installs the particular template pluggable database into a container database.

Claims

1. A method comprising:

loading a plurality of rules into a rules engine, wherein each rule of the plurality of rules contains a predicate and a respective list that consists of multiple suitable container databases of a plurality of container databases that satisfy the rule, wherein said loading comprises at least one of;

loading said plurality of rules as text, or loading said plurality of rules from a database, wherein the predicate contains a compound expression that has multiple terms connected by one or more operators;

receiving a request to install a target pluggable database;

detecting, by the rules engine, one or more satisfied rules of the plurality of rules whose predicates match the request;

selecting, by the rules engine and based on the suitable container databases of the one or more satisfied rules, a particular container database;

installing the target pluggable database into the particular container database;

wherein the method is performed by one or more computers.

2. The method of claim 1 wherein:

each rule of the one or more satisfied rules specifies a priority;

selecting the particular container database comprises selecting a rule of the one or more satisfied rules that has a highest priority.

3. The method of claim 1 wherein detecting one or more satisfied rules comprises generating a structured query language (SQL) where clause.

4. The method of claim 1 wherein:

a source container database comprises a source pluggable database;

a software application is configured to access the source pluggable database;

the method further comprises;

reconfiguring the software application to access the target pluggable database;

uninstalling the source pluggable database.

5. The method of claim 1 wherein

the predicate of each rule of the one or more satisfied rules specifies a criterion that identifies at least one of:

a recovery policy, a replication policy, a downtime policy, a data retention policy, an availability of a feature, or a concurrency level.

6. The method of claim 5 wherein at least one of:

the downtime policy specifies a minimum uptime, a maximum downtime, or a minimum mean time between failures (MTBF);

the concurrency level comprises a maximum number of concurrent network sessions;

or

the predicate of each rule of the satisfied rules specifies a second criterion that identifies a maximum size of a pluggable database.

10. The method of claim 1 wherein:

the request to install the target pluggable database specifies an amount of a resource;

selecting the particular container database comprises detecting that the particular container database has the least amount of said resource of said suitable container databases of the one or more satisfied rules.

7. A method comprising:

storing a first plurality of template pluggable databases in a repository that associates a service name with a second plurality of template pluggable databases that is a subset of the first plurality of template pluggable databases;

receiving an installation request that specifies said service name;

using, in response to said receiving said installation request, said service name as a lookup key to select, from said repository, said second plurality of template pluggable databases;

selecting, based on the installation request, a particular template pluggable database of the second plurality of template pluggable databases;

installing the particular template pluggable database into a container database.

8. The method of claim 7 wherein the installation request identifies the particular template pluggable database.

9. The method of claim 7 further comprising executing a structured query language (SQL) statement on the particular template pluggable database within the container database.

11. One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause:

loading a plurality of rules into a rules engine, wherein each rule of the plurality of rules contains a predicate and a respective list that consists of multiple suitable container databases of a plurality of container databases that satisfy the rule, wherein said loading comprises at least one of;

loading said plurality of rules as text, or loading said plurality of rules from a database, wherein the predicate contains a compound expression that has multiple terms connected by one or more operators;

receiving a request to install a target pluggable database;

detecting, by the rules engine, one or more satisfied rules of the plurality of rules whose predicates match the request;

selecting, by the rules engine and based on the suitable container databases of the one or more satisfied rules, a particular container database;

installing the target pluggable database into the particular container database.

12. The one or more non-transitory computer-readable media of claim 11 wherein:

each rule of the one or more satisfied rules specifies a priority;

selecting the particular container database comprises selecting a rule of the one or more satisfied rules that has a highest priority.

13. The one or more non-transitory computer-readable media of claim 11 wherein detecting the one or more satisfied rules comprises generating a structured query language (SQL) where clause.

14. The one or more non-transitory computer-readable media of claim 11 wherein:

a source container database comprises a source pluggable database;

a software application is configured to access the source pluggable database;

the instructions further cause;

reconfiguring the software application to access the target pluggable database;

uninstalling the source pluggable database.

15. The one or more non-transitory computer-readable media of claim 11 wherein

the predicate of each rule of the one or more satisfied rules specifies a criterion that identifies at least one of:

a recovery policy, a replication policy, a downtime policy, a data retention policy, an availability of a feature, or a concurrency level.

16. The one or more non-transitory computer-readable media of claim 15 wherein at least one of:

the downtime policy specifies a minimum uptime, a maximum downtime, or a minimum mean time between failures (MTBF);

the concurrency level comprises a maximum number of concurrent network sessions;

or

the predicate of each rule of the satisfied rules specifies a second criterion that identifies a maximum size of a pluggable database.

17. One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause:

storing a first plurality of template pluggable databases in a repository that associates a service name with a second plurality of template pluggable databases that is a subset of the first plurality of template pluggable databases;

receiving an installation request that specifies said service name;

using, in response to said receiving said installation request, said service name as a lookup key to select, from said repository, said second plurality of template pluggable databases;

selecting, based on the installation request, a particular template pluggable database of the second plurality of template pluggable databases;

installing the particular template pluggable database into a container database.

18. The one or more non-transitory computer-readable media of claim 17 wherein the installation request identifies the particular template pluggable database.

19. The one or more non-transitory computer-readable media of claim 17 wherein the instructions further comprise instructions that, when executed by one or more processors, cause executing a structured query language (SQL) statement on the particular template pluggable database within the container database.