Database Table: SEGMENTATION

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035102850 SEGMENTATION_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable