Embedded R Execution has the following benefits:

• Eliminates moving data from the Oracle Database environment to your local R session.

  As well as being more secure, the transfer of database data between Oracle Database and an internal R engine is much faster than to a separate client R engine.

• Uses the database server to start, manage, and control the running of R scripts in R engines running on the server.

• Leverages the memory and processing power of the database server machine for R engine running, which provides better scalability and performance.

• Enables data-parallel and task-parallel execution of user-defined R functions.

• Provides parallel simulations capability.

• Allows the use of third-party CRAN packages in R scripts running on the database server in the database environment.

• Provides the ability to develop and operationalize comprehensive scripts for analytical applications in a single step, without leaving the R environment.

  You can directly integrate R scripts used in exploratory analysis into application tasks. You can also immediately run R scripts in production to drastically reduce time to market by eliminating porting and enabling instantaneous updates of changes to application code.

• Running R scripts from SQL enables integration of R script results with Oracle Analytics Server, Oracle Analytics Cloud, Oracle APEX, and other SQL-enabled tools for structured data, R objects, and images.

• Deploys the User-defined Functions (UDFs) in REST-based applications.