Systems, methods, and computer program products to reduce computer processing in grid cell size determination for indexing of multidimensional databases
First Claim
1. A computer-implemented method for identifying related data that is associated with selected data, said selected data that is implemented in a subject multidimensional database, said selected data being obtained by use of index data that is implemented in an index multidimensional database, comprising:
- identifying related index data from said index data by creating a query and executing said query against said index data; and
identifying said related data from said selected data by use of said related index data.
1 Assignment
0 Petitions
Accused Products
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 sampling data for 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.
57 Citations
6 Claims
-
1. A computer-implemented method for identifying related data that is associated with selected data, said selected data that is implemented in a subject multidimensional database, said selected data being obtained by use of index data that is implemented in an index multidimensional database, comprising:
-
identifying related index data from said index data by creating a query and executing said query against said index data; and identifying said related data from said selected data by use of said related index data. - View Dependent Claims (2)
-
-
3. A computer system that reduces a number of index entries for efficiently indexing data in a multidimensional database, said multidimensional database having at least one associated grid, comprising:
-
two or more said grids that are associated with levels, wherein the levels represent partitions of space at various resolutions of said grids, and wherein each grid cell has a same grid cell size that is used for cells of a grid at one level of said levels; said two or more grids being sampled at a first said level to produce an estimated number of index entries for at least one geometric shape as if said at least one geometric shape were indexed at said first level while determining sizes for said sampled grid at each level; at least one said sampled grid size being optimized; an estimated said number of index entries associated with two or more said levels, comprising; a said size for said grids for each of at least two said levels; a ratio of said sizes of said grids of said at least two levels, wherein said ratio represents at least said size at a level i compared to said size at a level (i−
1) of said at least two levels; andsaid ratio being used to estimate said number of index entries; and said at least one optimized size and said estimated number of index entries that determine an efficient number of said index entries in said multidimensional database thereby efficiently indexing said data in said multidimensional database. - View Dependent Claims (4)
-
-
5. An article of manufacture comprising a computer usable storage medium embodying one or more instructions executable by said computer for causing said computer to reduce a number of index entries for efficiently indexing data in a multidimensional database, said multidimensional database having at least one associated grid, wherein:
-
said computer instructions use levels associated with two or more said grids, wherein the levels represent partitions of space at various resolutions of said grids, and wherein each grid cell has a same grid cell size that is used for cells of a grid at one level of said levels; said computer instructions sample said grid at a first said level to produce an estimated number of index entries for at least one geometric shape as if said at least one geometric shape were indexed at said first level while determining sizes for said sampled grid at each level; said computer instructions optimize at least one said size for said sampled grid; said computer instructions estimate said number of index entries associated with two or more said levels, wherein; said computer instructions determine a said size for said grids for each of at least two said levels; said computer instructions determine a ratio of said sizes of said grids of said at least two levels, wherein said ratio represents at least said size at a level i compared to said size at a level (i−
1) of said at least two levels; andsaid computer instructions use said ratio to estimate said number of index entries; and said computer instructions use said at least one optimized size and said estimated number of index entries to determine an efficient number of said index entries in said multidimensional database thereby efficiently indexing said data in said multidimensional database. - View Dependent Claims (6)
-
Specification