# US 2020/0004838 A9 · Provisioning of pluggable databases using a central repository

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2020/0004838 A9
- Document ID: US20200004838A9
- Status: Published application
- Kind: A9
- Application number: 15/266,902
- Filed: 2016-09-15
- Published: 2020-01-02
- Earliest claimed: 2015-10-23
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Andre Kruglikov; Kumar Rajamani; Debaditya Chatterjee
- Web page: https://patentgrep.com/patent/US20200004838A9

## CPC

- G06F 8/62: {Uninstallation}
- G06F 8/63: {Image based installation; Cloning; Build to order}
- G06F 16/214: {Database migration support}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim 1

A method comprising:
loading a plurality of rules into a rules engine, wherein each rule of the plurality of rules associates a predicate with suitable container databases of a plurality of container databases;
receiving a request to install a target pluggable database;
detecting, by the rules engine, 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 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.

### Claim 2 (depends on 1)

The method of claim 1 wherein:
each rule of the satisfied rules specifies a priority;
selecting the particular container database comprises selecting a rule of the satisfied rules that has a highest priority.

### Claim 3 (depends on 1)

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

### Claim 4 (depends on 1)

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.

### Claim 5 (depends on 1)

The method of claim 1 wherein:
the predicate of each rule of the satisfied rules specifies a criterion;
the criterion identifies at least one of: a recovery policy, a replication policy, a host capacity, a level of service, a downtime policy, a data retention policy, a maximum size, an availability of a feature, or a concurrency level.

### Claim 6 (depends on 5)

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 maximum size is a maximum size of a pluggable database.

### Claim 7

A method comprising:
storing a plurality of template pluggable databases in a repository;
receiving an installation request at the repository;
selecting, based on the installation request, a particular template pluggable database of the plurality of template pluggable databases;
installing the particular template pluggable database into a container database.

### Claim 8 (depends on 7)

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

### Claim 9 (depends on 7)

The method of claim 7 wherein:
the installation request specifies a service name;
selecting the particular template pluggable database comprises using the service name as a lookup key to select the particular template pluggable database.

### Claim 10 (depends on 7)

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

### Claim 11

One or more non-transitory computer-readable media storing instructions comprising:
first 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 associates a predicate with suitable container databases of a plurality of container databases;
second instructions that, when executed by one or more processors, cause receiving a request to install a target pluggable database;
third instructions that, when executed by one or more processors, cause detecting, by the rules engine, satisfied rules of the plurality of rules whose predicates match the request;
fourth instructions that, when executed by one or more processors, cause selecting, by the rules engine and based on the suitable container databases of the satisfied rules, a particular container database;
fifth instructions that, when executed by one or more processors, cause installing the target pluggable database into the particular container database.

### Claim 12 (depends on 11)

The one or more non-transitory computer-readable media of claim 11 wherein:
each rule of the satisfied rules specifies a priority;
selecting the particular container database comprises selecting a rule of the satisfied rules that has a highest priority.

### Claim 13 (depends on 11)

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

### Claim 14 (depends on 11)

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 comprise:
sixth instructions that, when executed by one or more processors, cause reconfiguring the software application to access the target pluggable database;
seventh instructions that, when executed by one or more processors, cause uninstalling the source pluggable database.

### Claim 15 (depends on 11)

The one or more non-transitory computer-readable media of claim 11 wherein:
the predicate of each rule of the satisfied rules specifies a criterion;
the criterion identifies at least one of: a recovery policy, a replication policy, a host capacity, a level of service, a downtime policy, a data retention policy, a maximum size, an availability of a feature, or a concurrency level.

### Claim 16 (depends on 15)

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 maximum size is a maximum size of a pluggable database.

### Claim 17

One or more non-transitory computer-readable media storing instructions comprising:
first instructions that, when executed by one or more processors, cause storing a plurality of template pluggable databases in a repository;
second instructions that, when executed by one or more processors, cause receiving an installation request at the repository;
third instructions that, when executed by one or more processors, cause selecting, based on the installation request, a particular template pluggable database of the plurality of template pluggable databases;
fourth instructions that, when executed by one or more processors, cause installing the particular template pluggable database into a container database.

### Claim 18 (depends on 17)

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

### Claim 19 (depends on 17)

The one or more non-transitory computer-readable media of claim 17 wherein:
the installation request specifies a service name;
selecting the particular template pluggable database comprises using the service name as a lookup key to select the particular template pluggable database.

### Claim 20 (depends on 17)

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.
