When is the Data Vault model the right model for a data-warehouse?

Question

I recently found a reference to 'Data Vault Modeling' as a model for data-warehouses. The models I've seen before are Inmon and Kimball. The author refers to possible performance problems due to the joins needed. It looks like a nice model, but I wonder about the gotcha's. Are there any experience reports on-line?

Answer 1

Hi Stephan,

You can find a whole lot more information on my blog: http://danLinstedt.com, and on the forums at datavaultinstitute dot com

But to give you a quick/brief answer to your question:

The gotchas are as follows:

1) Have to accept the concept of loading raw data to the data warehouse 2) Understand that the Data Vault usually doesn't allow "end-users" direct access because of the model.

There may be a few more, but the benefits outweigh the drawbacks.

Feel free to check out the blog, it's free to register/follow.

Cheers, Dan Linstedt