7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The function outputs a community vertex table and, optionally, a community edges table.

The community vertex table has a row of modularity results for each specified resolution level.

Community Vertex Table Schema (Default Resolution)
Column Name Data Type Description
accumulate_column Same as in vertices table Column copied from the vertices table. For details, see the description of the Accumulate argument in Modularity Arguments.
resolution DOUBLE PRECISION Resolution at which modularity score is computed.
community_id VARCHAR or same as in vertices table Identity of the community to which the vertex belongs.
num_communities INTEGER Number of communities at this resolution. (This value is the same for each resolution level.)
modularity_score DOUBLE PRECISION Modularity score at this resolution.(This value is the same for each resolution level.)

The community edges table contains the edge weights (strength) between different communities at specified resolutions. The table is created implicitly on the database and is not displayed at the output of function execution. To display the contents of the community edges table, use the command SELECT * FROM community_edge_table (where community_edge_table is the name that you specified in the CommunityEdgeTable argument).

Community Edges Table Schema
Column Name Data Type Description
src_community_id VARCHAR or same as in vertices table Identity of the first community of the edge.
target_community_id VARCHAR or same as in vertices table Identity of the second community of the edge.
resolution DOUBLE PRECISION Resolution at which modularity score is computed.
weight DOUBLE PRECISION Strength of the link from the first community to the second community.