New Features in Oracle Graph Server and Client 24.3

Features That Work With Oracle Database Release 23ai and Prior Oracle Database Releases

• Added support for lazy loading of property graphs into the graph server (PGX).

  See Enabling Lazy Loading of Graphs for more information.

• Added setSessionIdleTimeout API to allow updating the session idle timeout after session creation.

  See Updating Session Idle Timeout for more information.

• Added the following new built-in graph algorithms:
  • Filtered Version of Speaker Listener: This graph algorithm is designed to detect overlapping communities. The filtered version employs an EdgeFilter to consider only edges that meet the filter criteria during the listening phase.
  • Filtered Weighted Version of Speaker Listener: The weighted filtered version combines both the weighted and filtered approaches, taking into account both edge filters and edge weights. Only edges with weights greater than the specified input weight will be considered.
• Progress tracking support for graph algorithms is extended to include more built-in graph algorithms.

  See Getting the Progress of a Running Algorithm for the list of supported built-in graph algorithms.

• Added support for a new Graph Visualization application which can be accessed from https://<server_host>:7007/dash/. The redesigned user interface of the Graph Visualization application provides a new look and feel, enhancing user experience in creating and visualizing graphs.

  See the following topics for more information:

  • Running the Graph Visualization Web Client
  • Using the Graph Visualization Application
• Added support for creating property graphs in the Graph Server tab of the Graph Visualization application.

  See Visualizing PGQL Queries on Graphs Loaded Into the Graph Server (PGX) for more information.

• Added support for loading property graphs from the database into the graph server memory using the Load graph into memory button in the Graph Server tab of the Graph Visualization application.

  See Loading a Database Property Graph into the Graph Server (PGX) Memory for more information.

• Added support for Oracle JDK 21 for Oracle Graph Server and Client installation.

Feature That Works Only With Oracle Database Release 23ai

• Added PGQL support for migrating PGQL property graphs to SQL property graphs by calling the migrate_pgql_to_sql() function.

  See Migrating PGQL Property Graphs to SQL Property Graphs for more information.

Key Property Graph Features in Oracle Database Release 23ai

• Support for creating SQL property graph objects in Oracle Database.

  See Introduction to SQL Property Graphs for more information.

• Support for running graph queries on SQL property graphs.

  See SQL Graph Queries for more information.

• Support for using aggregate functions in SQL graph queries.

  See Using Aggregate Functions in SQL Graph Queries for more information.

• Support for loading SQL property graphs into the graph server (PGX).

  See Loading a SQL Property Graph Using the readGraphByName API for more information.

• Support for loading a subgraph from a SQL property graph into the graph server (PGX).

  See Loading a Subgraph Using PGQL Queries for more information.

• Support for dynamically expanding a subgraph in the graph server (PGX).

  See Expanding a Subgraph for more information.

• Support for running PGQL SELECT queries against SQL property graphs.

  See Executing PGQL Queries Against SQL Property Graphs for more information.

• Support for selecting all the vertex or edge properties in the COLUMNS clause of a SQL graph query.

  See Selecting All Properties in the COLUMNS Clause for more information.

• Support for determining the direction of edges using the SOURCE and DESTINATION predicates inside the WHERE or COLUMNS clause of a SQL graph query.

  See Using the SOURCE and DESTINATION Predicates for more information.

• Support for visualizing SQL graph queries on graphs in the database using the Graph Visualization application.

  See Visualizing Graph Queries on SQL Property Graphs for more information.

• Support for visualizing SQL graph queries using the APEX Graph Visualization plug-in in APEX applications.

  See Visualizing SQL Graph Queries Using the APEX Graph Visualization Plug-in for more information.