1. Machine Learning for SQL Use Cases
  2. Concepts
  3. Machine Learning Algorithms
  4. Oracle Machine Learning for SQL with R Extensibility

Oracle Machine Learning for SQL with R Extensibility

Learn how you can use Oracle Machine Learning for SQL to build, score, and view OML4SQL models as well as R models.

The Oracle Machine Learning for SQL framework is enhanced extending the Oracle Machine Learning for SQL algorithm set with algorithms from the open source R ecosystem. Oracle Machine Learning for SQL is implemented in the Oracle Database kernel. The Oracle Machine Learning for SQL models are Database schema objects. With the extensibility enhancement, the Oracle Machine Learning for SQL framework can build, score, and view both Oracle Machine Learning for SQL models and R models.

Registration of R scripts

The R engine on the database server runs the R scripts to build, score, and view R models. These R scripts must be registered with the database beforehand by a privileged user with rqAdmin role. You must first install Oracle Machine Learning for R to register the R scripts.

Functions of Oracle Machine Learning for SQL with R Model

The following functions are supported for an R model:

  • Oracle Machine Learning for SQL DBMS_DATA_MINING package is enhanced to support R model. For example, CREATE_MODEL and DROP_MODEL.

  • MODEL VIEW to get the R model details about a single model and a partitioned model.

  • Oracle Machine Learning for SQL SQL functions are enhanced to operate with the R model functions. For example, PREDICTION and CLUSTER_ID.

R model extensibility supports the following Oracle Machine Learning for SQL functions:

  • Association

  • Attribute Importance

  • Regression

  • Classification

  • Clustering

  • Feature Extraction