ODMR_USER_WF_CLAS_TEST_RESULTS

By using the ODMR_USER_WF_CLAS_TEST_RESULTS repository view, you can query the generated classification results for a specific mining model in the last workflow run.

Table 8-15 provides more information about this .

Table 8-15 ODMR_USER_WF_CLAS_TEST_RESULTS

Column Data Type Description

PROJECT_ID

NUMBER

This is the ID of the project in which the workflow was created in.

PROJECT_NAME

VARCHAR2 (30 CHAR)

This is the name of the project in which the workflow was created in.

WORKFLOW_ID

NUMBER

This is the ID of the workflow.

WORKFLOW_NAME

VARCHAR2 (30 CHAR)

This is the name of the workflow.

NODE_TYPE

VARCHAR2 (30 CHAR)

This is the node type.

NODE_ID

NUMBER

This is the ID of the node.

NODE_NAME

VARCHAR2 (30 CHAR)

This is the name of the node.

NODE_STATUS

VARCHAR2 (10 CHAR)

  • INVALID: Indicates that the node is not ready to be run.

  • WARNING: Indicates that the node has run completely, but with warning.

  • READY: Indicates that the node is ready to be run.

  • FAILURE: Indicates that the node run has failed.

  • COMPLETE: Indicates that the node has run successfully.

MODEL_ID

NUMBER

This is the ID of the model.

MODEL_NAME

VARCHAR2 (30 CHAR)

This is the name of the model.

MODEL_STATUS

VARCHAR2 (10 CHAR)

  • WARNING: Indicates that the model has run, but with warning.

  • READY: Indicates that the model is ready to be run.

  • FAILURE: Indicates that the model run has failed.

  • COMPLETE: Indicates that the model run has completed successfully.

MODEL_CREATIONDATE

VARCHAR2 (30 CHAR)

This is the creation time of the model.

TEST_METRICS

VARCHAR2 (128 CHAR)

The test metric result table that contains Predictive Confidence, accuracy, and so on.

CONFUSION_MATRIX

VARCHAR2 (128 CHAR)

The Confusion Matrix result table.

LIFTS

DM_NESTED_CATEGORICALS

The table of DM_NESTED_CATEGORICAL, where:

  • ATTRIBUTE_NAME contains target class

  • VALUE contains lift result table

ROCS

DM_NESTED_CATEGORICALS

The table of DM_NESTED_CATEGORICAL, where:

  • ATTRIBUTE_NAME contains target class

  • VALUE contains ROC result table

ROC_AREA

DM_NESTED_NUMERICALS

The table of DM_NESTED_NUMERICAL, where:

  • ATTRIBUTE_NAME contains target class

  • VALUE contains ROC area under curve value

Parent topic: Repository Views