Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-01-11
2009-06-16
Vital, Pierre M (Department: 2169)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
07548903
ABSTRACT:
A method, apparatus, and computer instructions for selecting and recommending of clustering indexes are provided. Baseline run time cost estimates are calculated based on database designs. Workload benefit of a candidate clustering design is calculated and compared to the baseline costs. If the workload benefit outweighs the baseline costs, clustering dimension solutions originated from the record identifier (RID) based index are identified. A clustering design is selected based on the identified clustering dimension solutions and the total number of recommended clustering dimensions for a given table. Based on the number of dimensions observed, either a multidimensional clustering solution or a RID based clustering index is recommended.
REFERENCES:
patent: 5551027 (1996-08-01), Choy et al.
patent: 5778353 (1998-07-01), Schiefer et al.
patent: 5864857 (1999-01-01), Ohata et al.
patent: 5887274 (1999-03-01), Barry et al.
patent: 5913206 (1999-06-01), Chaudhuri et al.
patent: 5913207 (1999-06-01), Chaudhuri et al.
patent: 5950186 (1999-09-01), Chaudhuri et al.
patent: 5960423 (1999-09-01), Chaudhuri et al.
patent: 6026412 (2000-02-01), Sockut et al.
patent: 6081799 (2000-06-01), Beavin et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6356891 (2002-03-01), Agrawal et al.
patent: 6470344 (2002-10-01), Kothuri et al.
patent: 7080081 (2006-07-01), Agarwal et al.
patent: 2002/0138466 (2002-09-01), Arning et al.
patent: 2004/0215626 (2004-10-01), Colossi et al.
Chiang Fei Yen
Cranston Leslie Anne
Lightstone Sam Sampson
Zilio Daniele Costante
International Business Machines - Corporation
Plow Greg
Raab Christopher J
Vital Pierre M
Yee & Associates P.C.
LandOfFree
Method and apparatus for automatic recommendation and... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for automatic recommendation and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for automatic recommendation and... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4135233