Posted by: michaelverzijl | 30/11/2011

Using R within Oracle

Update: Nice Retweet bij Oracle:

Today I followed a session on “Using R within Oracle”. This session was organised by the BIWA SIG (thanks Shyam)
The presentation was given by Mark Hornick, Senior Manager, Oracle Advanced Analytics Development.

Mark started with explaining what “R” is all about. “R” is an open source environment for advanced analysis.

Limitations of R
R is a client and server bundled as one. Therefore all data has to be loaded into memory and this provides a bottleneck when analyzing large data sets.

Oracle strategy for R is to deliver enterprise-level advanced analytics based on the R environment.
By support R enterprises have support for open-source R (a reason why enterprises wouldn’t use this tool because support was limited)

Oracle R Enterprise
Oracle R is a part of the database. Therefore the analysis are brought to the data, not the data to the analyze software which improves performance.
Furthermore Oracle R can use all benefits a Oracle database brings (parallelism/Exadata/Big Data Appliance)

What is Oracle “R” Enterprise?
R packages, database library and SQL extensions that bring Oracle Database closer to advanced Analytics users in a Enterprise:

Transparency library
Enables users of R to work with large data sets as data is stored in the database with R expressions executed on database

Statistics Engine
Commonly-used statistical library (executed in Database)

SQL Extensions
Embed R in Operational systems and eliminate client data loading and result write-back in Oracle Database

Hadoop connector
Connect to data stored in HDFS

Data Sources for Oracle R Enterprise
  • Oracle R is a comprehensive advanced analytics solution for big data
  • Offers a compelling alternative advanced analytics technology stack for enterprises to leverage emerging trends
  • Expands support for emerging data sources and IT infrastructures

Interesting links



  1. […] Michael Verzijl reports on the “Using R within Oracle” session at a recent BIWA SIG meeting.    Oracle Read the original post on Oracle Technology Network… […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: