9.54 OPG_APIS.SPARSIFY_GRAPH_CLEANUP
Format
OPG_APIS.SPARSIFY_GRAPH_CLEANUP( edge_tab_name IN VARCHAR2, wt_out_tab IN OUT VARCHAR2, wt_und_tab IN OUT VARCHAR2, wt_hsh_tab IN OUT VARCHAR2, wt_mch_tab IN OUT VARCHAR2, options IN VARCHAR2 DEFAULT NULL);
Description
Cleans up after sparsification (edge trimming) for a property graph edge table.
Parameters
- edge_tab_name
-
Name of the property graph edge table (GE$).
- wt_out_tab
-
A working table to hold the output, a sparsified graph.
- wt_und_tab
-
A working table to hold the undirected version of the original graph.
- wt_hsh_tab
-
A working table to hold the min hash values of the graph.
- wt_mch_tab
-
A working table to hold matching count of min hash values.
- tbs
-
A working table to hold the working table data
- options
-
(Reserved for future use.)
Usage Notes
The working tables will be dropped after the operation completes.
Examples
The following example does the preparation work for the edges table of mypg
, prints out the working table names, runs sparsification, and then performs cleanup.
SQL> set serveroutput on DECLARE my_lean_pg varchar2(100) := 'lean_pg'; wt2 varchar2(100); wt3 varchar2(100); wt4 varchar2(100); BEGIN opg_apis.sparsify_graph_prep('mypgGE$', my_lean_pg, wt2, wt3, wt4, null); dbms_output.put_line('wt2 ' || wt2 || ', wt3 ' || wt3 || ', wt4 '|| wt4); opg_apis.sparsify_graph('mypgGE$', 0.5, 1, 4, my_lean_pg, wt2, wt3, wt4, 'SEMTS', null); -- Add logic here to consume SVID, DVID in LEAN_PG table -- -- cleanup opg_apis.sparsify_graph_cleanup('mypgGE$', my_lean_pg, wt2, wt3, wt4, null); END; /
Parent topic: OPG_APIS Package Subprograms