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?
• Understanding Oracle Universal Installer
• • Installation Directories
  • Installation Methods
  • Installation Types
  • Creating a Database During Installation
• Preparing for Installation
• • Hardware Requirements
  • Software Requirements
  • Preexisting Oracle Products
  • • Stop Oracle Services
    • Delete the ORACLE_HOME Environment Variable
  • Dynamic IP
• Installing the Data Mining Option
• • Adding the Data Mining Option to a Database
  • Removing the Data Mining Option
• Installing the Data Mining Scoring Engine
• • Performing a Custom Installation
  • Adding the Scoring Engine to an Existing Installation
  • Removing the Scoring Engine
• Verifying Installation of Data Mining Components
• Tips for Linux Installations
• 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

• 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 Data Mining Users
• • Creating Tablespaces
  • • Using SQL Commands
    • Using Enterprise Manager Database Control
  • Creating Users
  • • Access Rights
    • Using SQL
    • Using Enterprise Manager Database Control
  • About the DMSYS Schema
• 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 Tools for Data Mining

• 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
• Oracle Spreadsheet Add-In for Predictive Analytics
• • Installation Steps
  • Adding the Spreadsheet Add-In to Excel
  • Installing Oracle Client
  • Creating an Oracle Net Service Name
  • • Remote Database
    • Local Database
  • Connecting Excel to Oracle Database

4 Installing and Using the Demo Programs

• Requirements Checklist
• Obtaining the Demo Programs
• • Downloading from OTN
  • Installing Oracle Database Companion
  • Verifying the Installation
• Creating a Demo User
• • Using SQL*Plus to Create the User
  • Using Enterprise Manager to Create the User
  • Granting Access Rights
  • • Run DMSHGRANTS
  • Populating the Schema
  • • Run DMSH
    • Sample Schemas
  • A Sample User Scenario
• Examining the Data
• • Customer Data for Data Mining
  • Market Basket Data for Association Rules
  • Customer Data for Text Mining
• PL/SQL Demo Programs
• • PL/SQL Program Summaries
  • Data Mining SQL Functions
  • Running the PL/SQL Programs
• Java Demo Programs
• • Java Program Summaries
  • Preparing to Run the Java Programs
  • Running the Java Programs
• Text Mining Demo Programs
• • Text Mining in PL/SQL
  • • Text Transformation Demo
    • Text Transformation for the PL/SQL Text Mining Demo Programs
    • The Sample Text Mining Models (PL/SQL)
  • Text Mining in Java
  • • Text Transformation for the Java Demo Text Mining Programs
    • The Sample Text Mining Models (Java)
• BLAST Demo Program
• • Preparing to Run the BLAST Demo
  • Running the BLAST Table Functions

Index