A.13.9 OPG_APIS.COUNT_TRIANGLE_CLEANUP
Format
COUNT_TRIANGLE_CLEANUP( edge_tab_name IN VARCHAR2, wt_undBM IN VARCHAR2, wt_rnmap IN VARCHAR2, wt_undAM IN VARCHAR2, options IN VARCHAR2 DEFAULT NULL);
Description
Cleans up and drops the temporary working tables used for triangle counting.
Parameters
- edge_tab_name
-
Name of the property graph edge table.
- wt_undBM
-
A working table holding an undirected version of the original graph (before renumbering optimization).
- wt_rnmap
-
A working table that is a mapping table for renumbering optimization.
- wt_undAM
-
A working table holding the undirected version of the graph data after applying the renumbering optimization.
- options
-
Additional settings for operation. An optional string with one or more (comma-separated) of the following values:
-
PDML=T
enables parallel DML.
-
Usage Notes
You should use this procedure to clean up after triangle counting.
The working tables must exist in the database.
Examples
The following example performs triangle counting in the property graph named connections
, and drops the working table after it has finished.
set serveroutput on DECLARE wt1 varchar2(100); -- intermediate working table wt2 varchar2(100); wt3 varchar2(100); n number; BEGIN opg_apis.count_triangle_prep('connectionsGE$', wt1, wt2, wt3); n := opg_apis.count_triangle_renum( 'connectionsGE$', wt1, wt2, wt3, num_sub_ptns=>1, dop=>2, tbs => 'MYPG_TS', options=>'PDML=T' ); dbms_output.put_line('total number of triangles ' || n); opg_apis.count_triangle_cleanup('connectionsGE$', wt1, wt2, wt3); END; /
Parent topic: OPG_APIS Package Subprograms