Datavault, Anchor modeling or Inmon 3NF

This article will give you the pros and cons of different datawarehouse architectures, so that you can choose which one is best for your customer. As a BI architect, my job is to be objective. Try not to defend the things you know, but try to keep an open mind.

We will limit our scope to 3 popular architectures: Datavault, Anchor modeling and Inmon 3NF.

Example domain: Nasa Facilities. This is just a simple listing of Nasa centers and facilities. Each Centers hosts one or more facilities.

Powered by Socrata

Modelled in Data Vault 2.0

 

MODELLED in Inmon style 3NF
nasa_f_3NF
MODELLED IN ANCHOR MODELING

Usability

 

Links
  1. Comparisons between modelling techniques – Hybrid (including Data Vault) Roelant V.

Leave a Reply

Your email address will not be published. Required fields are marked *