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?

• Oracle Database 11g Release 2 (11.2.0.3) Oracle Data Mining
• Oracle Database 11g Release 2 (11.2.0.2) New Features in Oracle Data Mining
• Oracle Database 11g Release 1 New Features in Oracle Data Mining

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: If You Want to Use Oracle Data Miner
• Step Five: If You Want to Use the Spreadsheet Add-In
• Step Six: If You Want to Use the Sample Programs

2 Installing Oracle Data Mining

• Install Oracle Database
• Verify the Data Mining Installation
• Enable or Disable the Data Mining Option
• Optionally Install Oracle Database Examples
• Optionally Install Oracle Data Miner
• Optionally 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 Application Development Tools
• Connect SQL*Plus
• Connect SQL Developer
• Connect Oracle Data Miner
• 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 Working With 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
• Data Definition Language for Mining Models
• 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
  • Using Oracle Data Pump
  • Using EXPORT_MODEL and IMPORT_MODEL
  • Database Privileges for Export/Import
  • Directory Object for EXPORT_MODEL and IMPORT_MODEL
  • Tablespace for IMPORT_MODEL
  • Tables Created By EXPORT_MODEL and IMPORT_MODEL
  • Examples: Exporting and Importing Mining Models
    • Exporting Models from the DMUSER Schema
    • Importing Models Into the Same Schema
    • Importing Models Into a Different Schema
    • Exporting and Importing Specific Models
• Importing From PMML

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