Optimized caching of SQL data in an object server system

• US 5,897,634 A
• Filed: 05/09/1997
• Issued: 04/27/1999
• Est. Priority Date: 05/09/1997
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Wisneski, David J., Attaluri, Gopi Krishna, Fan, Catalina Y., Nayak, Harry Rohidas, Jackson, Robert Dean, Fisher, Gerald A.
• Primary Examiner(s): Lintz, Paul R.
• Application Number:
  US08/853,270
• Time in Patent Office: 718 Days
• Field of Search: 707/8, 707/10, 707/103, 707/104, 711/113, 711/118, 711/121
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

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.

Claims

1. 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.

4. The method of claim 1 above, wherein the data cache can operate in an optimistic mode, a pessimistic mode, or an exclusive mode.

5. 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.

6. 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.

7. The method of claim 1 above, wherein, in an exclusive mode, the relational database is exclusively locked and is readable by one transaction.

8. 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.

9. The method of claim 1 above, further comprising an application profile specifying a data caching mode and a pre-fetch option.

10. The method of claim 1 above, further comprising multiple application profiles, with each transaction selecting an application profile.

2. 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.

3. 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.

11. 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.

14. The apparatus of claim 11 above, wherein the data cache can operate in an optimistic mode, a pessimistic mode, or an exclusive mode.

15. 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.

16. 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.

17. The apparatus of claim 11 above, wherein, in an exclusive mode, the relational database is exclusively locked and is readable by one transaction.

18. 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.

19. The apparatus of claim 11 above, further comprising an application profile specifying a data caching mode and a pre-fetch option.

20. The apparatus of claim 11 above, further comprising multiple application profiles, with each transaction selecting an application profile.

12. 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.

13. 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.

21. 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.

24. The method of claim 21 above, wherein the data cache can operate in an optimistic mode, a pessimistic mode, or an exclusive mode.

25. 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.

26. 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.

27. The method of claim 21 above, wherein, in an exclusive mode, the relational database is exclusively locked and is readable by one transaction.

28. 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.

29. The method of claim 21 above, further comprising an application profile specifying a data caching mode and a pre-fetch option.

30. The method of claim 21 above, further comprising multiple application profiles, with each transaction selecting an application profile.

22. 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.

23. 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.