Using R with Oracle Database Setting Up Your Working Environment Before you can start using Oracle R Also, to follow along with the article examples, you will need a SQL tool to interact with your Oracle database, such as Oracle SQL Developer or Oracle SQL Plus. Deploying R Scripts to Oracle Database Using the following code, you store an R...

By Yuli Vasiliev Before you can start using Oracle R technologies, you need to install the software components enabling them. In particular, you will need to install: Oracle R Distribution and Oracle R Enterprise. The latter in turn consists of two components: a server and a client. The server is installed on the machine running the Oracle Database server that...

By Yuli Vasiliev Oracle R Technologies provides a comprehensive platform for data analysts and data scientists, making it easy to perform statistical data analysis and generate advanced graphics. If you are using an Oracle database to store your data and are interested in advanced analytics, then employing Oracle R Technologies should be your natural choice. The key component of Oracle...

By Yuli Vasiliev Oracle R Enterprise comes with the packages that include functions for building and scoring regression models, neural network models, and Oracle Data Mining models. Regardless of the package they belong, all those functions have a similar syntax, requiring you to write just a couple lines of R code to build a model and then score it on...

By Yuli Vasiliev One of the most important features Oracle R Enterprise offers is the ability to store R scripts in the database and then invoke them through either an R interface or a SQL interface. The latter becomes especially important when it comes to the production stage, since SQL remains the primary interface in production database applications. This article...

By Yuli Vasiliev Oracle R technologies bring R, an open source statistical programming language and software environment, into an Oracle Database engine, allowing for better scalability, performance, and production deployment. Through this integration, data analysts can leverage the database computing environment for sophisticated data analysis, without having to move data to separate analytic servers. Before you can start testing Oracle...

By Yuli Vasiliev Starting with Oracle Database 12c Release 2, PL/SQL supports JSON, thus enabling programmatic access to JSON data within the database. In particular, SQL/JSON functions and conditions, such as json_object, json_query, and json_exists have been included to PL/SQL as built-in functions. Also, you can take advantage of the PL/SQL object types for JSON, such as JSON_ELEMENT_T, JSON_OBJECT_T, and...

By Yuli Vasiliev In R, the issue of efficient data access becomes extremely important as data volumes to be processed increase, largely due to the fact that R loads an entire data set into memory at once. So, working in Big Data environments on large data sets requires a smart approach to make your work efficient. When using Oracle R...

Building Machine Learning Models With Oracle R Enterprise 1.5 By Yuli Vasiliev Oracle R Enterprise 1.5 came with multiple enhancements and new features, including: new parallel algorithms, improved datastore and R script repository management, performance and capability enhancements. Whether you are a machine learning practitioner or a data analyst specializing in another field of data science, you may find these...