Facebook Twitter LinkedIn YouTube RSS
magnify
Home Posts tagged "hub"
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

Q:Are Satellite Tables Required?

Published on 2010/11/10 by in Data Vault

Fast Fact about Hubs, Links And Satellite Table Structures

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

From a 3NF to Data Vault – short lesson

Published on 2010/05/07 by in Data Vault

A short way to create a Data Vault model from a 3NF system. This is a very brief introduction/overview of the process.

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

When a Business Key is not available

Published on 2010/04/20 by in Data Vault

Short discussion on business keys, and what to do when you can’t find the right one for the hub’s purposes.

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