7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The output table schema depends on the graph type. The graph types are:

  • BUN: Unweighted, undirected network
  • BDN: Unweighted, directed network
  • WUN: Weighted, undirected network
  • WDN: Weighted, directed network

The output table schemas for BDN and WDN graphs (described by the following two tables) see cycle, middleman, in, and out triangles, which are explained in Unweighted, Directed Network (BDN).

LocalClusteringCoefficient Output Table Schema for BUN Graph
Column Name Data Type Description
accumulate_column Same as in vertices table Column copied from the vertices table.
degree INTEGER Number of neighbors (nodes directly connected to this node).
tri_cnt INTEGER Number of triangles of the node.
cc DOUBLE PRECISION Clustering coefficient of the node.
LocalClusteringCoefficient Output Table Schema for BDN Graph
Column Name Data Type Description
accumulate_column Same as in vertices table Column copied from the 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 the node.
mid_tri_cnt INTEGER Number of middleman triangles for the node.
in_tri_cnt INTEGER Number of in triangles for the node.
out_tri_cnt INTEGER Number of out triangles for the node.
tri_cnt INTEGER Total number of triangles for the node.
cyc_cc DOUBLE PRECISION Clustering coefficient for cycle triangles for the node.
mid_cc DOUBLE PRECISION Clustering coefficient for middleman triangles for the node.
in_cc DOUBLE PRECISION Clustering coefficient for in triangles for the node.
out_cc DOUBLE PRECISION Clustering coefficient for out triangles for the node.
avg_cc DOUBLE PRECISION Overall clustering coefficient for the node.
LocalClusteringCoefficient Output Table Schema for WUN Graph
Column Name Data Type Description
accumulate_column Same as in vertices table Column copied from the vertices table.
degree INTEGER Number of neighbors (nodes directly connected to this node).
tri_cnt INTEGER Number of triangles of the node.
cc DOUBLE PRECISION Clustering coefficient of the node.
w_cc DOUBLE PRECISION Weighted clustering coefficient of the node.
LocalClusteringCoefficient Output Table Schema for WDN Graph
Column Name Data Type Description
accumulate_column Same as in vertices table Column copied from the 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 the node.
mid_tri_cnt INTEGER Number of middleman triangles for the node.
in_tri_cnt INTEGER Number of in triangles for the node.
out_tri_cnt INTEGER Number of out triangles for the node.
tri_cnt INTEGER Total number of triangles for the node.
cyc_cc DOUBLE PRECISION Clustering coefficient for cycle triangles for the node.
mid_cc DOUBLE PRECISION Clustering coefficient for middleman triangles for the node.
in_cc DOUBLE PRECISION Clustering coefficient for in triangles for the node.
out_cc DOUBLE PRECISION Clustering coefficient for out triangles for the node.
avg_cc DOUBLE PRECISION Overall clustering coefficient for the node.
w_cyc_cc DOUBLE PRECISION Weighted clustering coefficient for cycle triangles for the node.
w_mid_cc DOUBLE PRECISION Weighted clustering coefficient for middleman triangles for the node.
w_in_cc DOUBLE PRECISION Weighted clustering coefficient for in triangles for the node.
w_out_cc DOUBLE PRECISION Weighted clustering coefficient for out triangles for the node.
w_avg_cc DOUBLE PRECISION Overall weighted clustering coefficient for the node.