1 Getting Started with Oracle Data Mining

Step One: Install the Database

Perform a basic installation of Oracle Database Enterprise Edition and create a starter database.

1. In Windows Control Panel, Administrative Tools, choose Services. Stop any Oracle services that may be running on your computer.

2. From the Oracle Database installation directory, run SETUP.EXE to start Oracle Universal Installer.

   • 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.

3. The Installer performs prerequisite checks, displays summary information about the installation, and copies the Oracle executables and the starter database files to your computer.

4. The Installer configures Oracle Net to enable client connections.

5. The Installer starts Oracle Database Configuration Assistant to create the starter database.

6. 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 SH account.

7. Exit the Installer. The starter database is now running, and Oracle Net is ready to accept client connections.

8. If necessary, restart the Oracle services that you stopped in step 1.

Step Two: Verify the Data Mining Installation

Once you have installed the Oracle Database software and created a 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.

Step Three: Create a Data Mining User

Create a database user with data mining privileges.

1. Log in to SQL*Plus as the system user and execute the following CREATE USER statement. Specify a user name for dmuser and password for dmpassword.

   CREATE USER dmuser IDENTIFIED BY dmpassword
          DEFAULT TABLESPACE users
          TEMPORARY TABLESPACE temp
          QUOTA UNLIMITED ON users;
   Commit;
   

2. 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
   

3. 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.

Step Four: Install and Launch Oracle Data Miner

To install and launch Oracle Data Miner:

1. Download Oracle Data Miner from the Oracle Technology Network.

   http://www.oracle.com/technology/products/bi/odm/odminer.html
   

   Open the zip file and extract the contents to an empty directory on your computer.

2. Navigate to the bin subdirectory of the Oracle Data Miner installation directory and double click odminerw.exe to launch Oracle Data Miner.

3. In the New Connection dialog, specify:

   • a name for the connection

   • the user name and password of the data mining user

   • localhost for Host

   • 1521 for Port

4. In the Choose Connection dialog, select the connection name that you have just defined. Click OK to launch Oracle Data Miner.

Step Five: Install and Launch the Spreadsheet Add-In

To install and launch the Oracle Spreadsheet Add-In for Predictive Analytics in Microsoft Excel:

1. Install Oracle Client and create a Net Service Name as described in "Oracle Client and Oracle Net".

2. Download the Spreadsheet Add-In from the Oracle Technology Network.

   http://www.oracle.com/technology/products/bi/odm/index.html
   

3. Open the zip file and extract the contents to the Microsoft Office Library, typically:

   C:\Program Files\Microsoft Office\Office\Library
   

4. Open Excel and click Tools > Add–Ins. Select Oracle Predictive Analytics from the Add–Ins dialog box. The OraclePA menu is added to the Excel toolbar.

5. From the Add-In menu in Excel, choose Connect.

6. 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.

Step Six: If You Want to Use the Sample Programs

Follow these steps to install and configure the sample Data Mining programs:

1. Install Oracle Database Examples as described in "Install Oracle Database Examples".

2. The sample programs are copied to the RDBMS\demo subdirectory of the Oracle home directory of the database. You can find the PL/SQL programs by searching for dm*.sql. You can find the Java programs by searching for dm*.java.

3. 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.

   @  ORACLE_BASE\ORACLE_HOME\RDBMS\demo\dmshgrants dmuser
   

   Note:

   In this manual, and in other Oracle manuals, ORACLE_BASE\ORACLE_HOME represents the full path to the Oracle home directory on a Windows platform.

   See Oracle Database Installation Guide for Microsoft Windows for more information about Oracle directory naming conventions.

4. Connect to the database as the data mining user. Run the dmsh script.

   CONNECT dmuser
   @ ORACLE_BASE\ORACLE_HOME\RDBMS\demo\dmsh
   COMMIT;
   

5. Once you have completed steps 1 through 4, you can run the PL/SQL programs.

6. Before running the Java programs, complete these additional steps:

   • Add ORACLE_BASE\ORACLE_HOME\jdk\bin\ to your Windows PATH before the paths of any other Java versions. ORACLE_BASE\ORACLE_HOME is the full path to the Oracle home directory of the database.

   • Add the following Data Mining JAR files to your Windows CLASSPATH. ORACLE_BASE\ORACLE_HOME is the full path to the Oracle home directory of the database.

     ORACLE_BASE\ORACLE_HOME\RDBMS\jlib\jdm.jar
                 ORACLE_BASE\ORACLE_HOME\RDBMS\jlib\ojdm_api.jar
                 ORACLE_BASE\ORACLE_HOME\RDBMS\jlib\xdb.jar
                 ORACLE_BASE\ORACLE_HOME\jdbc\lib\ojdbc5.jar
                 ORACLE_BASE\ORACLE_HOME\oc4j\j2ee\home\lib\connector.jar
                 ORACLE_BASE\ORACLE_HOME\jlib\orai18n.jar
                 ORACLE_BASE\ORACLE_HOME\jlib\orai18n-mapping.jar
                 ORACLE_BASE\ORACLE_HOME\lib\xmlparserv2.jar
     

   See:

   Chapter 7, "The Data Mining Sample Programs" for more detailed instructions