Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Where to Find Database Tuning Documentation
• Conventions

What's New in Oracle Data Mining Administration?

• New Administrative Features in Oracle Data Mining 11g Release 2 (11.2)
• New Administrative Features in Oracle Data Mining 11g Release 1 (11.1)

1 Getting Started with Oracle Data Mining

• Step One: Install the Database
• Step Two: Verify the Data Mining Installation
• Step Three: Create a Data Mining User
• Step Four: Install and Launch Oracle Data Miner
• Step Five: Install and Launch the Spreadsheet Add-In
• Step Six: If You Want to Use the Sample Programs

2 Installing the Oracle Database Software

• Install Oracle Database
• Verify the Data Mining Installation
• Install Oracle Database Examples
• Install Oracle Data Miner
  • Data Miner: Requirements
  • Data Miner: Installation Steps
  • Start Oracle Data Miner
• Install the Spreadsheet Add–In
  • Spreadsheet Add–In: Requirements
  • Spreadsheet Add–In: Install Steps
  • Start Data Mining in Excel

3 Connecting to an Oracle Database

• Connect Oracle Data Miner
• Connect Application Development Tools
  • Connect SQL*Plus
  • Connect SQL Developer
  • Connect Using Java
• Oracle Client and Oracle Net
  • Install Oracle Client
  • Create a Net Service Name
• Connect the Spreadsheet Add–In

4 Users and Privileges for Data Mining

• Create a Database User
  • Example: Create a Database User in SQL*Plus
• Grant Data Mining Privileges
• System Privileges for Data Mining
  • Example: Grant System Privileges for Data Mining
• Object Privileges for Mining Models
  • Example: Grant Object Privileges on Mining Models

5 Mining Model Schema Objects

• Obtaining Information from the Data Dictionary
  • Obtaining Information about Mining Models
  • Obtaining Information about Mining Model Attributes
  • Obtaining Information about Mining Model Settings
• Adding a Comment to a Mining Model
• Auditing Mining Models
  • Enabling Auditing in the Database
  • Opening an Audit Trail on Mining Models
  • Closing the Audit Trail
  • Viewing the Audit Trail
• Exporting and Importing Mining Models
  • Prerequisites
    • Directory Objects
    • Additional Database Privileges
  • PL/SQL APIs for Exporting and Importing Models
  • Java APIs for Exporting and Importing Models
  • Tables Created By Exporting and Importing Models
  • Example: Exporting and Importing Models
    • Exporting Models from the DMUSER Schema
    • Importing Models Into the Same Schema
    • Importing Models Into a Different Schema
    • Exporting and Importing Specific Models

6 Upgrading Oracle Data Mining

• Data Mining Upgrade Overview
  • Data Mining Model Upgrade
  • Upgrading from 10g
  • Upgrading from 11.1
• Upgrade Using Database Upgrade Assistant
• Upgrade Using Export/Import
  • Export/Import Release 11.1 Data Mining Models
  • Export/Import Release 10g Data Mining Models
• Post Upgrade Steps
• Downgrade Data Mining

7 The Data Mining Sample Programs

• Installation and Setup
  • Install the Sample Programs
  • Run the Configuration Scripts
  • Locate the Sample Programs
  • Run the Sample Programs
    • Run the PL/SQL Sample Programs
    • Prepare to Run the Java Programs
    • Run the Java Programs
  • List the Sample Models
• The PL/SQL Programs
  • PL/SQL Programs: Algorithms
  • PL/SQL Programs: Mining Functions
  • PL/SQL Text Mining Programs
• The Java Programs
  • Java Programs: Algorithms
  • Java Programs: Mining Functions
  • Java Text Mining Programs
• The Sample Data
  • Customer Data for Data Mining
  • Market Basket Data for Association Rules
  • Customer Data for Text Mining

A Verifying Your Data Mining Installation

• Connect to the Database
• Create a Script or Execute the Commands Individually
• Command Output

Index