Support for cloud-based multi-tenant environments using connection labeling

Patent metadata

Field	Value
Publication number	US-9268798-B2
Application number	US-201313912098-A
Country	US
Kind code	B2
Filing date	Jun 6, 2013
Priority date	Apr 26, 2013
Publication date	Feb 23, 2016
Grant date	Feb 23, 2016

Abstract

A system and method for connection labeling for use with connection pools, including support for cloud-based multi-tenant environments using connection labeling. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and controls the creation or repurposing of high-cost connections to serve requests from the multiple tenants or tenant applications.

First claim

What is claimed is:

1. A system for connection labeling for use with connection pools, comprising:
a computer including a processor and a database, and providing a multi-tenant cloud environment that includes or provides access to the database, for use by a plurality of tenant applications in a cloud-based environment;
a connection pool, including a plurality of connection objects which provide connections that the plurality of tenant applications use to make requests to access the database, wherein each connection of the connections is labeled according to configuration information of one or more of the plurality of tenant applications; and a connection pool logic that operates to
receive a request, from a tenant application, for a connection with a particular label,
invoke a cost callback method to calculate, for each idle connection in the connection pool, a cost for reconfiguring that idle connection to a state associated with the particular label,
identify one or more of the idle connections as high-cost connections by comparing the calculated cost associated with each idle connection, with a high-cost value, wherein each identified high-cost connection is associated with a calculated cost larger than the high-cost value,
determine whether a total number of active and idle connections in the connection pool is less than a threshold value defined by the tenant application, and
based on a result of the determining, create a new connection, or repurpose one identified high-cost connection of the identified high-cost connections to serve the request from the tenant application.

2. The system of claim 1 , wherein each particular one of the plurality of tenant applications is associated with a labeled connection type that the tenant application uses to connect to the database.

3. The system of claim 1 , wherein the connection pool includes support for the tenant application to use a configure callback to repurpose a particular connection from the tenant application to another of the plurality of tenant applications, which has the effect of switching the tenant application on the particular connection.

4. The system of claim 1 , wherein the connection pool logic further performs the steps comprising
determining, for the received request, if there is an existing matching connection; and
if there is an existing matching connection, returning the existing matching connection.

5. The system of claim 1 , wherein the cost for configuring each idle connection to the state associated with the particular label is an estimated value.

6. The system of claim 1 , wherein the repurposed connection is the cheapest identified high-cost connection in the connection pool.

7. The system of claim 1 , wherein the state is defined by the particular label.

8. A method for connection labeling for use with connection pools, comprising:
providing, at a computer including a processor and a database, a multi-tenant cloud environment that includes or provides access to the database, for use by a plurality of tenant applications in a cloud-based environment;
providing a connection pool, including a plurality of connection objects which provide connections that the plurality of tenant applications use to make requests to access the database, wherein each connection of the connections is labeled according to configuration information of one or more of the plurality of tenant applications;
receiving a request, from a tenant application, for a connection with a particular label;
invoking a cost callback method to calculate, for each idle connection in the connection pool, a cost for reconfiguring that idle connection to a state associated with the particular label;
identifying, using a connection pool logic, one or more of the idle connections as high-cost connections by comparing the calculated cost associated with each idle connection, with a high-cost value;
determining whether a total number of active and idle connections in the connection pool is less than a threshold value; and
based on a result of the determining, creating a new connection, or repurposing one identified high-cost connection of the identified high-cost connections to serve the request from the tenant application.

9. The method of claim 8 , wherein each particular one of the plurality of tenant applications is associated with a labeled connection type that the tenant application uses to connect to the database.

10. The method of claim 8 , wherein the connection pool includes support for the tenant application to use a configure callback to repurpose a particular connection from the tenant application to another of the plurality of tenant applications, which has the effect of switching the tenant application on the particular connection.

11. The method of claim 8 , wherein the connection pool logic further performs the steps comprising
determining, for the received request, if there is an existing matching connection; and
if there is an existing matching connection, returning the existing matching connection.

12. The method of claim 8 , wherein the cost for configuring each idle connection to the state associated with the particular label is an estimated value.

13. The method of claim 8 , wherein the repurposed connection is the cheapest identified high-cost connection in the connection pool.

14. The method of claim 8 , wherein the state is defined by the particular label.

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:
configuring, at a computer including a processor and a database, a multi-tenant cloud environment that includes or provides access to the database, for use by a plurality of tenant applications in a cloud-based environment;
configuring a connection pool, including a plurality of connection objects which provide connections that the plurality of tenant applications use to make requests to access the database, wherein each connection of the connections is labeled according to configuration information of one or more of the plurality of tenant applications;
receiving a request, from a tenant application, for a connection with a particular label;
invoking a cost callback method to calculate, for each idle connection in the connection pool, a cost for reconfiguring that idle connection to a state associated with the particular label;
identifying, using a connection pool logic, one or more of the idle connections as high-cost connections by comparing the calculated cost associated with each idle connection, with a high-cost value;
determining whether a total number of active and idle connections in the connection pool is less than a threshold value; and
based on a result of the determining, creating a new connection, or repurposing one identified high-cost connection of the identified high-cost connections to serve the request from the tenant application.

16. The non-transitory computer readable storage medium of claim 15 , wherein each particular one of the plurality of tenant applications is associated with a labeled connection type that the tenant application uses to connect to the database.

17. The non-transitory computer readable storage medium of claim 15 , wherein the connection pool includes support for the tenant application to use a configure callback to repurpose a particular connection from the tenant application to another of the plurality of tenant applications, which has the effect of switching the tenant application on the particu

Assignees

• Oracle Int Corp

Inventors

• De Lavarene Jean
• Zhou Tong
• Surber Douglas
• Felts Stephen
• Merrill David

Classifications

• G06F2209/5011

  Pool · CPC title

• G06F16/90

  Details of database functions independent of the retrieved data types · CPC title

• G06F9/5011 Primary

  the resources being hardware resources other than CPUs, Servers and Terminals · CPC title

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F17/30289 Primary

  Physics · mapped topic