Method for sampling a compressed index to create a summarized index

• US 5,765,158 A
• Filed: 08/09/1996
• Issued: 06/09/1998
• Est. Priority Date: 08/09/1996
• Status: Expired due to Term

• Current Assignee: R2 Solutions LLC (Acacia Research Corporation)
• Original Assignee: Digital Equipment Corporation (HP Inc.)
• Inventors: Burrows, Michael
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/696,409
• Time in Patent Office: 669 Days
• Field of Search: 395/613, 395/610, 395/603, 395/615, 395/612, 395/607, 395/602, 707/101, 707/102, 707/7, 707/2, 707/3
• US Class Current: 1/1
• CPC Class Codes: G06F 16/328 Management therefor
• 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/99937 Sorting
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

In a computer implemented method, a summary index data structure is generated from a data structure which indexes information stored in a database. Compressed word entries are written to a compressed index data structure. The word entries are written according to a collating order of the words which represent the unique portions of information of the database. Compressed location entries for each word entry are also written to the compressed index data structure immediately following each word entry. Each location entry indicates instances of the associated unique portions of the information represented by the words. While writing the word and location entries to the compressed index data structure, periodically sampling the location entries to generated summary entries. Each summary entry including an encoding of a last word entry written, an encoding of a last location entry written. Each summary entry also includes a pointer to the next entry following the sampled location entry. The summary entries are written to the summary index data structure in an order that the location entries are sampled.

Claims

1. A computer implemented method for generating a summary index data structure of information stored in a database, comprising:

writing, for each unique portion of the information of the database, a compressed word entry in a compressed index data structure, the word entries being written according to a collating order of the unique portions of information of the database;

immediately following each word entry, writing compressed location entries in the compressed index data structure to indicate where the associated unique portions of the information occur in the database;

while writing the word and location entries to the compressed index data structure, periodically sampling the entries being written to generated summary entries, each summary entry including an encoding of a last word entry written, an encoding of a last location entry written associated with the particular word entry, and an address of a next entry written, the next entry being written following the sampled entry; and

writing the summary entries to a summary index data structure in an order that the word and location entries are sampled.

2. The method of claim 1 further comprising:

reading the summary entries of the summary index data structure in a predetermined order to find a particular summary entry presenting a particular unique portion of the information of the database, and the summary entry encoding a particular location at least equal to a target location but greater than a limit location.

3. The method of claim 2 further comprising:

using the address stored in the particular summary entry as a starting point to begin a sequential search of the compressed index data structure to find a particular location entry at least equal to the target location but greater than the limit location.