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