Reducing index size for multi-level grid indexes

• US 7,836,082 B2
• Filed: 01/25/2008
• Issued: 11/16/2010
• Est. Priority Date: 05/10/2002
• Status: Expired due to Fees

• Current Assignee: Hulu LLC (The Walt Disney Company)
• Original Assignee: International Business Machines Corporation
• Inventors: Stolze, Knut, Adler, David William
• Primary Examiner(s): Woo; Isaac M
• Application Number:
  US12/020,474
• Publication Number:
  US 20080133559A1
• Time in Patent Office: 1,026 Days
• Field of Search: 707600-831
• US Class Current: 707/791
• CPC Class Codes: G06F 16/2246 Trees, e.g. B+trees
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/5854 using shape and object relationship
• CPC Class Codes: Y10S 707/955 Object-oriented
• 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
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

The number of index entries in a grid index for indexing geometric shapes is reduced by establishing a pool storage area for geometric shapes, selecting a threshold number of grid cells which a geometric shape may overlap, storing the shape in the grid index if a geometric shape overlaps a number of grid cells not exceeding the threshold number, and storing the shape in the pool storage area if the geometric shape overlaps a number of grid cells which exceeds the threshold number.

Claims

1. A computer program for reducing the number of index entries for use in an index for indexing an object, the computer program having program instructions executable by a computer and recorded on a computer-readable medium to perform:

determining whether a number of grid cells the object overlaps is more than a defined limit number of grid cells at successively coarser levels of a multilevel grid index until it is determined that the number of grid cells that the object overlaps at one of the levels of the multilevel grid index does not exceed the defined limit number of grid cells or it is determined that the number of grid cells that the object overlaps exceeds the defined limit number of grid cells at a coarsest level;

in response to determining that the number of grid cells that the object overlaps at one of the levels of the multilevel grid index does not exceed the defined limit number of grid cells, using that level of the multilevel grid index for grid indexing; and

in response to determining that the object overlaps more than the defined limit number of grid cells at the coarsest level,

determining a number of index entries for the object;

storing the index entries in the multilevel grid index if the number of index entries does not exceed a threshold number using the coarsest level of the multilevel grid index for grid indexing; and

storing an indicator of the object in a pool storage area if the number of index entries exceeds the threshold number.

2. The computer-program of claim 1, wherein the object is a geometric shape, and said determining a number of index entries is based on how many cells the object overlaps.

3. The computer-program of claim 2, further performing:

selecting the threshold number of grid cells that a geometric shape may overlap; and

establishing the pool storage area for storing indicators of geometric shapes overlapping the number of grid cells exceeding the threshold number.

4. The computer-program of claim 2, wherein the geometric shapes are from a database of geometric shapes.

5. The computer-program of claim 4, wherein an indicator for each geometric shape in the database that overlaps a number of grid cells exceeding the threshold number is stored in the pool storage area.

6. The computer-program of claim 2, wherein the multilevel grid index includes a data structure and if one of said geometric shapes is placed in the pool storage area, an identifier representative of such geometric shape is placed in the data structure of the multilevel grid index.

7. The computer-program of claim 2, wherein the threshold number of grid cells is related to the coarsest level of the multilevel grid index.

8. A computer system for indexing objects, comprising:

an index comprised of a plurality of index entries for storing indicators of first objects, wherein the index is a multilevel grid index;

a pool storage area for storing an indicator of second objects that are not stored in the multilevel grid index, wherein a number of index entries for the second objects if stored in the multilevel grid index is greater than a threshold number;

means for determining whether a number of grid cells the object overlaps is more than a defined limit number of grid cells at successively coarser levels of the multilevel grid index until it is determined that the number of grid cells that the object overlaps at one of the levels of the multilevel grid index does not exceed the defined limit number of grid cells or it is determined that the number of grid cells that the object overlaps exceeds the defined limit number of grid cells at a coarsest level; and

means for, in response to determining that the number of grid cells that the object overlaps at one of the levels of the multilevel grid index does not exceed the defined limit number of grid cells, using that level of the multilevel grid index for grid indexing.

9. The computer system of claim 8, wherein the first and second objects are geometric shapes.

10. The computer system of claim 9, wherein the pool storage area is for storing indicators of geometric shapes that overlap more than a preselected threshold number of grid cells if the multilevel grid index is laid over said geometric shapes.

11. The computer system of claim 10, wherein the multilevel grid index contains stored geometric shapes and wherein the pool storage area contains larger geometric shapes.

12. The computer system of claim 11, wherein the multilevel grid index includes a data structure and for each geometric shape in the pool storage area there is an identifier in the data structure of the multilevel grid index.

13. The computer system of claim 10, further comprising:

in response to determining that the object overlaps more than the defined limit number of grid cells at the coarsest level,

means for storing the shape in the multilevel grid index if a geometric shape overlaps a number of cells that does not exceed the threshold number using the coarsest level of the multilevel grid index for grid indexing; and

means for storing the shape in the pool storage area if a geometric shape overlaps a number of grid cells exceeding the threshold number.