Modularity Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.