PSALSA Example 1: User Similarity in Social Network without Edge Weight - Teradata Vantage

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

Input

The likes column is not used as edgeweight in this example.

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 ')
  MaxHubNum (2)
  MaxAuthorityNum (2)
  TeleportProb (0.15)
  RandomWalkLength (1000)
) AS dt ORDER BY followers;

Output

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