This table defines data mining segments (or models) used with WebSphere Commerce Analyzer.
Column Description(s):
Column Name | Column Type | Description |
SEGMENTATION_ID |
INTEGER NOT NULL |
The ID for the segmentation run. |
PER_ID |
INTEGER |
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. |
SEGMENTATION_NAME |
VARCHAR(64) |
The name of the segmentation run. |
SEGMENTATION_DESC |
VARCHAR(254) |
The text describing the segmentation. Multi-language descriptions are taken from the SEGMENTATION_REF table. |
SEGMENTATION_TYPE |
INTEGER |
Each mining model (or segment) can have slight variations. This column describes the variation number. |
SEGMENTATION_ALG |
INTEGER |
The data mining algorithm used to create this segment. |
NUM_SEGMENTS |
INTEGER |
The number of members of this segment. |
NUM_ATTRIBUTES |
INTEGER |
The number of attributes in this segmentation model. |
NUM_ITEMS |
INTEGER |
The total population for the model build. |
SAMPLE_SIZE_PCT |
INTEGER |
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. |
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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031310390 |
SEGMENTATION_ID |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.