Oracle | OPG

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 anywhere in North America, EMEA, LATAM, or APAC 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	FIND_CC	POPULATE_SKELETON_TAB
CREATE_SUB_GRAPH	FIND_CC_MAPPING_BASED	SPARSIFY_GRAPH

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