PSALSA Example 2: User Similarity in Social Network with Edge Weight - Teradata Vantage

This example uses the arguments MaxHubNum and MaxAuthorityNum to output a maximum of two hub and two authority users.

Input

SQL Call

SELECT * FROM PSALSA (
  ON users_vertex AS vertices PARTITION BY username
  ON users_edges AS edges PARTITION BY followers
  USING
  SourceKey ('followers ')
  TargetKey ('leaders ')
  EdgeWeight ('likes')
  MaxHubNum (2)
  MaxAuthorityNum (2)
  TeleportProb (0.15)
  RandomWalkLength (1000)
) AS dt ORDER BY 1, 3 DESC, 5 DESC;

Output

The output shows that John and Winston are similar to Carla. John is more similar, as he has a higher hub_score. The output varies with every run.