Data Vault - Link

1 - About

Typical examples of Links in the data vault methodology:

  • associations,
  • hierarchies,
  • and re-definition of business terms.

Every table which has more than one foreign key is a candidate to become a link.

3.1 - Driving Key

The driving key is the main key that drives the rest of the relationship. She is arbitrarily assigned. The driving key is necessary to identify so that Satellites based on the Link can be appropriately “end-dated” when the relationship changes.

3.2 - History

  • in a link satelitte
  • of as an attribute of a satellite
  • Bookmark "Data Vault - Link" at del.icio.us
  • Bookmark "Data Vault - Link" at Digg
  • Bookmark "Data Vault - Link" at Ask
  • Bookmark "Data Vault - Link" at Google
  • Bookmark "Data Vault - Link" at StumbleUpon
  • Bookmark "Data Vault - Link" at Technorati
  • Bookmark "Data Vault - Link" at Live Bookmarks
  • Bookmark "Data Vault - Link" at Yahoo! Myweb
  • Bookmark "Data Vault - Link" at Facebook
  • Bookmark "Data Vault - Link" at Yahoo! Bookmarks
  • Bookmark "Data Vault - Link" at Twitter
  • Bookmark "Data Vault - Link" at myAOL
data_modeling/link.txt · Last modified: 2017/01/20 21:00 by gerardnico