Slide 1

Slide 1 text

OML feature highlight: New OML Notebook templates for ML Clustering OML Office Hours Marcos Arancibia, Senior Principal Product Manager, Machine Learning Sherry LaMonica, Consulting Member of Technical Staff Supported by Mark Hornick Senior Director, Product Management, Data Science and Machine Learning Move the Algorithms; Not the Data! Copyright © 2022, Oracle and/or its affiliates. This Session will be Recorded

Slide 2

Slide 2 text

• Upcoming Sessions • Oracle Data Miner UI now supported on Autonomous Database • Follow-along OML Notebooks ML Clustering demo • Q&A Topics for today Copyright © 2022, Oracle and/or its affiliates 2

Slide 3

Slide 3 text

We will begin a Series of Follow-along reviews of the Example Template notebooks every week, with one subject per week. These will be Hands-on if you have access to any Autonomous Database, even the Always-Free one. • Classification - done • Regression - done • Clustering • Feature Extraction I – Dimensionality Reduction • Feature Extraction II - Explicit Semantic Analysis • Time Series Upcoming Sessions Copyright © 2022, Oracle and/or its affiliates 3

Slide 4

Slide 4 text

• Plus a Hands-on Lab Session on OML4Py in Portuguese to be scheduled on February 11, 2022 at 8AM Pacific, 11Am Eastern, 1PM Brazil time. Upcoming Sessions Copyright © 2022, Oracle and/or its affiliates 4

Slide 5

Slide 5 text

Copyright © 2022, Oracle and/or its affiliates 5 Oracle Data Miner for Autonomous Database How to setup the ODMr Repository

Slide 6

Slide 6 text

New support for Autonomous Database • Introduced in SQL Developer 21.4 • No-code user interface • Analytical workflows for machine learning • Wide range of machine learning algorithms • Leverages the database to maximize workload scalability and performance Oracle Data Miner Copyright © 2022, Oracle and/or its affiliates 6

Slide 7

Slide 7 text

ADB Wallet with ADMIN user and service level low • Obtain the Oracle Wallet zip file from the Autonomous Database UI (or request from ADMIN) – Password-protected container for storing database credentials – Avoids exposing user credentials in clear text • Connect to Autonomous Database – ADMIN user – Connection Type Cloud Wallet – Service level low (important!) Connecting to Autonomous Database Copyright © 2022, Oracle and/or its affiliates 7

Slide 8

Slide 8 text

Run the installodmr.sql script as ADMIN user • Input parameters – The script contains two inputs, the user and temporary tablespaces. – The default tablespaces in Autonomous Database are DATA and TEMP. • Use the "double at" @@ symbol to run the installodmr.sql script from the SQL Developer home directory, sqldeveloper\dataminer\scripts • Alternatively, use a single @ symbol and specify the full path to the script. Install the Oracle Data Miner Repository Copyright © 2022, Oracle and/or its affiliates 8 …\sqldeveloper\dataminer\scripts\installodmr.sql DATA TEMP

Slide 9

Slide 9 text

Run the usergrants.sql as ADMIN for existing users Configure an Existing Oracle Data Miner User Copyright © 2022, Oracle and/or its affiliates 9 • Input parameters – The script contains one input, the existing ADB user • Use the "double at" @@ symbol to run the usergrants.sql script from the SQL Developer home directory, sqldeveloper\dataminer\scripts • Alternatively, use a single @ symbol and specify the full path to the script. • The user is granted access to all objects through ODMRUSER role. …\sqldeveloper\dataminer\scripts\usergrants.sql USERNAME

Slide 10

Slide 10 text

Run the createuser.sql as ADMIN user for new users • Input parameters – The script contains one input, the existing ADB user • Use the "double at" @@ symbol to run the createuser.sql script from the SQL Developer home directory, sqldeveloper\dataminer\scripts • Alternatively, use a single @ symbol and specify the full path to the script, as shown here. • The user is created and required grants are applied through ODMRUSER role. Configure a New Oracle Data Miner User Copyright © 2022, Oracle and/or its affiliates 10 …\sqldeveloper\dataminer\scripts\createuser.sql USERNAME PASSWORD

Slide 11

Slide 11 text

Oracle Data Miner Resources Oracle Data Miner on O.com: https://www.oracle.com/database/technologies /datawarehouse-bigdata/dataminer.html Oracle Data Miner Examples on Github: https://github.com/oracle/oracle-db- examples/tree/master/machine-learning/odmr Blog: Oracle Data Mining in ADB: https://blogs.oracle.com/machinelearning/post /oracle-data-miner-now-available-for- autonomous-database Helpful Links Copyright © 2022, Oracle and/or its affiliates 11

Slide 12

Slide 12 text

OML feature highlight: New OML Notebook templates for ML Clustering OML Office Hours Marcos Arancibia Senior Principal Product Manager, Machine Learning

Slide 13

Slide 13 text

There are 5 Clustering Demos that are specific to certain algorithms

Slide 14

Slide 14 text

Two options to access the Template Examples Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 14

Slide 15

Slide 15 text

Select one of the Examples to create your own notebook Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 15 1. Type "clus" in the Search Filter 2. Click on the "Lip" around the Template or on the light grey area. Note: Do NOT click its name, since it opens it as read-only

Slide 16

Slide 16 text

Click Create Notebook to create a copy for yourself Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 16 Click on "Create Notebook" Give it a name Click OK

Slide 17

Slide 17 text

The new notebook will show up in the notebooks listing. Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 17

Slide 18

Slide 18 text

Q & A Copyright © 2022, Oracle and/or its affiliates 18

Slide 19

Slide 19 text

Copyright © 2022, Oracle and/or its affiliates. 19 Thank you