Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle R Enterprise 1.3?

• New Features for Release 1.3
• New Features for Release 1.1

1 Overview of Oracle R Enterprise

• Oracle R Enterprise Architecture
  • Oracle R Enterprise Supported Configurations
• GUIs and IDEs for R
• Oracle R Enterprise Training
• Oracle R Enterprise Useful Links

2 Oracle R Enterprise Transparency Layer

• Data Types Supported
  • Date and Time Data Types
    • Date and Time Data Types in Oracle
    • Oracle R Enterprise Support for Date and Time
• Operators and Functions Supported

3 Using Oracle R Enterprise

• Tables in the Oracle Database
• View Oracle R Enterprise Documentation
• Oracle R Enterprise Data
  • Long Names
  • Load an R Data Frame into the Database
    • Example: Load Data
  • Materialize R Data
  • Verify that an ore.frame Exists
  • Drop a Database Table
  • Pull a Database Table to an R Frame
  • Order in Tables
  • Sampling and Partitioning
    • Indexing
    • Sampling
    • Random Partitioning
  • Persist and Manage R Objects in the Database
    • ore.save()
    • ore.load()
    • ore.delete()
    • ore.datastore()
    • ore.datastoreSummary()
• Using R with Oracle R Enterprise Data Types
• Derived Columns in Oracle R Enterprise
• Using CRAN Packages with Oracle R Enterprise
  • Build and Use a Regression Model
• Oracle R Enterprise Database-Embedded R Engine
  • Perform R Computation in the Oracle Database
  • Build a Series of Regression Models Using Data Parallelism
• Oracle R Enterprise Examples
  • Load Data Frame to a Table
  • Handle NULL Values Using airquality
  • Oracle R Enterprise Demos

4 Oracle R Enterprise Statistical Functions

• Data for Examples
• ore.corr
  • ore.corr Parameters
  • ore.corr Examples
    • Basic Correlation Calculations
    • Partial Correlation
    • Create Several Correlation Matrices
    • Visualization of Correlations
• ore.crosstab
  • ore.crosstab Parameters
  • ore.crosstab Examples
    • Single-Column Frequency Table
    • Analyze Two Columns
    • Weighting Rows
    • Order Rows in the Cross Tabulated Table
    • Analyze Three or More Columns
    • Specify a Range of Columns
    • Produce One Cross Table for Each Value of Another Column
    • Augment Cross Tabulation with Stratification
    • Custom Binning Followed by Cross Tabulation
    • ore.extend
• ore.freq
  • ore.freq Parameters
  • ore.freq Examples
• ore.rank
  • ore.rank Parameters
  • ore.rank Examples
    • Rank Two Columns
    • Handle Ties
    • Rank Within Groups
    • Partition into Deciles
    • Estimate Cumulative Distribution Function
    • Score Ranks
• ore.sort
  • ore.sort Parameters
  • ore.sort Examples
    • Sort Columns in Descending Order
    • Sort Different Columns in Different Orders
    • Sort and Return One Row per Unique Value
    • Remove Duplicate Columns
    • Remove Duplicate Columns and Return One Row per Unique Value
    • Preserve Relative Order in Output
    • Examples Using ONTIME_S
• ore.summary
  • ore.summary Parameters
  • ore.summary Examples
    • Calculate Default Statistics
    • Skew and t Test
    • Weighted Sum
    • Two Separate Group By Columns
    • All Possible Group By
• ore.univariate
  • ore.univariate Parameters
  • ore.univariate Examples
    • Default Univariate Statistics
    • Location Statistics
    • Complete Quantile Statistics

5 Predicting With R Models

• ore.predict for R Models
• Examples

6 Oracle R Enterprise Versions of R Models

• ore.lm()
  • ore.lm() and ore.stepwise() Advantages
  • Linear Regression Example
• ore.stepwise()
  • Stepwise Regression Example
• ore.neural()
  • Neural Network Example

7 In-Database Predictive Models in Oracle R Enterprise

• OREdm Requirements
• OREdm Models and Oracle Data Mining Models
• OREdm Models
  • Data Mining Terminology
    • Formula
  • Overloaded Functions
  • Attribute Importance
    • Attribute Importance Example
  • Decision Tree
    • Decision Tree Example
  • Generalized Linear Models
    • GLM Examples
  • k-Means
    • k-Means Example
  • Naive Bayes
    • Naive Bayes Example
  • Support Vector Machine
    • Support Vector Machine Examples

8 Oracle R Enterprise Embedded Execution

• Security Considerations for Scripts
  • RQADMIN Role
• Support for Database Parallelism
• R Interface for Embedded Oracle R Enterprise Scripts
  • Security Issues for Embedded R Scripts
  • Input for ore.*Apply() and ore.doEval()
  • ore.doEval()
  • ore.tableApply()
  • ore.groupApply()
  • ore.rowApply()
  • ore.indexApply()
  • ore.scriptCreate()
    • ore.scriptCreate() Example
  • ore.scriptDrop()
  • Embedded Execution Auto Connect for R Scripts
  • Examples of Embedded R Script
• Oracle R Enterprise Embedded SQL Scripts
  • Registering and Managing SQL Scripts
  • Oracle R Enterprise SQL Functions
    • rqGroupEval() Function
    • rq*Eval() and Objects in a Datastore
    • Datastore Management in SQL

A Oracle R Enterprise License Information

• Third-Party Software Installed with Oracle R Enterprise
  • Open-Source R Distribution
    • GNU GENERAL PUBLIC LICENSE Version 2
    • Code derived from software contributed to Berkeley by Guido van Rossum
    • FIG: Facility for Interactive Generation of figures
    • unzip.h -- IO for uncompress .zip files using zlib
  • ROracle
    • GNU Lesser General Public License Version 2.1

B Oracle R Enterprise and Oracle R Distribution Packages

• Packages Related to Oracle R Distribution
• Packages Related to Oracle R Enterprise

C RStudio Installation

• RStudio Desktop
• RStudio Server

Index