SUPPORT FOR CLOUD-BASED MULTI-TENANT ENVIRONMENTS USING CONNECTION LABELING

• US 20140324911A1
• Filed: 06/06/2013
• Published: 10/30/2014
• Est. Priority Date: 04/26/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: de Lavarene, Jean, Zhou, Tong, Surber, Douglas, Felts, Stephen, Merrill, David
• Granted Patent: US 9,268,798 B2
• Time in Patent Office: Days
• US Class Current: 707/781
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/90 Details of database functions independent of the retrieved data types
• CPC Class Codes: G06F 2209/5011 Pool
• CPC Class Codes: G06F 9/5011 the resources being hardware resources other than CPUs, Servers and Terminals

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.

Claims

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 multiple tenants or tenant applications in a cloud-based environment;

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.

2. The system of claim 1, wherein each particular one of the multiple tenants or tenant applications can be associated with a labeled connection type, which connection type the particular applications use to connect to the database for that particular tenant.

3. The system of claim 1, wherein the connection pool includes support for the particular applications to use a configure callback to specify or set a container, to repurpose a particular connection from one of the multiple tenants or tenant applications to another of the multiple tenants or tenant application, which has the effect of switching the tenant on a particular database connection.

4. The system of claim 1, wherein the connection pool logic performs a process of

determining, for a received request, if there is an existing matching connection;

and

if there is an existing matching connection, returning the existing matching connection, otherwise

finding a cheapest non-matching connection and determining whether the cheapest non-matching connection cost is less than a high-cost value, and if so repurposing the cheapest non-matching connection for use with the request, otherwise

if the sum of all connections is less than a threshold value, creating a new connection for use with request, and returning the new connection, and

if the sum of all connections is greater than or equal to the threshold value, repurposing the cheapest connection for use with the request.

5. 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 multiple tenants or tenant applications in a cloud-based environment;

providing 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

using 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.

6. The method of claim 5, wherein each particular one of the multiple tenants or tenant applications can be associated with a labeled connection type, which connection type the particular applications use to connect to the database for that particular tenant.

7. The method of claim 5, wherein the connection pool includes support for the particular applications to use a configure callback to specify or set a container, to repurpose a particular connection from one of the multiple tenants or tenant applications to another of the multiple tenants or tenant application, which has the effect of switching the tenant on a particular database connection.

8. The method of claim 5, wherein the connection pool logic performs a process of

determining, for a received request, if there is an existing matching connection;

and

if there is an existing matching connection, returning the existing matching connection, otherwise

finding a cheapest non-matching connection and determining whether the cheapest non-matching connection cost is less than a high-cost value, and if so repurposing the cheapest non-matching connection for use with the request, otherwise

if the sum of all connections is less than a threshold value, creating a new connection for use with request, and returning the new connection, and

if the sum of all connections is greater than or equal to the threshold value, repurposing the cheapest connection for use with the request.

9. A non-transitory computer readable 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 a computer including a processor and a database, a multi-tenant cloud environment that includes or provides access to the database, for use by multiple tenants or tenant applications in a cloud-based environment;

providing 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

using 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.

10. The non-transitory computer readable medium of claim 9, wherein each particular one of the multiple tenants or tenant applications can be associated with a labeled connection type, which connection type the particular applications use to connect to the database for that particular tenant.

11. The non-transitory computer readable medium of claim 9, wherein the connection pool includes support for the particular applications to use a configure callback to specify or set a container, to repurpose a particular connection from one of the multiple tenants or tenant applications to another of the multiple tenants or tenant application, which has the effect of switching the tenant on a particular database connection.

12. The non-transitory computer readable medium of claim 9, wherein the connection pool logic performs a process of

determining, for a received request, if there is an existing matching connection;

and

if there is an existing matching connection, returning the existing matching connection, otherwise

finding a cheapest non-matching connection and determining whether the cheapest non-matching connection cost is less than a high-cost value, and if so repurposing the cheapest non-matching connection for use with the request, otherwise

if the sum of all connections is less than a threshold value, creating a new connection for use with request, and returning the new connection, and

if the sum of all connections is greater than or equal to the threshold value, repurposing the cheapest connection for use with the request.