Oracle OPG_GRAPHOP
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located in North America that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Provides support for Graph Database Operations on property graphs in the Oracle Database.
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DBMS_STATS OPG_LOG
DBMS_DEBUG_VC2COLL DBMS_UTILITY OPG_UTL
DBMS_LOCK OPG_APIS PLITBLM
Documented Yes
First Available 19c
Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);
Security Model Owned by MDSYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/mdsys/admin/opggraphoph.sql
{ORACLE_HOME}/mdsys/admin/opggraphoph.plb
Subprograms
 
CLONE_GRAPH
Clones a graph opg_graphop.clone_graph(
orgGraph      IN VARCHAR2,
newGraph      IN VARCHAR2,
dop           IN INTEGER  DEFAULT 4,
num_hash_ptns IN INTEGER  DEFAULT 8,
tbs           IN VARCHAR2 DEFAULT NULL,
options       IN VARCHAR2 DEFAULT NULL);
TBD
 
CREATE_SUB_GRAPH
Undocumented opg_graphop.create_sub_graph(
graph_owner  IN VARCHAR2,
orgGraph     IN VARCHAR2,
newGraph     IN VARCHAR2,
nSrc         IN NUMBER,
depth        IN INTEGER,
dop          IN INTEGER  DEFAULT 4,
nPQThreshold IN INTEGER  DEFAULT 10000,
tbs          IN VARCHAR2 DEFAULT NULL,
options      IN VARCHAR2 DEFAULT NULL);
TBD
 
FIND_CC
Finds connected components in the original graph. All connected components are stored in the given wt_clusters.

Note that the original graph will be treated as undirected.
opg_graphop.find_cc(
edge_tab_name IN     VARCHAR2,
wt_clusters   IN OUT VARCHAR2,
wt_undir      IN OUT VARCHAR2,
wt_cluas      IN OUT VARCHAR2,
wt_newas      IN OUT VARCHAR2,
wt_delta      IN OUT VARCHAR2,
dop           IN     INTEGER  DEFAULT 4,
rounds        IN     INTEGER  DEFAULT 0, -- continue until all components found
tbs           IN     VARCHAR2 DEFAULT NULL,
options       IN     VARCHAR2 DEFAULT NULL);
TBD
 
FIND_CC_MAPPING_BASED
Finds connected components in the original graph. connected components will be stored in the given wt_clusters. opg_graphop.find_cc_mapping_based(
edge_tab_name IN     VARCHAR2,
wt_clusters   IN OUT VARCHAR2,
wt_undir      IN OUT VARCHAR2,
wt_cluas      IN OUT VARCHAR2,
wt_newas      IN OUT VARCHAR2,
wt_delta      IN OUT VARCHAR2,
dop           IN     INTEGER  DEFAULT 4,
rounds        IN     INTEGER  DEFAULT 0, -- continue until all components found
tbs           IN     VARCHAR2 DEFAULT NULL,
options       IN     VARCHAR2 DEFAULT NULL);
TBD
 
POPULATE_SKELETON_TAB
Populates the skeleton table (GT$). By default, the content in the existing GT$ table ar removed opg_graphop.populate_skeleton_tab(
graph   IN VARCHAR2,
dop     IN INTEGER  DEFAULT 4,
tbs     IN VARCHAR2 DEFAULT NULL,
options IN VARCHAR2 DEFAULT NULL);
TBD
 
SPARSIFY_GRAPH
Sparsifies a graph. The remaining edges are stored in the wt_out_tab opg_graphop.sparsify_graph(
edge_tab_name IN     VARCHAR2,
threshold     IN     NUMBER  DEFAULT 0.5,
min_keep      IN     INTEGER DEFAULT 1,
dop           IN     INTEGER DEFAULT 4,
wt_out_tab    IN OUT VARCHAR2,
wt_und_tab    IN OUT VARCHAR2,
wt_hsh_tab    IN OUT VARCHAR2,
wt_mch_tab    IN OUT VARCHAR2,
tbs           IN     VARCHAR2 DEFAULT NULL,
options       IN     VARCHAR2 DEFAULT NULL);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
OPG_APIS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx