1.1 - 8.10 - EigenvectorCentrality Example: Katz Centrality - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

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 from the attachment in the left sidebar.