<model name>_ITEMS table

This table contains the frequent items of the input table. Frequent items are contained in a fraction or number of the input transactions that exceeds the minimum support. The minimum support is defined in the minsupport parameter.

The following table shows the table columns.

Table 1. Columns of the <model name>_ITEMS table
Column name Data type Description
ITEMID INTEGER The ID of the frequent item in the model
ITEM Type of column as specified by the item parameter The ID of the frequent item in the input table
ITEMNAME VARCHAR(1024) The name of the frequent item

The name of the item is contained in the table that is specified by the nametable parameter. The name of the item is in the column that is specified by the namecol parameter, and in the row that is identified by the ITEM value. If no name mapping table is specified, or if no name is found in this table, the value is identical to the value of the ITEM column.

COUNT BIGINT The number of input transactions that contain the frequent item
SUPPORT DOUBLE The fraction of the input transactions that contain the frequent item