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 and 3.1.
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.
Oracle Data Miner that ships with SQL Developer 3.1 includes these features:
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 the prerequisites for Data Miner and install the Data Miner Repository:
Step 1: Install Oracle 11g Release 2 Database.
Download the software from Oracle Database Software Downloads at http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.
To use Oracle Data Miner, you must connect to an Oracle Database that satisfies the requirements specified in Before You Start.
Chapter 2 of Oracle Data Miner Administrator's Guide at http://download.oracle.com/docs/cd/E11882_01/datamine.112/e16807/toc.htm describes how to install Oracle Database Enterprise Edition on Microsoft Windows. For instructions for other platforms, see Installing and Upgrading in the Oracle Database Documentation Library.
Step 2: Download SQL Developer 3.1 from SQL Developer. Install SQL Developer by unzipping the download to any directory on your system.
Alternatively, you can install the Data Miner Repository using the Installation Scripts. The installation scripts are in
SQLDevHome is the directory where you installed SQL Developer. Use of the scripts is optional. The scripts are described in
SQLDevHome\sqldeveloper\dataminer\scripts/install_scripts_readme.html and in the online help for Data Miner.
After you install SQL Developer 3.1, you can also view start up instructions for Data Miner as follows: Select the menu item Help>Table of Contents ; in the Help Center, expand Data Miner Concepts and Usage and then expand Install Oracle Data Miner.
When you initially open a connection from the Data Miner navigator to an existing Data Miner repository, you are prompted to update the repository. The repository update will be performed for you through the GUI-guided process. If you want to run the scripts manually, refer to the installation scripts located in
SQLDevHome is the directory where SQL Developer is installed.
Data Miner includes cue cards to illustrate basic usage. Select Help > Table of Contents >Data Miner Cue Cards in Oracle SQL Developer 3.1.
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 build a model be cautious about turning Automatic Data Processing (ADP) off. Turning ADP off can lead to failures.
If you have
SELECT privileges to other user tables/views and the
SELECT privileges are 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 (184.108.40.206).
When you upgrade to Oracle Database 11g Release 2 (220.127.116.11), you must also upgrade the ODMRSYS repository so that it is compatible with Release 18.104.22.168. When you start SQL Developer 3.1 after the database upgrade, you are prompted to perform an upgrade for Data Miner. The upgrade process is fully automated in the Data Miner GUI.