Modularity Example: Unweighted Edges - 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ā„¢
This example specifies CommunityEdgeTable, which Teradata recommends only when necessary, because creating this table can greatly increase function run time.

Followers follow leaders with equal intensity (all edges have default weight 1).

SQL Call

SELECT * FROM Modularity (
  ON friends AS Vertices PARTITION BY friends_name
  ON followers_leaders AS Edges PARTITION BY follower
  USING
  TargetKey ('leader')
  CommunityAssociation ('group_id')
  Accumulate ('friends_name','location')
) AS dt ORDER BY friends_name;

Output

 friends_name location      resolution community_id num_communities modularity_score    
 ------------ ------------- ---------- ------------ --------------- ------------------- 
 alex         san francisco        1.0 los angeles                3 0.42592594027519226
 bob          los angeles          1.0 los angeles                3 0.42592594027519226
 casey        los angeles          1.0 los angeles                3 0.42592594027519226
 danny        new york city        1.0 austin                     3 0.42592594027519226
 eve          birmingham           1.0 austin                     3 0.42592594027519226
 fox          austin               1.0 austin                     3 0.42592594027519226
 gohar        miami                1.0 chicago                    3 0.42592594027519226
 harry        chicago              1.0 chicago                    3 0.42592594027519226

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.