专利检索 ap:("Fei Chiang" OR "Leslie Cranston" OR "Sam Lightstone" OR "Daniele Zilio") AND inv:"Leslie Cranston" 第 1 页

1.

发明申请
Method and apparatus for automatic recommendation and selection of clustering indexes 失效

公开(公告)号：US20060155681A1

公开(公告)日：2006-07-13

申请号：US11033327

申请日：2005-01-11

申请人： Fei Chiang , Leslie Cranston , Sam Lightstone , Daniele Zilio

发明人： Fei Chiang , Leslie Cranston , Sam Lightstone , Daniele Zilio

IPC分类号： G06F7/00

CPC分类号： G06F17/30312 , Y10S707/99932 , Y10S707/99933

摘要： 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.