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).
Conceptual, Canonical, and Raw Data Integration
Lengthy questions about the canonical structure, conceptual vs physical data vault modeling, Raw Data Vault vs business applications. An interesting read, please add your own comments to the end of this posting.
Data Vault Methodology – Introduction
A short video introduction to defining the Data Vault Methodology.
Dan Linstedt & Ronald Damhof on the Raw Data Vault
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
Clarification: Training, Standards, Certification
This is a clarification post about the standards, certification, and offering licensed training in the market place.
Data Vault: About the Standards And Methodology
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”…
Succeeding at BI Projects
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.
Do You Believe in Standards?
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.
Nature of DV Structure
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.
In search of Better Business Keys…
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.
DV Modeling Specification v1.0.9
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.
Data Vault Loading Specification v1.2
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.






