data mining

• vnj

  SSC-Addicted

  Points: 439

  More actions

  January 12, 2012 at 12:08 am

  #249503

  can we use clustering to find cluster with following data?

  PrdID Thk Wt

  x1 2.3 3.4

  x1 3.4 4.5

  x2 4.5 4.7

  PrdID is not the primary key.

  But want the clusters to show x1 and x2

  Is this possible?

  How

• Brandie Tarvin

  SSC Guru

  Points: 173068

  More actions

  January 13, 2012 at 6:07 am

  #1433175

  I don't understand your question because it has no context. When you say "cluster" are you referring to data in a table or an actual SQL Server Cluster set up?

  Please give us more details. If this is data in tables, we need Create Table statements, sample data in an INSERT statement, and a better explanation of what you're trying to find and what tools / queries you're using to find it.

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  January 14, 2012 at 5:05 am

  #1433677

  Hope you are taking about this (assumption based on data mining forum):

  http://en.wikipedia.org/wiki/Cluster_analysis

  If Yes, please go through following articles as well:

  http://www-users.cs.umn.edu/~han/dmclass/cluster_survey_10_02_00.pdf

  http://social.msdn.microsoft.com/Forums/en/sqldatamining/thread/96f5c700-8de8-4921-8862-aee8585071a3

  If No, please provide more details.