Oracle 19c New Features: Support for Machine Learning

Oracle Database 19c is the latest version of Oracle’s flagship database product. It introduces a number of new features and enhancements, including support for machine learning.

Machine learning is a powerful technology that can be used to automate tasks, improve decision-making, and discover new insights from data. Oracle Database 19c makes it easy to use machine learning with a number of new features, including:

Machine learning algorithms: Oracle Database 19c includes a number of machine learning algorithms that can be used to solve a variety of problems, including classification, regression, and clustering.
Machine learning functions: Oracle Database 19c includes a number of machine learning functions that can be used to build and train machine learning models.
Machine learning APIs: Oracle Database 19c exposes a number of machine learning APIs that can be used to interact with machine learning models.

The support for machine learning in Oracle Database 19c makes it a powerful platform for data scientists and other users who want to use machine learning to solve business problems.

Benefits of Machine Learning

There are a number of benefits to using machine learning, including:

Automate tasks: Machine learning can be used to automate tasks that would otherwise be done manually. This can save time and improve efficiency.
Improve decision-making: Machine learning can be used to improve decision-making by providing insights from data that would not be visible to humans.
Discover new insights: Machine learning can be used to discover new insights from data that would not be possible to find manually.

How to Use Machine Learning in Oracle Database 19c

To use machine learning in Oracle Database 19c, you need to create a machine learning model. You can do this by using the CREATE MODEL statement. Once you have created a machine learning model, you can use it to make predictions or other inferences.

Here is an example of how to create a machine learning model:

SQL

CREATE MODEL orders_classification
USING ALGORITHM 'classification'
DATA (customer_id, product_id, quantity, order_date)
TARGET (order_status);

In this example, we are creating a machine learning model called orders_classification. The model will use the customer_id, product_id, quantity, and order_date columns to predict the order_status column.

Once you have created a machine learning model, you can use it to make predictions. You can do this by using the PREDICT statement.

Here is an example of how to make a prediction using a machine learning model:

SQL

DECLARE
    customer_id NUMBER := 1000;
    product_id NUMBER := 1001;
    quantity NUMBER := 1;
    order_date DATE := SYSDATE;
    
    order_status VARCHAR2 (10);
BEGIN
    SELECT PREDICT (orders_classification, customer_id, product_id, quantity, order_date)
    INTO order_status
    FROM dual;
    
    DBMS_OUTPUT.PUT_LINE ('The predicted order status is: ' || order_status);
END;
/

In this example, we are predicting the order status for a customer with the customer_id of 1000 and the product_id of 1001. The predicted order status is pending.

DataBaseGuru