<model name>_MODEL table

This table contains information about the entire Naive Bayes classification model.

Note: This feature is available starting from Db2® version 11.5.4.

The table contains one row for each triple of column, column value, and target attribute value.

The following table shows the table columns:

Table 1. Columns of the <model name>_MODEL table
Column name Data type Description
ATTRIBUTE VARCHAR(128) Column name from the intable
VAL VARCHAR(n) The value that is associated with the ATTRIBUTE value

For nominal attributes, the VAL value is is associated with the ATTRIBUTE value.

For numeric attributes, the value of the bin number corresponds to the discretization that is defined in the <model name_DISCRANGES> table for the numeric column. The value starts with 1 for the bin with the lowest values.

CLASS VARCHAR(m) The value of the target that is associated with the ATTRIBUTE, VAL pair
CLASSVALCOUNT BIGINT The number of rows from the intable that is associated with the ATTRIBUTE, VAL, CLASS triples
ATTRCLASSCOUNT BIGINT The number of rows from the intable that is associated with the CLASS value

Rows with null values are ignored.

CLASSCOUNT BIGINT The number of rows from the intable that is associated with the CLASS value
TOTALCOUNT BIGINT The number of rows from the intable with a non-null target value