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 23.4
- Added support for synchronizing SQL property graphs.
See Synchronizing a SQL Property Graph for an example.
- Added support for
IS SOURCE OF
andIS DESTINATION OF
predicates in PGQL queries.See Supported PGQL Features with Examples for more information.
Features That Work With Oracle Database Release 23ai and Prior Oracle Database Releases
- Added support for checking permissions periodically on the source
data tables for graphs loaded from the database.
See Graph Sharing Options and Validating Graph Permissions for more information.
- Added support to inherit the published state of the properties when
creating a new snapshot.
See Publishing a Graph With Snapshots for more information.
- Added support for configuring the Autonomous Database Graph Client using a JDBC
connection.
See Configuring the
AdbGraphClient
using a JDBC Connection for more information. - Modified Oracle Graph Python client installation.
See Installing the Python Client From the Graph Server and Client Downloads for more information.
- The
oracle-graph-plsql-<ver>.zip
artifact is removed from the Oracle Graph Server and Client deployment. Thecreate_graph_roles.sql
script is now available in/opt/oracle/graph/scripts
folder.Also, see Basic Steps for Using an Oracle Database for Authentication for more information.
- Added support for creating PGQL property graphs from existing
property graphs in the current user schema.
See Creating a PGQL Property Graph with the BASE_GRAPHS Clause for more information.
- Added support for new
KEEP
clause in PGQL.See Support for PGQL GRAPH_TABLE Operator for more information.
- Added support for
JSON_ARRAYAGG
function in PGQL queries.See Supported PGQL Features with Examples for more information.
- Added support for a new built-in validation function
(
pg.validate()
) to check if vertex and edge keys are unique and if sources and destinations of edges exist.See Supported PGQL Features with Examples 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 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.