Methods to improve indexing of multidimensional databases

• US 7,383,275 B2
• Filed: 05/10/2002
• Issued: 06/03/2008
• Est. Priority Date: 05/10/2002
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Chen, Ying, Stolze, Knut, Rao, Fang Yan
• Primary Examiner(s): Mizrahi; Diane D.
• Application Number:
  US10/144,058
• Publication Number:
  US 20030212689A1
• Time in Patent Office: 2,216 Days
• Field of Search: 707/102, 707 1- 10, 707100-1041, 345/423
• US Class Current: 707/743
• CPC Class Codes: G06F 16/2264 Multidimensional index structures
• CPC Class Codes: Y10S 707/957 Multidimensional
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Systems, methods, and computer products that improve the techniques used to search multidimensional databases over techniques of the past. The preferred embodiment of the present invention advantageously improves the technique of determining a grid index that is used to locate a geometric shape in a spatial database. More particularly, the preferred embodiment of the present invention improves the technique of defining the grid cell size in a grid for a given data set, thereby improving the grid indexing process that locates a particular minimum-bounding rectangle and the associated geometric shape.

Claims

1. A computer-implemented method for determining a grid index in a multidimensional database, comprising:

sampling a grid associated with said multidimensional database;

determining an index performance indicator associated with said sampled grid; and

generating an improved said index performance indicator thereby determining said grid index, wherein said improved index performance indicator describes a number of index entries that are evaluated in said grid index during a search of said multidimensional database.

2. The computer-implemented method of claim 1 further comprising determining sizes for at least one grid cell associated with said sampled grid based on said improved index performance indicator.

3. The computer-implemented method of claim 1 wherein said improved index performance indicator is a minimum said index performance indicator.

4. The computer-implemented method of claim 1 further comprising determining said improved index performance indicator by using a key generator function.

5. The computer-implemented method of claim 4 further comprising:

said multidimensional database being a spatial said multidimensional database that represents at least one geometric shape;

using said key generator function to generate at least one index entry that is associated with said at least one geometric shape; and

determining said improved index performance indicator when minimum said index entries are associated with each said at least one geometric shape.

6. The computer-implemented method of claim 1 further comprising determining said improved index performance indicator by using a query box.

7. The computer-implemented method of claim 1 wherein said multidimensional database is a spatial said multidimensional database.

8. A computer-implemented method for determining a grid index in a multidimensional database, comprising:

sampling a plurality of grids associated with said multidimensional database;

determining an index performance indicator associated with each said sampled grid; and

generating an improved said index performance indicator that is the sum of said each grid index performance indicator thereby determining said grid index, wherein said improved index performance indicator describes a number of index entries that are evaluated in said grid index during a search of said multidimensional database.