ORE (Oracle R Enterprise)

Card Puncher Data Processing

About

Oracle R Enterprise is a component of Oracle Advanced Analytics that enables R processing on Oracle Database servers.

Features

Enhanced Model Scoring

The new package OREpredict enables in-database scoring of R-generated models.

Supported models:

Oracle Data Mining Support

The new package OREdm provides an R interface for in-database Oracle Data Mining predictive analytics and data mining algorithms.

Supported models include:

R Script to R database function

“embedded R execution” characterizes the storing of R scripts in Oracle Database – using the ORE R script repository – and invoking that script in one or more database-side R engines.

R scripts can be deploy as an R function to the database where it can be invoke either from R or SQL.

Executing R scripts from SQL enables integration of R script results within SQL Data Access Tools (such as OBIEE, Oracle BI Publisher, …)

API

The function f refers to the user-defined R code, or script, that is provided as either an R function object or a named R function in the database R script repository.

R API SQL API Description
ore.doEval rqEval To create functions in the R script repository. Executes f with no automatic transfer of data (ie do not automatically receive any data from the database).
ore.tableApply rqTableEval Executes f passing all rows of provided input ore.frame as the first parameter of f. First parameter provided as a data.frame.
ore.groupApply “rqGroupEval” (must be explicitly defined as function by user) Executes f by partitioning data according to an “index” column’s values. Each data partition provided as a data.frame in the first parameter of f. Supports parallel execution of each f invocation in pool of database server-side R engines.
ore.rowApply rqRowEval Executes f passing a specified number of rows (a “chuck”) of the provided input ore.frame. Each chunk provided as a data.frame in the first parameter of f. Supports parallel execution of each f invocation in pool of database server-side R engines.
ore.indexApply N/A Executes f with no automatic transfer of data, but provides the index of the invocation, 1 through n, where n is the number of functions to invoke. Supports parallel execution of each f invocation in pool of database server-side R engines.
ore.scriptCreate sys.rqScriptCreate Load the provided R function into the R script repository with the provided name.
ore.scriptDrop sys.rqScriptDrop Remove the named R function from the R script repository.

Documentation / Reference





Discover More
Data Mining Tool 2
Machine Learning - Data Mining (Software, Library and Framework)

This sections contains software library or framework that contains the implementation of machine learning algorithm. See Data...
Card Puncher Data Processing
ORE - Install 1.3.1

grant rqrole to grant execute on rqsys.rqGroupEvalImpl for each user. Create all the synonyms listed in rquser.sql for each user. startup scriptfunctions ore.attach(USER, SID, host, password) establishes...
Card Puncher Data Processing
ORE - Snippet

ore snippet Connect to the database. Load Data Frame to table Create IRIS_TABLE_N that does not contain SPECIES, the nonnumeric column: The sample null.R is the only sample that does...
Card Puncher Data Processing
R

is a language and environment for statistical computing and graphics. Syntax is very similar to the S_(programming_language)S language. S is a language that was developed by John Chambers et al. at Bell...



Share this page:
Follow us:
Task Runner