🗄️Data Vault
Also known as Data Vault Modeling, Data Vault 2.0
A way to build a warehouse. It uses hubs, links and satellites.
Think of it like
It is like a family tree. Names, ties and life stories go on their own cards.
Example
Emma moves from Leeds to York. The customer satellite gets a new row with the new city, and the old row stays.
Why it matters
It keeps the full history and copes well with many changing sources. That suits large firms with strict audit rules.
Definition
Common mistake
Key takeaways
- 1Hubs for keys. One table per business key.
- 2Links for ties. One table per relationship.
- 3Satellites for details. Changes add rows, never overwrite.