1.1 - 8.10 - LocalClusteringCoefficient Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

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.