Exhaustive clustering
Previous Top 

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
 graphic
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