Method and apparatus for generating and searching range-based index of word locations

• US 5,915,251 A
• Filed: 04/03/1998
• Issued: 06/22/1999
• 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: Hisgen, Andrew L., Burrows, Michael
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US09/054,445
• Time in Patent Office: 445 Days
• Field of Search: 707/102, 707/2
• US Class Current: 707/700
• CPC Class Codes: G06F 16/319 Inverted lists
• CPC Class Codes: G06F 16/38 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• 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/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method indexes a database so that records including literal values, and numeric values within a specified range can be located. The range is selected from an interval of values. Each record of the database is indexed by storing index entries in a memory. Each index entry includes a literal word entry representing a unique portion of information of the database, and one or more numeric location entries indicating occurrences of the portion of information. A plurality of sets of subintervals are generated from the numeric interval of values. Each set of subintervals includes all of the values of the interval. A first set includes one subinterval for each value of the interval, and each next set includes one interval for a group of adjacent subintervals of a previous set. The subinterval of the last set is the entire interval of numeric values. Each subinterval is represented by a unique literal which can be indexed as a word entry in the index. While indexing the records, some portions of information are identified as range-based values. The range-based values are indexed by storing word and location entries in the index such that there is one word entry for each subinterval which includes the range-based values, the locations indicating occurrences of the range-based portions of information.

Claims

1. A system for generating an index to a database, the system comprising:

a memory configured to store the index, each index entry including a literal word entry representing a unique portion of information of the database and one or more location entries indicating where the unique portion of information occurs in the records of the database;

a processor configured to generate a plurality of levels of subintervals of an interval, each level including all numeric values of the interval, and each level having a unique set of subintervals, each subinterval of each level comprising at least one numeric value in the interval, the processor further configured to store a representation of each subinterval of each level in the index;

a parser for receiving records of the database and breaking down portions of the records into indexable elements, thereby providing parsed records, the parser further detecting numeric values within the records and providing one parsed record for each subinterval in which each numeric value occurs; and

an indexer for sorting the parsed records and adding the sorted records to the index.

2. The system of claim 1 wherein the representation of each subinterval stored in the index comprises a unique literal including a starting value of the subinterval and a length of the subinterval.

3. The system of claim 1 wherein the levels include a first level and a second level, the subintervals of the second level being twice the size of the subintervals of the first level.

4. The system of claim 1 wherein the index includes literals for representing various data types.

5. The system of claim 1, further comprising an automated browser for periodically requesting records from the database and providing the records to the parser.

6. The system of claim 1 wherein the parser provides a plurality of different parsed records for an expressly identified word, each parsed record include a literal representing a different form of the expressly identified word.

7. The system of claim 1 wherein the parser detects attributes of records and provides parsed attribute records, each parsed attribute record including a literal representing the detected attribute.

8. The system of claim 1 wherein the database comprises the World Wide Web.

9. A system for searching an index of a database to locate records including numeric values within a selected range, the system comprising:

a memory configured to store the index, each index entry including a literal word entry representing a unique portion of information of the database and one or more location entries indicating where the unique portion of information occurs in the records of the database;

an interval stored in the index, the interval comprising a plurality of levels of subintervals of the interval, each level including all numeric values of the interval, and each level having a unique set of subintervals, each subinterval of each level comprising at least one numeric value in the interval;

a query module for parsing a query received from a user and providing a parsed query, the query module being configured to receive a range-based query; and

one or more index stream readers for locating records in the index qualified by the parsed query and providing a list of identified records qualified by the parsed query.

10. The system of claim 9 wherein each subinterval is stored in the index as a unique literal, the unique literal comprising a starting value of the subinterval and a length of the subinterval.

11. The system of claim 9 wherein the levels include a first level and a second level, the subintervals of the second level being twice the size of the subintervals of the first level.

12. The system of claim 9 wherein the database comprises the World Wide Web.