Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Differences between Data Vault and Dimensional modeling?

When modeling a data warehouse, is there any reason we should favor Data Vault over Dimensional modelling? What are the major differences between these two?

like image 304
jrara Avatar asked Apr 19 '11 10:04

jrara


1 Answers

Dimensional modelling is in my opinion still the best practise for analysis & reporting and as a visible model best understand by business users.

Data Vault is more suitable for large Enterprise Data Warehousing, also recommended by Bill Inmon, but not that suitable for analysis & reporting, for that you still might need dimensional modelling for creating you "virtual" Data marts. Take a peak at some blogs like those from Martijn Evers, Hennie de Nooijer or Ronald Damhof.

Data Vault is more flexible, easier to add new sources, more audit able and keeps all data all the time so you will be able to always recreate you DM's.

So a conclusion might be that the ideal situation is to use Data Vault for your Enterprise Data Warehouse and Dimensional Modelling for you Datamarts.

like image 115
Arjan Fraaij Avatar answered Oct 04 '22 14:10

Arjan Fraaij