EigenvectorCentrality Example: Katz Centrality | Teradata Vantage - EigenvectorCentrality Example: Katz Centrality - Teradata Vantage

Input

Both input tables are from EigenvectorCentrality Example: Eigenvector Centrality:

• 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','name')
  Family ('katz')
  EdgeWeight ('electives')
) AS dt;

Output

 id name   centrality          
 -- ------ ------------------- 
 d  darren  0.5071260939364596
 a  allen   0.4413130299990051
 b  becky  0.38537192565216905
 c  cathy   0.6321031666753343

Download a zip file of all examples and a SQL script file that creates their input tables.