Oracle Data Mining (ODM), is a component of the Oracle Advanced Analytics Option for Oracle Database 11g Enterprise Edition. ODM provides a collection of in-database data mining algorithms that solve a wide range of business problems. It provides the necessary mining model building, testing and scoring capabilities. Because of data, models, and results remain in Oracle Database, data movement is eliminated, security is maximized, and information latency is minimized.
The purpose of this blog is to explain various steps involved in setting up Oracle Data Miner 11g Release 2 by using SQL Developer 3.1.
Pre-requisites for Setting up Oracle Data Miner
The following configuration elements and information is required for setting up Oracle Data Miner.
Oracle Database 11g Enterprise Edition, Release 2 (18.104.22.168) with following services which are critical in support of Oracle Data Miner
- Oracle Data Mining- ODM provides the necessary mining model building, testing and scoring capabilities
- Oracle XML DB- Provides services to manage the Data Miner Repository metadata, such as the details of the workflow specifications
- Oracle Scheduler- Provides the engine of mining the Data Miner workflows
- Oracle Text - Provides services necessary to support text mining
Oracle SQL Developer Version 3.1 (or Later)
Database Information for SYS user to perform the configuration work for the setup – such as password, database port number, SID value or Service Name
Steps to setup the Oracle Data Miner
For setting up the Oracle Data Miner, user needs to perform following steps
- SQL Developer 3.1 ( or Later) Install
- Set up Data Miner by using SQL Developer
Installing SQL Developer
Oracle SQL Developer can be downloaded from Oracle Technology Network (OTN), it is freeware. To download Oracle SQL Developer 3.1 (or later), click on following link, after accepting agreement, choose SQL Developer download for appropriate operating system.
After downloading file, unzip the archive in the empty folder. There is no formal installation routine and there is no in-pace upgrade available for SQL Developer.
Oracle SQL Developer can be downloaded from Oracle Technology Network (OTN), it is freeware. To download Oracle SQL Developer 3.1 (or later), click on following link, after accepting agreement, choose SQL Developer download for chosen operating system.
Setting up Data Miner
Create SQL Developer Connection for SYS
This connection will be used to create the Data Miner user and install the Oracle Data Miner repository.
Create a database user account for data mining
Create a database account for data mining user, the user information as follows
Name of User – dmuser
Password – XXX
Default Tablespace –USERS
Temporary Tablespace –TEMP
Grant CONNECT Role to dmuser and then set Tablespace Quota for USERS Tablespace to Unlimited as shown, then click on APPLY to create dmuser with all selected parameters.
Creation of user confirmed.
Create a SQL Developer connection for the data mining user
Create connection for Data Miner user (dmuser)
Enable the Data Miner GUI and user
Display data miner tab similar to the normal connection tab by selecting Tool > Data Miner > Make Visible
On data miner tab, click on Add Connection and then select the dmuser (data mining user) from the list of connections available.
The result of execution of these steps a data miner user should appear under the Connection node in the Data Miner Tab.
Install the Oracle Data Miner Repository
The following automated process is used to create the data miner repository
Double-click the data minder user on the Data Miner tab
A message tells you that the Data Miner Repository is not installed in the database and asks whether you want to install the repository, click ‘Yes’ to launch the installation.
Enter the password for SYS user and click ‘OK’ to continue
Select the Default and Temporary table spaces for the ODMSYS user, this user is created as part of the repository installation process. Click ‘OK’ to continue.
Start Install Data Mining Repository
Once repository installation completion confirms that the Oracle Data Miner setup is finished. The data miner interface is ready for use.