9.28 OPG_APIS.FIND_CLUSTERS_PREP
Format
OPG_APIS.FIND_CLUSTERS_PREP( 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, options IN VARCHAR2 DEFAULT NULL);
Description
Prepares for running weakly connected components (WCC) cluster detection.
Parameters
- edge_tab_name
-
Name of the property graph edge table.
- wt_clusters
-
A working table holding the final vertex cluster mappings. This table has two columns (VID NUMBER, CLUSTER_ID NUMBER). Column VID stores the vertex ID values, and column CLUSTER_ID stores the corresponding cluster ID values. Cluster ID values are long integers that can have gaps between them.
If an empty name is specified, a new table will be generated, and its name will be returned.
- wt_undir
-
A working table holding an undirected version of the graph.
- wt_cluas
-
A working table holding current cluster assignments.
- wt_newas
-
A working table holding updated cluster assignments.
- wt_delta
-
A working table holding changes ("delta") in cluster assignments.
- options
-
Additional settings for index creation.
Usage Notes
The property graph edge table must exist in the database.
Examples
The following example prepares for doing cluster detection in a property graph named mypg
.
DECLARE wtClusters varchar2(200); wtUnDir varchar2(200); wtCluas varchar2(200); wtNewas varchar2(200); wtDelta varchar2(200); BEGIN opg_apis.find_clusters_prep('mypgGE$', wtClusters, wtUnDir, wtCluas, wtNewas, wtDelta, ''); dbms_output.put_line('working tables names ' || wtClusters || ' ' || wtUnDir || ' ' || wtCluas || ' ' || wtNewas || ' ' || wtDelta ); END; /
Parent topic: OPG_APIS Package Subprograms