Data Vault and DWH modeling interest group (Brisbane)https://www.meetup.com/Data-Vault-and-DWH-modeling-interest-group-Brisbane/https://a248.e.akamai.net/secure.meetupstatic.com/photos/event/c/c/f/8/global_194032472.jpeg20130107
Data Vault is a next-generation technique for (data)modeling the Enterprise Data Warehouse (EDW). It provides full historical storage and integration of data loaded from multiple (disparate) applications and systems and other sources of information and is designed for large scale, rapidly changing (agile!) and industry standard Data Warehouse and Business Intelligence platforms.
Stated as the 'optimal choice for modeling the EDW in the DW2.0 framework' by Bill Inmon it fits in perfectly with other existing approaches such as the well-known Kimball methodology. Data Vault provides the EDW architecture, the modular components and built-in audit trail to meet these ambitions. Due to the way Data Vault defines the entity types the EDW becomes a fully standardised and asynchronous environment where data can be added and loaded at any time. If you are looking for 100% of the data 100% of the time Data Vault is the technique to use.
Dan Linstedt - the father of Data Vault - defines the Data Vault as ‘a detailed historically oriented, uniquely linked set of normalised tables that support one or more areas of the business’. In other words; it is a semi-normalised model where key distribution, relationships and descriptive data are separated.
The historical data is denormalised to some extent, labeling it as a hybrid modeling approach for data modeling. It is the way Data Vault uses the archetypical entities to allows for a natural, almost organic, controlled expansion of the model that makes it such a powerful technique. Data Vault's architecture specifically caters for today’s complex Data Management needs, focusing on dealing with issues such as auditing, tracing of data, loading speed and resilience to change.
DW and BI solutions more than ever need infrastructure that can handle massive data volumes, be responsive to change and provide data auditability and traceability without massive effort. Data Vault can scale out for very large implementations while retaining flexibility to change.
Everyone is invited to join this group and discuss possibilities, implementation, case studies and in general what everyone would like to know about Data Vault.