Relationship Information

Information about all links between each set of nodes composes a relationship. This information describes the aggregate association between the nodes and is automatically captured for each link in a network. Table 15 provides the column name and definition of the captured relationship information. Column names are not relationship information but IDs of the linked nodes and the link summary ID.

Table 7-6 Relationship Info in the KDD_LINK_SUMMARY Table

Column Name Description
TOT_LINK_WEIGHT Absolute sum of the link weight of all links between the two nodes, regardless of the directionality
TOT_LINK_CT Total count of all links between the two nodes, regardless of the directionality

LINK_WEIGHT_INTO_FIRST

_NODE

Absolute sum of the link weight of all links between the two nodes that have directionality to the node represented by the FIRST_NODE_ID
LINK_CT_INTO_FIRST_NOD E Count of the links between the two nodes that have directionality to the node represented by the FIRST_NODE_ID

LINK_WEIGHT_INTO_SCND

_NODE

Absolute sum of the link weight of all links between the two nodes that have directionality to the node represented by the SCND_NODE_ID
LINK_CT_INTO_SCND_NOD E Count of the links between the two nodes that have directionality into the node represented by SCND_NODE_ID
LINK_WEIGHT_NO_DIRN Absolute sum of the link weight of all links between the two nodes that have no directionality
LINK_CT_NO_DIRN Count of the links between the two nodes that have no directionality
AGGR_LINK_DIRN

Summarization of the directionality of the links between the two nodes

(that is, NONE, ONE_WAY, or BOTH)

LINK_SUMMARY_ID Unique internal ID of the link summary
FIRST_NODE_ID ID of the first node in the pair
SCND_NODE_ID ID of the second node in the pair