Oracle Data Miner generates PL/SQL code for build, test, and apply mining activities. The PL/SQL code contains all the steps in an activity, including data preparation, data transformations, and model operations. The code is organized into user-specified PL/SQL packages. The generated packages are self-contained, so no external reference is needed during code runtime (except in the case of result type apply calls). A PL/SQL package may contain procedures or functions generated from one or more activities of different types. The procedures or functions are thread-safe, so that multiple instances of them can run in the same schema simultaneously (different output must have different names). The generated code uses procedures from the PL/SQL packages DBMS_DATA_MINING
and DBMS_DATA_MINING_TRANSFORM
, the Oracle Data Mining packages.
The user interface for code generation is an extension to Oracle JDeveloper and to Oracle SQL Developer. Packages generated using JDeveloper or SQL Developer are stored in a Packages folder.
Oracle Data Miner allows you to generate code for selected activities and allows the you to save the code to a file.
The generated PL/SQL package can be deployed to any Oracle database for model scoring, model rebuild, and model test purposes. In addition, a generated package can be easily integrated into the Oracle technology stack so that it can be used with products such as Oracle Workflow, BPEL, and Oracle Warehouse Builder.
For information about using Code Generator and deploying the code, see:
For an example of how to generate code and execute it, see Code Generation Example.
For information about Oracle Data Miner Installation and requirements, see the Release Notes.
Copyright © 2006, 2008, Oracle. All rights reserved.