Manage Property Graphs
You can load a property graph into memory, share, edit, rename, delete or preview a graph.
- Click Graphs on the left navigation menu and navigate to the Graphs page.
- 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 the illustration list_graphs.pngIn 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.
- The Type column indicates the type of the graph.
- 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.
- Optionally, click to perform any one of the following actions on the property graph:
Action Description 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. To rename the graph. To edit the graph. To share the graph with other users. 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 the illustration load_graph_into_memory.pngYou 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.
To delete the 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.