People come to me all the time complaining about the NUMBER OF JOINS in the Data Vault. I thought I might take a crack at answering this question/complaint, and provide some solid mathematical proof behind the fundamental design of the Data Vault model. I welcome your feedback (I hope you take the time to comment).
Hardcore Table Comparisons: Dimensional and Data Vault
There are a lot of comments, and questions out there about the Data Vault model, particularly from those who claim to know it and understand it. Yet some of them have a) not engaged me, nor b) gone to take the certification class. Reasons for the DV model are buried in the methodology – a lot of benefits come from using both the data modeling techniques and the methodology. That’s for another post. In this post I will try to focus JUST on the physical table structures, similarities and differences, so that the physical nature of the structures can be “compared” (so to speak).
Clash of the Titans: Post on Kimball Forum
The Data Vault Model is NOT the be-all-end-all solution to data warehousing, it IS a single evolutionary step forward, as it is a Hybrid design. If you don’t feel pain in your current implementation, then you may not be a candidate for the Data Vault model and methodology.
More: Data Vault VS Star Schema – for EDW
A long written response to a well-thought out comment about a successful Dimensional Data Warehouse. Including the values and benefits of the Data Vault.
Data Vault Vs Dimensional – Part 3
I begin to examine why the star schema or dimensional modeling technique doesn’t really meet the true needs of enterprise data warehousing. If you’ve succeeded with a dimensional model at an enterprise level, please add your comments, I’d love to hear from you.
Data Vault Vs Dimensional – Part 2
A short entry in the series where I compare/juxtapose star schema data warehousing with Data Vault data warehousing. I DO believe star schemas are necessary, I just believe they should be Data Marts and that they should not be used for data warehousing architecture.
Data Vault Versus Dimensional – Part 1
A couple of questions came to me through e-mail, and I think these questions are important enough for the world to see the answers. I’ve protected the country, and the name of the retailer, but you can see – you’re not the only one struggling to understand the Data Vault. If you are struggling, PLEASE contact me so I can help.
From Star Schema to Data Vault
A quick guideline for bootstrapping your effort of building a Data Vault model based on a Star Schema model.
Comments Off 
Data Vault, Kimball Star Schema, Inmon CIF
Covering the Frameworks, Architectures, and Data Modeling designs – basic overview of where you can compare/contrast, and how you can talk about these issues
Comments Off
