Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• 1 Oracle Data Miner System Overview
  • Oracle Data Miner Architecture
  • About the Oracle Data Miner Repository
  • Database Features Used by Oracle Data Miner
  • Oracle Data Miner and Oracle Advanced Analytics
  • About Data Mining APIs
    • Data Mining PL/SQL Packages
    • Data Mining SQL Scoring Functions
    • Data Mining Data Dictionary Views
  • Resources For Learning About Oracle Data Miner
• 2 Installing the Database to Support Oracle Data Miner
  • Database Requirements for Oracle Data Miner
  • Oracle Text and Oracle Data Miner
  • XML DB and Oracle Data Miner
  • Storage Configuration for Oracle Data Miner
  • Installing Oracle Database 11.2.0.4 or Later
  • Connecting to an Oracle Cloud Database Schema
• 3 Installing Oracle Data Miner
  • Oracle Data Miner Installation Overview
  • About Oracle Data Miner Sample Data
  • Downloading SQL Developer
  • Installing the Repository Using a Script
  • Loading the Sample Data Using a Script
  • Installing the Repository Using SQL Developer GUI
  • Installing JSON Parser and Data Guide
    • About the Scripts for Installing JSON Support
    • Requirements for Running the Scripts to Install JSON Parser
    • Installing JSON Parser in a Remote Database
    • Installing JSON Parser Locally on the Database Host
• 4 Managing Oracle Data Miner Users
  • About User Objects and Repository Objects
    • Controlling the Size of Users' Schemas
    • Objects in Oracle Data Miner Users' Schema
    • About Oracle Data Miner Internal Tables
  • About Proxy Users for Oracle Data Miner
  • Setting the JVM Property
  • Choosing an Access Model for Oracle Data Miner
    • Single User Access
    • Multiple User Access
    • Shared User Environment
    • About the Document in Use Condition
  • Granting or Dropping Access Rights to Oracle Data Miner Repository
    • Granting Access Rights Using the GUI
    • Granting Access Rights Using a Script
    • Dropping Access Rights Using a Script
    • Granting Access to Data
• 5 Managing the Oracle Data Miner Repository
  • About Oracle Data Miner Administration Scripts
  • Setting the Path to Oracle Data Miner Scripts
  • Determining the Status and Version of the Repository
  • Backing Up and Restoring the Repository
    • Full Backup and Restore
      • Full Backup and Restore in Database 11.2.0.4 and Later
    • Workflow Only Backup
    • Workflow Only Restore
    • Workflow Only Restore Examples
  • Migrating the Repository
    • Upgrading ODMRSYS
    • Scripts to Migrate the Repository
    • Upgrading New ODMRSYS Tablespace From Object-Relational to Binary
    • Upgrading ODMRSYS From Object-Relational to Binary
  • Dropping the Repository
• 6 Managing System Resources for Oracle Data Miner
  • Oracle Data Miner Resource Management Overview
  • Allocating Resources to Oracle Data Miner User Sessions
  • Managing Model Builds
  • Managing Workflow Execution
  • Managing Parallel Processing
  • Summary of Oracle Data Miner Repository Properties for System Management
• 7 Generating and Deploying SQL Scripts
  • Overview of the SQL Script Generation Feature
  • Overview of the SQL Script Generation Use Case
    • Premise of the SQL Script Generation Use Case
      • Location of Demo Workflow Files
    • About the Sample Workflow
    • Performing Prerequisite Tasks
    • Importing and Running a Workflow
  • Generating SQL Script Files from the Workflow
    • List of Generated SQL Script Files
    • Variable Definitions in Script Files
    • Control Tables
      • Structure of the Control Table
      • Columns in the Control Table
  • Scheduling Workflow Script Files
    • Prerequisites for Scheduling Workflow Script Files
      • Adding Complete Directory Path in the Master Script
      • Creating Credentials for Database Host and Database
    • Schedule SQL Scripts Using SQL Developer
      • Creating Credentials for Database Host and Database
      • Defining Scheduler Job using Job Wizard
    • Scheduling SQL Scripts using Oracle Enterprise Manager
  • Deploying SQL Scripts on the Target Database
    • Querying the Control Table
• 8 Using PL/SQL API to Manage Workflows
  • About PL/SQL APIs
  • PL/SQL APIs
    • PROJECT_CREATE
    • PROJECT_RENAME
    • PROJECT_DELETE
    • WF_RUN
      • WF_RUN Parameters
      • WF_RUN with Project Name, Workflow Name, and Node Name
      • WF_RUN with Project Name, Workflow Name Node Name and Time Interval
      • WF_RUN with Project ID, Workflow ID, Node ID and Time Interval
      • WF_RUN with Project ID, Workflow ID and Node IDs
    • WF_STOP
    • WF_RENAME
    • WF_DELETE
    • WF_IMPORT
    • WF_EXPORT
  • Repository Views
    • ODMR_USER_PROJECT_WORKFLOW
    • ODMR_USER_WORKFLOW_ALL
    • ODMR_USER_WORKFLOW_LOG
    • ODMR_USER_WORKFLOW_NODES
    • ODMR_USER_WORKFLOW_MODELS
    • ODMR_USER_WF_CLAS_TEST_RESULTS
    • ODMR_USER_WF_REGR_TEST_RESULTS
    • ODMR_USER_WF_TEST_RESULTS
    • ODMR_USER_WORKFLOW_ALL_POLL
  • PL/SQL APIs Use Cases
    • Premise of the PL/SQL Use Cases
    • Use case to Schedule and Run Apply Workflows
      • Querying Scoring Result
    • Use Case to Schedule and Run a Build Workflow
      • Querying the MODEL_COEFFICIENT Table
      • Querying Named Objects
      • Querying Test Results
• A Oracle Data Miner Releases
• Index