Data Vault vs Dimensional Modeling
People think data vault and dimensional modeling compete, so a team must pick one. They do different jobs in the same warehouse. A data vault takes in data from many sources. It keeps every change. A dimensional model lays data out as facts and details for reports. Many teams build the vault first, then star schemas on top.
Data Vault
A way to build a warehouse. It uses hubs, links and satellites.
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.
Dimensional Modeling
Warehouse tables split in two kinds. Facts count things. Dimensions say who, what and where.
Dimensional modeling is a way to lay out warehouse tables for easy reports. It splits data into facts and dimensions. Facts are events you count, such as sales. Dimensions describe those events, such as the date, the shop and the product. Reports then join facts to dimensions to slice the numbers any way they like.
In one line
- Data Vault
- A way to build a warehouse. It uses hubs, links and satellites.
- Dimensional Modeling
- Warehouse tables split in two kinds. Facts count things. Dimensions say who, what and where.