System and method for eager relationship caching of entity beans

• US 20030182307A1
• Filed: 02/19/2003
• Published: 09/25/2003
• Est. Priority Date: 02/21/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: BEA Systems Incorporated (Oracle Corporation)
• Inventors: Chen, Michael, White, Seth
• Granted Patent: US 7,464,069 B2
• Time in Patent Office: Days
• US Class Current: 707/103X
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

A system and method for increasing entity bean performance in an application server environment. The system reduces the need for multiple or unnecessary queries by formulating a join query for the related beans and applying this query to the database. When a request is made to a database to read or retrieve a set of EJB beans, related beans are simultaneously retrieved and stored in a cache. In this manner, when the client sends a request for any of these related beans, they can be supplied from the cache rather than making another call to the database.

Claims

1. A system for caching of entity beans in a server environment, comprising:

an object relationship that defines a relationship between a plurality of object types, including a first object type and second object type;

a server that receives a request from a client to retrieve data from a database corresponding to a first object type and retrieving both first object type and second object type data from the database, as specified by said object relationship;

an object cache for temporary storage of first object type and second object type data; and

,

wherein a request from a client to retrieve. database information corresponding to the second object type causes the server to retrieve second object type data directly from the cache, without making another call to the database.

2. The system of claim 1 wherein the object relationship is between a first object type and a second object type.

4. The system of claim 1 wherein the object types are entity Java beans.

5. The system of claim 1 wherein the server retrieves said first object type and said second object type data from the database by forming a join query for the two or more object types, and applying said join query to the database.

6. The system of claim 4 wherein the server retrieves said first object type and said second object type data from the database by forming a structured query language join query for the two or more object types, and applying said join query to the database.

3. The system of claim I wherein the object relationship is between a plurality of object types.

7. A method for caching of entity beans in a server environment, comprising the steps of:

defining an object relationship between a first object type and a second object type;

receiving a request from a client to retrieve data from a database corresponding to the first object type;

retrieving both first object type and second object type data from the database, as specified by said object relationship;

placing the first object type and second object type data in an object cache;

receiving a request from a client to retrieve database information corresponding to the second object type; and

,

retrieving data corresponding to said second object type directly from said object cache, without making another call to the database.

8. The method of claim 7 wherein the object relationship is between a first object type and a second object type.

9. The method of claim 7 wherein the object relationship is between a plurality of object types.

10. The method of claim 7 wherein the object types are entity Java beans.

11. The method of claim 7 wherein the server retrieves said first object type and said second object type data from the database by forming a join query for the two or more object types, and applying said join query to the database.

12. The method of claim 10 wherein the server retrieves said first object type and said second object type data from the database by forming a structured query language join query for the two or more object types, and applying said join query to the database.

13. A computer readable medium, including instruction stored thereon which when executed by a computer causes the computer to perform the steps of:

interpreting an object relationship between a first object type and a second object type;

receiving a request from a client to retrieve data from a database corresponding to the first object type;

retrieving both first object type and second object type data from the database, as specified by said object relationship;

placing the first object type and second object type data in an object cache;

receiving a request from a client to retrieve database information corresponding to the second object type; and

,

providing data corresponding to said second object type directly from said object cache, without making another call to the database.

14. The computer readable medium of claim 13 wherein the object relationship is between a first object type and a second object type.

15. The computer readable medium of claim 13 wherein the object relationship is between a plurality of object types.

16. The computer readable medium of claim 13 wherein the object types are entity Java beans.

17. The computer readable medium of claim 13 wherein the server retrieves said first object type and said second object type data from the database by forming a join query for the two or more object types, and applying said join query to the database.

18. The computer readable medium of claim 16 wherein the server retrieves said first object type and said second object type data from the database by forming a structured query language join query for the two or more object types, and applying said join query to the database.