1.1 - 8.10 - Modularity 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)
Table Description
Community vertex table Has a row of modularity results for each specified resolution level.
CommunityEdgeTable [Optional] Contains edge weights (strengths) between different communities at specified resolutions.

Function creates this table on database but does not display it as output. To display this table, use command SELECT * FROM community_edge_table .

Community Vertex Table Schema (Default Resolution)

Column Data Type Description
accumulate_column Same as in Vertices table Column appears once for each specified accumulate_column.] Column copied from Vertices table.
resolution DOUBLE PRECISION Resolution at which modularity score is computed.
community_id VARCHAR or Same as in Vertices table Identifier of community to which vertex belongs.
num_communities INTEGER Number of communities at this resolution. (Same for each resolution level.)
modularity_score DOUBLE PRECISION Modularity score at this resolution. (Same for each resolution level.)

CommunityEdgeTable Schema

Column Data Type Description
src_community_id Same as in Vertices table or VARCHAR Identifier of first community of edge.
target_community_id Same as in Vertices table or VARCHAR Identifier of second community of edge.
resolution DOUBLE PRECISION Resolution at which modularity score is computed.
weight DOUBLE PRECISION Strength of link from first community to second community.