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

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

• Added support to track the progress of the running graph algorithms in the graph server (PGX).

  See the following topics for more information:

  • Getting the Progress of a Running Algorithm
  • Tracking the Progress of a Running Custom PGX Graph Algorithm
• Added graph server (PGX) support for the following new built-in algorithms:
  • Harmonic Centrality: An alternative to closeness centrality algorithm that evaluates centrality by considering reciprocal sums of shortest path distances.
  • Article Rank: This is a variant of Pagerank. Page Rank follows the assumption that relationships originating from low-degree nodes have a higher influence than relationships from high-degree nodes. Article Rank lowers the influence of low-degree nodes.
  • Weighted Version of Speaker Listener: An example use case for this algorithm is to identify communities who share similar interests in social networks.
• Added PgxML support to monitor the training process which allows you to review how the loss and accuracy are improved during the training process. It also helps you determine how many training steps are needed in order to get to a desired accuracy on a validation data set.

  See the following for more information:

  • Training a Supervised GraphWise Model and Getting the Training Log for a Supervised GraphWise Model
  • Training a Supervised EdgeWise Model and Getting the Training Log for a Supervised EdgeWise Model
  • Training an Unsupervised GraphWise Model and Getting the Training Log for an Unsupervised GraphWise Model
  • Training an Unsupervised EdgeWise Model and Getting the Training Log for an Unsupervised EdgeWise Model
• Added support to create PGQL property graphs with arbitrary property expressions.

  See Creating a PGQL Property Graph with Arbitrary Property Expressions for more information.

• Added PGQL support for LATERAL subqueries after MATCH clause and other LATERAL subqueries.

  See Support for PGQL Lateral Subqueries for more information.

• Upgraded Logback to 1.3.x version and this requires the date pattern in the Logback configuration files to be provided as a string parameter. Therefore, if you are using a custom logback-server.xml or logback.xml file, then ensure to apply the required date pattern changes. The following describes the date pattern parameter for the old and new versions:
  • Old Version: This version is no longer supported.

    <encoder>
        <pattern>%d{HH:mm:ss,SSS} [%t] %p %C{1} - %m%n</pattern> <- Old version (throws error after upgrade)
    </encoder>

    The preceding version will throw Unknown time-zone ID: SSS error.

  • New Version: The supported date pattern is as shown:

    <encoder>
        <pattern>%d{'HH:mm:ss,SSS'} [%t] %p %C{1} - %m%n</pattern> <- New version (no errors thrown)
    </encoder>

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

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