Oracle Modeling Node Properties
The following properties are common to Oracle database modeling nodes.
| Common Oracle Node Properties | Values | Property Description |
|---|---|---|
target
|
field | |
inputs
|
List of fields | |
partition
|
field | Field used to partition the data into separate samples for the training, testing, and validation stages of model building. |
datasource
|
||
username
|
||
password
|
||
epassword
|
||
use_model_name
|
flag | |
model_name
|
string | Custom name for new model. |
use_partitioned_data
|
flag | If a partition field is defined, this option ensures that only data from the training partition is used to build the model. |
unique_field
|
field | |
auto_data_prep
|
flag | Enables or disables the Oracle automatic data preparation feature (11g databases only). |
costs
|
structured | Structured property in the form:
[[drugA drugB 1.5] [drugA drugC 2.1]], where the arguments in [] are actual
predicted costs. |
mode
|
Simple
Expert
|
Causes certain properties to be ignored if set to Simple, as noted in the
individual node properties. |
use_prediction_probability
|
flag | |
prediction_probability
|
string | |
use_prediction_set
|
flag |
Oracle Naive Bayes
The following properties are available for nodes of type
oranbnode.
oranbnode Properties |
Values | Property Description |
|---|---|---|
singleton_threshold
|
number | 0.0–1.0.* |
pairwise_threshold
|
number | 0.0–1.0.* |
priors
|
Data
Equal
Custom
|
|
custom_priors
|
structured | Structured property in the form:
set :oranbnode.custom_priors = [[drugA 1][drugB 2][drugC 3][drugX 4][drugY 5]]
|
* Property ignored if mode is set to
Simple.
Oracle Adaptive Bayes
The following properties are available for nodes of type
oraabnnode.
oraabnnode Properties |
Values | Property Description |
|---|---|---|
model_type
|
SingleFeature
MultiFeature
NaiveBayes
|
|
use_execution_time_limit
|
flag | * |
execution_time_limit
|
integer | Value must be greater than 0.* |
max_naive_bayes_predictors
|
integer | Value must be greater than 0.* |
max_predictors
|
integer | Value must be greater than 0.* |
priors
|
Data
Equal
Custom
|
|
custom_priors
|
structured | Structured property in the form:
set :oraabnnode.custom_priors = [[drugA 1][drugB 2][drugC 3][drugX 4][drugY 5]]
|
* Property ignored if mode is set to
Simple.
Oracle Support Vector Machines
The following properties are available for nodes of type
orasvmnode.
orasvmnode Properties |
Values | Property Description |
|---|---|---|
active_learning
|
Enable
Disable
|
|
kernel_function
|
Linear
Gaussian
System
|
|
normalization_method
|
zscore
minmax
none
|
|
kernel_cache_size
|
integer | Gaussian kernel only. Value must be greater than 0.* |
convergence_tolerance
|
number | Value must be greater than 0.* |
use_standard_deviation
|
flag | Gaussian kernel only.* |
standard_deviation
|
number | Value must be greater than 0.* |
use_epsilon
|
flag | Regression models only.* |
epsilon
|
number | Value must be greater than 0.* |
use_complexity_factor
|
flag | * |
complexity_factor
|
number | * |
use_outlier_rate
|
flag | One-Class variant only.* |
outlier_rate
|
number | One-Class variant only. 0.0–1.0.* |
weights
|
Data
Equal
Custom
|
|
custom_weights
|
structured | Structured property in the form:
set :orasvmnode.custom_weights = [[drugA 1][drugB 2][drugC 3][drugX 4][drugY 5]]
|
* Property ignored if mode is set to
Simple.
Oracle Generalized Linear Models
The following properties are available for nodes of type
oraglmnode.
oraglmnode Properties |
Values | Property Description |
|---|---|---|
normalization_method
|
zscore
minmax
none
|
|
missing_value_handling
|
ReplaceWithMean
UseCompleteRecords
|
|
use_row_weights
|
flag | * |
row_weights_field
|
field | * |
save_row_diagnostics
|
flag | * |
row_diagnostics_table
|
string | * |
coefficient_confidence
|
number | * |
use_reference_category
|
flag | * |
reference_category
|
string | * |
ridge_regression
|
Auto
Off
On
|
* |
parameter_value
|
number | * |
vif_for_ridge
|
flag | * |
* Property ignored if mode is set to
Simple.
Oracle Decision Tree
The following properties are available for nodes of type
oradecisiontreenode.
oradecisiontreenode Properties |
Values | Property Description |
|---|---|---|
use_costs
|
flag | |
impurity_metric
|
Entropy
Gini
|
|
term_max_depth
|
integer | 2–20.* |
term_minpct_node
|
number | 0.0–10.0.* |
term_minpct_split
|
number | 0.0–20.0.* |
term_minrec_node
|
integer | Value must be greater than 0.* |
term_minrec_split
|
integer | Value must be greater than 0.* |
display_rule_ids
|
flag | * |
* Property ignored if mode is set to
Simple.
Oracle O-Cluster
The following properties are available for nodes of type
oraoclusternode.
oraoclusternode Properties |
Values | Property Description |
|---|---|---|
max_num_clusters
|
integer | Value must be greater than 0. |
max_buffer
|
integer | Value must be greater than 0.* |
sensitivity
|
number | 0.0–1.0.* |
* Property ignored if mode is set to
Simple.
Oracle KMeans
The following properties are available for nodes of type
orakmeansnode.
orakmeansnode Properties |
Values | Property Description |
|---|---|---|
num_clusters
|
integer | Value must be greater than 0. |
normalization_method
|
zscore
minmax
none
|
|
distance_function
|
Euclidean
Cosine
|
|
iterations
|
integer | 0–20.* |
conv_tolerance
|
number | 0.0–0.5.* |
split_criterion
|
Variance
Size
|
Default is Variance.* |
num_bins
|
integer | Value must be greater than 0.* |
block_growth
|
integer | 1–5.* |
min_pct_attr_support
|
number | 0.0–1.0.* |
* Property ignored if mode is set to
Simple.
Oracle NMF
The following properties are available for nodes of type
oranmfnode.
oranmfnode Properties |
Values | Property Description |
|---|---|---|
normalization_method
|
minmax
none
|
|
use_num_features
|
flag | * |
num_features
|
integer | 0–1. Default value is estimated from the data by the algorithm.* |
random_seed
|
number | * |
num_iterations
|
integer | 0–500.* |
conv_tolerance
|
number | 0.0–0.5.* |
display_all_features
|
flag | * |
* Property ignored if mode is set to
Simple.
Oracle Apriori
The following properties are available for nodes of type
oraapriorinode.
oraapriorinode Properties |
Values | Property Description |
|---|---|---|
content_field
|
field | |
id_field
|
field | |
max_rule_length
|
integer | 2–20. |
min_confidence
|
number | 0.0–1.0. |
min_support
|
number | 0.0–1.0. |
use_transactional_data
|
flag |
Oracle Minimum Description Length (MDL)
There are no specific properties defined for nodes of type
oramdlnode. See the common Oracle properties at the start of this section.
Oracle Attribute Importance (AI)
The following properties are available for nodes of type
oraainode.
oraainode Properties |
Values | Property Description |
|---|---|---|
custom_fields
|
flag | If true, allows you to specify target, input, and other fields for the current node. If false, the current settings from an upstream Type node are used. |
selection_mode
|
ImportanceLevel
ImportanceValue
TopN
|
|
select_important
|
flag | When selection_mode is set to ImportanceLevel, specifies
whether to select important fields. |
important_label
|
string | Specifies the label for the "important" ranking. |
select_marginal
|
flag | When selection_mode is set to ImportanceLevel, specifies
whether to select marginal fields. |
marginal_label
|
string | Specifies the label for the "marginal" ranking. |
important_above
|
number | 0.0–1.0. |
select_unimportant
|
flag | When selection_mode is set to ImportanceLevel, specifies
whether to select unimportant fields. |
unimportant_label
|
string | Specifies the label for the "unimportant" ranking. |
unimportant_below
|
number | 0.0–1.0. |
importance_value
|
number | When selection_mode is set to ImportanceValue, specifies
the cutoff value to use. Accepts values from 0 to 100. |
top_n
|
number | When selection_mode is set to TopN, specifies the cutoff
value to use. Accepts values from 0 to 1000. |