WebSphere Commerce database table: SEGMENTATION

This table defines data mining segments (or models) used with WebSphere Commerce Analyzer.


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
SQL050212031310390 SEGMENTATION_ID Primary Key

Feedback