X

Best practices, news, tips and tricks - learn about Oracle's R Technologies for Oracle Database and Big Data

FAQ

FAQ

Integrating custom algorithms with Oracle Advanced Analytics with R

Data scientists and other users of machine learning and predictive analytics technology often have their favorite algorithm for solving particular problems. If...

Data scientists and other users of machine learning and predictive analytics technology often have their favorite algorithm for solving particular problems. If they are using a tool like Oracle Advanced Analytics -- with Oracle R Enterprise and Oracle Data Mining -- there's a desire to use these algorithms within that tool's framework. Using ORE's embedded R execution, users can already use 3rd party R packages in combination with Oracle  Database for execution at the...

FAQ

Contrasting Oracle R Distribution and Oracle R Enterprise

What is the distinction between Oracle R Distribution and Oracle R Enterprise? Oracle R Distribution (ORD) is Oracle's redistribution of open source R, with...

What is the distinction between Oracle R Distribution and Oracle R Enterprise? Oracle R Distribution (ORD) is Oracle's redistribution of open source R, with enhancements for dynamically loading high performance libraries like Intel's Math Kernel Library (MKL) and setting R memory limits on database server-side R engine execution. Oracle provides support for ORD to customers of the Oracle Advanced Analytics option (which includes Oracle R Enterprise and Oracle Data Mining),...

FAQ

R Package Installation with Oracle R Enterprise

Programming languages give developers the opportunity to write reusable functions and to bundle those functions into logical deployable entities. In R, these...

Programming languages give developers the opportunity to write reusable functions and to bundle those functions into logical deployable entities. In R, these are called packages. R has thousands of such packages provided by an almost equally large group of third-party contributors. To allow others to benefit from these packages, users can share packages on the CRAN system for use by the vast R development community worldwide. R's package system along with the CRAN framework...

FAQ

FAQ: Oracle R Enterprise and External Procedures

Oracle R Enterprise uses external procedures in Oracle Database to support embedded R execution. An external procedure, or extproc, is a procedure stored in a...

Oracle R Enterprise uses external procedures in Oracle Database to support embedded R execution. An external procedure, or extproc, is a procedure stored in a shared library that is called to perform special-purpose processing.  When ORE invokes an external procedure, Oracle Database starts an extproc agent and passes instructions to the agent for executing the procedure. The agent loads an ORE shared library or DLL, runs the external procedure in the database, and passes...

FAQ

ORE graphics using Remote Desktop Protocol

Oracle R Enterprisegraphics are returned as raster, or bitmap graphics. Rasterimages consist of tiny squares of color information referred to aspixels that form...

Oracle R Enterprisegraphics are returned as raster, or bitmap graphics. Rasterimages consist of tiny squares of color information referred to aspixels that form points of color to create a complete image. Plotsthat contain raster images render quickly in R and create small,high-quality exported image files in a wide variety of formats. However, it is a knownissue that the rendering of raster images can be problematic whencreating graphics using a Remote Desktop connection. ...

FAQ

Accessing Data from Multiple Schemas using Oracle R Enterprise

The most common Oracle R Enterprise configuration is to connect directly to a database schema that contains tables you wish to analyze. However, users may...

The most common Oracle R Enterprise configuration is to connect directly to a database schema that contains tables you wish to analyze. However, users may occasionally need to access tables that exist in other schemas. Oracle R Enterprise allows several options when accessing tables from another schema is desired. Database tables and views are currently supported, and these form the basis for our recommendations. Named Schema AccessIf you have SELECT TABLE or SELECT ANY TABLE...

FAQ

HOWTO: X11 Forwarding for Oracle R Enterprise

Oracle R Enterprise enables users to generate R graphs at the database server and return them in a variety of ways: an XML representation using base 64 encoding...

Oracle R Enterprise enables users to generate R graphs at the database server and return them in a variety of ways: an XML representation using base 64 encoding of the PNG images, in a table with a BLOB column containing the PNG images, and interactively returning the actual image to the R user at the client. This last case allows users to generate images at the database server machine and have the actual PNG image display at the user’s client R engine.To take advantage of...

Oracle

Integrated Cloud Applications & Platform Services