1/11

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle R Enterprise User's Guide

• Changes in Oracle R Enterprise Release 1.2
• Changes in Oracle R Enterprise Release 1.1

1 Overview of Oracle R Enterprise

• Oracle R Enterprise Architecture
  • Oracle R Connector for Hadoop
  • Oracle R Enterprise Data Types
  • Oracle R Enterprise Supported Configurations

2 Installation

• Prerequisites
  • Linux, Windows, Solaris, and/or AIX
  • R
    • Oracle R Distribution
    • Install R on Windows
    • Install Oracle R Distribution on Linux
    • Install Oracle R Distribution on Oracle Exadata
    • Install R on Solaris
    • Install R on AIX
  • Oracle Database
• Install Oracle R Enterprise
  • Download Oracle R Enterprise Software
    • Use Oracle Universal Installer (Server Only)
    • Download from Oracle Technology Network
  • Install Client on Microsoft Windows
  • Install Client on Linux
  • Install Client on Solaris
  • Install Client on AIX
  • Install the Server
    • Before You Install the Server
    • Install Server on Microsoft Windows
    • Install Server on Linux
    • Install Server on Solaris
    • Install Server on AIX
    • Administrative Roles
    • Create Users
    • Configure Oracle Wallet (Optional)
  • Start the Oracle R Enterprise Client on Microsoft Windows
  • Start the Oracle R Enterprise Client on Linux, Solaris, or AIX
  • Connect to an Oracle Database
  • Oracle R Enterprise Samples
  • Troubleshoot the Installation
• Upgrade Oracle R Enterprise
• Validate Oracle R Enterprise Installation
• Uninstall Oracle R Enterprise

3 Using Oracle R Enterprise

• Tables in Oracle Database
• View Oracle R Enterprise Documentation
• Oracle R Enterprise Data
  • Load Data into the Database
  • Materialize R Data
  • Drop a Database Table
  • Pull a Database Table to an R Frame
• Oracle R Enterprise Transparency Layer
  • Using R with Oracle R Enterprise Data Types
  • Derived Columns in Oracle R Enterprise
• Oracle R Enterprise Database-Embedded R Engine
  • Build a Regression Model
  • Perform R Computation in the Database
  • Build a Series of Regression Models Using Data Parallelism
• Oracle R Enterprise Additional R Functions
• Oracle R Enterprise SQL Functions
  • rqGroupEval() Function
  • Registering R Scripts
    • Roles Required to Create and Use Scripts
• Oracle R Enterprise Examples
  • Load Data Frame to a Table
  • Handle NULL Values Using airquality
  • List of Examples

4 Predicting With R Models

• ore.predict for R Models
• Examples

5 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

A Third-Party Licenses

• 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

Index