1/13
Contents
List of Examples
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Oracle R Enterprise Online Resources
Conventions
Changes in This Release for Oracle R Enterprise
Changes in Oracle R Enterprise 1.4
Changes in Oracle R Enterprise 1.3
Changes in Oracle R Enterprise 1.1
1
Introducing Oracle R Enterprise
About Oracle R Enterprise
Advantages of Oracle R Enterprise
Get Online Help for Oracle R Enterprise Classes, Functions, and Methods
About Transparently Using R on Oracle Database Data
About the Transparency Layer
Transparency Layer Support for R Data Types and Classes
About Oracle R Enterprise Data Types and Classes
About the ore.frame Class
Support for R Naming Conventions
About Coercing R and Oracle R Enterprise Class Types
Typical Operations in Using Oracle R Enterprise
Oracle R Enterprise Global Options
Oracle R Enterprise Examples
Listing the Oracle R Enterprise Examples
Running an Oracle R Enterprise Example Script
2
Getting Started with Oracle R Enterprise
Connecting to an Oracle Database Instance
About Connecting to the Database
About Using the ore.connect Function
About Using the ore.disconnect Function
Using the ore.connect and ore.disconnect Functions
Creating and Managing R Objects in Oracle Database
Creating R Objects for In-Database Data
About Creating R Objects for Database Objects
Using the ore.sync Function
Using the ore.get Function
Using the ore.attach Function
Creating Ordered and Unordered ore.frame Objects
About Ordering in ore.frame Objects
Global Options Related to Ordering
Ordering Using Keys
Ordering Using Row Names
Using Ordered Frames
Moving Data to and from the Database
Creating and Deleting Database Tables
Saving and Managing R Objects in the Database
About Persisting Oracle R Enterprise Objects
About Oracle R Enterprise Datastores
Saving Objects to a Datastore
Getting Information about Datastore Contents
Restoring Objects from a Datastore
Deleting a Datastore
About Using a Datastore in Embedded R Execution
3
Preparing and Exploring Data in the Database
Preparing Data in the Database Using Oracle R Enterprise
About Preparing Data in the Database
Selecting Data
Indexing Data
Combining Data
Summarizing Data
Transforming Data
Sampling Data
Partitioning Data
Preparing Time Series Data
Exploring Data
About the Exploratory Data Analysis Functions
About the NARROW Data Set for Examples
Correlating Data
Cross-Tabulating Data
Analyzing the Frequency of Cross-Tabulations
Building Exponential Smoothing Models on Time Series Data
Ranking Data
Sorting Data
Summarizing Data
Analyzing Distribution of Numeric Variables
Using a Third-Party Package on the Client
4
Building Models in Oracle R Enterprise
Building Oracle R Enterprise Models
About OREmodels Functions
About the longley Data Set for Examples
Building Linear Regression Models
Building a Generalized Linear Model
Building a Neural Network Model
Building Oracle Data Mining Models
About Building Oracle Data Mining Models using Oracle R Enterprise
Oracle Data Mining Models Supported by Oracle R Enterprise
About Oracle Data Mining Models Built by Oracle R Enterprise Functions
Building an Association Rules Model
Building an Attribute Importance Model
Building a Decision Tree Model
Building General Linearized Models
Building a k-Means Model
Building a Naive Bayes Model
Building a Non-Negative Matrix Factorization Model
Building an Orthogonal Partitioning Cluster Model
Building a Support Vector Machine Model
5
Predicting With R Models
6
Using Oracle R Enterprise Embedded R Execution
About Oracle R Enterprise Embedded R Execution
Benefits of Embedded R Execution
APIs for Embedded R Execution
Security Considerations for Scripts
Support for Parallel Execution
Installing a Third-Party Package for Use in Embedded R Execution
R Interface for Embedded R Execution
Arguments for Functions that Run Scripts
Input Function to Execute
Optional Arguments
Structure of Return Value
Input Data
Parallel Execution
Unique Arguments
Automatic Database Connection in Embedded R Scripts
Using the ore.doEval Function
Using the ore.tableApply Function
Using the ore.groupApply Function
Partitioning on a Single Column
Partitioning on Multiple Columns
Using the ore.rowApply Function
Using the ore.indexApply Function
Simple Example of Using the ore.indexApply Function
Column-Parallel Use Case
Simulations Use Case
Using the ore.scriptCreate and ore.scriptDrop Functions
SQL Interface for Embedded R Execution
Registering and Managing SQL Scripts
About Oracle R Enterprise SQL Functions
Using the rqGroupEval Function
Using SQL Functions and Objects in a Datastore
Datastore Management in SQL
A
R Operators and Functions Supported by Oracle R Enterprise
Index
Scripting on this page enhances content navigation, but does not change the content in any way.