Exhaustive clustering
As stated earlier, the cluster analysis method included in SA+ is far from perfect, and we
hope to incorporate the new approach that Aylin Cimenser is currently developing
shortly. In difficult cases, one can still succeed to cluster using the exhaustive clustering
approach as following:
· Start from the easiest (most prominent and distinct) clusters and cluster
them throughout development.
· Use the mySQL Control Center to split the data into unclustered and
clustered tables:
CREATE TABLE bird109_unclustered SELECT * FROM bird109 where
cluster=0;
CREATE TABLE bird109_clustered SELECT * FROM bird109 where
cluster>0;
ALTER TABLE bird109_unclustered CHANGE recnum recnum PRIMARY
KEY;
· Open SA+ and cluster bird109_unclustered - you might find that this is
an easier task now
· Finally, merge the two tables in mySQL Control Center typing
INSERT INTO b109clustered SELECT * FROM b109unclustered
Comment: always make sure that recnum is the primary key and that the table
is sorted by recnum. You can always change sorting by editing the table and
changing sorting in
Also, you can sort by any field after deleting recnum, and then recreate
recnum as the primary key and auto-increment to change sorting order as
desired.
Created using Helpmatic Pro HTML