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.2
- Added support for running PGQL statements and queries on graphs in Oracle
SQL Developer 22.2 release.
See Property Graph Support in SQL Developer for more information.
- Added support for Oracle JDK 17 for Oracle Graph Server and Client installation.
- Added new
AdbGraphClient
API for accessing graph features in Graph Studio on Oracle Autonomous Database programmatically using the client shell CLIs or through Java or Python application.See Using Autonomous Database Graph Client for more information.
- Added support for loading a subgraph from property graph views.
See Loading a Subgraph from Property Graph Views for more information.
- Added support for the execution of PGQL update queries against property
graph views.
See Executing PGQL Update Queries for more information.
- Added support for retrieving the metadata of property graph views using PGQL
queries.
See Retrieving Metadata for Property Graph Views for more information.
- Added PGQL support for built-in functions in unnesting of variable length path
queries.
See Built-in Function Support for Recursive Path Unnesting Queries.
- Added support for
ALL
path finding goal in PGQL queries for property graph views.See PGQL Features Supported in Property Graph Views for more information.
- Enhanced
readGraphByName(String name, GraphSource source)
API to support graph optimization options.See Using Graph Optimization Options When Loading a Property Graph View for more information.
- Enhanced
GNNExplainer
support in Supervised and Unsupervised GraphWise models in PgxML library, by adding aGnnExplainer
object to allow user-configurable options toGNNExplainer
.- See Explaining a Prediction of a Supervised GraphWise Model for more information.
- See Explaining a Prediction for an Unsupervised GraphWise Model for more information.
- Enhanced building of Supervised and Unsupervised GraphWise models by adding
an optional weight decay parameter to counteract overfitting.
- See Advanced Hyperparameter Customization for a Supervised GraphWise model for more information.
- See Advanced Hyperparameter Customization for an UnSupervised GraphWise model for more information.
- Added a new model repository API for managing the PgxML model tables.
See Model Repository and Model Stores for more information.
- Migrated the logger implementation for the graph server (PGX) from Log4j to
Logback.
Note:
If you use non-default logging settings inlog4j2.xml
and upgrade to Oracle Graph Server and Client 22.2, then you must migrate those settings to their Logback equivalents inlogback.xml
.See Log Management in the Graph Server (PGX) 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
- PgxML:
inferAndGetExplanation
FunctionGraphWiseModel.inferAndGetExplanation()
is deprecated. Instead, useGraphWiseModel.gnnExplainer()
to obtain aGnnExplainer
object for the model and useGnnExplainer.inferAndExplain()
. 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;
Desupported Features
- The following Java API classes are desupported:
oracle.pg.rdbms.OraclePgqlColumnDescriptor.java
oracle.pg.rdbms.OraclePgqlColumnDescriptorImpl.java
oracle.pg.rdbms.OraclePgqlExecution.java
oracle.pg.rdbms.OraclePgqlExecutionFactory.java
oracle.pg.rdbms.OraclePgqlPreparedStatement.java
oracle.pg.rdbms.OraclePgqlResult.java
oracle.pg.rdbms.OraclePgqlResultElement.java
oracle.pg.rdbms.OraclePgqlResultElementImpl.java
oracle.pg.rdbms.OraclePgqlResultImpl.java
oracle.pg.rdbms.OraclePgqlResultIterable.java
oracle.pg.rdbms.OraclePgqlResultIteratorImpl.java
oracle.pg.rdbms.OraclePgqlResultSet.java
oracle.pg.rdbms.OraclePgqlResultSetImpl.java
oracle.pg.rdbms.OraclePgqlResultSetMetaData.java
oracle.pg.rdbms.OraclePgqlResultSetMetaDataImpl.java
oracle.pg.rdbms.OraclePgqlSqlTrans.java
oracle.pg.rdbms.OraclePgqlSqlTransImpl.java
oracle.pg.rdbms.OraclePgqlStatement.java
- Support for mixed case string arguments in PyPGX for cases where there are a fixed,
enumerated list of possible values (such as,
['linear', 'tanh', 'relu']
) are desupported. Only lower case arguments are now supported. - 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.