How to use Clustering Algorytm is SQL Server 2005

Hi,

Pl clarify how to use SQL server 2005 clustering Algorythm , I want to use the case and nested table concept. Pl let me know what is key column , Input and product with an example

I have table in the following structure

Cust_id

Age

Product

Location

Income

the above mentioned columns are in my tableand i want to perdict which product is mostly likely to sold with other based on age , location and income

Pl clarify and mail me on rajesh.ladda@.lntinfotech.com

Thanks in advance

Rajesh Ladda

Essentially to use a case/nested table you need two tables. The first would have

Cust_id, Age, Location, Income (CustID becomes the mining key)

The second

Cust_id, Product (Product becomes the nested table key)

In general if you have one table, you don't need nested tables, but if you have lots of products you still may want to. In this case, you would use the same table as the case and nested table and mark the columns appropriately.

For prediction, Clustering is not likely to give you a good response. I would use Trees or Association Rules.