Go to main content
1/9
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 10
g
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
Scripting on this page enhances content navigation, but does not change the content in any way.