23 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 SQL or PGQL queries on graphs in the database.

See Also:

Property Graph Visualization Developer's Guide and Reference

The Graph Visualization application is made up of the following three tabs:

• Database (SQL Property Graphs): To visualize SQL property graphs. This tab option is supported only with Oracle Database 23ai.
• Graph Server: To visualize graphs loaded into the graph server (PGX).
• Database (PGQL Property Graphs): To visualize PGQL property graphs in the database.

Each tab comprises a query editor at the top and a graph visualization panel at the bottom of the interface. The toolbar following the query editor supports the following options:

Figure 23-1 Supported Actions

Description of "Figure 23-1 Supported Actions"

• Parallelism: You can specify the degree of parallelism to be used for query operations.

  This option is not supported in Database (SQL Property Graphs) tab.

• Get graphs list: You can view the list of graphs to which you have access in a specific tab.
• Run query: To run the query entered in the query editor.

  You can choose to view the results of the graph visualization query as a graph or in tabular format using the Display graph view (default) or Display table view mode options which are displayed in the right of the graph visualization panel:

  Figure 23-2 Display Views

  
  

  
  Description of "Figure 23-2 Display Views"

  
  
• Run table-only query: To run the query entered in the query editor and view the results in tabular format only.

  If you run the query using this option, then the Display graph view mode (shown in the preceding figure) will be disabled.

• Cancel query execution: To cancel the execution of a regular or table-only query.
• Load graph into memory: This option is supported only in the Graph Server tab. See Loading or Unloading a Database Property Graph Into or From the Graph Server (PGX) Memory for more information.
• Open settings: To configuring the settings for visualizing the output. See Graph Visualization Settings for more information.

• 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.
• 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.
• 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.
• Graph Visualization Modes and Graph Legends
  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.
• Managing the Display Size of the Graph
  You can use the Display Size visualization setting to control the number of graph elements (vertices and edges) to be displayed in the Graph Visualization panel.
• Graph Visualization Settings
  You can click the Settings gear icon to open the Graph Visualization settings window.