Upgrade to Pro — share decks privately, control downloads, hide ads and more …

OML feature highlight: New OML Notebook templates for ML Clustering

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.

Marcos Arancibia

January 11, 2022
Tweet

More Decks by Marcos Arancibia

Other Decks in Technology

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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

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

    View Slide

  13. There are 5 Clustering Demos that are specific to certain algorithms

    View Slide

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

    View Slide

  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

    View Slide

  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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide