System and method for retrieving data

• US 5,995,972 A
• Filed: 12/30/1996
• Issued: 11/30/1999
• Est. Priority Date: 12/30/1996
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: JD Edwards World Source Company
• Inventors: Allgeier, Axel J.
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/774,427
• Time in Patent Office: 1,065 Days
• Field of Search: 707/10, 707/8, 707/103, 707/2, 707/3, 395/600, 340/568
• US Class Current: 1/1
• CPC Class Codes: G06F 16/10 File systems; File servers
• 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/99944 Object-oriented database structure

Abstract

A computing system according to the present invention includes data having a primary access location in the system and having a secondary access location in the system. The system also includes a computer running an application, where the application requests for the data having the primary and secondary access locations. In response to the application requesting the data, middleware on the computer determines whether the requested data is at the primary access location. If the data is at the primary access location, the middleware retrieves the requested data from the primary access location and sends the requested data to the application. In response to the data not being found at the primary access location, the middleware retrieves the data from the secondary access location. The middleware then sends the requested data to the application and stores a copy of the requested data at the primary access location. The middleware is implemented as software.

Claims

1. A method of retrieving data requested at a first node in a computer network, wherein the first node has a first database and wherein the first node is coupled to a second node having a second database, the method comprising the steps of:

maintaining access information indicating that a primary access location for select data is the first database and that a secondary access location for the select data is the second database;

receiving a request for the select data at the first node, the request generated by an application executing on the first node;

obtaining the access information for the select data primary access location;

initially querying the select data primary access location to determine whether the select data exists in the first database;

in response to determining that the select data exists in the first database, retrieving the select data from the first database;

in response to determining that the select data does not exist in the first database, sending a request from the first node to the second node for the select data;

obtaining the access information for the select data secondary access location;

in response to the request from the first node, subsequently querying the select data secondary access location to determine whether the select data exists in the second database; and

in response to determining that the select data exists in the second database, retrieving the select data from the second database, sending the select data to the first node, and writing the select data to the first database.

2. The method of claim 1, further comprising:

maintaining the access information at each of a plurality of nodes in the computer network of the primary and secondary access locations for different types of data.

3. A computer program embodied in a tangible medium and capable of being executed by a computer for performing the method of claim 1.

4. A method of retrieving data requested at a first node in a computer network, wherein the first node has a first database and wherein the first node is coupled to a second node having a second database, the method comprising the steps of;

maintaining access information indicating that a primary access location for select data is the first database and that a secondary access location for the select data is the second database;

receiving a request for the select data at the first node, the request generated by an application executing on the first node;

obtaining the access information for the select data primary access location;

initially querying the select data primary access location to determine whether the select data exists in the first database;

in response to determining that the select data exists in the first database, determining at the first node whether the select data in the first database is current;

in response to determining that the select data exists in the first database and is current, retrieving the select data from the first database;

in response to determining that the select data does not exist in the first database or in response to determining that the select data is not current in the first database, sending a request from the first node to the second node for the select data;

obtaining the access information for the select data secondary access location;

in response to the request from the first node, subsequently querying the select data secondary access location to determine whether the select data exists in the second database; and

in response to determining that the select data exists in the second database, retrieving the select data from the second database, sending the select data to the first node, and writing the select data to the first database.

5. The method of claim 4, further comprising:

maintaining the access information at each of a plurality of nodes in the computer network of the primary and secondary access locations for different types of data.

6. A computer network comprising:

a first node having a first database, a second node having a second database, and middleware means including a first object locator for enabling the querying of the first database and the second database, the object locator adapted to maintain access information indicating that a primary access location for the select data is the first database and that a secondary access location for the select data is the second database, the middleware means adapted to receive a request for the select data from an application executing on the first node, adapted to obtain the access information for the select data primary access location and to initially query the select data primary access location to determine whether the select data exists in the first database in response to receiving the request, and adapted to read the select data from the first database in response to determining that the select data exists in the first database; and

the middleware means further adapted to obtain the access information for the select data secondary access location and to subsequently query the select data secondary access location to determine whether the select data exists in the second database in response to determining that the select data does not exist in the first database, and adapted to send the requested data to the first database in response to determining that the requested data exists in the second database.

7. The computer network of claim 6, wherein the middleware means further includes a second object locator adapted to maintain second node access information indicating the primary and secondary access locations for data which may be needed by the second node.

8. The computer network of claim 6, wherein the first object locator is adapted to maintain other access information indicating the primary and secondary access locations for other data which may be needed by the first node.

9. A computer network comprising:

a first node having a first database, a second node having a second database, and middleware means including a first object locator for enabling the querying of the first database and the second database, the object locator adapted to maintain access information indicating that a primary access location for the select data is the first database and that a secondary access location is the second database, the middleware means adapted to receive a request for the select data from an application executing on the first node, adapted to obtain the access information for the select data primary access location and to initially query the select data primary access location to determine whether the select data exists and is current in the first database in response to receiving the request, and adapted to read the select data from the first database in response to determining that the select data exists in the first database and is current in the first database; and

p1 the middleware means further adapted to obtain the access information for the select data secondary access location and to subsequently query the select data secondary access location to determine whether the select data exists in the second database in response to determining that the select data does not exist or is not current in the first database, and adapted to send the selected data to the first database in response to determining that the requested data exists and is current in the second database.

10. The computer network of claim 9, wherein the middleware means further includes a second object locator adapted to maintain second node access information indicating the primary and secondary access locations for data which may be needed by the second node.

11. The computer network of claim 9, wherein the first object locator is adapted to maintain other access information indicating the primary and secondary access locations for other data which may be needed by the first node.

12. A method of retrieving data in a computer network, the method comprising:

maintaining access information at each of a plurality of nodes in the computer network indicating a primary access location and a secondary access location for select data;

receiving a request for the select data at one of the plurality of nodes, the request generated by an application executing on said node;

obtaining the access information for the select data primary access location;

initially determining whether the select data exists at the primary access location;

in response to the select data existing at the primary access location, retrieving the select data from the primary access location and providing the select data to the application executing on said node;

in response to the select data not existing at the primary access location, obtaining the access information for the select data secondary access location and subsequently determining whether the requested data exists at the secondary access location; and

in response to determining that the requested data exists at the secondary access location, retrieving the select data from the secondary access location, providing the select data to the application executing on said node, and writing the select data to the primary access location.

13. The method of claim 12, wherein the primary access location is said one node.

14. The method of claim 12, wherein different ones of the plurality of nodes maintain different access information indicating different primary and secondary access locations for the select data.

15. A computer program embodied in a tangible medium and capable of being executed by a computer for performing the method of claim 12.

16. A computer network, comprising;

database means for storing data required by an application;

middleware means for enabling the querying of said database means;

said middleware means including object locator means for maintaining access information identifying a primary access location and a secondary access location for said data on said database means;

wherein said middleware means is responsive to an application request for select data for obtaining said access information to identify a select data primary access location and a select data secondary access location for said select data, for initially querying said select data primary access location for said select data, for subsequently querying said select data secondary access location for said select data when said initial query indicates that said select data does not exist at said select data primary access location, and for causing said select data to be replicated at said select data primary access location when said subsequent query indicates that said select data does exist at said select data secondary access location.

17. A computer network according to claim 16, wherein said middleware means further includes just-in-time means for initiating said subsequent query of said select data secondary access location.

18. A computer network according to claim 16, further including object configuration means for specifying said select data primary access location and said select data secondary access location.