Changes in This Release for This Guide

The following changes apply to property graph support that is shipped with Oracle Graph Server and Client.

Oracle Graph Server and Client is required for using the property graph feature of Oracle Database (see Oracle Graph Server and Client Installation), and is released four times a year.

New Features in Oracle Graph Server and Client 24.1

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

• Added support for the new Graph Server Administrator Dashboard to monitor and manage the graph server (PGX) memory usage.

  See Using the Graph Server Administrator Dashboard for more information.

• Added support for querying graphs in the graph server (PGX) using the PGX JDBC driver.

  See the following topics for more information:

  • Executing PGQL Queries Using the PGX JDBC Driver
  • Using the PGX JDBC Driver when Graph Server (PGX) is Utilized as a Library
• Added GPU support to the Pgx.ML library to run the trainings magnitudes faster than on CPU.

  See the following topics for more information:

  • Building a Customized Supervised GraphWise Model
  • Building a Customized Supervised EdgeWise Model
  • Building a Customized Unsupervised GraphWise Model
  • Building a Customized Unsupervised EdgeWise Model
  • Advanced Hyperparameter Customization
• Added support to check the real-time on-heap memory usage using the max_on_heap_memory_usage_ratio field in the graph server (PGX) configuration file.

  See Configuring On-Heap Limits for more information.

• Added support for setting label of providers, selecting key column for edge providers, and specifying ID strategy when creating a graph from frames.

  See Creating a Graph from Multiple PgxFrame Objects for an example.

• When using the enterprise scheduler, if the graph server (PGX) fails to start with the following error message in the log file - The enterprise scheduler backend is not supported on this system, then note that the server no longer falls back to the basic scheduler.

  See Prerequisites for Using the Enterprise Scheduler to ensure that you meet all the requirements for using the enterprise scheduler.

• Added support for configuring the degree of parallel hints in Flashback Synchronizer queries.

  See Synchronizing a PGQL Property Graph for an example.

• Added support for the unnesting of paths using the ONE ROW PER STEP clause in the GRAPH_TABLE operator when running PGQL queries on PGQL property graphs in the database.

  See Supported PGQL Features for an example.

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 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.

• Deprecated Features
  Review the deprecated features in Oracle Graph Server and Client.
• Desupported Features
  Review the desupported features in Oracle Graph Server and Client.