LocalClusteringCoefficient Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

The output table schema depends on the graph type. For descriptions of the graph types, see LocalClusteringCoefficient Background.

The output table schemas for BDN and WDN graphs use cycle, middleman, in, and out triangles, which are explained in Unweighted, Directed Network (BDN).

Output Table Schema, BUN Graph

Column Data Type Description
accumulate_column Same as in vertices table [Column appears once for each specified accumulate_column.] Column copied from vertices table.
degree INTEGER Number of neighbors of node (nodes directly connected to this node).
tri_cnt INTEGER Number of triangles of node.
cc DOUBLE PRECISION Clustering coefficient of node.

Output Table Schema, BDN Graph

Column Data Type Description
accumulate_column Same as in vertices table [Column appears once for each specified accumulate_column.] Column copied from vertices table.
in_degree INTEGER Number of incoming edges.
out_degree INTEGER Number of outgoing edges.
bi_degree INTEGER Total number of edges.
cyc_tri_cnt INTEGER Number of cycle triangles for node.
mid_tri_cnt INTEGER Number of middleman triangles for node.
in_tri_cnt INTEGER Number of in triangles for node.
out_tri_cnt INTEGER Number of out triangles for node.
tri_cnt INTEGER Total number of triangles for node.
cyc_cc DOUBLE PRECISION Clustering coefficient for cycle triangles for node.
mid_cc DOUBLE PRECISION Clustering coefficient for middleman triangles for node.
in_cc DOUBLE PRECISION Clustering coefficient for in triangles for node.
out_cc DOUBLE PRECISION Clustering coefficient for out triangles for node.
avg_cc DOUBLE PRECISION Overall clustering coefficient for node.

Output Table Schema, WDN Graph

Column Data Type Description
accumulate_column Same as in vertices table [Column appears once for each specified accumulate_column.] Column copied from vertices table.
in_degree INTEGER Number of incoming edges.
out_degree INTEGER Number of outgoing edges.
bi_degree INTEGER Total number of edges.
cyc_tri_cnt INTEGER Number of cycle triangles for node.
mid_tri_cnt INTEGER Number of middleman triangles for node.
in_tri_cnt INTEGER Number of in triangles for node.
out_tri_cnt INTEGER Number of out triangles for node.
tri_cnt INTEGER Total number of triangles for node.
cyc_cc DOUBLE PRECISION Clustering coefficient for cycle triangles for node.
mid_cc DOUBLE PRECISION Clustering coefficient for middleman triangles for node.
in_cc DOUBLE PRECISION Clustering coefficient for in triangles for node.
out_cc DOUBLE PRECISION Clustering coefficient for out triangles for node.
avg_cc DOUBLE PRECISION Overall clustering coefficient for node.
w_cyc_cc DOUBLE PRECISION Weighted clustering coefficient for cycle triangles for node.
w_mid_cc DOUBLE PRECISION Weighted clustering coefficient for middleman triangles for node.
w_in_cc DOUBLE PRECISION Weighted clustering coefficient for in triangles for node.
w_out_cc DOUBLE PRECISION Weighted clustering coefficient for out triangles for node.
w_avg_cc DOUBLE PRECISION Overall weighted clustering coefficient for node.

Output Table Schema, WUN Graph

Column Data Type Description
accumulate_column Same as in vertices table [Column appears once for each specified accumulate_column.] Column copied from vertices table.
degree INTEGER Number of neighbors (nodes directly connected to this node).
tri_cnt INTEGER Number of triangles of node.
cc DOUBLE PRECISION Clustering coefficient of node.
w_cc DOUBLE PRECISION Weighted clustering coefficient of node.