Access OML Notebooks

To perform Oracle Machine Learning tasks, you can access Oracle Machine Learning Notebooks from Autonomous Database

Access Oracle Machine Learning User Interface

You can access Oracle Machine Learning User Interface from Autonomous AI Database.

To access Oracle Machine Learning User Interface (UI) from Autonomous AI Database:

  1. Select your Oracle Autonomous AI Database instance and on the Autonomous AI Database details page click Database Actions.
  2. On the Database Actions page, go to the Development section and click Oracle Machine Learning. The Oracle Machine Learning sign in page opens.

    Figure 2-2 Oracle Machine Learning option on Database Actions - Development tab


    Description of Figure 2-2 follows
    Description of "Figure 2-2 Oracle Machine Learning option on Database Actions - Development tab"

  3. On the Oracle Machine Learning sign in page, enter your username and password.
  4. Click Sign In.

This opens the Oracle Machine Learning user application.

Create a Notebook Classic

A Notebook Classic is a web-based interface for data analysis, data discovery, data visualization and collaboration.

Whenever you create a Notebook Classic, it has an interpreter settings specification. The Notebook Classic contains an internal list of bindings that determines the order of the interpreter bindings. A Notebook Classic comprises paragraphs which is a notebook component where you can write SQL statements, run PL/SQL scripts, and run Python commands. A paragraph has an input section and an output section. In the input section, specify the interpreter to run along with the text. This information is sent to the interpreter to be executed. In the output section, the results of the interpreter are provided.
To create a Notebook Classic:
  1. On the Oracle Machine Learning UI home page, click Notebooks Classic. The Notebooks Classic page opens.
  2. On the Notebooks Classic page, click Create.
    The Create Notebook window appears.
  3. In the Name field, provide a name for the notebook.
  4. In the Comments field, enter comments, if any.
  5. Click OK.
Your Notebook Classic is created and it opens in the notebook editor. You can now use it to run SQL statements, run PL/SQL scripts, run Python, R and Conda commands. To do so, specify any one of the following directives in the input section of the paragraph:
  • %sql — To connect to the SQL interpreter and run SQL statements
  • %script — To connect to the PL/SQL interpreter and run PL/SQL scripts
  • %md — To connect to the Markdown interpreter and generate static html from Markdown plain text
  • %python — To connect to the Python interpreter and run Python scripts
  • %r — To connect to the R interpreter and run R scripts.
  • %conda — To connect to the Conda interpreter, and install third-party Python and R libraries inside a notebook session.

Edit Your Notebook Classic

Upon creating an OML Notebook Classic, it opens automatically, presenting you with a single paragraph using the default %sql interpreter. You can change the interpreter by explicitly specifying one of %script, %python, %sql , %r , %md or %conda.

Set the context with a project with which your notebook is associated.
You can edit an existing Notebook Classic in your project. To edit an existing Notebook Classic:
  1. On Oracle Machine Learning UI home page, select the project in which your notebook is available.
  2. Go to the Oracle Machine Learning UI navigator, and select Notebooks Classic. All notebooks that are available in the project are listed.
  3. Click the notebook that you want to open and edit.
    The selected notebook opens in edit mode.
  4. In the edit mode, you can use the Oracle Machine Learning Notebooks Classic toolbar options to run code in paragraphs, for configuration settings, and display options.

    Figure 2-3 Notebook toolbar

    Notebooks Classic toolbar
    You can perform the following tasks:
    • Write code to fetch data
    • Click run to run one or all paragraphs in the notebook.
    • Click show hide code to hide all codes from all the paragraphs in the notebook. Click it again to display the codes.
    • Click show hide output to hide all outputs from all the paragraphs in the notebook. Click it again to view the outputs.
    • Click clear output to remove all outputs from all the paragraphs in the notebook. To view the output, click the run icon again.
    • Click clear notebook to delete all the paragraphs in the notebook.
    • Click export notebookto export the notebook.
    • Click search code to search any information in the codes present in the notebook.
    • Click keyboard shortcuts to view the list of keyboard shortcuts.
    • Click interpreter bindings to set the order for interpreter bindings for the notebook.
    • Click notebook display options to select one of the three notebook display options.
      • Click default to view the codes, output, and metadata in all paragraphs in the notebook.
      • Click Simple to view only the code and output in all paragraphs in the notebook. In this view, the notebook toolbar and all edit options are hidden. You must hover your mouse to view the edit options.
      • Click Report to view only the output in all paragraphs in the notebook.
    • Click edit options to access paragraph specific edit options such as clear output, remove paragraph, adjust width, font size, run all paragraphs above or below the selected paragraph and so on.
    • Add dynamic forms such as the Text Input form, Select form, Check box form for easy selection of inputs and easy filtering of data in your notebook. Oracle Machine Learning supports the following Apache Zeppelin dynamic forms:

      • Text Input form — Allows you to create a simple form for text input.

      • Select form — Allows you to create a form containing a range of values that the user can select.

      • Check Box form — Allows you to insert check boxes for multiple selection of inputs.

    Note:

    The Apache Zeppelin dynamic forms are supported only on SQL interpreter notebooks.
  5. Once you have finished editing the notebook, click Back.
    This takes you back to the Notebooks Classic page.