9.27 OPG_APIS.FIND_CLUSTERS_CLEANUP
Format
OPG_APIS.FIND_CLUSTERS_CLEANUP( 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
Cleans up after 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
-
(Reserved for future use.)
Usage Notes
The property graph edge table must exist in the database.
Examples
The following example cleans up after performing doing cluster detection in a property graph named mypg
.
EXECUTE OPG_APIS.FIND_CLUSTERS_CLEANUP('mypgGE$', wtClusters, wtUnDir, wtCluas, wtNewas, wtDelta, null);
Parent topic: OPG_APIS Package Subprograms