Key Property Graph Features in Oracle Database Release 23ai

Learn about the key property graph features in Oracle Database 23ai.

New Feature in Release Update 23.9

• Added support for declaring path variables when there are multiple path patterns in a SQL graph query.

  See Path Variables for more information.

• Added support for referencing a path variable using the IN path clause within ONE ROW PER VERTEX or ONE ROW PER STEP clause in a SQL graph query.

  See Using IN Path Clause for more information.

• Added support for using PATH_NAME function in combination with ONE ROW PER VERTEX or ONE ROW PER STEP to return the name of the path that the iterator variables are currently iterating over.

  See Using the PATH_NAME Function for more information.

• Added support for IS LABELED and PROPERTY_EXISTS predicates in SQL graph queries.

  See the following topics for more information:

  • Using the IS LABELED Predicate
  • Using the PROPERTY_EXISTS Predicate

New Feature in Release Update 23.8

• Added support for MATCHNUM and ELEMENT_NUMBER functions in the COLUMNS clause of SQL graph queries.

  See the following topics for more information:

  • Using the MATCHNUM Function
  • Using the ELEMENT_NUMBER Function

New Feature in Release Update 23.7

• Added support for retrieving results using ONE ROW PER MATCH, ONE ROW PER VERTEX, or ONE ROW PER STEP option in SQL graph queries. These options are supported in combination with variable-length path patterns.

  See Using ONE ROW PER Clause in a SQL Graph Query for more information.

New Feature in Release Update 23.6

• Added support for using binding_count in SQL graph queries. binding_count is an aggregate to count the number of bindings to an element variable.

  See Using binding_count() in SQL Graph Queries for more information.

New Features in Release Update 23.4

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

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.