Use this stored procedure to apply a Naive Bayes model to generate classification
predictions for a data set.
Authorization
The privileges held by the authorization ID of the statement must include the IDAX_USER role.
Syntax
IDAX.PREDICT_NAIVEBAYES(in parameter_string varchar(32672))
Parameter descriptions
- parameter_string
- Mandatory one-string parameter that contains pairs of
<parameter>=<value> entries that are separated by a comma.
- Data type: VARCHAR(32672)
- The following list shows the parameter values:
-
- model
- Mandatory.
- The name of the Naive Bayes model.
- Data type: VARCHAR(64)
- intable
- Mandatory.
- The name of the input table.
- Data type: VARCHAR(128)
- outtable
- Mandatory.
- The name of the output table where the predictions are stored.
- Data type: VARCHAR(128)
- id
- Optional.
- The column of the input table that identifies a unique instance ID.
- Default: the same id column that is specified in the stored procedure to build the model.
- Data type: VARCHAR(128)
- outtableProb
- Optional.
- The output table where the probabilities for each of the classes are stored.
- If this parameter is not specified, the table is not created.
- Default: none
- Data type: VARCHAR(128)
- mestimation
- A flag that indicates to use m-estimation for probabilities.
- This kind of estimation might be slower than other ones, but it might produce better results for
small or unbalanced data sets.
- Default: false
- Data type: VARCHAR(5)
Returned information
The number of input table records for which predictions are generated as a result set.