OML feature highlight: New OML Notebook templates for ML Clustering

In this weekly Office Hours for Oracle Machine Learning on Autonomous Database, where introduced the latest Notebook templates for Machine Learning Clustering problems. This was a follow-along Session, since the OML Notebook templates are available to any Autonomous Database tenancy, and people were able to run it while we demonstrated it.

We also discussed the Oracle Data Miner setup and connectivity from SQL Developer Desktop, which is now compatible with Autonomous Database.

The Oracle Machine Learning product family supports data scientists, analysts, developers, and IT to achieve data science project goals faster while taking full advantage of the Oracle platform.

Oracle Machine Learning Notebooks offers an easy-to-use, interactive, multi-user, collaborative interface based on Apache Zeppelin notebook technology, and supports SQL, PL/SQL, Python and Markdown interpreters. It is available on all Autonomous Database versions and tiers, including Always-Free.

Oracle Machine Learning for Python includes AutoML, which provides automated machine learning features for algorithm selection, feature selection, and model tuning for in-database algorithms. In addition, Oracle Machine Learning AutoML UI provides a no-code user interface for the modeling process to enhance data scientist productivity while empowering non-experts with in-database machine learning. OML AutoML UI is exclusive to the Autonomous Database.

OML Services, which is also included with Autonomous Database provides a REST interface for model deployment and management. OML Services supports in-database models as well as ONNX-format models (for classification, regression and clustering) built using third-party engines. OML Services also supports cognitive text analytics in English, French, Spanish and Italian.

Transcript

1. 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
2. • 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
3. 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
4. • 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
5. Copyright © 2022, Oracle and/or its affiliates 5 Oracle Data Miner for Autonomous Database How to setup the ODMr Repository
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. OML feature highlight: New OML Notebook templates for ML Clustering OML Office Hours Marcos Arancibia Senior Principal Product Manager, Machine Learning
13. There are 5 Clustering Demos that are specific to certain algorithms
14. Two options to access the Template Examples Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 14
15. 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
16. 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
17. The new notebook will show up in the notebooks listing. Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 17
18. Q & A Copyright © 2022, Oracle and/or its affiliates 18
19. Copyright © 2022, Oracle and/or its affiliates. 19 Thank you