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 22.1
- Enhanced support for running the graph server (PGX) behind a load balancer
on Oracle Cloud using session persistence.
See Deploying Graph Server (PGX) Using OCI Load Balancer for more information.
- Added support for reading all entity providers of a graph using the same SCN.
See Reading Entity Providers at the Same SCN for more information.
- Added PGQL support for retrieving all properties of a vertex or an edge
through
SELECT v.*
clause when executing PGQL queries against the graph server (PGX) and property graph views.See Support for Selecting All Properties and PGQL Features Supported in Property Graph Views for more information.
- Added PGQL support for unnesting of variable-length path queries.
See Unnesting of Variable-Length Path Queries for more information.
- Added PGQL support for more quantifiers when executing PGQL queries against property
graph views.
See Table 6-7 for more information.
- Added support for reading graphs from the database with property names
different from the column names in the database.
See the partitioned graph configuration file in Creating a JSON Configuration to Load a Graph and the
CREATE PROPERTY GRAPH
statement in Creating a Property Graph Using PGQL for more information. - Added support for optimizing graph performance using the
OPTIONS
clause when creating a property graph in the graph server (PGX).See Creating Property Graphs Using Graph Optimization Options for more information.
Migrating Property Graph Applications to Oracle Database 21c
From Release 21c onwards, Oracle Graph Server and Client must be installed separately. It is recommended to remove the older property graph libraries from $ORACLE_HOME
. See Uninstalling Previous Versions of Property Graph Libraries for more details.
Deprecated Features
Pg2vecModelBuilder.setUseGraphletSize(java.lang.Boolean useGraphletSize)
method inoracle.pgx.api.mllib
API is deprecated. Instead, use thePg2vecModelBuilder.setUseGraphletSize(boolean useGraphletSize)
method.- PL/SQL API OPG_APIS.GET_SCN FunctionThe PL/SQL API OPG_APIS.GET_SCN function is deprecated. Instead, to retrieve the current SCN (system change number), use the DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER function:
SELECT dbms_flashback.get_system_change_number FROM DUAL;
- OraclePgqlResultSet
The
oracle.pg.rdbms.OraclePgqlResultSet
interface was deprecated in 19c and will be removed in a future release. Instead, use the standardized interfaceoracle.pgql.lang.ResultSet
to retrieve values from a PGQL result set.
Desupported Features
- Support for Python 3.5 is desupported.
- Support for the two-table format is desupported.
- The following Java API methods, objects and fields in
oracle.pgx.api
are no longer supported:Desupported Methods:
PgxCollection
methods:addAllAsync(Collection<E> source)
removeAllAsync(Collection<E> source)
addAll(ID...ids)
removeAll(ID...ids)
PgqlResultSet
methods:getResults()
: instead, usePgqlResultSet
to directly iterate the result setdestroy()
- User-defined pattern matching semantic methods:
PgxGraph#queryPgql(String, PatternMatchingSemantic)
: instead, usePgxGraph#queryPgql(String)
PgxSession.setPatternMatchingSemantic(..)
GraphMetaData
constructors and related methods:GraphMetaData()
GraphMetaData(GraphMetaData other, java.net.URI baseUri)
GraphMetaData(IdType vertexIdType)
GraphMetaData.setVertexIdType()
GraphMetaData.setEdgeIdType()
PgxSession#getAvailableSnapshots(GraphConfig)
: instead, usePgxSession#getAvailableSnapshots(PgxGraph)
- All
Analyst#filteredBfs
andAnalyst#filteredDfs
methods that acceptsfilter
parameter: instead, use thenavigator
parameter
Desupported Objects
PgqlResult
(a result ofresultSet.getResults().iterator().next()
: instead, usePgxResult
as returned fromresultSet.iterator().next()
Desupported Fields
pattern_matching_semantic
configuration field
- The Java API method
AbstractGraphConfigBuilder#setNodeIdType
inoracle.pgx.config
is desupported. Instead, useAbstractGraphConfigBuilder#setVertexIdType()
. - The following PyPGX classes are desupported in
pypgx
package. Instead, usepypgx.api.filters
subpackage to access these classes:EdgeFilter
GraphFilter
VertexFilter
-
The following PyPGX classes are desupported in
pypgx.api
package. Instead, usepypgx.api.frames
subpackage to access these classes:PgxCsvFrameReader
PgxCsvFrameStorer
PgxDbFrameReader
PgxDbFrameStorer
PgxFrame
PgxFrameBuilder
PgxFrameColumn
PgxGenericFrameReader
PgxGenericFrameStorer
PgxPgbFrameReader
PgxPgbFrameStorer
- The following Python API packages are no longer supported:
common
: This internal package is desupported. Few of the classes from this package are moved to the public packagepypgx.api
.utils
: This internal package is renamed to_utils
.
- Graph property text search based on Apache Solr/Lucene is desupported. Instead, use Oracle Text or PGQL query expressions.
- The PGX property type DATE is desupported. Instead, use LOCAL_DATE or TIMESTAMP.
- Property Graph support for data stored in Oracle NoSQL Database is desupported.
- Support for Gremlin Groovy shell is desupported.
- Apache Tinkerpop API support for Oracle Database is desupported.
- Loading data from flat file formats into the property graph schema is desupported.
- Support for the Apache Groovy-based shell was deprecated in 19c and is now desupported.
- Support for Apache HBASE and Apache HDFS on Cloudera CDH5 is desupported.