The data mining SQL functions provide the following benefits:
Models can be easily deployed within the context of existing SQL applications.
Scoring operations take advantage of existing query execution functionality. This provides performance benefits.
Scoring results are pipelined, enabling the rows to be processed without requiring materialization.
The data mining functions produce a score for each row in the selection. The functions can apply a mining model schema object to compute the score, or they can score dynamically without a pre-defined model, as described in "Dynamic Scoring".
See Also:
Table 2-5 for a list of the data mining functions
Oracle Database SQL Language Reference for syntax of the data mining SQL functions