Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Installing Oracle Database for Data Mining

• Who Needs to Install Oracle Database?
• Installation of Oracle Database 10g
• • Hardware Requirements
  • Software Requirements
  • Preliminary Steps
  • Installing Oracle Database
  • Installing the Data Mining Sample Programs
• Tips for Linux Installations
• Additional Information for Enterprise Installations
• • Creating Data Mining Tablespaces on Real Application Clusters
  • Installing the Data Mining Scoring Engine
• Verifying Installation of Data Mining Components
• Upgrading from Oracle Database 10g Release 1 (10.1)
• • Post-Upgrade Steps for Data Mining
  • Upgrading PL/SQL Models
  • Downgrading Oracle Data Mining

2 Administering Oracle Database for Data Mining

• Introduction to Oracle Administration Tools
• • Local Administration on Microsoft Windows
  • • Oracle Enterprise Manager Database Control
    • SQL*Plus
    • Database Configuration Assistant
    • Oracle Universal Installer
    • Oracle Services
  • Local Administration on Linux
  • Remote Administration
• Creating Oracle Database Users for Data Mining
• • Creating a Demo User for Data Mining
  • Creating Analytic Users for Data Mining
  • • Creating Default Tablespaces
    • Creating Database Users for Data Mining
  • Granting Access Rights
  • • What the dmshgrants Script Does
    • What the dmshgrants Script Does Not Do
  • About the DMSYS Schema
• Creating a Sample Schema for Data Mining
• Exporting and Importing Data 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

3 Installing Client Tools and Applications

• Oracle Spreadsheet Add-In for Predictive Analytics
• • Prerequisites
  • Installing the Spreadsheet Add-In for Predictive Analysis
  • Connecting Excel to Oracle Database
  • Creating an Oracle Net Service Name
• Oracle Data Miner
• • Installing Oracle Data Miner on Windows
  • Installing Oracle Data Miner on Linux
  • • Prerequisite
    • Installation Steps
  • Connecting Oracle Data Miner to Oracle Database
• Data Mining Application Programming Interfaces
• • PL/SQL Development Tools
  • Java Development Tools

4 Installing and Using the Sample Programs

• Obtaining the Sample Programs
• • The PL/SQL Samples
  • The Java Samples
• Preparing to Run the Sample Programs
• • A Sample User Scenario
• Examining the Data
• • Customer Data for Data Mining
  • Market Basket Data for Association Rules
  • Customer Data for Text Mining
• Using the PL/SQL Samples
• • Running the PL/SQL Programs
  • PL/SQL Program Summaries
  • SQL Scoring Functions
• Using the Java Samples
• • Preparing to Run the Java Programs
  • Running the Java Programs
  • Java Program Summaries
• Using the Text Mining Samples
• • Text Mining in PL/SQL
  • • Text Transformation Sample
    • Text Transformation for the PL/SQL Sample Text Mining Programs
    • The Sample Text Mining Models (PL/SQL)
  • Text Mining in Java
  • • Text Transformation for the Java Sample Text Mining Programs
    • The Sample Text Mining Models (Java)
• Using the BLAST Sample
• • Preparing to Run the BLAST Demo
  • Running the BLAST Table Functions

Index