These release notes contain the following information about Oracle Data Miner 4.0:
Oracle Data Mining, part of the Oracle Advanced Analytics option of Oracle Enterprise Edition, provides powerful data mining functionality to leverage data stored in an Oracle Database.
Oracle Data Miner is the graphical user interface (GUI) for Oracle Data Mining. Oracle Data Miner is an extension to Oracle SQL Developer.
Oracle Data Mining enables users to build descriptive and predictive models that:
For more information about Oracle Data Mining, see Oracle Data Mining on Oracle Technology Network.
The Oracle Data Miner extension to SQL Developer 4.0 includes these new features:
ODMR_CARS_DEMOtable to the demo data scripts
To use Oracle Data Miner, you must connect to an Oracle Database that satisfies these requirements:
New features may require Oracle Database 12c Release 1.
Oracle Text is installed. Oracle Text is installed automatically when you install Oracle Database Enterprise Edition.
If you plan to use Oracle Text to extract Themes, you must install the Knowledge Base by installing the Oracle Database Examples, as described in the Oracle Database Examples Installation Guide.
Oracle XML DB is installed. Oracle XML DB is installed automatically when you install Oracle Database Enterprise Edition.
Data used by the Oracle By Example tutorials requires the SH schema. If you install a starter database when you install Oracle Database Enterprise Edition, SH is automatically installed.
Data Miner has two components:
For released products, 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 post Data Miner questions or issues at Data Mining Forum and receive replies from other Data Miner users as well as from Oracle Data Mining Development team. You may find it useful to "follow" the Data Miner forum to keep up with useful postings.
Follow these steps to install the prerequisites for Data Miner and install the Data Miner Repository:
Step 1: Install Oracle 11g Release 2 or higher Database. To have access to all available data mining features install Oracle 12.1.
Download the software from Oracle Database Software Downloads.
For Oracle Database 12c Release 1, Oracle® Data Mining User's Guide describes Oracle Data Mining installation.
Oracle Data Mining Documentation describes how to view Data Mining Documentation.
Step 2: Download SQL Developer 4.0 from SQL Developer. Install SQL Developer by unzipping the download to any directory on your system.
Note that SQL Developer 4.0 requires Java version 1.7 and above.
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 4.0, 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 Data Miner 4.0 and its subfolder Install Prerequisites and Oracle Data Miner Repository.
You can view or download Oracle documentation from Documentation. Go to Database to find the documentation library for your database. Oracle Data Mining is a component of the Oracle Advanced Analytics Option. Oracle Advanced Analytics is described on the Data Warehousing and Business Intelligence page.
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 perform migration by running scripts manually, the installation scripts are located in
SQLDevHome is the directory where SQL Developer is installed. The scripts are described in
install_scripts_readme.html in the
scripts directory. and in the online help for Data Miner.
Data Miner includes Oracle By Example (OBE) tutorials in the Oracle Learning Library at Oracle Data Mining 12c OBE Series. The OBEs describe how to set up and use Oracle Data Miner.
In-depth White Papers are available at Oracle Data Mining under the heading Technical Information for the following topics:
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. You can click on the Info icon in the toll bar of the Event Viewer to see the information event logs in addition to the Warnings and Errors.
If the workflow is complete but the UI still shows that the workflow is running, simply close the workflow and reopen it.
When you upgrade to Oracle Database 11g Release 2 (18.104.22.168) or higher from 22.214.171.124 or lower, you must also upgrade the ODMRSYS repository. When you start SQL Developer 4.0 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.
Beginning with Oracle Database 12c, you can specify a maximum size of 32767 bytes for the
RAW data types.
You will have failures when you view data in an extended data type, that is, a
VARCHAR2 column with a declared size of greater than 4000 bytes.
In order to view extended data types, you must set the connection properties following these steps: