Input - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

The function has two required input tables, vertices and edges. Each row of the vertices table represents a vertex of the graph, and each row of the edges table represents an edge of the graph.

The function has two optional input tables, sources and targets, which specify the vertices that are sources and targets, respectively. For a directed graph, these tables are required. By default, all vertices are sources and targets; that is, the graph is undirected.

For an undirected graph, the graph table might have duplicate rows. Remove them, using the code in the section Deleting Duplicate Edges Table Rows of the function AllPairsShortestPath.

For a large graph, specifying the optional sources and targets tables can improve function performance time.

Betweenness Vertices Table Schema
Column Name Data Type Description
vertex_key_column Any allowed in PARTITION BY clause Column that is, or is part of, the unique vertex key. Every column that is part of this key must appear in the PARTITION BY clause. This column cannot contain NULL values.
Betweenness Edges Table Schema
Column Name Data Type Description
source_vertex_key_column Any allowed in PARTITION BY clause Column that is, or is part of, the key that identifies the source vertex of the edge. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause. This column cannot contain NULL values.
target_vertex_key_column Same as data type of source_vertex_key_column Column that is, or is part of, the key that identifies the target vertex of the edge. This key must be a vertex key in the vertices table. This column can contain NULL values.
edge_weight SMALLINT, INTEGER, or NUMERIC Column that contains the weights of the edges, which must be positive values. This column is required only for a weighted graph. This column can contain NULL values.
Betweenness Sources Table Schema
Column Name Data Type Description
source_vertex_key_column Same as data type of corresponding vertex_key_column in vertices table Column that is, or is part of, the key that identifies a source vertex. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause.
Betweenness Targets Table Schema
Column Name Data Type Description
target_vertex_key_column Same as data type of corresponding vertex_key_column in vertices table Column that is, or is part of, the key that identifies a target vertex. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause.