These release notes contain the following information:
Oracle Data Mining, an Oracle Database Enterprise Edition Option, provides powerful data mining functionality to leverage data inside an Oracle Database. Oracle Data Miner is the graphical user interface for Oracle Data Mining. Oracle Data Miner is an extension to Oracle SQL Developer 3.0.
Oracle Data Mining enables users to build descriptive and predictive models to:
For more information about Oracle Data Mining, see Oracle Data Mining on Oracle Technology Network.
To use Oracle Data Miner, you must connect to an Oracle database that satisfies these requirements:
Data Miner has two components:
You are supported by Oracle Support under your current Oracle Database Support license. Log Oracle Data Miner bugs and issues using My Oracle Support for the product.
You can discuss installation and use of Oracle Data Miner at Data Mining Forum.
Follow these steps to install Data Miner:
Step 2: Download the SQL Developer 3.0 client from SQL Developer following the instructions provided on the downloads page.
You can install Data Miner from the Data Miner GUI, as described in the OBE, or using Installation Scripts that you download from the Downloads section of Oracle Data Miner 11g Release 2. Use of the scripts is optional.
After you install SQL Developer 3.0, you can also view installation instructions as follows: select the menu item Help > Data Miner and then click "Getting Started" for installation information.
migrateodmr.sql migrates the Data Miner Repository from an earlier version (such as EA4) to the current version. All workflows created by users are preserved; at this release, only the repository software is updated.
This script is packaged with the Installation Scripts down loadable from the Downloads section of Oracle Data Miner 11g Release 2. For more information about this script, see the readme included with the scripts.
Data Miner includes cue cards to illustrate basic usage. Select Help > Table of Contents >Data Miner Cue Cards in Oracle SQL Developer 3.0.
Data Miner also includes Oracle By Example (OBE) tutorials in the Oracle Learning Library at Oracle Data Mining 11g Release 2 OBE Series. The OBEs describe how to set up and use Oracle Data Miner.
To revoke all the privileges granted to a user for data miner, run
dropusergrants.sql, included in the Installation Scripts.
When you a build a model be cautious about turning Automatic Data Processing (ADP) off. Turning ADP off can led to failures.
SELECT privileges to other user tables/views, and the privilege is provided to you via a role, then you will not be able to create views based on that data. This will trigger failures when running the model build nodes and possibly other nodes as well. To avoid these failures, either create a table in your own user account using the Create Table node, or have the DBA or user grant
SELECT privileges to you directly rather than through a role.
If a workflow appears to be running too long, you can use the Event Viewer to determine the status of the workflow. To open the Event Viewer, click the Event Viewer icon in the workflow tool bar. If the workflow is complete but the UI still shows that the workflow is running, simply close the workflow and reopen it.
A performance problem may result if you try to view the Settings tab in the model viewer for a model built using data with nested columns. This problem has been corrected in Oracle Database 11g Release 2 Patchset 18.104.22.168.