US5995972A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for retrieving data
Assignee: Oracle International Corp
•
Filing: 1996-12-30
•
Granted: 1999-11-30
•
Expires: 2016-12-30
Abstract
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.
Inventors
- 👤 Axel J. Allgeier
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 19:18
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/10; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99941; Y10S707/99944
Claims Analysis
Total Claims: 24
Claim 1
Independent Claim
254 words
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.
Claim 2
Independent Claim
254 words
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.
Claim 3
Dependent Claim
34 words
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.
Claim 4
Dependent Claim
23 words
A computer program embodied in a tangible medium and capable of being executed by a computer for performing the method of claim 1.
Claim 5
Independent Claim
301 words
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.
Claim 6
Independent Claim
301 words
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.
Claim 7
Dependent Claim
34 words
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.
Claim 8
Dependent Claim
236 words
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.
Claim 9
Dependent Claim
236 words
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.
Claim 10
Dependent Claim
40 words
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.
Claim 11
Dependent Claim
36 words
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.
Claim 12
Dependent Claim
250 words
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.
Claim 13
Dependent Claim
250 words
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.
Claim 14
Dependent Claim
40 words
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.
Claim 15
Dependent Claim
36 words
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.
Claim 16
Independent Claim
201 words
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.
Claim 17
Independent Claim
201 words
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.
Claim 18
Dependent Claim
14 words
The method of claim 12, wherein the primary access location is said one node.
Claim 19
Dependent Claim
28 words
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.
Claim 20
Dependent Claim
23 words
A computer program embodied in a tangible medium and capable of being executed by a computer for performing the method of claim 12.
Claim 21
Dependent Claim
167 words
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.
Claim 22
Dependent Claim
167 words
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.
Claim 23
Dependent Claim
27 words
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.
Claim 24
Dependent Claim
27 words
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.
References Cited (Backward Citations)
US5475836A
Cited
US5329628A
Cited
US5557792A
Cited
US5506984A
Cited
US5721904A
Cited
US5560005A
Cited
US5696695A
Cited
US5689238A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-11-29 | 2003-05-31 | 2003-11-30 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-11-29 | 2007-05-31 | 2007-11-30 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-11-29 | 2011-05-31 | 2011-11-30 | $7700.00 | Window Closed / Lapsed |