Techniques for partitioning indexes

Details Techniques for partitioning indexes Techniques for partitioning indexes

2007-08-31

2010-11-09

Filipczyk, Marc R (Department: 2158)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S746000, C707S970000

Reexamination Certificate

active

07831590

ABSTRACT:
Techniques for partitioning indexes are provided. A predefined data type associated with a column of a database table is acquired. Column value statistics for the column are acquired. The values are analyzed to produce multiple partitions for the values. Each partition includes each of the values and each partition includes multiple groupings of the values. Also, each grouping of a particular partition includes a subset or range of the values. Furthermore, each grouping of a partition includes a same distribution for the values as other groupings of that partition. Each partition represents a potential partitioning index for the column and its values.

REFERENCES:
patent: 5551027 (1996-08-01), Choy et al.
patent: 5960194 (1999-09-01), Choy et al.
patent: 6795821 (2004-09-01), Yu
patent: 6920460 (2005-07-01), Srinivasan et al.
patent: 7124071 (2006-10-01), Rich et al.
patent: 7447681 (2008-11-01), Lightstone et al.
patent: 2003/0055822 (2003-03-01), Yu
patent: 2007/0294319 (2007-12-01), Mankad et al.
patent: 2008/0120275 (2008-05-01), Cruanes et al.
patent: 2008/0313246 (2008-12-01), Shankar et al.
patent: 2009/0037365 (2009-02-01), Sinclair et al.

Affiliated with

Also associated with

Rating

Techniques for partitioning indexes does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Techniques for partitioning indexes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Techniques for partitioning indexes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4212617