Using the Graph Visualization Application

21 Using the Graph Visualization Application

The Graph Visualization application is based on the graph visualization library. Using this interface, you can run PGQL queries on graphs in the graph server (PGX) and database.

21.1 Visualizing PGQL Queries on Graphs Loaded Into the Graph Server (PGX)

You can create or load a graph into the graph server (PGX), and then run PGQL graph queries in the Graph Server tab of the Graph Visualization application.

The following sections describe in detail the various actions that you can perform in the Graph Server tab.

Creating a Property Graph in the Graph Server (PGX)

You can run the CREATE PROPERTY GRAPH PGQL statement to create a graph in the graph server (PGX). For example:

Figure 21-3 Creating a Property Graph in the Graph Server Memory

Description of "Figure 21-3 Creating a Property Graph in the Graph Server Memory"

The graph gets created and loaded into the graph server memory (PGX). Note that this is a transient graph which will be destroyed at the end of the session.

You can click the Get Graphs List icon (shown highlighted in the preceding figure) to view all the graphs that are loaded into the graph server memory.

Loading a Database Property Graph into the Graph Server (PGX) Memory

You can also load any existing PGQL or SQL property graph from the database into the graph server (PGX) memory by performing the following steps:

Click the Load graph into memory icon in the GraphServer tab.
The list of database graphs to which you have access are displayed as shown:

Figure 21-4 List of Database Graphs

Description of "Figure 21-4 List of Database Graphs"

Note that the SQL property graphs get listed only if you are connected to Oracle Database 23ai.
Click Load graph against the desired graph.
The confirmation dialog for loading the graph into memory opens.

Figure 21-5 Loading Graph Into Memory Confirmation

Description of "Figure 21-5 Loading Graph Into Memory Confirmation"
Optionally, click to expand the Advanced Options configuration.
The following advanced options can be configured:
- Ignore Invalid Edges Errors: Switch ON this toggle to ignore all edges that do not connect to a vertex.
- Synchronizable: Switch ON this toggle to verify that the graph can be synchronized.
- Optimized For: Select one of the following graph optimization strategies:
  - READ: To optimize for read-intensive scenarios.
  - UPDATE: To optimize for update-intensive scenarios.
- Parallelism: To specify the degree of parallelism.
Click Load graph into memory.
The In Progress status against the graph indicates that the graph loading process is initiated and once the graph is successfully loaded into memory, the status gets updated to Memory.
Click Close and click the Get Graphs List icon to verify that the graph is loaded into memory.

Running PGQL queries on the graph

You can enter a PGQL query on the desired graph and click Run Query to execute the query. On successful execution, the graph visualization result (including nodes and their connections) is displayed in the bottom panel. You can right-click a node or connection to display tooltip information, and you can drag the nodes around.

The following figure shows a sample query visualization identifying all edges that are directed edges from any vertex in the graph to any other vertex.

Figure 21-6 Visualizing a PGQL Query

Description of "Figure 21-6 Visualizing a PGQL Query"

Parent topic: Using the Graph Visualization Application

21.2 Visualizing PGQL Queries on PGQL Property Graphs

You can visualize PGQL queries on PGQL property graphs in the database in the Database (PGQL Property Graphs) tab of the Graph Visualization application.

You can create, query, modify and visualize PGQL property graphs in the database using the Graph Visualization application. The following PGQL operations are supported:

CREATE PROPERTY GRAPH: To create a new PGQL property graph as shown:

Figure 21-7 Creating a PGQL property graph

Description of "Figure 21-7 Creating a PGQL property graph"
INSERT, UPDATE and DELETE: To modify an existing PGQL property graph. For example:

Figure 21-8 Updating an Edge in a PGQL property graph

Description of "Figure 21-8 Updating an Edge in a PGQL property graph"

Note that you must provide the graph name in the PGQL query. You can click the List of available graphs icon to view the list of PGQL property graphs to which you have access.

Figure 21-9 Deleting an Edge in a PGQL property graph

Description of "Figure 21-9 Deleting an Edge in a PGQL property graph"
SELECT: To query a PGQL property graph as shown:

Figure 21-10 Querying a PGQL property graph

Description of "Figure 21-10 Querying a PGQL property graph"
DROP PROPERTY GRAPH: To delete a PGQL property graph as shown:

Figure 21-11 Dropping a PGQL property graph

Description of "Figure 21-11 Dropping a PGQL property graph"

Parent topic: Using the Graph Visualization Application

21.3 Visualizing Graph Queries on SQL Property Graphs

You can query and visualize a SQL property graph in the database in the Database (SQL Property Graphs) tab of the Graph Visualization application.

However, in order to visualize the vertices and edges of a GRAPH_TABLE query together with their IDs and all their labels and properties, the query must return the vertex ID, or edge ID, or both.

For example, the following figure shows the visualization of a SQL GRAPH_TABLE query on a SQL property graph. Note that the COLUMNS clause in the query uses the VERTEX_ID and EDGE_ID functions.

Note:

The Graph Visualization application supports only SELECT graph queries.

Figure 21-12 Graph Query on a SQL Property Graph

Description of "Figure 21-12 Graph Query on a SQL Property Graph"

The name of the graph must be provided in the SQL graph query. You can click the List of available graphs icon (shown highlighted in the preceding figure) to view the list of SQL property graphs to which you have access.

21.4 Graph Visualization Modes and Graph Legend

Learn about the graph visualization toolbar, supported graph visualization modes and graph legend if you are viewing the results of the query in graph format.

Graph Visualization Toolbar

The graph visualization toolbar is displayed on the left of the graph visualization panel as shown:

Figure 21-13 Graph Visualization Toolbar

Description of "Figure 21-13 Graph Visualization Toolbar"

The toolbar supports the following graph visualization modes:

Move/Zoom: This mode allows you to zoom in and out, as well as to move to another part of the visualization.
Fit to Screen: This mode fits the resulting graph in the graph visualization view.
Toggles Sticky Mode: This mode allows you to cancel the action of dragging the nodes around.
Activate Network Evolution: This allows you to activate or deactivate network evolution.
Graph Manipulation: This mode allows you to interact with your graph visualization. Supported actions are:
- Drop: To remove selected vertices from the visualization. Can also be executed from the tooltip.
- Group: To group selected multiple vertices and collapse them into a single one.
- Ungroup: To select a group of collapsed vertices and ungroup them.
- Undo: To undo the last action.
- Redo: To redo the last action.
- Reset: To reset the visualization to the original state after the query.

In addition, Toggle fullscreen mode is available on the right of the graph visualization panel.

Graph Visualization Legend

The graph visualization legend appears on the right of the graph visualization panel and displays the legend items that represent the vertices and edges of the graph. For example:

Figure 21-14 Graph Legend

Description of "Figure 21-14 Graph Legend"

Parent topic: Using the Graph Visualization Application

21.5 Graph Visualization Settings

You can click the Settings gear icon to open the Graph Visualization settings window.

The Visualization settings window comprises the General, Graph Exploration, and Styles tab.

Configuring General Settings

You can add vertex and edge captions, set the graph layout and page size in the General of the Graph Visualization settings:

Figure 21-15 General Tab Configuration

Description of "Figure 21-15 General Tab Configuration"

Vertex Caption Orientation: Determines where the selected vertex property will be displayed.
Vertex Caption: Determines the property to be displayed for a vertex.
Click + Add more to add a vertex caption and select the required vertex Label and vertex Property.
Edge Caption: Determines the property to be displayed for an edge.
Click + Add more to add an edge caption and select the required edge Label and edge Property.
Maximum Visible Caption Length: Maximum caption length before truncating.
Layout: Computes the position of the nodes and determines the visual structure of the graph.
Supported layouts are: Circle, Concentric, Force (default), Grid, Hierarchical, Preset, Radial, and Random.
Page Size: Determines the number of entries to be visualized from the result set.

Configuring Graph Exploration Settings

You can enable and configure Network Evolution in the Graph Exploration tab of the Graph Visualization settings. See Using Network Evolution in Graph Visualization for more information.

Figure 21-16 Graph Exploration Tab Configuration

Description of "Figure 21-16 Graph Exploration Tab Configuration"

Configuring Vertex and Edge Styles

You can configure and manage vertex and edge styles to customize the appearance of the vertices and edges in the graph. All the configured styles are listed in the Styles tab of the Graph Visualization settings.

Figure 21-17 Vertex and Edge Styles Configuration

Description of "Figure 21-17 Vertex and Edge Styles Configuration"

To add a new vertex or edge style, click New vertex style or New edge style as appropriate and configure the following values:

Name: Name of the style
Conditions: Click + to add a condition for an element (vertex or edge) and provide the following values:
- Property of the vertex or edge element.
- Operator to be applied. The following operators are supported:
  - = (equal to)
  - < (less than)
  - <= (less than or equal to)
  - > (greater than)
  - >= (greater than or equal to)
  - != (not equal to)
  - ~ (filter is a regular expression)
  - * (any: like a wildcard, can match to anything)
- Value that needs to be fulfilled for the property and the operator
You can add as many conditions as required. For all elements that meet the conditions, you can configure any of the following styling highlights:
- Size: Size of the vertex or edge
- Color: Color of the vertex or edge
- Icon: Image for the vertex (does not apply for edges)
- Label: Label for the vertex or edge
- Animations: Animation (Pulsating or Flashing) and duration of the animation cycle

The following example shows a sample vertex style configuration.

Figure 21-18 Adding a Vertex Style

Description of "Figure 21-18 Adding a Vertex Style"

Parent topic: Using the Graph Visualization Application

21.6 Using Network Evolution in Graph Visualization

You can visualize the evolution of a graph over time using the Network Evolution feature in the Graph Visualization application.

In order to visualize a dynamic graph, it is important that the graph contains date or time properties. It can either be a vertex or an edge property.

Perform the following steps for configuring network evolution:

Click Settings in the graph visualization panel to open the graph Visualization settings.
Click the Graph Exploration tab.
Switch on the Enable Network Evolution toggle.
Select a graph element from the Based On drop-down list.

You can configure the network evolution to be based on vertices, or edges, or both.
Depending on your selection, you must select one or more of the following properties:
- Vertex Start Property: Select the name of the property to use for the vertex filtering.
  The time frame for the graph will be after the Vertex Start Property.
- Vertex End Property: Optionally, select the name of the property to use for the vertex filtering.
  The time frame for the graph will be before the Vertex End Property.
- Edge Start Property: Select the name of the property to use for the edge filtering.
  The time frame for the graph will be after the Edge Start Property.
- Edge End Property: Optionally, select the name of the property to use for the edge filtering.
  The time frame for the graph will be before the Edge End Property.
Select the data type from the Property Type drop-down list.

Supported property type values are Integer and Date.
Optionally, select the Unit of time for the increment and the Date Format if the Property Type is Date.
Optionally, enable Advanced Settings if you want to explore advanced network evolution features and select one or more of the following options:
- Height: Select a value to specify the height of the network evolution chart.
- Chart Type: Select the type of the chart to be used to show the network evolution.
- Granularity: Specify the aggregation granularity for the input unit.
- Exclude Values: Specify one or more values to be excluded.
- Playback Step: Specify a value to determine how often does the playback advance in ms.
- Playback Timeout: Specify a value to determine how many steps are taken per time out during playback.
Close the Settings dialog.
The chart displaying the evolution of the graph data gets displayed at the bottom of the graph visualization. You can view the graph animation by clicking the Play Network Evolution button. The animation shows the changes in the graph network over time.

The following figure shows an example for network evolution of graph data using line chart in the graph visualization panel:

Figure 21-19 Dynamic Graph Visualization

Description of "Figure 21-19 Dynamic Graph Visualization"

Also, you can activate and deactivate network evolution by clicking the Activate Network Evolution icon which is show highlighted in the preceding figure.

Parent topic: Using the Graph Visualization Application