Data Modeling - Data Vault

1 - About

The DV modeling technique shows to the light the importance of the business keys.

The Data Vault consists of three primary entity types:

  • Hubs: They are core business keys,
  • Links: They form all relationships,
  • and Satellites: They provide all descriptive information

The data vault is a detailed oriented, historical tracking and uniquely linked set of normalized tables that support one or more functional areas of business.

It's an hybrid approach encompassing the best of breed between 3rd normal form (3nf) and star schema. The design is flexible, scalable and adaptable of the needs of enterprise. Dan LINSTEDT http://www.danlinstedt.com

3 - Naming Convention

Naming convention allow management, identification and monitoring of the entire system.

3.1 - Table

Suffix Description
HUB or H HUB tables
LNK or L Standard Link Tables
HLNK or HL Hierarchical Links
LSA, SAL, SLNK, SL Same as Links
TLNK, TL Transactional Links
SAT. or S Generic Satellites
HSAT Hub Satellites
LSAT Link Satellites
PIT, or P Point-in-time tables
BR or B Bridge tables
REF or R Reference tables

3.2 - Column

The naming convention for the standardized fields is:

Suffix Description
LDTS, LDT Load date time stamps
LEDTS, LEDT Load end date time stamps
SQN Sequence numbers
REC_SRC, RSRC Record sources
LSD, LSDT Last seen dates
SSQN Sub-sequencing identifiers

4 - Documentation / Reference

  • Bookmark "Data Modeling - Data Vault" at del.icio.us
  • Bookmark "Data Modeling - Data Vault" at Digg
  • Bookmark "Data Modeling - Data Vault" at Ask
  • Bookmark "Data Modeling - Data Vault" at Google
  • Bookmark "Data Modeling - Data Vault" at StumbleUpon
  • Bookmark "Data Modeling - Data Vault" at Technorati
  • Bookmark "Data Modeling - Data Vault" at Live Bookmarks
  • Bookmark "Data Modeling - Data Vault" at Yahoo! Myweb
  • Bookmark "Data Modeling - Data Vault" at Facebook
  • Bookmark "Data Modeling - Data Vault" at Yahoo! Bookmarks
  • Bookmark "Data Modeling - Data Vault" at Twitter
  • Bookmark "Data Modeling - Data Vault" at myAOL
data_modeling/data_vault.txt ยท Last modified: 2017/01/20 21:00 by gerardnico