Skip Headers
Oracle® Data Mining Administrator's Guide
11g Release 1 (11.1)

Part Number B28130-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

1 Getting Started

This chapter is intended for anyone who wishes to install and use Oracle Data Mining on a personal computer for educational or demonstration purposes. It provides the basic information you will need to install the Data Mining software on Microsoft Windows and run the sample programs locally on your pc or laptop. To run the programs remotely, see the instructions in Chapter 2.

See Also:

Oracle Database 2 Day DBA

Oracle Database Installation Guide for Microsoft Windows

This chapter contains the following sections. Complete the instructions in each section before proceeding to the next section.

Install Oracle Database

Oracle Data Mining is part of Oracle Database Enterprise Edition. To perform data mining activities, you must be able to log on to an Oracle database, and you user ID must have the appropriate database privileges.

The instructions in this section explain how to install Oracle Database with the sample schemas on your personal computer. The sample schemas are needed for the Data Mining sample programs.

Note:

These instructions assume that this is a fresh installation of Oracle Database 11g.

If you already have Oracle components installed on your computer, refer to Oracle Database Installation Guide for Microsoft Windows.

  1. From the Database installation directory, run SETUP.EXE.

    Oracle Universal Installer opens and displays the Select a Product to Install dialog. Choose Oracle Database 11g.

    Description of install1.gif follows
    Description of the illustration install1.gif

    Choose Next.

  2. The Installer displays the Select Installation Method page.

    Description of install2.gif follows
    Description of the illustration install2.gif

    • Choose Basic Installation.

    • Specify the Oracle Base and Home directories. Oracle home is a subdirectory of the Oracle Base directory. You can accept the default paths provided by the Installer, as long as they do not already exist on your computer.

    • Choose Enterprise Edition as the Installation Type.

    • Check the Create Starter Database box.

    • Specify a unique name for Global Database Name. You can use the default global database name provided by the Installer, as long as it does not already exist on your computer.

    • Specify a password for the database accounts. The password must have at least eight characters and include both alphabetic and numeric characters. For details about specifying passwords, refer to Oracle Database Security Guide.

      You will have the opportunity to change the passwords for the database accounts at a later time.

    • Click Next.

  3. On the Oracle Configuration Manager Registration page, you can choose to register your installation with your Metalink account.

    Description of install3.gif follows
    Description of the illustration install3.gif

    This page is optional. You can simply choose Next.

  4. The Summary page displays the settings and components for the installation.

    Description of install4.gif follows
    Description of the illustration install4.gif

    Click Install.

  5. The Installer proceeds with the installation.

    Description of install5.gif follows
    Description of the illustration install5.gif

  6. The Installer invokes the Configuration Assistants to configure and start the starter database.

    Description of install7.gif follows
    Description of the illustration install7.gif

    If the Configuration Assistants encounter an error, check the logs to determine the problem. You can choose to continue the installation and start the assistants manually later, or you can restart the installation. To continue the installation, click Install.

  7. Database Configuration Assistant creates the starter database.

    Description of install8.gif follows
    Description of the illustration install8.gif

  8. The Database Configuration Assistant page displays information about the starter database.

    Description of install9.gif follows
    Description of the illustration install9.gif

    Click the Password Management button.

  9. Unlock the SYS, SYSTEM, and SH accounts. Specify a password for SH. You can also change the passwords for SYS and SYSTEM if you wish. The password must have at least eight characters and include both alphabetic and numeric characters

    For details about specifying passwords, refer to Oracle Database Security Guide.

    Description of install10.gif follows
    Description of the illustration install10.gif

    Click OK to return to the Database Configuration Assistant page.

    On the Database Configuration Assistant page, click OK.

  10. Click EXIT to exit the Installer.

    Description of install11.gif follows
    Description of the illustration install11.gif

Install Oracle Database Companion

The Oracle Data Mining sample programs are installed with Oracle Database Companion.

The Database Companion installation process copies the Oracle Data Mining sample programs, along with examples and demonstrations of other database features, to the \rdbms\demo subdirectory of the Oracle home directory.

To install the Database Companion, perform these steps:

  1. From the Companion installation directory, run SETUP.EXE.

    Oracle Universal Installer opens and displays the Welcome page. Click Next to advance to the next page.

    Description of cpinstall1.gif follows
    Description of the illustration cpinstall1.gif

  2. On the Specify Home Details page, specify the Oracle home directory in which you installed Oracle Database. Do not assume that the directory displayed by the Installer is correct.

    Description of cpinstall2.gif follows
    Description of the illustration cpinstall2.gif

  3. On the Summary page, review the information and settings for your installation, then click Install.

    Description of cpinstall3.gif follows
    Description of the illustration cpinstall3.gif

  4. The Installer proceeds with the installation.

    Description of cpinstall4.gif follows
    Description of the illustration cpinstall4.gif

  5. On the End of Installation page, confirm that the installation was successful.

    Description of cpinstall5.gif follows
    Description of the illustration cpinstall5.gif

  6. Click Exit to exit the Installer.

Create a Data Mining Demo User

To build and score Data Mining models, you must have an Oracle user ID with the appropriate privileges. Follow these instructions to create a demo user that has required privileges for running the sample programs and creating and scoring models within the user's schema.

See Also:

Chapter 4, "Users and Privileges for Data Mining" to create data mining users that are capable of performing broader data mining tasks

Note:

In the following sections, you will find references to the environment variable for the Oracle home directory on Windows (%ORACLE_HOME%). If the environment variable does not exist on your computer, you can create it. To add or change environment variables, open System in Control Panel and choose the Advanced tab.
  1. Start SQL*Plus and login with system privileges.

    You can launch SQL*Plus from the Windows Start menu. Choose the Oracle home menu item and the Application Development submenu.

    Enter user-name: sys / as sysdba
        Enter password: password
    
  2. To create the user, type a command like the following.

    CREATE USER dmuser IDENTIFIED BY password
           DEFAULT TABLESPACE USERS
           TEMPORARY TABLESPACE TEMP
           QUOTA UNLIMITED ON USERS;
    
  3. Run dmshgrants.sql to grant access to the SH schema. Several tables in SH are used by the Data Mining sample programs. Specify the Data Mining user name and the password to SH as parameters.

    @ %ORACLE_HOME%\rdbms\demo\dmshgrants sh_password dmuser
    
  4. Now connect to the database as the Data Mining user.

    CONNECT dmuser
    Enter password: password
    
  5. Run dmsh.sql to populate the schema of the Data Mining user with tables, views, and other objects needed by the sample programs.

    @ %ORACLE_HOME%\rdbms\demo\dmsh
    COMMIT;
    

Once you have completed these steps, you can run the Data Mining sample programs whenever you log in to the database as the Data Mining demo user.

Run the Sample Programs

To locate the sample programs on your computer, navigate to the rdbms\demo subdirectory under Oracle home.

To display the Data Mining PL/SQL sample programs, search for the files that start with dm and end with .sql. (The list will include dmsh.sql and dmshgrants.sql, which are used to configure the Data Mining demo user ID.) The PL/SQL sample programs are listed in Table 1-1.

Table 1-1 Sample PL/SQL Data Mining Programs

Program File Algorithm Mining Function or Task

dmaidemo.sql

Minimum Descriptor Length

Attribute Importance

dmardemo.sql

Apriori

Association

dmdtdemo.sql

Decision Tree

Classification

dmdtxvlddemo.sql

Decision Tree (cross validation)

Classification

dmglcdem.sql

Binary Logistic Regression (GLM)

Classification

dmglrdem.sql

Multivariate Linear Regression (GLM)

Regression

dmkmdemo.sql

k-Means

Clustering

dmnbdemo.sql

Naive Bayes

Classification

dmnmdemo.sql

Non-Negative Matrix Factorization

Feature Extraction

dmocdemo.sql

O-Cluster

Clustering

dmsvcdem.sql

Support Vector Machine

Classification

dmsvodem.sql

Support Vector Machine

Anomaly Detection

dmsvrdem.sql

Support Vector Machine

Regression

dmtxtfe.sql

Term extraction using Oracle Text

Text transformation for mining

dmtxtnmf.sql

Non-Negative Matrix Factorization

Text mining using NMF

dmtxtsvm.sql

Support Vector Machine

Text mining using SVM


In the same directory, search for the files that start with dm and end with .java to display the Java samples. The Java sample programs are listed in Table 1-2.

Table 1-2 Sample Java Data Mining Programs

Program File Algorithm Mining Function or Task

dmaidemo.java

Minimum Description Length

Attribute importance

dmapplydemo.java

Naive Bayes

Illustrate scoring methods

dmardemo.java

Apriori

Association

dmexpimpdemo.java

NA

Model Export/Import

dmglcdemo.java

Binary Logistic Regression (GLM)

Classification

dmglrdemo.java

Multivariate Linear Regression (GLM)

Regression

dmkmdemo.java

k-Means

Clustering

dmnbdemo.java

Naive Bayes

Classification

dmnmdemo.java

Non-Negative Matrix Factorization

Feature extraction

dmocdemo.java

O-Cluster

Clustering

dmpademo.java

Automated predict and explain

Predictive Analytics

dmsvcdemo.java

Support Vector Machine

Classification

dmsvodemo.java

Support Vector Machine (one class)

Classification

dmsvrdemo.java

Support Vector Machine

Regression

dmtreedemo.java

Decision Tree

Classification

dmtxtnmfdemo.java

Non-Negative Matrix Factorization

Text mining with NMF

dmtxtsvmdemo.java

Support Vector Machine

Text mining with SVM classification

dmxfdemo.java

Binning, clipping, and normalization

Data Transformations


View the Source Code

You will learn a great deal about the Data Mining APIs by investigating the source code of the sample programs. The programs illustrate typical approaches to data preparation, algorithm selection, algorithm tuning, testing, and scoring. All the programs include extensive comments to help you understand what the code is doing.

You can view the source code simply by opening the files in a text editor.

Run the PL/SQL Sample Programs

Now that you have a user ID with the required privileges and a schema populated with the required objects, you can run the sample programs. Each program creates a Data Mining model.

While the program is running, it displays the code and the program output.

You can run the sample programs as many times as you wish. The programs clean up the results of the previous run before executing the current run.

To run the PL/SQL programs:

  1. Start SQL*Plus and login as the Data Mining user.

    Enter user-name: dmuser
        Enter password: password
    
  2. Run the program by specifying "@" followed by the fully-qualified path of the program. This example executes the program dmnbdemo.sql, which creates a Naive Bayes model.

    SQL>@ %ORACLE_HOME%\rdbms\demo\dmnbdemo
    

Prepare to Run the Java Programs

Before you can run the Java programs, you must set up your Java environment and compile the programs. You can do this in an Integrated Development Environment such as Oracle JDeveloper, or you can execute the following commands at the operating system prompt.

  1. Check that the version of Java you are using is 1.5 or higher. You can execute the following in a command window to check the version of Java.

    >java -version
    
  2. Add %ORACLE_HOME%\jdk\bin\ to your PATH variable before the paths of any other Java versions.

  3. Add the following Data Mining JAR files to your Windows CLASSPATH:

    %ORACLE_HOME%\rdbms\jlib\jdm.jar
                %ORACLE_HOME%\rdbms\jlib\ojdm_api.jar
                %ORACLE_HOME%\rdbms\jlib\xdb.jar
                %ORACLE_HOME%\jdbc\lib\ojdbc5.jar
                %ORACLE_HOME%\oc4j\j2ee\home\lib\connector.jar
                %ORACLE_HOME%\jlib\orai18n.jar   
                %ORACLE_HOME%\jlib\orai18n-mapping.jar
                %ORACLE_HOME%\lib\xmlparserv2.jar
    
  4. Compile the programs listed in Table 1-2. To use the JAVAC executable, open a command window and go to \rdbms\demo in Oracle home.

    >javac program_name.java
    

    For example:

    >javac dmnbdemo.java
    

    If JAVAC is not found, then check the value of the PATH variable.

Run the Java Programs

You can run a Java program from the operating system prompt with a command like this:

>java program_name host_name:port_number:database_identifier user password

View the Models Created by the Sample Programs

You can query the USER_MINING_MODELS view to list the models in your schema.

SQL> set linesize 100
SQL> SELECT model_name, mining_function, algorithm from user_mining_models;
 
MODEL_NAME               MINING_FUNCTION            ALGORITHM
------------------------ -------------------------- ------------------------------
AI_SH_SAMPLE             ATTRIBUTE_IMPORTANCE       MINIMUM_DESCRIPTION_LENGTH
AR_SH_SAMPLE             ASSOCIATION_RULES          APRIORI_ASSOCIATION_RULES

This example shows that there are two mining models in your schema. The model name, mining function, and algorithm are displayed. To find all the columns defined in a view, use a DESCRIBE command.

SQL> DESCRIBE user_mining_models

You can query the USER_MINING_MODEL_ATTRIBUTES and USER_MINING_MODEL_SETTINGS views to obtain information about the attributes and settings for the models in your schema.