dbTalk Databases Forums  

Write the cluster in dataset

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Write the cluster in dataset in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Paulo
 
Posts: n/a

Default RE: Write the cluster in dataset - 09-19-2008 , 05:32 PM






I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...

--
Paulo Carvalho


"Linchi Shea" wrote:

Quote:
What did your clustering processing do? What do you mean by writing the final
clusters in a table'?

Linchi

"Paulo" wrote:

Hi guys,

Please, how can I write, after clustering process, the final clusters in a
table?

Best,
--
Paulo Carvalho

Reply With Quote
  #42  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM






On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #43  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #44  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #45  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #46  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #47  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #48  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #49  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #50  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: Write the cluster in dataset - 09-19-2008 , 06:09 PM



On Fri, 19 Sep 2008 15:32:01 -0700, Paulo <paulo (AT) nospam (DOT) nospam> wrote:

Quote:
I'm running K-Means

So I just want to create a field with the cluster group in the table that I
applied the method...
I did a Google search and came up with something on Wikipedia:

=========
K-means algorithm
From Wikipedia, the free encyclopedia

The k-means algorithm is an algorithm to cluster n objects based on
attributes into k partitions, k < n. It is similar to the
expectation-maximization algorithm for mixtures of Gaussians in that
they both attempt to find the centers of natural clusters in the data.
It assumes that the object attributes form a vector space. The
objective it tries to achieve is to minimize total intra-cluster
variance, or, the squared error function
==========

I hate to disappoint you but microsoft.public.sqlserver.clustering is
for the discussion of Microsoft SQL Server running on multiple
(clustered) Windows servers. The idea is when one server goes down,
another server in the cluster takes over the work.

Which is quite different from K-Means.

Roy Harvey
Beacon Falls, CT


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.