<model name>_SEQRULES table

This table contains the confident rules that are implied based on the detected sequential patterns. The confidence value of these rules exceeds the value that is specified by the minconf parameter.

The following table shows the table columns.

Table 1. Columns of the <model name>_SEQRULES table
Column name Data type Description
RULEID INTEGER The ID of the rule in the model
SEQUENCEID INTEGER The ID of the whole sequential pattern, which the rule is implied from
BODYID INTEGER The ID of the sequential pattern that represents the left side of the rule
HEADID INTEGER The ID of the sequential pattern that represents the right side of the rule

The head sequential pattern can contain only one item set.

AVGTIME DOUBLE The average relative time between the body sequential patterns and the head sequential patterns

The value is 0.0 if the tid column is neither numeric nor of type date, time, or time stamp.

CONFIDENCE DOUBLE The confidence of the rule, that is, the probability that the head occurs when the body sequential patterns already occur

The confidence is calculated as the support for the whole sequential pattern that is divided by the support for the body sequential pattern.

PRUNED SMALLINT Indicates whether the rule is pruned

The default value is 0.