Data Vault 2.0

The Data Vault 2.0 modelling technique has grown to a standard used in the development of a Data Warehouse. It is one of the foundations for our Enterprise Data Warehouse projects and is therefore one of the keys to the success of these projects.

Data Vault 2.0 contains three areas (modeling, methodology and architecture) and is built on three main components:

HUB : natural business key

 LINK : natural business relationship

SATELLITE : all context, descriptive data and history

Our general approach for any Data Warehouse projects follows a reference architecture that is based on this Data Vault 2.0 model. When building a Raw Vault of all available data sources in an organisation, hard rules are applied to form a big web between the different tables from different source systems. By defining Hubs, Links and Satellites, this web is built, and connections are made without losing any information from the source and so providing all facts. It gives the advantage of always providing all realtime data and history preceding the real time information. The traceability of the data makes the model auditable. Every change is visible in satellite tables with exact time stamps.

The model’s resilience to change is notable is the Raw Data Vault when new sources are added, or source systems are deleted or transferred and further on also in de Business Data Vault when a company’s needs or expectations change in time.

The Business Data Vault is where needs and wishes of a business are applied, and all abundance of information is filtered out. The separation of these two layers makes them resilient to change in the future because all facts are still present in the Raw Data Vault and by merely changing the soft rules, a whole new truth can be formed without going through the process of extracting new data from the source. 

The Data Vault modelling technique handles difficulties of cross-platform data persistence, multi-latency and multi-structured data and massively parallel platforms. It brings high quality standards and best practices which lead to an easily automated technique that in turn leads to lower risk and faster implementation and time to market.

Would you like to know more about Data Vault 2.0?

DataSense NV
Kempische Steenweg 309 bus 1.01
3500 Hasselt
BE 0674 824 149
+32 11 64 30 16

DataSense BV
Pedro de Medinalaan 73
1086 Amsterdam
+31 20 303 05 80