System and method for integrating a database with a service deployed on a cloud platform

Patent metadata

Field	Value
Publication number	US-9817994-B2
Application number	US-201414476557-A
Country	US
Kind code	B2
Filing date	Sep 3, 2014
Priority date	Oct 30, 2013
Publication date	Nov 14, 2017
Grant date	Nov 14, 2017

Abstract

Described herein are systems and methods for integrating a database into a cloud computing environment. In accordance with an embodiment, a system includes a service management engine (SME) configured to execute in the cloud environment and to access a provider type including coordinates to a database and authentication information for the database. When a service deployed to the cloud environment requests use of a database, the provider type can trigger creation of the database and a schema for use by the associated provider. In accordance with an embodiment, the provider type can include coordinates to a container database (CDB) and authentication information for the CDB. When a service deployed in the cloud environment requests a database, the provider type can trigger creation, via the CDB, of a pluggable database (PDB), with a schema for use by the service.

First claim

What is claimed is:

1. A system for integrating a database into a cloud computing environment, comprising:
one or more computers including a processor and the cloud computing environment executing thereon;
at least one service management engine including, for each service type of one or more service types, a service management engine that executes in the cloud computing environment and is associated with the service type and provisions service instances of the service type;
wherein the one or more service types includes a provider type that is associated with a provider service management engine and provides access information for a database, including coordinates to the database and authentication information for accessing the database; and
whereupon a service that is deployed in the cloud computing environment requests that a database instance be associated with the service, the provider service management engine
uses the provider type to create the database instance and a schema for use by the service,
wherein the database instance is then associated with the service.

2. The system of claim 1 , wherein the provider type includes coordinates to a container database (CDB) and authentication information for the CDB;
wherein when the service deployed in the cloud environment requests a database, the provider type triggers creation, via the CDB, of a pluggable database (PDB).

3. The system of claim 1 , wherein when the service is associated with a provider, the service creates a provider association resource object that tracks use of the provider by the service.

4. The system of claim 1 , wherein the provider type triggers creation of a table in the database.

5. The system of claim 4 , wherein upon termination of the service, the provider service management engine (SME) drops the schema and the table from the database.

6. The system of claim 2 , wherein the provider type triggers creation of a table in the PDB.

7. The system of claim 6 , wherein upon termination of a service, the provider service management engine (SME) drops the schema and the table from the PDB and deletes the PDB.

8. A method for integrating a database into a cloud computing environment, comprising:
providing, at one or more computers including the cloud computing environment executing thereon,
at least one service management engine including, for each service type of one or more service types, a service management engine that executes in the cloud computing environment and is associated with the service type and provisions service instances of the service type,
wherein the one or more service types includes a provider type that is associated with a provider service management engine and provides access information for a database, including coordinates to the database and authentication information for accessing the database; and

upon receiving a request that a database instance be associated with a service that is deployed in the cloud computing environment,
using the provider type to create the database instance and a schema for use by the service, and
associating the database instance with the service.

9. The method of claim 8 , wherein the provider type includes coordinates to a container database (CDB) and authentication information for the CDB; and further comprising:
creating, upon request for a database instance by the service, a pluggable database (PDB) via the CDB with a schema for use by the service.

10. The method of claim 8 , further comprising:
creating, via the service, a provider association resource object that tracks use of a provider by the service.

11. The method of claim 8 , further comprising:
creating, upon trigger by the provider type, a table in the database.

12. The method of claim 11 , further comprising:
dropping the schema and the table from the database upon termination of the service.

13. The method of claim 9 , further comprising:
creating, upon trigger by the provider type, a table in the PDB.

14. The method of claim 13 further comprising:
dropping the schema and the table from the PDB upon termination of a service; and
deleting the PDB.

15. A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps comprising:
providing, at one or more computers including the cloud computing environment executing thereon,
at least one service management engine including, for each service type of one or more service types, a service management engine that executes in the cloud computing environment and is associated with the service type and provisions service instances of the service type,
wherein the one or more service types includes a provider type that is associated with a provider service management engine and provides access information for a database, including coordinates to the database and authentication information for accessing the database; and

upon receiving a request that a database instance be associated with a service that is deployed in the cloud computing environment,
using the provider type to create the database instance and a schema for use by the service, and
associating the database instance with the service.

16. The non-transitory computer readable storage medium of claim 15 , wherein the provider type includes coordinates to a container database (CDB) and authentication information for the CDB;
wherein the non-transitory computer readable storage medium further includes instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps further comprising:
creating, upon request for a database by the service, a pluggable database (PDB) via the CDB.

17. The non-transitory computer readable storage medium of claim 15 , wherein the non-transitory computer readable storage medium further includes instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps further comprising:
creating, via the service, a provider association resource object that tracks use of the provider by the service.

18. The non-transitory computer readable storage medium of claim 15 , wherein the non-transitory computer readable storage medium further includes instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps further comprising
creating, upon trigger by the provider type, a table in the database; and
dropping the schema and the table from the database upon termination of the service.

19. The non-transitory computer readable storage medium of claim 16 , wherein the non-transitory computer readable storage medium further includes instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps further comprising:
creating, upon trigger by the provider type, a table in the PDB.

20. The non-transitory computer readable storage medium of claim 19 wherein the non-transitory computer readable storage medium further includes instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps further comprising:
dropping the schema and the table from the PDB upon termination of the service; and
deleting the PDB.

Assignees

• Oracle Int Corp

Inventors

• Jain Sakshi
• Saxena Kshitiz
• Muthukrishnan Shalini

Classifications

• H04L67/1002

  Electricity · mapped topic

• H04L41/5054

  Automatic deployment of services triggered by the service manager, e.g. service implementation by automatic configuration of network components · CPC title

• H04L41/02

  Standardisation; Integration · CPC title

• G06F2221/2141

  Access rights, e.g. capability lists, access control lists, access tables, access matrices · CPC title

• H04L41/5096

  wherein the managed service relates to distributed or central networked applications · CPC title