<model name>_SEQPATTERNS_STATISTICS table
This table contains the statistics for the detected patterns.
The following table shows the table columns.
| Column name | Data type | Description |
|---|---|---|
| SEQUENCEID | INTEGER | The ID of the sequential pattern in the model |
| LENGTH | INTEGER | The number of items in the sequential pattern |
| COUNT | BIGINT | The number of input sequences that contain the sequential pattern |
| SUPPORT | DOUBLE | The fraction of the input sequences that contain the sequential pattern |
| LIFT | DOUBLE | The lift between the actual support for the sequential pattern that is
compared to the statistical probability of the sequential pattern The lift is calculated as the support for the sequential pattern that is divided by the product of the support for all items in the sequential pattern. |
| AVGTIME | DOUBLE | The average duration time of the sequential pattern The value is 0.0 if the tid column is neither numeric nor of type date, time, or time stamp. |
| DEVTIME | DOUBLE | The standard deviation of the average duration time of the sequential pattern The value is 0.0 if the tid column is neither numeric nor of type date, time, or time stamp. |
| PRUNED | SMALLINT | Indicates whether the sequential pattern is pruned The default value is 0. |