POI_KB_EXCLUDED_WORDS

Table that contains the list of words that are excluded from the classification process. It contains the excluded words against each knowledge base.

Details

  • Schema: FUSION

  • Object owner: POI

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

poi_kb_excluded_words_PK

KB_NAME, EXCLUDED_WORD

Columns

Name Datatype Length Precision Not-null Comments
KB_NAME VARCHAR2 100 Yes Name of the knowledge base. Knowledge base is the model that is trained and then used for classification.
EXCLUDED_WORD VARCHAR2 255 Yes Words that often appear in item descriptions however have no bearing to the meaning or type of item. For example and, the, for etc. These words if trained negatively affect the classification results.
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.
ENTITY_ID NUMBER 8 Yes Identifies the entity type for the training exclusion.

Indexes

Index Uniqueness Tablespace Columns
poi_kb_excluded_words_U1 Unique Default KB_NAME, EXCLUDED_WORD