Patent US5897634A successfully refreshed from Google Patents.
US5897634A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Optimized caching of SQL data in an object server system
Assignee: International Business Machines Corp
•
Filing: 1997-05-09
•
Granted: 1999-04-27
•
Expires: 2017-05-09
Abstract
Abstract A computer-implemented component broker series server for optimized caching of SQL data is implemented. In an object-oriented computer system, relational data from a relational database is cached in a data cache. The object-oriented computer system has a server that includes an instance manager and that is connected to at least one client. Objects that represent the relational data are created and managed under control of the instance manager. The relational data is stored in the data cache, which includes a virtual memory data cache for each client.
Inventors
- 👤 Gopi Krishna Attaluri
- 👤 Catalina Y. Fan
- 👤 Gerald A. Fisher
- 👤 Robert Dean Jackson
- 👤 Harry Rohidas Nayak
- 👤 David J. Wisneski
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 06:05
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; G06F16/28; G06F16/289; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99938; Y10S707/99941; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 39
Claim 1
Independent Claim
89 words
A method in an object-oriented computer system for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and a shared global data cache for lookaside functions.
Claim 2
Independent Claim
89 words
A method in an object-oriented computer system for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and a shared global data cache for lookaside functions.
Claim 3
Independent Claim
119 words
A method in an object-oriented computer system for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein each object includes a data access object interface, further comprising, under control of the data access object interface, using a transaction identifier generated by a transaction monitor to identify the virtual memory data cache for each client.
Claim 4
Independent Claim
119 words
A method in an object-oriented computer system for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein each object includes a data access object interface, further comprising, under control of the data access object interface, using a transaction identifier generated by a transaction monitor to identify the virtual memory data cache for each client.
Claim 5
Independent Claim
99 words
A method in an object-oriented computer system for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, where the data cache includes a virtual memory data cache for each client and wherein the data cache includes a global data cache for lookaside functions in an optimistic data caching mode.
Claim 6
Independent Claim
99 words
A method in an object-oriented computer system for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, where the data cache includes a virtual memory data cache for each client and wherein the data cache includes a global data cache for lookaside functions in an optimistic data caching mode.
Claim 7
Dependent Claim
23 words
The method of claim 1 above, wherein the data cache can operate in an optimistic mode, a pessimistic mode, or an exclusive mode.
Claim 8
Dependent Claim
26 words
The method of claim 1 above, wherein the data cache includes an expiration time interval for purging data from the data cache in an optimistic mode.
Claim 9
Dependent Claim
26 words
The method of claim 1 above, wherein, in a pessimistic mode, the relational database is locked in a shared mode and is readable by multiple transactions.
Claim 10
Dependent Claim
23 words
The method of claim 1 above, wherein, in an exclusive mode, the relational database is exclusively locked and is readable by one transaction.
Claim 11
Dependent Claim
32 words
The method of claim 1 above, further comprising: retrieving data from the relational database represented by an object; and prefetching data from the relational database that is related to the retrieved data.
Claim 12
Dependent Claim
20 words
The method of claim 1 above, further comprising an application profile specifying a data caching mode and a pre-fetch option.
Claim 13
Dependent Claim
18 words
The method of claim 1 above, further comprising multiple application profiles, with each transaction selecting an application profile.
Claim 14
Independent Claim
94 words
An apparatus for caching relational data from a relational database in a data cache, comprising: an object-oriented computer system having a server that includes an instance manager and that is connected to at least one client; and one or more computer programs, performed by the computer, for creating and managing objects that represent the relational data under control of the instance manager, and for storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and a shared global data cache for lookaside functions.
Claim 15
Independent Claim
94 words
An apparatus for caching relational data from a relational database in a data cache, comprising: an object-oriented computer system having a server that includes an instance manager and that is connected to at least one client; and one or more computer programs, performed by the computer, for creating and managing objects that represent the relational data under control of the instance manager, and for storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and a shared global data cache for lookaside functions.
Claim 16
Independent Claim
126 words
An apparatus for caching relational data from a relational database in a data cache, comprising: an object-oriented computer system having a server that includes an instance manager and that is connected to at least one client; and one or more computer programs, performed by the computer, for creating and managing objects that represent the relational data under control of the instance manager, and for storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein each object includes a data access object interface, further comprising means for, under control of the data access object interface, using a transaction identifier generated by a transaction monitor to identify the virtual memory data cache for each client.
Claim 17
Independent Claim
126 words
An apparatus for caching relational data from a relational database in a data cache, comprising: an object-oriented computer system having a server that includes an instance manager and that is connected to at least one client; and one or more computer programs, performed by the computer, for creating and managing objects that represent the relational data under control of the instance manager, and for storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein each object includes a data access object interface, further comprising means for, under control of the data access object interface, using a transaction identifier generated by a transaction monitor to identify the virtual memory data cache for each client.
Claim 18
Independent Claim
104 words
An apparatus for caching relational data from a relational database in a data cache, comprising: an object-oriented computer system having a server that includes an instance manager and that is connected to at least one client; and one or more computer programs, performed by the computer, for creating and managing objects that represent the relational data under control of the instance manager, and for storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein the data cache includes a global data cache for lookaside functions in an optimistic data caching mode.
Claim 19
Independent Claim
104 words
An apparatus for caching relational data from a relational database in a data cache, comprising: an object-oriented computer system having a server that includes an instance manager and that is connected to at least one client; and one or more computer programs, performed by the computer, for creating and managing objects that represent the relational data under control of the instance manager, and for storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein the data cache includes a global data cache for lookaside functions in an optimistic data caching mode.
Claim 20
Dependent Claim
23 words
The apparatus of claim 11 above, wherein the data cache can operate in an optimistic mode, a pessimistic mode, or an exclusive mode.
Claim 21
Dependent Claim
26 words
The apparatus of claim 11 above, wherein the data cache includes an expiration time interval for purging data from the data cache in an optimistic mode.
Claim 22
Dependent Claim
26 words
The apparatus of claim 11 above, wherein, in a pessimistic mode, the relational database is locked in a shared mode and is readable by multiple transactions.
Claim 23
Dependent Claim
23 words
The apparatus of claim 11 above, wherein, in an exclusive mode, the relational database is exclusively locked and is readable by one transaction.
Claim 24
Dependent Claim
36 words
The apparatus of claim 11 above, further comprising: means for retrieving data from the relational database represented by an object; and means for prefetching data from the relational database that is related to the retrieved data.
Claim 25
Dependent Claim
20 words
The apparatus of claim 11 above, further comprising an application profile specifying a data caching mode and a pre-fetch option.
Claim 26
Dependent Claim
18 words
The apparatus of claim 11 above, further comprising multiple application profiles, with each transaction selecting an application profile.
Claim 27
Dependent Claim
113 words
An article of manufacture comprising a program storage medium readable by an object-oriented computer system and embodying one or more instructions executable by the object-oriented computer system to perform method steps for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and a shared global data cache for lookaside functions.
Claim 28
Dependent Claim
113 words
An article of manufacture comprising a program storage medium readable by an object-oriented computer system and embodying one or more instructions executable by the object-oriented computer system to perform method steps for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and a shared global data cache for lookaside functions.
Claim 29
Dependent Claim
143 words
An article of manufacture comprising a program storage medium readable by an object-oriented computer system and embodying one or more instructions executable by the object-oriented computer system to perform method steps for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein each object includes a data access object interface, further comprising, under control of the data access object interface, using a transaction identifier generated by a transaction monitor to identify the virtual memory data cache for each client.
Claim 30
Dependent Claim
143 words
An article of manufacture comprising a program storage medium readable by an object-oriented computer system and embodying one or more instructions executable by the object-oriented computer system to perform method steps for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein each object includes a data access object interface, further comprising, under control of the data access object interface, using a transaction identifier generated by a transaction monitor to identify the virtual memory data cache for each client.
Claim 31
Dependent Claim
123 words
An article of manufacture comprising a program storage medium readable by an object-oriented computer system and embodying one or more instructions executable by the object-oriented computer system to perform method steps for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein the data cache includes a global data cache for lookaside functions in an optimistic data caching mode.
Claim 32
Dependent Claim
123 words
An article of manufacture comprising a program storage medium readable by an object-oriented computer system and embodying one or more instructions executable by the object-oriented computer system to perform method steps for caching relational data from a relational database in a data cache, the object-oriented computer system having a server including an instance manager and connected to at least one client, the method comprising the steps of: creating and managing objects that represent the relational data under control of the instance manager; and storing the relational data in the data cache, wherein the data cache includes a virtual memory data cache for each client and wherein the data cache includes a global data cache for lookaside functions in an optimistic data caching mode.
Claim 33
Dependent Claim
23 words
The method of claim 21 above, wherein the data cache can operate in an optimistic mode, a pessimistic mode, or an exclusive mode.
Claim 34
Dependent Claim
26 words
The method of claim 21 above, wherein the data cache includes an expiration time interval for purging data from the data cache in an optimistic mode.
Claim 35
Dependent Claim
26 words
The method of claim 21 above, wherein, in a pessimistic mode, the relational database is locked in a shared mode and is readable by multiple transactions.
Claim 36
Dependent Claim
23 words
The method of claim 21 above, wherein, in an exclusive mode, the relational database is exclusively locked and is readable by one transaction.
Claim 37
Dependent Claim
32 words
The method of claim 21 above, further comprising: retrieving data from the relational database represented by an object; and prefetching data from the relational database that is related to the retrieved data.
Claim 38
Dependent Claim
20 words
The method of claim 21 above, further comprising an application profile specifying a data caching mode and a pre-fetch option.
Claim 39
Dependent Claim
18 words
The method of claim 21 above, further comprising multiple application profiles, with each transaction selecting an application profile.
References Cited (Backward Citations)
US4930071A
Cited
US5261069A
Cited
US5426747A
Cited
US5448727A
Cited
US5596754A
Cited
US5615362A
Cited
US5706506A
Cited
US5574902A
Cited
US5694598A
Cited
US5751958A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-04-26 | 2002-10-26 | 2003-04-27 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-04-26 | 2006-10-26 | 2007-04-27 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-04-26 | 2010-10-26 | 2011-04-27 | $7700.00 | Window Closed / Lapsed |