POI_MODEL_STATISTICS

This table contains key statistics about the knowledge base creation process. Statistics like how many training set records were used for each unique category and knowledge base combination is available in this table. This table also includes the training confidence for each unique category and knowledge base combination.

Details

  • Schema: FUSION

  • Object owner: POI

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

POI_MODEL_STATISTICS_PK

CATEGORY_ID, MODEL_NAME

Columns

Name Datatype Length Precision Not-null Comments
CATEGORY_ID NUMBER 18 Yes Identifies the category in the model.
MODEL_NAME VARCHAR2 30 Yes Indicates the name of the model.
TRNG_COUNT NUMBER 18 Training record counts used in model statistics.
TRNG_CONFIDENCE NUMBER 7 Confidence percent value in the model statistics.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
POI_MODEL_STATISTICS_U1 Unique Default CATEGORY_ID, MODEL_NAME