Model Apply Procedures and Functions

The most common way to deploy the results of data mining is to apply an already-created model. The model that you apply must reside in the schema to which the program is connected. Oracle Data Mining must be installed and configured in any database where you deploy models. The schema the code is loaded into should also have the grants required for Oracle Data Mining grants, as described in the Oracle Data Mining Administrator's Guide.

An apply procedure is generated from a completed apply activity. The procedure scores the input data using the model in the related build activity. The number of input parameters for an apply procedure or function varies depending on he number of additional tables passed to the apply activity. All parameters are initialized to default values consisting of the values used by the apply activity. An apply procedure or function can take the input data as tables/views or SQL queries and returns the apply result as table/view, a result set, or via a cursor. he procedure or function includes all necessary data preparation and applies the model.

There are five apply procedures, divided into two groups:

Each type of apply produces several apply procedures and functions, depending on the input and output.

Batch Apply

The following batch apply procedures are generated:

Result Set Apply

The following result set apply functions are generated:

For overview information about result set apply, see Result Set Apply Functions.