Database accessing method and apparatus

• US 6,125,209 A
• Filed: 04/01/1998
• Issued: 09/26/2000
• Est. Priority Date: 04/04/1997
• Status: Expired due to Term

• Current Assignee: Sony United Kingdom Limited (Sony Group Corp.)
• Original Assignee: Sony United Kingdom Limited (Sony Group Corp.)
• Inventors: Dorricott, Martin Rex
• Primary Examiner(s): Ho, Ruay Lian
• Application Number:
  US09/053,565
• Time in Patent Office: 909 Days
• Field of Search: 707/1-10, 707/100-104, 707/200-206, 705/44, 705/45, 382/233, 382/181, 382/190, 382/203, 382/209
• US Class Current: 382/233
• CPC Class Codes: G06F 16/51 Indexing; Data structures therefor; Storage structures

Abstract

Apparatus for accessing a database having database records comprising data-compressed image data comprises a database server apparatus operable to respond to a database query by returning database records to the client process matching the criteria specified by the database query; and a client process for issuing database queries to the database server and for displaying information indicative of the database records returned by the database server apparatus; in which: the client process has a data decompressor for decompressing data-compressed images received from the database server and a data cache for storing decompressed image data representing those images; the client process is operable to retrieve, decompress, display and store in the data cache data-compressed a subset of the images relating to the database records returned by the database server; and the client process is then operable to retrieve, decompress and store in the data cache data-compressed images relating to the database records returned by the database server but not currently required for display.

Claims

1. Apparatus for accessing a database having database records comprising data-compressed image data, said apparatus comprising:

(i) a database server apparatus operable to respond to a database query by returning database records to the client process matching the criteria specified by said database query; and

(ii) a client process for issuing database queries to said database server and for displaying information indicative of said database records returned by said database server apparatus;

in which;

(i) said client process has a data decompressor for decompressing data-compressed images received from said database server and a data cache for storing decompressed image data representing those images;

(ii) said client process is operable to retrieve, decompress, display and store in said data cache a data-compressed subset of said images required for display relating to said database records returned by said database server; and

(iii) said client process is then operable to retrieve, decompress and store in said data cache data-compressed images relating to said database records returned by said database server but not currently required for display.

2. Apparatus according to claim 1, in which said client process runs on a client data processing apparatus different to said database server apparatus, said client data processing apparatus being connected to transfer data to and from said database server apparatus by a data communication link.

3. Apparatus according to claim 1, in which said database records comprise a main image characterising said record and one or more sub-images characterising sub-sections of said record, said client process being operable to retrieve, decompress and store in said data cache said data-compressed main images relating to said database records returned by said database server but not currently required for display, and then to retrieve, decompress and store in said data cache said data-compressed sub-images relating to said database records returned by said database server.

4. Apparatus according to claim 1, in which, when said data cache has been filled with image data, said client process is operable to overwrite the earliest-stored image in said data cache to store a newly retrieved and decompressed image, unless that earliest-stored image relates to a database record currently being displayed.