9.8 OPG_APIS.COUNT_TRIANGLE
Format
OPG_APIS.COUNT_TRIANGLE( edge_tab_name IN VARCHAR2, wt_und IN OUT VARCHAR2, num_sub_ptns IN NUMBER DEFAULT 1, dop IN INTEGER DEFAULT 1, tbs IN VARCHAR2 DEFAULT NULL, options IN VARCHAR2 DEFAULT NULL ) RETURN NUMBER;
Description
Performs triangle counting in property graph.
Parameters
- edge_tab_name
-
Name of the property graph edge table.
- wt_und
-
A working table holding an undirected version of the graph.
- num_sub_ptns
-
Number of logical subpartitions used in calculating triangles . Must be a positive integer, power of 2 (1, 2, 4, 8, ...). For a graph with a relatively small maximum degree, use the value 1 (the default).
- dop
-
Degree of parallelism for the operation. The default is 1.
- tbs
-
Name of the tablespace to hold the data stored in working tables.
- options
-
Additional settings for the operation:
-
’PDML=T' enables parallel DML.
-
Usage Notes
The property graph edge table must exist in the database, and the OPG_APIS.COUNT_TRIANGLE_PREP. procedure must already have been executed.
Examples
The following example performs triangle counting in the property graph named connections
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( 'connectionsGE$', wt1, num_sub_ptns=>1, dop=>2, tbs => 'MYPG_TS', options=>'PDML=T' ); dbms_output.put_line('total number of triangles ' || n); END; /
Parent topic: OPG_APIS Package Subprograms