Chapter 6.5

Introduction to Data Vault Implementation

Abstract

One of the most important components of the end-state architecture is that of the data
vault. The data vault exists to satisfy the need for rock-solid data integrity. Like all other
components of the end-state architecture, the data vault has gone through its own
evolution. And like all components of the end-state architecture, data vault will continue
to evolve.

Keywords

Data vault; Big data; Patterns; Automation; Data warehousing; Business intelligence

Implementation Overview

The data vault system of BI provides implementation guidelines, rules, and
recommendations as standards. As noted in previous sections of this chapter, well-
defined standards and patterns are the key to success of agile, CMMI, Six Sigma, and
TQM principles. These standards guide the implementation of

• the data model, finding business keys, designing entities, and applying key structures;


• the ETL/ELT load processes;


• the real-time messaging feeds;


• information mart delivery processes;


• virtualization of the information mart;


• automation best practices;


• business rules—hard and soft;


• write-back capabilities of managed self-service BI.

Some of the objectives of managing implementation through working practices include
meeting the needs of TQM, embracing master data, and assisting in alignment across
business, source systems, and the enterprise data warehouse.

Before going any further, it is necessary to understand that the highest level of
optimization can only be reached if the process, design, and implementation are pattern-

Chapter 6.5: Introduction to Data Vault Implementation