HubsAndLinks.com


H
Hub - Noun - Basic building block.


L
Link - Verb - Tie hubs together is a logical manner.


S
Same As Link - A "Same As" Link is a link where two of the references point to the same hub. This kind of link is used to indicate that one hub record is the same as another hub record. Typically, one of the hub records will be the master. This hub record will have satellite records. The other hubs will only be pointers back to the master hub record through the "Same As" link record.



In this example, you can see that the same component part can be refered to by more than one business key or name. The machining department may refer to "Phillips Screw 1/4-20 UNC-2A", while another department may refer to the same part as simply "Phillips Head Screw" because this is the only one they ever order. The L_SA_COMP_PART table allows both of these to be represented by the same hub record. In this case, the link table would indicate that "Phillips Screw 1/4-20 UNC-2A" is the master hub record and "Phillips Head Screw" is listed to be other.

Satellite - Adjective - Describe hubs and links. Attributes in a satellite should share rate of change, usage and logical grouping.