Skip to content
BENIBIX Learn

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

Data vault is a way to build a data warehouse from three kinds of table. Hubs hold only the business keys, like a customer number. Links record how keys are tied, like which customer placed which order. Satellites hold the details and add a new row each time they change. New sources slot in without changing what is already there.
Hubs hold keys and a link ties them. Satellites keep every version of the details.

Common mistake

Letting people report straight from the vault. It has many tables to join, so teams build a star schema on top for reports.

Key takeaways

  1. 1
    Hubs for keys. One table per business key.
  2. 2
    Links for ties. One table per relationship.
  3. 3
    Satellites for details. Changes add rows, never overwrite.

Compare