Data access system

• US 6,941,295 B2
• Filed: 05/15/2002
• Issued: 09/06/2005
• Est. Priority Date: 08/12/1999
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Nakamura, Lee Evan, Tate, Stewart Eugene
• Primary Examiner(s): Breene, John E.
• Assistant Examiner(s): DODDS, HAROLD E
• Application Number:
  US10/145,544
• Publication Number:
  US 20020174138A1
• Time in Patent Office: 1,210 Days
• Field of Search: 707 1- 5, 707 7- 10, 707100-1041, 707200-205, 709/200, 709/201, 711/100, 711/101, 711/154, 711/163, 711/164, 715/500, 715/513, 717/100, 717/106, 717/108, 717/114, 717/116
• US Class Current: 707/769
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/954 Relational
• 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/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

Data is stored in a persistent, user-defined, shareable in-memory database table. When a search request specifying a number of results to be retrieved from a desired starting point is received, the data is located in an in-memory database table and the specified number of results from the desired starting point are returned. Stored descriptors corresponding to search terms in the search request are retrieved and mapped to location information in a header area of the in-memory database table. Using the location information, data is retrieved either from a data area of the in-memory database table or from a relational data store. The data that is accessed via the in-memory database table is updated upon receiving an update request and may either be data in a data area of the in-memory database table or may be relational data.

Claims

1. A method for retrieving data from an in-memory database table stored at a computer, comprising:

retrieving stored descriptors corresponding to search terms in a search request;

mapping the stored descriptors to location information in a header area of an in-memory database table; and

using the location information to retrieve data.

2. The method of claim 1, wherein the location information indicates that data to be retrieved is in a data area of the in-memory database table.

3. The method of claim 1, wherein the location information indicates that data to be retrieved is in a relational data store.

4. The method of claim 1, wherein the in-memory database table is a persistent in-memory database table that remains in memory until a user specifies removal of said in-memory database table.

5. The method of claim 1, wherein the in-memory database table is a persistent in-memory database table in which the data remains after it is accessed by a first user and is available for access by a second user.

6. An apparatus for retrieving data from an in-memory database table, comprising:

a computer having a memory storing the in-memory database table, wherein the computer is connected to a data store;

one or more computer programs, performed by the computer, for retrieving stored descriptors corresponding to search terms in a search request, mapping the stored descriptors to location information in a header area of an in-memory database table, and using the location information to retrieve data.

7. The apparatus of claim 6, wherein the location information indicates that data to be retrieved is in a data area of the in-memory database table.

8. The apparatus of claim 6, wherein the location information indicates that data to be retrieved is in a relational data store.

9. The apparatus of claim 6, wherein the in-memory database table is a persistent in-memory database table that remains in memory until a user specifies removal of said in-memory database table.

10. The apparatus of claim 6, wherein the in-memory database table is a persistent in-memory database table in which the data remains after it is accessed by a first user and is available for access by a second user.

11. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to retrieve data from an in-memory database table stored at a computer, comprising:

retrieving stored descriptors corresponding to search terms in a search request;

mapping the stored descriptors to location information in a header area of an in-memory database table; and

using the location information to retrieve data.

12. The article of manufacture of claim 11, wherein the location information indicates that data to be retrieved is in a data area of the in-memory database table.

13. The article of manufacture of claim 11, wherein the location information indicates that data to be retrieved is in a relational data store.

14. The article of manufacture of claim 11, wherein the in-memory database table is a persistent in-memory database table that remains in memory until a user specifies removal of said in-memory database table.

15. The article of manufacture of claim 11, wherein the in-memory database table is a persistent in-memory database table in which the data remains after it is accessed by a first user and is available for access by a second user.