EigenVectorCentrality Example 3: Bonacich Centrality - Teradata Vantage

Input

Input tables are from EigenVectorCentrality Example 1: Eigenvector Centrality (by Default):

• vertices: sophomores
• edges: common_classes

SQL Call

SELECT * FROM EigenVectorCentrality (
  ON sophomores AS vertices PARTITION BY id
  ON common_classes AS edges PARTITION BY startid
  USING
  TargetKey ('endid')
  Accumulate ('id')
  Family ('bonacich')
  Beta (0.01)
  EdgeWeight ('electives')
) AS dt ORDER BY centrality DESC;

Output