Facebook Twitter LinkedIn YouTube RSS
Home Data Vault Archive for category "DV Standards"
formats

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).

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
6 Comments  comments 
formats

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.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments 
formats

Data Vault Methodology – Introduction

A short video introduction to defining the Data Vault Methodology.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off  comments 
formats

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

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Clarification: Training, Standards, Certification

This is a clarification post about the standards, certification, and offering licensed training in the market place.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off  comments 
formats

Data Vault: About the Standards And Methodology

Published on 2011/02/14 by in DV Standards, News

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”…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

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.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off  comments 
formats

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.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

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.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off  comments 
formats

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.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments 
formats

DV Modeling Specification v1.0.9

Published on 2010/05/13 by in DV Standards

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.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
11 Comments  comments 
formats

Data Vault Loading Specification v1.2

Published on 2010/05/13 by in DV Standards

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.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
4 Comments  comments 

Bad Behavior has blocked 1997 access attempts in the last 7 days.