Oracle Enterprise R

Oracle Enterprise R - language R for Oracle databases.

Being a part of the option Oracle Advanced Analytics, helps to use open coding environment R for corporate these DBMS Oracle century of Oracle R Enterprise it is developed especially for processing of data arrays, for this purpose it uses scalability and parallelism DBMS Oracle and also the built-in functions DBMS for optimization of work of the scripts written on R.

Oracle Enterprise R is a superstructure over language R which helps to use power DBMS Oracle for the analysis in language R of large volumes of data. Besides, Oracle Enterprise R gives the chance not to take out data from the database for the analysis that is very important for big industrial DBMS.

R is a programming language for statistical data processing and work with graphics and also free software environment of calculations open source within the GNU project.

Feature of language R — openness, it gives the chance to engineers independently to write own algorithms. In fact - the environment for development.

R has a number of restrictions:

• uses one processor
• before the analysis reads out all data in RAM of the client computer

These restrictions do not allow to use it for the analysis of large databases. Oracle solves these problems with the help of Oracle Enterprise R.

Solution architecture:

Architecture of Oracle Enterprise R (2012)

• environment R (for example RStudio).
• the special packet of Oracle R Enterprise which it is transparent forwards processing on database level
• on the party of Oracle there are also several libraries which are able to start R in the database, also to start processing on DBMS server side in separate engine R
• there is an opportunity to use means of Oracle for access to external systems (for example, other DBMS, the external file or Hadoop).