<model name>_DISCRETE_STATISTICS table

This table provides statistics about a cluster.

The following table shows the table columns:

Table 1. Columns of the <model name>_DISCRETE_STATISTICS table
Column name Data type Description
CLUSTERID (primary key column) INTEGER Index value of the cluster in the cluster model

If CLUSTERID is 0, the row applies to all input records.

COLUMNNAME VARCHAR(128) Name of an input column
VALUE VARCHAR(16000) Value occurring in the input column

The column might be numeric, in which case the value is a string representation of the true column value.

COUNT BIGINT Number of occurrences of records that contain the VALUE parameter.
RELFREQUENCY DOUBLE Percentage of occurrences of records that contain the VALUE parameter

The relative frequency is based on all records, including those records that contain invalid or null values.

DEVIATION DOUBLE RELFREQUENCY(CLUSTERID) -RELFREQUENCY(0)