The steps described in this chapter explain how to install Oracle Data Mining locally on your Windows PC or laptop and start up the client interfaces: Oracle Data Miner and Oracle Spreadsheet Add-In for Predictive Analytics.
This chapter provides summary information. Details are provided in subsequent chapters of this manual.
Note:The minimum requirements for a working installation of Oracle Data Mining are:
An installation of Oracle Database Enterprise Edition
A database user ID that has data mining privileges (see Chapter 4)
Perform a basic installation of Oracle Database Enterprise Edition and create a starter database.
In Windows Control Panel, Administrative Tools, choose Services. Stop any Oracle services that may be running on your computer.
From the Oracle Database installation directory, run
SETUP.EXE to start Oracle Universal Installer. Follow the instructions as specified on the initial pages, then:
On the Select Installation Options page, choose Create and Configure a Database.
On the System Class page, choose Desktop Class.
On the Typical Install Configuration page, specify the installation directories, the database name, and the database system passwords.
The Installer performs prerequisite checks, displays summary information about the installation, and copies the Oracle executables and the starter database files to your computer.
The Installer configures Oracle Net to enable client connections.
Database Configuration Assistant displays summary information about the starter database. If you wish to use Oracle sample data or the Data Mining sample programs, unlock the
Exit the Installer. The starter database is now running, and Oracle Net is ready to accept client connections.
If necessary, restart the Oracle services that you stopped in step 1.
See:"Install Oracle Database" for more detailed instructions
Once you have installed Oracle Database and created a starter database, you may wish to verify that Oracle Data Mining is functioning properly before proceeding further.
In Appendix A, you will find a series of SQL and PL/SQL commands that perform basic data mining operations. You can type these commands into SQL*Plus or SQL Developer to make sure that the database is enabled for data mining.
Create a database user with data mining privileges.
Log in to SQL*Plus or SQL Developer as the system user.
Execute the following
CREATE USER statement. Specify a user name for
dmuser and password for
CREATE USER dmuser IDENTIFIED BY dmpassword DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users; Commit;
Execute these statements to grant data mining privileges to the user.
GRANT CREATE JOB TO dmuser; GRANT CREATE MINING MODEL TO dmuser; -- required for creating models GRANT CREATE PROCEDURE TO dmuser; GRANT CREATE SEQUENCE TO dmuser; GRANT CREATE SESSION TO dmuser; GRANT CREATE SYNONYM TO dmuser; GRANT CREATE TABLE TO dmuser; GRANT CREATE TYPE TO dmuser; GRANT CREATE VIEW TO dmuser; GRANT EXECUTE ON ctxsys.ctx_ddl TO dmuser; -- required for text mining GRANT SELECT ON data TO dmuser; -- required for mining data that is not in your schema
If the user will need to import or export data mining models, grant this additional privilege.
GRANT CREATE ANY DIRECTORY TO dmuser;
For import/export operations, the user must create a directory object. The user may also require additional privileges. See "Exporting and Importing Mining Models" for details.
See:Chapter 4, "Users and Privileges for Data Mining" for more detailed instructions
Oracle Data Miner, an extension to Oracle SQL Developer 3.0, is a graphical user interface to Oracle Data Mining. Oracle Data Miner uses a workflow paradigm to perform data mining tasks.
You can use Oracle Data Miner to explore data, build and evaluate multiple mining models, and apply the models to new data. By building workflows, you can capture and document the methodology you use to perform a range of mining tasks. You can save and share workflows.
Go to the following page on the Oracle Technology Network:
Follow the installation instructions provided on the page. The basic steps can be summarized as:
Install Oracle Database (also described in Step One: Install the Database earlier in this chapter).
Install Oracle SQL Developer 3.0, which includes Oracle Data Miner 11gR2.
Install the Oracle Data Miner repository.
For further instructions, use the Online Help provided by SQL Developer.
For additional assistance, use the Oracle By Example tutorials. Links to the tutorials are available with the installation instructions at the URL provided in Step 1.
Note:Oracle Data Miner Classic, the previous release of Oracle Data Mining, is still available for download on the Oracle Technology Network.
Oracle Data Miner Classic is no longer under active development.
The Oracle Spreadsheet Add-In for Predictive Analytics lets you perform certain limited data mining operations in an Excel spreadsheet.
To install and launch the Spreadsheet Add-In:
Install Oracle Client and create a Net Service Name as described in "Oracle Client and Oracle Net".
Download the Spreadsheet Add-In from the Oracle Technology Network.
Open the zip file and extract the contents to the Microsoft Office Library, typically:
C:\Program Files\Microsoft Office\Office\Library
From the Add-In menu in Excel, choose Connect.
In the Connect (Oracle Database) dialog:
Select the Net Service Name that you created.
Provide the user name and password of the data mining user.
Click Connect to launch the Spreadsheet Add-In.
See:"Optionally Install the Spreadsheet Add–In" for more detailed instructions
Follow these steps to install and configure the sample Data Mining programs:
Install Oracle Database Examples as described in "Optionally Install Oracle Database Examples".
The sample programs are copied to the
RDBMS\demo subdirectory of the Oracle home directory. You can find the PL/SQL programs by searching for
Start SQL*Plus and connect to the database as the system user. Run the
dmshgrants script. Specify the full path to the Oracle home directory and the name of the data mining user.
Connect to the database as the Data Mining user. Run the
CONNECT dmuser @ ORACLE_HOME\RDBMS\demo\dmsh COMMIT;
See:Chapter 7, "The Data Mining Sample Programs" for more detailed instructions