Manage Property Graphs

You can load a property graph into memory, share, edit, rename, delete or preview a graph.

To manage property graphs:
  1. Click Graphs on the left navigation menu and navigate to the Graphs page.
  2. Select the Property Graph tab.
    You can see a list of property graphs for which you have access in the Autonomous Database as shown in the following figure.

    Description of list_graphs.png follows
    Description of the illustration list_graphs.png

    In the preceding figure:

    • The Type column indicates the type of the graph.

      Graph Studio supports the creation of two types of property graphs:

      • SQL Property Graph: The option to create a SQL property graph is available only if you are using an Autonomous Database instance with Oracle Database 23ai.
      • PGQL Property Graph: The option to create a PGQL property graph is available on all types of tenancies and supported on all database versions.
    • The In Memory column indicates the property graphs that are loaded into memory. You must ensure that a graph is fully loaded into memory before accessing it, as the notebook interpreters operate only on the in-memory graphs. See Available Notebook Interpreters for more information on notebook interpreters.
  3. Select any property graph.
    The details of the graph are displayed in the graph details section of the Graphs page.

    Note that this section also displays the previously computed Estimated In-Memory Graph Size.

  4. Optionally, click to perform any one of the following actions on the property graph:
    Action Description
    re-compute_metadata_icon To recompute the graph metadata to refresh metadata information about the graph which might have become stale, like the total number of vertices and edges. This action also recomputes and updates the Estimated In-Memory Graph Size.
    rename_icon To rename the graph.
    edit_graph_icon To edit the graph.
    share_graph_icon To share the graph with other users.
    load_inmemory_icon To load the graph into memory for analysis.

    Note:

    Optionally, you can load a PGQL Property Graph by name directly in the notebook. See Load Graphs into Memory Programmatically for an example.

    When you click the Load Graph Into Memory icon, the following slider is displayed:

    Description of load_graph_into_memory.png follows
    Description of the illustration load_graph_into_memory.png

    You can switch on the Ignore Invaild Edges Errors toggle to ignore all edges with missing source or destination vertices. It is only then the graph gets successfully loaded into memory. Otherwise, the Loading Graph Into Memory job fails with an error.

    delete_graph_icon To delete the graph.
    convert_to_sql_graph To convert a PGQL property graph into SQL graph.

    Note that this option is supported only if you are using an Autonomous Database instance with Oracle Database 23ai. Also, this action is available only for PGQL property graphs. See Convert a PGQL Property Graph to SQL Property Graph for more information.

    This executes the desired action on the property graph.