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

Significant New Features in Oracle Graph Server and Client 23.2 That Work With Oracle Database 23ai

Oracle Graph Server and Client Release 23.2 works with the following Property Graph features of Oracle Database 23ai:

• Added support for creating SQL property graph objects in Oracle Database.

  See Introduction to SQL Property Graphs for more information.

• Added support for running graph queries on SQL property graphs.

  See SQL GRAPH_TABLE Queries for more information.

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

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

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

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

  See Expanding a Subgraph for more information.

• Added support for running PGQL SELECT queries against SQL property graphs.

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

• Added support for visualizing SQL GRAPH_TABLE queries on graphs in the database.

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

Significant New Features in Oracle Graph Server and Client 23.2 (Applies for 23ai and Prior Oracle Database Releases)

• Added support for installing the Python client from PyPI.

  See Installing the Python Client from PyPI for more information.

• Added PGQL support for traversing database graphs and also the graphs that are loaded into the graph server using path modes such as WALK, TRAIL, SIMPLE, and ACYCLIC.

  See Using Path Modes with PGQL for more information.

• Added PGQL support for running LATERAL subqueries on the graphs in the graph server (PGX).

  See Support for PGQL Lateral Subqueries for more information.

• Added PGQL support for GRAPH_TABLE expressions in the FROM clause of a PGQL query.

  See Support for PGQL GRAPH_TABLE Subquery for more information.

• Added support for configuring the maximum header size for an embedded Tomcat deployment.

  See the max_header_size field in Configuring the Graph Server (PGX) for more information.

• The OPTIONS clause is mandatory when creating any type of property graph using the CREATE PROPERTY GRAPH statement.
  • • SQL Property Graph: OPTIONS ( PG_SQL )
    • Property Graph View: OPTIONS ( PG_VIEW )
    • Graph using property graph schema objects (deprecated): OPTIONS ( PG_SCHEMA )

    If you created property graph schema graphs using the earlier releases of Oracle Graph Server and Client, then note that you must update the CREATE PROPERTY GRAPH statement in your graph definition to include the OPTIONS ( PG_SCHEMA ) clause. See Creating Property Graphs through CREATE PROPERTY GRAPH Statements for an example.

• Added support for Unsupervised EdgeWise models in PgxML library.

  See Using the Unsupervised EdgeWise Algorithm for more information.

• Added support for Unsupervised Anomaly Detection model in PgxML library.

  See Using the Unsupervised Anomaly Detection GraphWise Algorithm (Vertex Embeddings and Anomaly Scores) for more information.

• Added support for categorical features in GraphWise and EdgeWise models.
  • See Supported Property Types for Supervised GraphWise Model for more information.
  • See Supported Property Types for Supervised EdgeWise Model for more information.
  • See Supported Property Types for Unsupervised GraphWise Model for more information.
  • See Supported Property Types for Unsupervised EdgeWise Model 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.