ODMR_USER_WORKFLOW_MODELS

You can query mining models that belong to a specific Build or Model node of a workflow by using the ODMR_USER_WORKFLOW_MODELS repository view.

Table 8-14 provides more information about this view.

Table 8-14 ODMR_USER_WORKFLOW_MODELS Repository Views

Column Data Types Description

PROJECT_ID

NUMBER

This is the project ID 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 workflow node ID.

NODE_NAME

VARCHAR2 (30 CHAR)

This is the name of the workflow node.

NODE_STATUS

VARCHAR2 (30 CHAR)

  • INVALID: Indicates that the node is not valid, and cannot be run.

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

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

  • FAILURE: Indicates that the node run has failed.

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

MODEL_TYPE

VARCHAR2 (30 CHAR)

This is the model type. For example, Naive Bayes Model.

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 (30 CHAR)

Same as node status.

MODEL_CREATIONDATE

VARCHAR2 (30 CHAR)

This is the date when the model is created.

Parent topic: Repository Views