System and method for providing a shareable global cache for use with a database environment

• US 9,747,341 B2
• Filed: 04/15/2014
• Issued: 08/29/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): Gofman, Alex
• Application Number:
  US14/253,573
• Publication Number:
  US 20150026213A1
• Time in Patent Office: 1,232 Days
• Field of Search: None
• CPC Class Codes: G06F 16/24552 Database cache management

Abstract

Described herein is a system and method for providing a shareable global cache for use with a database environment. In accordance with an embodiment, a shareable global cache is used for caching connections to database instances. When a request is received for a particular service, the system looks for an idle connection to that service, and, if none is available, locates an existing connection to a database instance serving that service and switches a service on the existing connection to that service.

Claims

1. A system for providing a global cache for use with a database environment, the system comprising:

a computer including a processor;

a database that includes a plurality of database instances, wherein each of the plurality of database instances hosts one or more services;

an application server on the computer, wherein the application server includes

a plurality of data sources and a plurality of connection caches, wherein each data source is associated with a connection cache that includes a plurality of connections, and

a global cache shared by the plurality of data sources, wherein the global cache includes a plurality of connections,

wherein each connection in the plurality of connection caches and the global cache is configured for a service hosted on one or more instances of the plurality of database instances; and

whereupon receiving, at one of the plurality of data sources, a request for a service, the system

determines that an idle connection configured for the requested service is not available in the connection cache associated with the data source that receives the request or in the global cache,

identifies, from the plurality of database instances, a database instance that hosts the requested service;

locates, within the global cache, an idle connection configured for a different service on the identified database instance,

repurposes the idle connection configured for the different service, wherein the repurposing includes switching the different service which the idle connection is configured for to the requested service, and

directs the request to the requested service on the identified database instance using the repurposed idle connection.

2. The system according to claim 1, further comprising

a data defining a service topology, which describes a plurality of services that the database instances host.

3. The system according to claim 1, wherein the global cache includes one or more connections not attached with a database session.

4. The system according to claim 1, wherein the identified database instance is the least loaded database instance.

5. The system according to claim 1, wherein each connection in the plurality of connection caches associated with the plurality of data sources and the global cache further includes information describing a name of the service that the connection is configured for.

6. The system according to claim 1, wherein the database and application server are used in a multi-tenant cloud environment.

7. The system of claim 1, wherein when a connection in a connection cache associated with a data source is closed, the connection is stored in the global cache.

8. A method for providing a global cache for use with a database environment, the method comprising:

providing an application server executing on a microprocessor, wherein the application server includes

a plurality of data sources and a plurality of connection caches, wherein each data source is associated with a connection cache that includes a plurality of connections, and

a global cache, which includes a plurality of connections,

wherein each connection in the plurality of connection caches and the global cache is configured for a service hosted on one or more database instances of a plurality of database instances in a database;

receiving, at one of the plurality of data sources, a request for a service;

determining that an idle connection configured for the requested service is not available in the connection cache associated with the data source that receives the request or in the global cache;

identifying, from the plurality of database instances, a database instance that hosts the requested service;

locating, within the global cache, an idle connection configured for a different service on the identified database instance;

repurposing the idle connection configured for the different service, wherein the repurposing includes switching the different service which the idle connection is configured for to the requested service; and

directing the request to the requested service on the identified database instance using the repurposed idle connection.

9. The method according to claim 8, further comprising

providing a data defining a service topology, which describes a plurality of services that the database instances host.

10. The method according to claim 8, wherein the global cache includes one or more connections not attached with a database session.

11. The method according to claim 8, wherein the identified database instance is the least loaded database instance.

12. The method according to claim 8, wherein each connection in the plurality of connection caches associated with the plurality of data sources and the global cache further includes information describing a name of the service that the connection is configured for.

13. The method of claim 8, wherein when a connection in a connection cache associated with a data source is closed, the connection is stored in the global cache.

14. A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more microprocessors cause the one or more microprocessors to perform the steps comprising:

configuring an application server to include

a plurality of data sources and a plurality of connection caches, wherein each data source is associated with a connection cache that includes a plurality of connections, and

a global cache, which includes a plurality of connections,

wherein each connection in the plurality of connection caches and the global cache is configured for a service hosted on one or more database instances of a plurality of database instances in a database;

receiving, at one of the plurality of data sources, a request for a service;

determining that an idle connection configured for the requested service is not available in the connection cache associated with the data source that receives the request or in the global cache;

identifying, from the plurality of database instances, a database instance that hosts the requested service;

locating, within the global cache, an idle connection configured for a different service on the identified database instance;

repurposing the idle connection configured for the different service, wherein the repurposing includes switching the different service which the idle connection is configured for to the requested service; and

directing the request to the requested service on the identified database instance using the repurposed idle connection.

15. The non-transitory computer readable storage medium according to claim 14, wherein the instructions further cause the one or more microprocessors to perform the step of

configuring a data defining a service topology on the application server, wherein the service topology describes a plurality of services that the database instances host.

16. The non-transitory computer readable storage medium according to claim 14, wherein the global cache includes one or more connections not attached with a database session.

17. The non-transitory computer readable storage medium according to claim 14, wherein the identified database instance is the least loaded database instance.

18. The non-transitory computer readable storage medium according to claim 14, wherein each connection in the plurality of connection caches associated with the plurality of data sources and the global cache further includes information describing a name of the service that the connection is configured for.

19. The non-transitory computer readable storage medium according to claim 14, wherein the database and application server are used in a multi-tenant cloud environment.

20. The non-transitory computer readable storage medium according to claim 14, wherein when a connection in a connection cache associated with a data source is closed, the connection is stored in the global cache.