This table holds each segmentation run's output. A segmentation is made up of several segments (clusters) defined by attributes (data columns) which are then grouped into several value bins.
Column Name | Column Type | Column Description |
---|---|---|
LAST_UPDATED | TIMESTAMP NOT NULL, DEFAULT CURRENT TIMESTAMP |
The time stamp of the last update to the record. |
LAST_UPDATED_ID | INTEGER NOT NULL, DEFAULT 0 |
The ID of the application that last updated the record. |
NUM_ATTRIBUTES | INTEGER NULL |
The number of attributes in this segmentation model. |
NUM_ITEMS | INTEGER NULL |
The total population for the model build. |
NUM_SEGMENTS | INTEGER NULL |
The number of segments that this segmentation run discovered. |
PER_ID | INTEGER NULL |
A uniquely generated ID used for joining the PERIOD table to all other fact tables. Allows the user to select or group dates into standard period definitions such as week, month, quarter, year, and fiscal periods. |
SAMPLE_SIZE_PCT | INTEGER NULL |
The sample size of the data used for building this model. It is defined in term of the percentage size. It ranges from 1 - 100. |
SEGMENTATION_ALG | INTEGER NULL |
An indication which segmentation algorithm was selected by the end user. 0 Demographic segmentation 1 Neural segmentation |
SEGMENTATION_DESC | VARCHAR (254) NULL |
The text describing the segmentation. |
SEGMENTATION_ID | INTEGER NOT NULL |
The ID for the segmentation run. |
SEGMENTATION_NAME | VARCHAR (64) NULL |
The name of the segmentation run. |
SEGMENTATION_TYPE | INTEGER NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035102850 | SEGMENTATION_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|