Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2011-06-28
2011-06-28
Ali, Mohammad (Department: 2158)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S803000
Reexamination Certificate
active
07970756
ABSTRACT:
A system for executing a query on data that has been partitioned into a plurality of partitions is provided. The system includes providing partitioned data including one or more columns and the plurality of partitions. The partitioned data includes a limit key value associated with each column for a given partition. The system further includes receiving a query including a predicate on one of the one or more columns of the partitioned data; and utilizing the predicate on the one of the one or more columns in a pruning decision on at least one of the one or more partitions based on the limit key values associated with the plurality of partitions.
REFERENCES:
patent: 5664172 (1997-09-01), Antoshenkov
patent: 5794229 (1998-08-01), French et al.
patent: 6006220 (1999-12-01), Haderle et al.
patent: 6014656 (2000-01-01), Hallmark et al.
patent: 6081799 (2000-06-01), Beavin et al.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6125370 (2000-09-01), Courter et al.
patent: 6269375 (2001-07-01), Ruddy et al.
patent: 6272498 (2001-08-01), Muthukrishnan et al.
patent: 6374232 (2002-04-01), Dageville et al.
patent: 6439783 (2002-08-01), Antoshenkov
patent: 7756889 (2010-07-01), Yu et al.
patent: 7774379 (2010-08-01), Basu et al.
patent: 2002/0194157 (2002-12-01), Zait et al.
patent: 2003/0208503 (2003-11-01), Roccaforte
patent: 2004/0044662 (2004-03-01), Ganesan et al.
patent: 2004/0148293 (2004-07-01), Croisettier et al.
patent: 2004/0199533 (2004-10-01), Celis et al.
patent: 2004/0215638 (2004-10-01), Kapoor et al.
patent: 2004/0249845 (2004-12-01), Das
patent: 2005/0038784 (2005-02-01), Zait et al.
patent: 2006/0253429 (2006-11-01), Raghavan et al.
patent: 2011/0029557 (2011-02-01), Raghavan et al.
Maurice Bernader, “Basis of a Fuzzy Knowledge Discovery System”, 2000, Springer (Abstract only).
Beavin Thomas Abel
Goswami Sauraj
Purcell Terence Patrick
Ali Mohammad
International Business Machines - Corporation
Sawyer Law Group P.C.
Smith Brannon W
LandOfFree
Generalized partition pruning in a database system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Generalized partition pruning in a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Generalized partition pruning in a database system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2742349