The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 16, 2009
Filed:
Jan. 11, 2005
Fei Yen Chiang, Toronto, CA;
Leslie Anne Cranston, Toronto, CA;
Sam Sampson Lightstone, Toronto, CA;
Daniele Costante Zilio, Georgetown, CA;
Fei Yen Chiang, Toronto, CA;
Leslie Anne Cranston, Toronto, CA;
Sam Sampson Lightstone, Toronto, CA;
Daniele Costante Zilio, Georgetown, CA;
International Business Machines Corporation, Armonk, NY (US);
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.