System and method for providing a second level connection cache for use with a database environment

• US 9,569,472 B2
• Filed: 04/15/2014
• Issued: 02/14/2017
• Est. Priority Date: 06/06/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Hegde, Vidya, de Lavarene, Jean, Chand, Pankaj, Surber, Douglas, Zhou, Tong
• Primary Examiner(s): Patel, Chirag R
• Application Number:
  US14/253,580
• Publication Number:
  US 20150026405A1
• Time in Patent Office: 1,036 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 12/0813 with a network or matrix configuration
• CPC Class Codes: G06F 12/0815 Cache consistency protocols
• CPC Class Codes: G06F 12/0868 Data transfer between cache memory and other subsystems, e.g. storage devices or host systems
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/9574 of access to content, e.g. by caching
• CPC Class Codes: G06F 2212/465 Structured object, e.g. database record

Abstract

Described herein is a system and method for providing a level 2 connection cache for use with a database environment. In accordance with an embodiment, a second level, or level 2 (L2), connection cache is used to cache no-session connections for use with a database. When a connection is requested, a no-session connection (NSC) can be retrieved from the cache and a database session is attached. Later, when the connection is closed, the database session is logged off and the no-session connection returned to the cache for subsequent use.

Claims

1. A system for providing a second-level connection cache for use with a database environment, comprising:

a computer including a processor and a database;

an application server, wherein the application server includes a data source, wherein the data source is associated with a first-level data source connection cache, wherein the first-level data source connection cache includes at least one first-level database connection object, and wherein each first-level database connection object is attached to a session of the database;

a second-level connection cache, which caches a plurality of no-session connection objects, wherein each no-session connection object includes a socket to the database together with network protocol information, and wherein each no-session connection is unattached to any session of the database;

wherein, the data source receives a request for a connection from the software application;

wherein, if there is an idle first-level database connection object in the first-level database connection cache, then the data source returns the idle first-level database connection object to the software application in response to the request;

wherein, if each first-level database connection object in the first-level database connection cache is not idle and there is an idle no-session connection object in the second-level cache, then the system attaches a session of the database to the idle no-session connection object to form a complete connection object and returns the complete connection object to the software application in response to the request; and

wherein, if each first-level database connection object in the first-level database connection cache is not idle and each no-session connection object in the second-level cache is not idle, then the system creates an un-cached connection object and attaches a session of the database to the un-cached connection object to form a new un-cached connection object and returns the new un-cached connection object to the software application in response to the request.

2. The system of claim 1, wherein the first-level data source connection cache and the second-level connection cache are Universal Connection Pools (UCP) that provides access to the database using JDBC.

3. The system of claim 1, wherein the complete database connection object is closed by first attempting to store it in the data source connection cache, and if there is no available space in the data source connection cache, then the complete database connection object is detached from its attached database session, and then stored in the second-level connection cache.

4. The system of claim 1, wherein the data source connection cache and the second-level connection cache are of static sizes.

5. The system of claim 1, wherein the database environment is within a multi-tenant cloud environment.

6. The system of claim 1, wherein the data source connection cache and second-level connection cache are contained and managed by a single, global connection pool.

7. A method for providing a connection cache for use with a database environment, comprising:

providing an application server, wherein the application server includes a data source, wherein the data source is associated with a first-level data source connection cache, wherein the first-level data source connection cache includes at least one first-level database connection object, and wherein each first-level database connection object is attached to a session of the database;

providing a second-level connection cache, which caches a plurality of no-session connection objects, wherein each no-session connection object includes a socket to the database together with network protocol information, and wherein each no-session connection is unattached to any session of the database;

if there is an idle first-level database connection object in the first-level database connection cache, then returning, by the data source, the idle first-level database connection object to the software application;

if each first-level database connection object in the first-level database connection cache is not idle and there is an idle no-session connection object in the second-level cache, then attaching, by the system, a session of the database to the idle no-session connection object to form a complete connection object and returning the complete connection object to the software application; and

if each first-level database connection object in the first-level database connection cache is not idle and each no-session connection object in the second-level cache is not idle, then creating, by system, an un-cached connection object and attaching a session of the database to the un-cached connection object to form a new un-cached connection object and returning the new un-cached connection object to the software application.

8. The method of claim 7, wherein the data source connection cache and the second-level connection cache are Universal Connection Pools (UCP) that provides access to the database using JDBC.

9. The method of claim 7, wherein the complete database connection object is closed by first attempting to store it in the data source connection cache, and if there is no available space in the data source connection cache, then the complete database connection object is detached from its attached database session, and then stored in the second-level connection cache.

10. The method of claim 7, wherein all the data source connection cache and the second-level connection cache are of static sizes.

11. The method of claim 7, wherein the database environment is within a multi-tenant cloud environment.

12. The method of claim 7, wherein the data source connection cache and second-level connection cache are contained and managed by a single, global connection pool.

13. 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 an application server, wherein the application server includes a data source, wherein the data source is associated with a first-level data source connection cache, wherein the first-level data source connection cache includes at least one first-level database connection object, and wherein each first-level database connection object is attached to a session of the database;

providing a second-level connection cache, which caches a plurality of no-session connection objects, wherein each no-session connection object includes a socket to the database together with network protocol information, and wherein each no-session connection is unattached to any session of the database;

if there is an idle first-level database connection object in the first-level database connection cache, then returning, by the data source, the idle first-level database connection object to the software application;

if each first-level database connection object in the first-level database connection cache is not idle and there is an idle no-session connection object in the second-level cache, then attaching, by the system, a session of the database to the idle no-session connection object to form a complete connection object and returning the complete connection object to the software application; and

if each first-level database connection object in the first-level database connection cache is not idle and each no-session connection object in the second-level cache is not idle, then creating, by system, an un-cached connection object and attaching a session of the database to the un-cached connection object to form a new un-cached connection object and returning the new un-cached connection object to the software application.