The Data Vault vs. Kimball – Round 2
Here we go again, the discussion about the claimed benefits of the Data Vault. Thomas Christensen has written some great blog posts about his take on the Vault method. Dan Linstedt has been commenting.
The discussions are a good read to track:
Apologies in advance for my spelling errors in the comments, the posts are written while travelling.
As with most complex subjects, it is often hard to have people state with clarity what EXACTLY their claim is and what their supporting arguments are. It seems that the Vault is no exception – I hope the discussions lead somewhere this time.
For your reference, here are some of the posts I have previous done on how to approach the “integration” problem the Vault claims to solve:
Notice that there are some very interesting claims being made about normalization creating more load and query parallelism in the comments on Thomas Christensen’s Blog by Sanjay. I personally look forward to hearing the argument for that.
And here is the big picture architecture I am arguing for: