Contents

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

• No DMSYS Schema
• Mining Models in the Oracle Data Dictionary
• Enhanced Security
• Scoping of Nested Data and Enhanced Handling of Sparse Data
• Desupported and Deprecated Features

1 Installing Oracle Database for Data Mining

• Install Oracle Database
• Install Database Companion
• Create a Data Mining Demo User
• Run the Sample Programs
  • View the Source Code
  • Run the PL/SQL Sample Programs
  • Prepare to Run the Java Programs
  • Run the Java Programs
  • View the Models Created by the Sample Programs

2 Connecting to a Database for Data Mining

• Your User ID
• Connect to a Local Database
• Connect to a Remote Database
  • Install Oracle Client
  • Perform Data Mining on a Remote Computer
  • Run the Data Mining Sample Programs on a Remote Computer
• Create a Net Service Name

3 Upgrading Oracle Data Mining

• Upgrading Oracle Data Mining
  • Supported Version Upgrades
  • Using Oracle Database Upgrade Assistant
  • Exporting and Importing from a Dump File
• Downgrading Oracle Data Mining

4 Users and Privileges for Data Mining

• Creating Data Mining Users
  • Privileges Required for Data Mining
• System Privileges for Mining Models
• Object Privileges on Mining Models

5 Installing the Spreadsheet Add-In for Predictive Analytics

• About the Spreadsheet Add-In
• Requirements
• Install the Spreadsheet Add-In

6 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
• 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
  • 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

7 The Data Mining Sample Programs

• PL/SQL Programs
  • PL/SQL Program Summaries
  • Data Mining SQL Scoring Functions
• Java Programs
  • Java Program Summaries
• Text Mining Programs
  • Text Mining in PL/SQL
    • Text Transformation Demo
    • Text Transformation for the PL/SQL Text Mining Sample Programs
    • The Sample Text Mining Models (PL/SQL)
  • Text Mining in Java
    • Text Transformation for the Sample Java Text Mining Programs
    • The Sample Text Mining Models (Java)
• The Sample Data
  • Customer Data for Data Mining
  • Market Basket Data for Association Rules
  • Customer Data for Text Mining

Index