A cross-link to a post that Ronald Damhof and I have made… http://prudenza.typepad.com/dwh/2011/02/dan-linstedt-ronald-damhof-lets-be-clear-about-the-raw-data-vault.html
Houses the basic standards and rules to follow when implementing Data Vault
This is a clarification post about the standards, certification, and offering licensed training in the market place.
A personal take on the state of the Data Vault Standards – model and Methodology, and the groups out there trying to “take over and make changes”…
A short look in to the Data Vault Methodology, and some of the foundational concepts for changing team culture within data warehousing and BI projects.
In this entry I discuss how and why I arrived at the DV standards. It seems there is a push out there to modify the standards, and I want people to understand what they should go through before proposing changes to the model and methodology.
A quite lengthy entry on the nature of business keys, and the discussion of how the Data Vault model plays a role in architecture and design.
A short trip down memory lane in exploring MD5 hashes as primary keys in the Data Vault. I also discuss the business Data Vault, and the operational data vault in passing.
Here are the rules for specification Version 1.0.9 of Data Vault Modeling. (Please feel free to comment on them by replying to this post). The new pieces are marked in RED as usual. (more…)
1.0 Goals and Objectives The following elements are part of the goals and objectives for loading the Data Vault. The data warehouse should truly represent the source systems in their original formats, and the only thing that should be done to the data is basic defaults, and error reporting. (more…)