Columns in the Control Table

The columns in the Control Table contains information related to nodes and models.

Table 7-2 lists the columns in the Control Table along with their description and examples.


Table 7-2 Columns in the Control Table and their Description

Column Name Description Examples

NODE_ID

This is the ID of the node that constitutes a part of the workflow. It uniquely identifies the node.

10001, 10002

NODE_NAME

This is the name of the node that constitutes a part of the workflow.

Class Build, MINING_DATA_BUILD_V

NODE_TYPE

This is the category of node.

Data Source node, Class Build node and so on.

MODEL_ID

This is the ID of the workflow model. It uniquely identifies each model referenced within a workflow.

10101, 10102

MODEL_NAME

This is the name of the model.

CLAS_GLM_1_6

MODEL_TYPE

Model type is the algorithm type used by the model.

Generalized Linear Model, Support Vector Machines and so on

OUTPUT_NAME

This is the name of the output. These are internally generated names unless the names are under the control of the user.

Table/View Name, Model Name, Text object names such as:

ODMR$15_37_21_839599RMAFRXI - table name

"DMUSER"."CLAS_GLM_1_6" - fully qualified model name

OUTPUT_TYPE

It qualifies the type of output object.

Table, view, model

ADDITIONAL_INFO

This is the information that qualifies the purpose of the object about the script execution.

Target class for test lift result

CREATION_TIME

This is the time of object creation.

11-DEC-12 03.37.25.935193000 PM (format determined by locale)

COMMENTS

Comment to qualify the role of the object about the script execution.

Output Data (displayed for nodes like Data Source)

Data Usage (displayed for the view passed into model build)

Weights Setting (displayed for a weights table passed into model build)

Build Setting (displayed for a build settings table passed into model build)

Model (displayed for a Model object)