9 Model Operations
Oracle Data Mining enables you to test Classification and Regression models.
A Test node is one of several ways to test a model. After you build a model, you apply the model to new data using an Apply node. Evaluate and Apply data must be prepared in the same way that build data was prepared.
The nodes related to model operations are:
- Apply Node
The Apply node takes a collection of models, both partitioned models and non-partitioned models, and returns a single score. The Apply node produces a query as the result. - Feature Compare Node
The Feature Compare node allows you to perform calculations related to semantics in text data, contained in one Data Source node against another Data Source node. - Test Node
Oracle Data Mining enables you to test Classification and Regression models. You cannot test other kinds of models.
Related Topics
Apply Node
The Apply node takes a collection of models, both partitioned models and non-partitioned models, and returns a single score. The Apply node produces a query as the result.
The result can further transformed or connected to a Create Table or View node to save the data as a table. To make predictions using a model, you must apply the model to new data. This process is also called scoring the new data.
An Apply node generates the SQL for Scoring using one or more models. The SQL includes pass-through (supplemental) attributes and columns generated using Scoring functions.
Note:
You cannot apply Association or Attribute Importance models.
- Apply Preferences
In the Preferences dialog box, you can view and change preferences for Apply operations. - Apply Node Input
Inputs for an Apply node can be Model nodes, Model Build nodes, or any node that generates data, such as Data node. - Apply Node Output
An Apply node generates a data flow based on the Apply and Output specifications. - Creating an Apply Node
You create an Apply node to score data based on the models. - Apply and Output Specifications
There are several ways to create Apply and Output specifications for an Apply node. - Evaluate and Apply Data
Test and Apply data for a model must be prepared in the same way that Build data for the model was prepared. - Edit Apply Node
In the Edit Apply Node dialog box, you can specify or change the characteristics of the models to build. - Apply Node Properties
In the Properties pane, you can examine and change the characteristics or properties of a node. - Apply Node Context Menu
The context menu options depend on the type of the node. It provides the shortcut to perform various tasks and view information related to the node. - Apply Data Viewer
The Apply Data Viewer displays the data, columns, and the SQL queries used to generate the Apply output.
Related Topics
Parent topic: Model Operations
Apply Preferences
In the Preferences dialog box, you can view and change preferences for Apply operations.
To apply preferences to an Apply Node:
Parent topic: Apply Node
Apply Node Input
Inputs for an Apply node can be Model nodes, Model Build nodes, or any node that generates data, such as Data node.
An Apply node requires the following input:
-
One or more of the following:
-
Model node
-
Model Build node
You must specify at least one model to apply. You can apply several models at the same time.
-
-
Any node that generates data as an output such as a Data node, a Transforms node, or an appropriate Text node.
Only one input node is permitted.
When you apply a model to new data, the new data must be transformed in the same way as the data used to build the model.
Note:
You cannot apply Association or Attribute Importance models.
Parent topic: Apply Node
Apply Node Output
An Apply node generates a data flow based on the Apply and Output specifications.
You can provide specifications for Apply and Output in different ways such as using the Automatic Settings option, Define Apply Column Wizard and so on.
Related Topics
Parent topic: Apply Node
Creating an Apply Node
You create an Apply node to score data based on the models.
Related Topics
Parent topic: Apply Node
Apply and Output Specifications
There are several ways to create Apply and Output specifications for an Apply node.
You can choose to use any one of the following:
- Edit Apply Node
In the Edit Apply Node dialog box, you can edit settings for predictions, additional output, and automatic settings. - Define Apply Columns Wizard
The Define Apply Column wizard is a two step wizard, that allows you to define Apply and Output specifications. - Additional Output
Additional Output consists of columns that are passed unchanged through the Apply operation.
Parent topic: Apply Node
Edit Apply Node
In the Edit Apply Node dialog box, you can edit settings for predictions, additional output, and automatic settings.
To edit or view an Apply specification, either double-click the Apply node or right-click the Apply node and select Edit. The Edit Apply Node dialog box has two tabs:
-
Predictions: Defines the Apply Scoring specifications.
An Apply specification consists of several Output Apply columns. The column names are generated automatically.
-
You can specify names. The names must not be more than 30 characters.
-
You can then select a model from the list of models in all Input nodes and an Apply function. The Apply functions that you can select depend on the selected models.
-
-
Additional Output: Specifies pass-through columns from the Input node. You can select as many columns as you want. You can specify that these selected columns are displayed before the Apply columns (the default) or after the Apply columns.
These columns are often used to identify the Apply output. For example, you can use the Case ID column to identify the Apply output.
The default is to not specify any additional output.
The Default Column Order, at the bottom of the Edit Apply Node dialog box, is Data Columns First
in the output. You can change this to Apply Columns First.
Select Order Partitions option if you want predictions for partitioned models. By default, this option is selected, even when there are non-partitioned models as inputs for the Apply node.
- Predictions
In the Predictions tab, you can define Apply Scoring specifications. - Add or Edit Apply Output Column
In the Add Apply Output dialog box or the Edit apply Output dialog box, you can manually add or edit a single column Apply definition. You can edit or add Apply definitions one at a time. - Add Output Apply Column Dialog
In the Add Output Apply Column dialog box, you can manually add and edit columns in a node that is connected to the Apply node.
Related Topics
Parent topic: Apply and Output Specifications
Predictions
In the Predictions tab, you can define Apply Scoring specifications.
To define specific Apply settings or to edit the default settings, deselect Automatic Settings. You then add new Apply functions or edit existing ones.
Select a case ID from the Case ID drop-down list, as applicable.
You can edit settings in several ways:
-
Show Partition Columns: Select a column and click
to view the partition keys.
-
Add a setting: Click
to open the Add Output Apply Column dialog box.
-
Edit an existing setting: Select the setting and click
. The Edit Output Data Column dialog box opens.
-
Delete a specification: Select it and click
.
-
Define Apply Columns: Click
. In the Define Apply Columns Wizard, click the Define Apply Columns icon.
- Apply Functions
The Apply functions that you can choose depend on the models that you apply. - Apply Functions Parameters
- Default Apply Column Names
Related Topics
Parent topic: Edit Apply Node
Apply Functions
The Apply functions that you can choose depend on the models that you apply.
Note:
Certain Apply functions are available only if you are connected to Oracle Database 12c or later.
The Apply functions, arranged according to Model node are:
-
Anomaly Detection Models
-
Prediction: An automatic setting that returns the best prediction for the model. The data type returned depends on the target value type used during the build of the model. For Regression models, this function returns the expected value. The function returns the lowest cost prediction using the stored cost matrix if a cost matrix exists. If no stored cost matrix exists, then the function returns the highest probability prediction.
-
Prediction Details: Returns prediction details. The return value describes the attributes of the prediction. For Anomaly Detection, the returned details refer to the highest probability class or the specified class value.
Note:
Prediction Details requires a connection to Oracle Database 12 c or later.
The defaults for Predictions Details are:
-
Target Value:
Most Likely
-
Sort by Weights: Absolute value
-
Maximum Length of Ranked Attribute List:
5
Prediction Details output is in XML format (XMLType data type). You must parse the output to find the data that you need.
-
-
Prediction Probability: An automatic setting that returns the probability associated with the best prediction.
-
Prediction Set: Returns a varray of objects containing all classes in a multiclass classification scenario. The object fields are named
PREDICTION, PROBABILITY,
andCOST.
The data type of thePREDICTION
field depends on the target value type used during the build of the model. The other two fields are both OracleNUMBER.
The elements are returned in the order of best prediction to worst prediction.
-
-
Clustering Models
-
Cluster Details: The return value describes the attributes of the highest probability cluster or the specified cluster ID. If you specify a value for TopN, then the function returns the N attributes that most influence the cluster assignment (the score). If you do not specify TopN, then the function returns the five most influential attributes.
Note:
Cluster Details requires a connection to Oracle Database 12c or later.
The defaults for Predictions Details are as follows:
-
Cluster ID:
Most Likely
-
Sort by Weight: Absolute value
-
Maximum Length of Ranked Attribute List:
5
The returned attributes are ordered by weight. The weight of an attribute expresses its positive or negative impact on cluster assignment. A positive weight indicates an increased likelihood of assignment. A negative weight indicates a decreased likelihood of assignment.
Cluster Details output is in XML format (XMLType data type). You must parse the output to find the data that you need.
-
-
Cluster Distance: Returns a cluster distance for each row in the selection. The cluster distance is the distance between the row and the centroid of the highest probability cluster or the specified cluster ID.
Note:
Cluster Distance requires connection to Oracle Database 12c. or later.
The defaults for Predictions Details are as follows:
-
Cluster ID:
Most Likely
-
-
Cluster ID: An automatic setting that returns the
NUMBER
of the most probable cluster ID. If the cluster ID has been renamed, then aVARCHAR2
is returned instead. -
Cluster Probability: An automatic setting that returns a measure of the degree of confidence of membership (NUMBER) of an input row in a cluster associated with the specified model.
-
Cluster Set: Returns an array of objects containing all possible clusters that a given row belongs to given the parameter specifications. Each object in the array is a pair of scalar values containing the cluster ID and the cluster probability. The object fields are named
CLUSTER_ID
andPROBABILITY,
and both are Oracle NUMBER Clustering models only.
-
-
Feature Extraction Models
-
Feature ID: Returns an Oracle NUMBER that is the identifier of the feature with the highest value for the row.
-
Feature Set: An automatic setting that is similar to Cluster Set.
-
Feature Value: Returns the value of a given feature. If you omit the feature ID argument, then the function returns the highest feature value.
-
Feature Details: The return value describes the attributes of the highest value feature or the specified feature ID. If you specify a value for TopN, then the function returns the
N
attributes that most influence the feature value. If you do not specify TopN, then the function returns the 5 most influential attributes.Note:
Feature Extraction Model requires connection to Oracle Database 12c or later.
The returned attributes are ordered by weight. The weight of an attribute expresses its positive or negative impact on the value of the feature. A positive weight indicates a higher feature value. A negative weight indicates a lower feature value.
The defaults for Predictions Details are as follows:
-
Feature ID:
Most Likely
-
Sort by Weight: Absolute value
-
Maximum Length of Ranked Attribute List:
5
Feature Details output is in XML format (XMLType data type). You must parse the output to find the data that you need.
-
-
-
Classification and Regression Models
-
Prediction: An automatic setting that returns the best prediction for the model. The data type returned depends on the target value type used during the build of the model.
-
For Regression models, this function returns the expected value.
-
For Classification models, the returned details refer to the highest probability class or the specified class value.
The function returns the lowest cost prediction using the stored cost matrix if a cost matrix exists. If no stored cost matrix exists, then the function returns the highest probability prediction.
-
-
Prediction Bounds: For generalized linear models, it returns an object with two NUMBER fields
LOWER
andUPPER.
If the GLM was built using Ridge Regression, or if the Covariance Matrix is found to be singular during the build, then this function returnsNULL
for both fields.-
For a Regression mining function, the bounds apply to value of the prediction.
-
For a Classification mining function, the bounds apply to the probability value.
-
-
Prediction Bounds Lower: Same as Prediction Bounds but only returns the lower bounds as a scalar column. Automatic Setting for GLM models.
-
Prediction Bounds Upper: Same as Prediction Bounds but only returns the upper bounds as a scalar column. Automatic Setting for GLM models.
-
Prediction Details: Requires connection to Oracle Database 12 c or later, except for Decision Tree.
The defaults for Predictions Details for Classification are as follows:
-
Target Value:
Most Likely
-
Sort by Weights: Absolute value
-
Maximum Length of Ranked Attribute List:
5
The defaults for Predictions Details for Regression are as follows:
-
Sort by Weights: Absolute value
-
Maximum Length of Ranked Attribute List:
5
DT Prediction Details: Returns a string containing model-specific information related to the scoring of the input row. In Oracle Data Miner releases earlier than 4.0, the return value is in the form
<Node id = "integer"/>
.Note:
DT Prediction Details requires a connection to Oracle Database 11g Release 2 (11.2) or later.
-
-
-
Classification
-
Prediction Costs: Returns a measure of cost for a given prediction as a
NUMBER.
Classification models only. Automatic Setting for DT models. -
Prediction Probability: Returns the probability associated with the best prediction. The Automatic Setting for is
Most Likely.
-
Prediction Set: Returns an array of objects containing all classes in a multiclass classification scenario. The object fields are named
PREDICTION, PROBABILITY,
andCOST.
The data type of thePREDICTION
field depends on the target value type used during the build of the model. The other two fields are both Oracle NUMBER. The elements are returned in the order of best prediction to worst prediction.
-
Related Topics
Parent topic: Predictions
Apply Functions Parameters
The Apply Function parameters that can be specified:
-
Cluster ID: The default is
Most Probable.
No other parameters are supported. -
Cluster Probability: The default is
Most Probable.
You can also select a specific cluster ID or specifyNULL
orMost Likely
to return the bounds for the most likely cluster. -
Cluster Set: The default is
All Clusters
You can also specify either or both of the following:-
TopN:
WhereN
is between one and the number of clusters. The optional TopN argument is a positive integer that restricts the set of features to those that have one of the topN
values. If there is a tie at theN
th value, then the database still returns onlyN
values. If you omit this argument, then the function returns all features. -
Probability Cutoff:
It is a number strictly greater than zero and less than or equal to 1. The optional cutoff argument restricts the returned features to only those that have a feature value greater than or equal to the specified cutoff. To filter only by cutoff, specify Null for TopN and the desired cutoff for cutoff.
-
-
Feature ID: The default is
Most Probable.
No other values are supported. -
Feature Set: The default is
All Feature IDs.
You can also specify either or both of the following:-
TopN:
WhereN
is between 1 and the number of clusters. The optional TopN argument is a positive integer that restricts the set of features to those that have one of the topN
values. If there is a tie at theN
th value, then the database still returns onlyN
values. If you omit this argument, then the function returns all features. -
Probability Cutoff:
It is a number strictly greater than zero and less than or equal to one. The optional cutoff argument restricts the returned features to only those that have a feature value greater than or equal to the specified cutoff. To filter only by cutoff, specify Null for TopN and the desired cutoff.
-
-
Feature Value: The default is
Highest Value.
You can also select a specific feature ID value or specify anyone of the following value to return the bounds for the most likely feature:-
NULL
-
Most Likely
-
-
Prediction: The default is
Best Prediction
to consider the cost matrix. -
Prediction Upper Bounds or Prediction Lower Bounds: The default is
Best Prediction
with Confidence Level 95%. You can change Confidence Level to any number strictly greater than zero and less than or equal to one. For Classification models only, you can use the Target Value Selection dialog box option to pick a specific target value. You can also specifyNull
orMost Likely
to return the bounds for the most likely target value. -
Prediction Costs: The default is
Best Prediction.
Applicable for Classification models only. You can use the Target Value Selection option to pick a specific target value. -
Prediction Details: Only value is the details for the Best Prediction.
-
Prediction Probability: The default is
Best Prediction.
Applicable for Classification models only. You can use the Target Value Selection option to pick a specific target value. -
Prediction Set: The default is
All Target Values.
You can also specify one or both of the following:-
bestN:
WhereN
is between one and the number of targets. The optionalbestN
argument is a positive integer that restricts the returned target classes to theN
having the highest probability, or lowest cost if cost matrix clause is specified. If multiple classes are tied in theN
th value, then the database still returns onlyN
values. To filter only by cutoff, specifyNull
for this parameter. -
Probability Cutoff:
Is a number strictly greater than zero and less than or equal to one. The optional cutoff argument restricts the returned target classes to those with a probability greater than or equal to (or a cost less than or equal to if cost matrix clause is specified) the specified cutoff value. You can filter solely by cutoff by specifyingNull
for this value.
-
Parent topic: Predictions
Default Apply Column Names
The syntax of the default Apply column name:
"<FUNCTION ABBREVIATION>_<MODEL NAME><SEQUENCE>
SEQUENCE
is used only if necessary to avoid a conflict. A sequence number may force the model name to be partially truncated.
FUNCTION ABBREVIATION
is one of the following:
-
Cluster Details:
CDET
-
Cluster Distance:
CDST
-
Cluster ID:
CLID
-
Cluster Probability:
PROB
-
Cluster Set:
CSET
-
Feature Details:
FDET
-
Feature ID:
FEID
-
Feature Set:
FSET
-
Feature Value:
FVAL
-
Prediction:
PRED
-
Prediction Bounds:
PBND
-
Prediction Upper Bounds:
PBUP
-
Prediction Lower Bounds:
PBLW
-
Prediction Costs:
PCST
-
Prediction Details:
PDET
-
Prediction Probability:
PROB
-
Prediction Set:
PSET
Specific target, feature, or cluster default names are abbreviated in one of two ways.
-
The first approach attempts to integrate the value of the target, feature, or cluster into the column name. This approach is used if the maximum value of the target, cluster, or feature does not exceed the remaining character spaces available in the name. The name must be 30 or fewer characters.
-
The second approach substitutes the target, cluster, or feature with a sequence ID. This approach is used if the first approach is not possible.
Parent topic: Predictions
Add or Edit Apply Output Column
In the Add Apply Output dialog box or the Edit apply Output dialog box, you can manually add or edit a single column Apply definition. You can edit or add Apply definitions one at a time.
Before you add or edit columns, you must deselect Automatic Settings.
You can perform the following tasks:
-
Add an Apply Output column: Click
.
-
Edit an Apply Output column: Click
. When you edit a column, only the Function selection box and its parameters can be edited.
The following controls are available:
-
Column: Name of column to be generated.
-
Auto :
-
If selected, then you cannot edit the name of the column.
-
If deselected, then auto naming is disabled, and you can rename the column. Column names are validated to ensure that they are unique.
-
-
Node: List of Model Input nodes connected to node. If there is only one Input node, then it is selected by default.
-
Model: List of models for the selected node. If there is only one model, then it is selected by default.
-
Function: List of model scoring functions for the selected model.
-
Parameters: Displays
0
or more controls necessary to support the parameter requirements of the selected function.
When you have finished defining the output column, click OK.
Related Topics
Parent topic: Edit Apply Node
Add Output Apply Column Dialog
In the Add Output Apply Column dialog box, you can manually add and edit columns in a node that is connected to the Apply node.
By default, name is automatically assigned to the output column.
To add a column:
- In the Column field, provide a name.
- Deselect Auto.
- In the Node field, select one of the node connected to the Apply node. The type of the node that you select determines the choices in the Model and Function fields.
- In the Model field, select a model.
- In the Function field, select a function.
- After you are done, click OK.
Related Topics
Parent topic: Edit Apply Node
Define Apply Columns Wizard
The Define Apply Column wizard is a two step wizard, that allows you to define Apply and Output specifications.
The Define Apply Column wizard comprises the following steps:
- Models
In the Models section in the Apply Columns wizard, you can select models and define the output specifications for it. - Output Specifications
In Output Specifications section, the possible output specifications for the selected model are listed with the default settings selected. - Define Top N
If you select the Top N option, then you must define the settings related to it.
Parent topic: Apply and Output Specifications
Models
In the Models section in the Apply Columns wizard, you can select models and define the output specifications for it.
To select a model:
- Select the Models for which you want to define output specification.
- Click Next.
Parent topic: Define Apply Columns Wizard
Output Specifications
In Output Specifications section, the possible output specifications for the selected model are listed with the default settings selected.
To define output specifications for the selected model:
Related Topics
Parent topic: Define Apply Columns Wizard
Define Top N
If you select the Top N option, then you must define the settings related to it.
To define the settings related to Top N option:
- Click Use Best N and select the N Value from the drop-down list.
- Click Cut Off and select a value from the Prob Value drop-down list.
- Click OK.
Parent topic: Define Apply Columns Wizard
Additional Output
Additional Output consists of columns that are passed unchanged through the Apply operation.
You can specify pass-through columns from the Input node. You can select as many columns as you want. You can specify that these selected columns are displayed before the Apply columns (the default) or after the Apply columns. These columns are often used to identify the Apply output. For example, you can use the Case ID column to identify the Apply output.
Related Topics
Parent topic: Apply and Output Specifications
Evaluate and Apply Data
Test and Apply data for a model must be prepared in the same way that Build data for the model was prepared.
To properly prepare Test and Apply data, duplicate the transformation chains of build data for Test and Apply data by copying and pasting build Transforms nodes.
Parent topic: Apply Node
Edit Apply Node
In the Edit Apply Node dialog box, you can specify or change the characteristics of the models to build.
The default value for Default Column Order is Data Columns First,
which means that any data columns that you add come first in the output. You can change this to Apply Columns First.
Select Order Partitions option if you want predictions for partitioned models. By default, this option is selected, even when there are non-partitioned models as inputs for the Apply node.
The Edit Apply Node dialog box has the following tabs:
- Predictions
In the Predictions tab, you can define Apply Scoring specifications. - Additional Output
In the Additional Output tab, you can specify pass-through attributes from Data Source nodes. - Apply Columns
To create an Apply specification, deselect Automatic Settings. By default, Automatic Settings is selected.
Parent topic: Apply Node
Predictions
In the Predictions tab, you can define Apply Scoring specifications.
To define specific Apply settings or to edit the default settings, deselect Automatic Settings. You then add new Apply functions or edit existing ones.
Select a case ID from the Case ID drop-down list, as applicable.
You can edit settings in several ways:
-
Show Partition Columns: Select a column and click
to view the partition keys.
-
Add a setting: Click
to open the Add Output Apply Column dialog box.
-
Edit an existing setting: Select the setting and click
. The Edit Output Data Column dialog box opens.
-
Delete a specification: Select it and click
.
-
Define Apply Columns: Click
. In the Define Apply Columns Wizard, click the Define Apply Columns icon.
Related Topics
Parent topic: Edit Apply Node
Additional Output
In the Additional Output tab, you can specify pass-through attributes from Data Source nodes.
To add columns:
- Click
. The Edit Output Data Column dialog box opens.
- In the Edit Apply Node dialog box, the Default Column Order is
Data Columns First.
You can change this toApply Columns First.
- After you are done, click OK.
Related Topics
Parent topic: Edit Apply Node
Apply Columns
To create an Apply specification, deselect Automatic Settings. By default, Automatic Settings is selected.
You can perform the following tasks:
-
To define Apply columns, click
. The Define Apply Column wizard opens.
-
To add an Output Apply column, click
.
The Add Output Apply Column dialog box opens.
-
To delete an Output Apply column, click
.
-
To edit an Output Apply column specification, select the specification. Click
. The Add or Edit Apply Output Column dialog box opens.
Related Topics
Parent topic: Edit Apply Node
Apply Node Properties
In the Properties pane, you can examine and change the characteristics or properties of a node.
To view the properties of a node, click the node and click Properties. If the Properties pane is closed, then go to View and click Properties. Alternately, right-click the node and click Go to Properties.
Apply Node Properties has the following sections:
-
Predictions: Displays the Output Apply columns defined on the Apply Columns. You can edit these details. The option Automatic Selection is selected if selections were not modified.
For each Output Apply Column, the Name, Function, Parameters, and Node are listed.
-
Additional Output: Lists the Output Data Columns that are passed through. For each column, the Name, Alias (if any), and Data Type are listed.
-
Cache
-
Details: Displays the name of the node and comments.
Related Topics
Parent topic: Apply Node
Apply Node Context Menu
The context menu options depend on the type of the node. It provides the shortcut to perform various tasks and view information related to the node.
To view the Apply node context menu, right-click the node. The following options are available in the context menu:
- Connect
Use the Connect option to link nodes in a workflow. - Run
Use the Run option to execute the tasks specified in the nodes that comprise the workflow. - Force Run
Use the Force Run option to rerun one or more nodes that are complete. - Create Schedule
Use the Create Schedule option to define a schedule to run a workflow at a definite time and date. - Edit
Use the Edit option to edit the default settings of a node. - View Data
Use the View Data option to view the data contained in a Data node. - Generate Apply Chain
Use the Generate Apply Chain to create a new node that contains the specification of a node that performs a transformation. - Show Event Log
Use the Show Event Log option to view information about events in the current connection, errors, warnings, and information messages. - Show Validation Errors
Use the Show Validation Errors option to view validation errors, if any. - Validate Parents
Use the Validate Parents option to validate all parent nodes of the current node. - Deploy
Use the Deploy option to deploy a node or workflow by creating SQL scripts that perform the tasks specified in the workflow. - Save SQL
Use the Save SQL option to generate SQL script for the selected node. - Cut
Use the Cut option to remove the selected object, which could be a node or connection. - Copy
Use the Copy option to copy one or more nodes and paste them into the same workflow or a different workflow. - Paste
Use the Paste option to paste the copied object in the workflow. - Select All
Use the Select All option to select all the nodes in a workflow. - Performance Settings
Use the Performance Settings option to edit Parallel settings and In-Memory settings of the nodes. - Go to Properties
Use the Go to Properties option to open the Properties pane of the selected node. - Navigate
Use the Navigate option to view the links available from the selected node.
Related Topics
Parent topic: Apply Node
Connect
Use the Connect option to link nodes in a workflow.
To connect nodes:
Related Topics
Parent topic: Apply Node Context Menu
Run
Use the Run option to execute the tasks specified in the nodes that comprise the workflow.
The Data Miner server runs workflows asynchronously. The client does not have to be connected. You can run one or more nodes in the workflow:
-
To run one node: Right-click the node and select Run.
-
To run multiple nodes simultaneously: Select the nodes by holding down the Ctrl key and click each individual node. Then right-click any selected node and select Run.
If a node depends on outputs of one or more parent nodes, then the parent node runs automatically only if the outputs required by the running node are missing.
Parent topic: Apply Node Context Menu
Force Run
Use the Force Run option to rerun one or more nodes that are complete.
Force Run deletes any existing models before building them once again.
To select more than one node, click the nodes while holding down the Ctrl
key.
You can Force Run a node at any location in a workflow. Depending on the location of the node in the workflow, you have the following choices for running the node using Force Run:
-
Selected Node
-
Selected Node and Children
(available if the node has child nodes) -
Child Node Only
(available if the node one or more child nodes) -
Selected Node and Parents
(available if the node has parent nodes)
Parent topic: Apply Node Context Menu
Create Schedule
Use the Create Schedule option to define a schedule to run a workflow at a definite time and date.
To save the workflow schedule settings, click . You can provide a name for the schedule in the Save a Schedule dialog box.
Related Topics
Parent topic: Apply Node Context Menu
Edit
Use the Edit option to edit the default settings of a node.
Nodes have default algorithms and settings. When you edit a node, the default algorithms and settings are modified. You can edit a node in any one of the following ways:
-
Edit nodes using the Edit dialog box
-
Edit nodes through Properties UI
Parent topic: Apply Node Context Menu
View Data
Use the View Data option to view the data contained in a Data node.
The Data nodes are Create Table or View node, Data Source node, Explore Data node, Graph node, SQL Query node, and Update Table node.
Related Topics
Parent topic: Apply Node Context Menu
Generate Apply Chain
Use the Generate Apply Chain to create a new node that contains the specification of a node that performs a transformation.
If you have several transformations performed in sequence, for example, Sample
followed by a Custom transform
, then you must select Generate Apply Chain for each transformation in the sequence.You must connect the individual nodes and connect them to an appropriate data source.
Generate Apply Chain helps you create a sequence of transformations that you can use to ensure that new data is prepared in the same way as existing data. For example, to ensure that Apply data is prepared in the same way as Build data, use this option.
The Generate Apply Chain option is not valid for all nodes. For example, it does not copy the specification of a Build node.
Parent topic: Apply Node Context Menu
Show Event Log
Use the Show Event Log option to view information about events in the current connection, errors, warnings, and information messages.
Clicking the Show Event Log option opens the View and Event Log dialog box.
Related Topics
Parent topic: Apply Node Context Menu
Show Validation Errors
Use the Show Validation Errors option to view validation errors, if any.
This option is displayed only when there are validation errors. For example, if an Association node is not connected to a Data Source node, then select Show Validation Errors to view the validation error No build data input node connected.
You can also view validation errors by moving the mouse over the node. The errors are displayed in a tool tip.
Parent topic: Apply Node Context Menu
Validate Parents
Use the Validate Parents option to validate all parent nodes of the current node.
To validate parent nodes of a node, right-click the node and select Validate Parents.
You can validate parent nodes when the node is in Ready, Complete
and Error
state. All parent nodes must be in completed state.
Parent topic: Apply Node Context Menu
Deploy
Use the Deploy option to deploy a node or workflow by creating SQL scripts that perform the tasks specified in the workflow.
The scripts generated by Deploy
are saved to a directory.
Note:
You must run a node before deploying it.
You can generate a script that replicates the behavior of the entire workflow. Such a script can serve as the basis for application integration or as a light-weight deployment than the alternative of installing the Data Miner repository and workflows in the target and production system.
To deploy a workflow or part of a workflow:
Parent topic: Apply Node Context Menu
Save SQL
Use the Save SQL option to generate SQL script for the selected node.
To generate SQL script for the selected node:
Related Topics
Parent topic: Apply Node Context Menu
Cut
Use the Cut option to remove the selected object, which could be a node or connection.
You can also delete objects by selecting them and pressing DELETE on your keyboard.
Parent topic: Apply Node Context Menu
Copy
Use the Copy option to copy one or more nodes and paste them into the same workflow or a different workflow.
To copy and paste nodes:
Note:
Copying and pasting nodes do not carry any mining models or results from the original node.
Parent topic: Apply Node Context Menu
Paste
Use the Paste option to paste the copied object in the workflow.
To paste an object, right-click the workflow and click Paste. Alternately, you can press Ctrl+V.
Note:
Node names and model names are changed to avoid naming collisions. To preserve names, use the option Extended Paste.
Related Topics
Parent topic: Apply Node Context Menu
Select All
Use the Select All option to select all the nodes in a workflow.
The selected nodes and links are highlighted in a dark blue border.
Parent topic: Apply Node Context Menu
Performance Settings
Use the Performance Settings option to edit Parallel settings and In-Memory settings of the nodes.
If you click Performance Settings in the context menu, or if you click Performance Options in the workflow toolbar, then the Edit Selected Node Settings dialog box opens. It lists all the nodes that comprise the workflow. To edit the settings in the Edit Selected Node Settings dialog box:
-
Click Parallel Settings and select:
-
Enable: To enable parallel settings in the selected nodes in the workflow.
-
Disable: To disable parallel settings in the selected nodes in the workflow.
-
All: To turn on parallel processing for all nodes in the workflow.
-
None: To turn off parallel processing for all nodes in the workflow.
-
-
Click In-Memory Settings and select:
-
Enable: To enable In-Memory settings for the selected nodes in the workflow.
-
Disable: To disable In-Memory settings for the selected nodes in the workflow.
-
All: To turn on In-Memory settings for the selected nodes in the workflow.
-
None: To turn off In-Memory settings for all nodes in the workflow
-
-
Click
to set the Degree of Parallel, and In-Memory settings such as Compression Method, and Priority Levels in the Edit Node Performance Settings dialog box.
If you specify parallel settings for at least one node, then this indication appears in the workflow title bar:
Performance Settings is either On for Selected nodes, On (for All nodes), or Off. You can click Performance Options to open the Edit Selected Node Settings dialog box.
-
Click
to edit default the preferences for parallel processing.
-
Edit Node Default Settings: You can edit the Parallel Settings and In-Memory settings for the selected node in the Performance Options dialog box. You can access the Performance Options dialog box from the Preferences options in the SQL Developer Tools menu.
-
Change Settings to Default
-
Parent topic: Apply Node Context Menu
Go to Properties
Use the Go to Properties option to open the Properties pane of the selected node.
Related Topics
Parent topic: Apply Node Context Menu
Navigate
Use the Navigate option to view the links available from the selected node.
Note:
The Navigate option is enabled only if there are links to other nodes.Navigate displays the collection of links available from this node. Selecting one of the links selects the link and the selected link is highlighted in the workflow. The link itself has context menu options as well so you can right click and continue with the Navigate option. You can also use the arrow keys to progress to the next node.
Parent topic: Apply Node Context Menu
Apply Data Viewer
The Apply Data Viewer displays the data, columns, and the SQL queries used to generate the Apply output.
The Apply Data viewer opens in a new tab. The viewer has these tabs:
-
Data: Displays rows of data. The default is to view the cache data. You can perform the following tasks:
-
View actual data.
-
Sort data.
-
Filter data with a SQL expression.
-
Refresh the display. To refresh, click
.
-
-
Columns: Lists the columns in the apply.
-
SQL: Lists the SQL queries used to generate the Apply Output.
Parent topic: Apply Node
Feature Compare Node
The Feature Compare node allows you to perform calculations related to semantics in text data, contained in one Data Source node against another Data Source node.
The requirements of a Feature Compare node are:
-
Two input data sources. The data source can be data flow of records, such as connected by a Data Source node or a single record data entered by user inside the node. In case of data entered by users, input data provider is not needed.
-
One input Feature Extraction model provider node, where a model can be selected for calculations related to semantics.
You can do compare features of two data inputs sources by right-clicking the node and selecting Edit.
- Create Feature Compare Node
You create a Feature Compare node to perform calculations about text data. - Feature Compare
In the Feature Compare dialog box, you can specify or change the characteristics of the models to build. - Feature Compare Node Context Menu
The context menu options depend on the type of the node. It provides the shortcut to perform various tasks and view information related to the node.
Parent topic: Model Operations
Create Feature Compare Node
You create a Feature Compare node to perform calculations about text data.
Related Topics
Parent topic: Feature Compare Node
Feature Compare
In the Feature Compare dialog box, you can specify or change the characteristics of the models to build.
In the Feature Compare dialog box, you can perform the following tasks.
-
In the Feature Compare tab, you can select a Feature Extraction model and specify the data sources to be used for feature comparison. To specify data sources:
-
In the Model field, select a model from the drop down list. The drop-down list displays all the Feature Extraction models that are connected to the model provider.
-
Deselect Auto, if you want to enter a custom column name. If Auto is selected, then the Column field automatically displays the column name based on the selected model. The Auto option is for automatic column name generation.
-
In the Data Input 1 and Data Input 2 fields, select a data provider node from the drop-down list respectively. If you want to enter a custom input, then select
User Defined
from the drop-down list, and enter the custom entry by clicking the corresponding Data Input cell in the model grid below. -
In the Case ID fields, select a supported column for each data provider node. If the Data Input field is set as
User Defined,
then the Case ID field is disabled. -
Click OK.
The model grid displays the following:
-
Model Attribute: Displays the input attributes from the model signature of the selected model.
-
Data Type: Displays the attribute of the data type.
-
Data Input 1: Displays the matching attribute or user defined data for Data Input 1.
-
Data Input 2: Displays the matching attribute or user defined data for Data Input 1.
-
-
In the Additional Outputs tab, the selected Case IDs added in the Feature Compare tab are also added here, when Automatic Setting is set to
On.
You can also add any model attributes as additional columns for output.
Parent topic: Feature Compare Node
Feature Compare Node Context Menu
The context menu options depend on the type of the node. It provides the shortcut to perform various tasks and view information related to the node.
To view the Feature Extraction node context menu, right-click the node. The following options are available in the context menu:
- Connect
Use the Connect option to link nodes in a workflow. - Run
Use the Run option to execute the tasks specified in the nodes that comprise the workflow. - Force Run
Use the Force Run option to rerun one or more nodes that are complete. - Create Schedule
Use the Create Schedule option to define a schedule to run a workflow at a definite time and date. - Edit
Use the Edit option to edit the default settings of a node. - View Data
Use the View Data option to view the data contained in a Data node. - Generate Apply Chain
Use the Generate Apply Chain to create a new node that contains the specification of a node that performs a transformation. - Show Event Log
Use the Show Event Log option to view information about events in the current connection, errors, warnings, and information messages. - Show Validation Errors
Use the Show Validation Errors option to view validation errors, if any. - Validate Parents
Use the Validate Parents option to validate all parent nodes of the current node. - Deploy
Use the Deploy option to deploy a node or workflow by creating SQL scripts that perform the tasks specified in the workflow. - Save SQL
Use the Save SQL option to generate SQL script for the selected node. - Cut
Use the Cut option to remove the selected object, which could be a node or connection. - Copy
Use the Copy option to copy one or more nodes and paste them into the same workflow or a different workflow. - Paste
Use the Paste option to paste the copied object in the workflow. - Select All
Use the Select All option to select all the nodes in a workflow. - Performance Settings
Use the Performance Settings option to edit Parallel settings and In-Memory settings of the nodes. - Go to Properties
Use the Go to Properties option to open the Properties pane of the selected node. - Navigate
Use the Navigate option to view the links available from the selected node.
Related Topics
Parent topic: Feature Compare Node
Connect
Use the Connect option to link nodes in a workflow.
To connect nodes:
Related Topics
Parent topic: Feature Compare Node Context Menu
Run
Use the Run option to execute the tasks specified in the nodes that comprise the workflow.
The Data Miner server runs workflows asynchronously. The client does not have to be connected. You can run one or more nodes in the workflow:
-
To run one node: Right-click the node and select Run.
-
To run multiple nodes simultaneously: Select the nodes by holding down the Ctrl key and click each individual node. Then right-click any selected node and select Run.
If a node depends on outputs of one or more parent nodes, then the parent node runs automatically only if the outputs required by the running node are missing.
Parent topic: Feature Compare Node Context Menu
Force Run
Use the Force Run option to rerun one or more nodes that are complete.
Force Run deletes any existing models before building them once again.
To select more than one node, click the nodes while holding down the Ctrl
key.
You can Force Run a node at any location in a workflow. Depending on the location of the node in the workflow, you have the following choices for running the node using Force Run:
-
Selected Node
-
Selected Node and Children
(available if the node has child nodes) -
Child Node Only
(available if the node one or more child nodes) -
Selected Node and Parents
(available if the node has parent nodes)
Parent topic: Feature Compare Node Context Menu
Create Schedule
Use the Create Schedule option to define a schedule to run a workflow at a definite time and date.
To save the workflow schedule settings, click . You can provide a name for the schedule in the Save a Schedule dialog box.
Related Topics
Parent topic: Feature Compare Node Context Menu
Edit
Use the Edit option to edit the default settings of a node.
Nodes have default algorithms and settings. When you edit a node, the default algorithms and settings are modified. You can edit a node in any one of the following ways:
-
Edit nodes using the Edit dialog box
-
Edit nodes through Properties UI
Parent topic: Feature Compare Node Context Menu
View Data
Use the View Data option to view the data contained in a Data node.
The Data nodes are Create Table or View node, Data Source node, Explore Data node, Graph node, SQL Query node, and Update Table node.
Related Topics
Parent topic: Feature Compare Node Context Menu
Generate Apply Chain
Use the Generate Apply Chain to create a new node that contains the specification of a node that performs a transformation.
If you have several transformations performed in sequence, for example, Sample
followed by a Custom transform
, then you must select Generate Apply Chain for each transformation in the sequence.You must connect the individual nodes and connect them to an appropriate data source.
Generate Apply Chain helps you create a sequence of transformations that you can use to ensure that new data is prepared in the same way as existing data. For example, to ensure that Apply data is prepared in the same way as Build data, use this option.
The Generate Apply Chain option is not valid for all nodes. For example, it does not copy the specification of a Build node.
Parent topic: Feature Compare Node Context Menu
Show Event Log
Use the Show Event Log option to view information about events in the current connection, errors, warnings, and information messages.
Clicking the Show Event Log option opens the View and Event Log dialog box.
Related Topics
Parent topic: Feature Compare Node Context Menu
Show Validation Errors
Use the Show Validation Errors option to view validation errors, if any.
This option is displayed only when there are validation errors. For example, if an Association node is not connected to a Data Source node, then select Show Validation Errors to view the validation error No build data input node connected.
You can also view validation errors by moving the mouse over the node. The errors are displayed in a tool tip.
Parent topic: Feature Compare Node Context Menu
Validate Parents
Use the Validate Parents option to validate all parent nodes of the current node.
To validate parent nodes of a node, right-click the node and select Validate Parents.
You can validate parent nodes when the node is in Ready, Complete
and Error
state. All parent nodes must be in completed state.
Parent topic: Feature Compare Node Context Menu
Deploy
Use the Deploy option to deploy a node or workflow by creating SQL scripts that perform the tasks specified in the workflow.
The scripts generated by Deploy
are saved to a directory.
Note:
You must run a node before deploying it.
You can generate a script that replicates the behavior of the entire workflow. Such a script can serve as the basis for application integration or as a light-weight deployment than the alternative of installing the Data Miner repository and workflows in the target and production system.
To deploy a workflow or part of a workflow:
Parent topic: Feature Compare Node Context Menu
Save SQL
Use the Save SQL option to generate SQL script for the selected node.
To generate SQL script for the selected node:
Related Topics
Parent topic: Feature Compare Node Context Menu
Cut
Use the Cut option to remove the selected object, which could be a node or connection.
You can also delete objects by selecting them and pressing DELETE on your keyboard.
Parent topic: Feature Compare Node Context Menu
Copy
Use the Copy option to copy one or more nodes and paste them into the same workflow or a different workflow.
To copy and paste nodes:
Note:
Copying and pasting nodes do not carry any mining models or results from the original node.
Parent topic: Feature Compare Node Context Menu
Paste
Use the Paste option to paste the copied object in the workflow.
To paste an object, right-click the workflow and click Paste. Alternately, you can press Ctrl+V.
Note:
Node names and model names are changed to avoid naming collisions. To preserve names, use the option Extended Paste.
Related Topics
Parent topic: Feature Compare Node Context Menu
Select All
Use the Select All option to select all the nodes in a workflow.
The selected nodes and links are highlighted in a dark blue border.
Parent topic: Feature Compare Node Context Menu
Performance Settings
Use the Performance Settings option to edit Parallel settings and In-Memory settings of the nodes.
If you click Performance Settings in the context menu, or if you click Performance Options in the workflow toolbar, then the Edit Selected Node Settings dialog box opens. It lists all the nodes that comprise the workflow. To edit the settings in the Edit Selected Node Settings dialog box:
-
Click Parallel Settings and select:
-
Enable: To enable parallel settings in the selected nodes in the workflow.
-
Disable: To disable parallel settings in the selected nodes in the workflow.
-
All: To turn on parallel processing for all nodes in the workflow.
-
None: To turn off parallel processing for all nodes in the workflow.
-
-
Click In-Memory Settings and select:
-
Enable: To enable In-Memory settings for the selected nodes in the workflow.
-
Disable: To disable In-Memory settings for the selected nodes in the workflow.
-
All: To turn on In-Memory settings for the selected nodes in the workflow.
-
None: To turn off In-Memory settings for all nodes in the workflow
-
-
Click
to set the Degree of Parallel, and In-Memory settings such as Compression Method, and Priority Levels in the Edit Node Performance Settings dialog box.
If you specify parallel settings for at least one node, then this indication appears in the workflow title bar:
Performance Settings is either On for Selected nodes, On (for All nodes), or Off. You can click Performance Options to open the Edit Selected Node Settings dialog box.
-
Click
to edit default the preferences for parallel processing.
-
Edit Node Default Settings: You can edit the Parallel Settings and In-Memory settings for the selected node in the Performance Options dialog box. You can access the Performance Options dialog box from the Preferences options in the SQL Developer Tools menu.
-
Change Settings to Default
-
Parent topic: Feature Compare Node Context Menu
Go to Properties
Use the Go to Properties option to open the Properties pane of the selected node.
Related Topics
Parent topic: Feature Compare Node Context Menu
Navigate
Use the Navigate option to view the links available from the selected node.
Note:
The Navigate option is enabled only if there are links to other nodes.Navigate displays the collection of links available from this node. Selecting one of the links selects the link and the selected link is highlighted in the workflow. The link itself has context menu options as well so you can right click and continue with the Navigate option. You can also use the arrow keys to progress to the next node.
Parent topic: Feature Compare Node Context Menu
Test Node
Oracle Data Mining enables you to test Classification and Regression models. You cannot test other kinds of models.
A Test node can test several models using the same test set. If the option Automatic Settings is set to ON,
then the Test node specification is generated when you connect the input nodes.
A Test node can run in parallel.
Note:
All models tested in a node must be either Classification or Regression Models. You cannot test both kinds of models in the same test node.
- Support for Testing Classification and Regression Models
Oracle Data Miner supports testing of a Classification or Regression models. - Test Node Input
The input for a Test node can be can be a Model node, a Classification node, or a Regression node. - Automatic Settings
By default, the option Automatic Settings is selected for a Test node. - Creating a Test Node
You create a test node to test Classification and Regression models. - Edit Test Node
In the Edit Test Node dialog box, you can specify or change the characteristics of the models to build. - Compare Test Results Viewer
The Compare Test Result viewer displays test results for one or more models in the same node. - Test Node Properties
In the Properties pane, you can examine and change the characteristics or properties of a node. - Test Node Context Menu
The context menu options depend on the type of the node. It provides the shortcut to perform various tasks and view information related to the node.
Related Topics
Parent topic: Model Operations
Support for Testing Classification and Regression Models
Oracle Data Miner supports testing of a Classification or Regression models.
Oracle Data Miner supports testing of a Classification or Regression models in the following ways:
-
Test the model as part of the Build node using any one of the following ways:
-
Split the Build data into build and test subsets.
-
Use all of the Build data as test data.
-
Connect a second Data Source node, the test Data Source node to the Build node
-
-
Test the model in a Test node. In this case, the test data can be any table that is compatible with the Build data.
-
After you have tested a Classification Model, you can tune it.
Note:
You cannot tune Regression models.
Related Topics
Parent topic: Test Node
Test Node Input
The input for a Test node can be can be a Model node, a Classification node, or a Regression node.
A Test node has the following input:
-
At least one node that identifies one or more models. The nodes can be a Model node, a Classification node, or a Regression node. A Model node must contain either Classification or Regression model, but not both.
-
Any node that generates data as an output such as a Data node, a Transform node, or an appropriate Text node. This node contains the test data.
-
It is recommended that a case ID is specified. If you do not specify a Case ID, then the processing will take longer.
You can test several Classification or several Regression Models at the same time. The models to be tested can be in different nodes. The models to be tested must satisfy these conditions:
-
The nodes that contain the models must have the same function type. That is, they must be all Classification Build nodes or all Regression Build nodes.
Classification Models must also have the same list of target attribute values.
-
The models must have the same target attribute with the same data type.
-
The Data Source node for Test must contain the target of the models.
-
The test data must be compatible with the models. That is, it should have been transformed in the same way as the data used to build the model.
Parent topic: Test Node
Automatic Settings
By default, the option Automatic Settings is selected for a Test node.
Automatic Settings result in the following behavior:
-
When a model input node is connected, all models are added to the specification.
-
When a model input node is disconnected, all models are removed from the specification. The test node may become invalid.
-
When a model input node is edited in the following ways, the resultant behavior is as follows:
-
If models are added, then model specifications are automatically added to the Test node.
-
If models are removed, then the specifications are removed from the Test node.
-
If models are changed, then the following is done:
-
The Test node is updated to ensure the algorithm is consistent.
-
If the target changes and there is only one node as input to the Test node, then the node is updated to reflect the new target and keep all the models. Also, the test input data is validated to ensure that it still has the new column target.
-
If there are multiple Model nodes as input to the Test nodes, then the models with the changed target are automatically removed.
-
-
If Automatic Settings is deselected, then you must edit the node to reflect all changes to the input. Models are validated if they are added.
Parent topic: Test Node
Creating a Test Node
You create a test node to test Classification and Regression models.
Related Topics
Parent topic: Test Node
Edit Test Node
In the Edit Test Node dialog box, you can specify or change the characteristics of the models to build.
To edit the Test Node, right-click the node and select Edit or double-click the node. The Edit Test Node dialog box opens.
The Edit Test Node dialog box displays the following:
-
Function (CLASSIFICATION or REGRESSION)
-
Target and the Data Type (data type of the target)
-
The Case ID (if there is one)
It is recommended that you specify a case ID. If you do not specify a case ID, then processing will be slower. The case ID that you specify for the Text node should be the same as the case ID specified for the Build node.
-
Automatic Settings: By default, Automatic Settings is selected.
You can perform the following tasks:
-
Compare test results and view individual models even when Automatic Settings is selected. The models tested are listed in the Selected Models grid.
-
Make change to the list of the models. Deselect Automatic Settings and make changes in the Selected Models grid.
Select Model
The Select Model dialog box lists the models that are available for testing. To select models:
- Move the Models from Available Models to Selected Models.
- Click OK.
Parent topic: Edit Test Node
Compare Test Results Viewer
The Compare Test Result viewer displays test results for one or more models in the same node.
The following test results are displayed:
Related Topics
Parent topic: Test Node
Test Node Properties
In the Properties pane, you can examine and change the characteristics or properties of a node.
To view the properties of a node, click the node and click Properties. If the Properties pane is closed, then go to View and click Properties. Alternately, right-click the node and click Go to Properties.
The Test node Properties pane has these sections:
- Models
The Models tab lists the models to test in the Selected Models grid. - Test
The Test section describes how testing is performed. - Details
The Details section displays the node name and comments about the node.
Parent topic: Test Node
Models
The Models tab lists the models to test in the Selected Models grid.
- Selected Models
The Selected Models dialog box displays the details of the selected model. You can also add and delete models here.
Parent topic: Test Node Properties
Selected Models
The Selected Models dialog box displays the details of the selected model. You can also add and delete models here.
For each model, the grid lists the following:
-
Model Name: Lists the model names. The partitioned models have the
icon next to it to indicate that they are partitioned.
Note:
If the Partitioned columns are incompatible among the selected models, then only global test results are generated.
-
Partition Columns: Lists the partition columns for each partitioned model.
-
Node: Lists the node containing the model.
-
Test: Indicates the test status of the model.
-
Algorithm: Lists the algorithm that is used to build the model.
You can perform the following tasks:
-
View Partition Column: Click
to view the details of the partitioned columns in the selected model. The name, data type and source of the partitioned columns are displayed in the Partition Columns Definition dialog box.
-
Add Model: Click
. You can only add models that have the same function. Before adding a model, deselect Automatic Settings.
-
Delete Model: Select it and click
. Before deleting a model, deselect Automatic Settings.
Related Topics
Parent topic: Models
Test
The Test section describes how testing is performed.
Test contains these information:
-
Function: CLASSIFICATION or REGRESSION.
-
Target: The name of the target.
-
Data Type: The data type of the target
-
For CLASSIFICATION, these test results are calculated by default:
-
Performance Metrics
-
ROC Curve (Binary Target Only)
-
Lift and Profit
You can deselect Metrics.
By default, the top 100 target values by frequency is specified. To change this value, click Edit. Edit the value in the Target Values Selection dialog box.
-
-
For REGRESSION, Accuracy Matrix and Residuals are selected. You can deselect Metrics.
-
The Performance Metrics are the metrics displayed on the Performance tab of the Test Viewer.
-
Residuals are displayed on the Residual tab of the Test Viewer.
-
Related Topics
Parent topic: Test Node Properties
Details
The Details section displays the node name and comments about the node.
You can change the name of the node and edit the comments in this section. The new node name and comments must meet the requirements.
Related Topics
Parent topic: Test Node Properties
Test Node Context Menu
The context menu options depend on the type of the node. It provides the shortcut to perform various tasks and view information related to the node.
To view the Test node context menu, right-click the node. The following options are available in the context menu:
-
Edit. Opens the Edit Test Node dialog box.
-
Compare Test Results. Opens the Compare Test Results dialog box.
-
Performance Settings. This opens the Edit Selected Node Settings dialog box, where you can set Parallel Settings and In-Memory settings for the node.
-
Show Runtime Errors. Displayed only if there is an error.
-
Show Validation Errors. Displayed only if there are validation errors.
-
Show Event Log. Displayed only if there is an error.
Related Topics
Parent topic: Test Node