What is a Data Vault?

What is a Data Vault?

What is a Data Vault?

DLH.io documentation for What is a Data Vault?

DLH.io believes a Data LakeHouse is a framework and a way of thinking in terms of structure and scale. We support the initiatives and guidance of the Data Vault 2.0 framework as a part of the DLH.io concept and continue to implement Data Vault concepts as well as supporting features in DLH.io on an ongoing basis as part of our roadmap.

Data Vault 2.0 is a hybrid data modeling methodology, architecture, and framework that allows for working with data of all types (structured, semi-structured, and unstructured) and is designed to be resilient to environmental changes. At the core it is a modern, agile way of designing and building efficient, effective Data Warehouses. Dan Linstedt, the Data Vault methodology creator once described the Data Vault as "A detail oriented, historical tracking and uniquely linked set of normalized tables that support one or more functional areas of business. It is a hybrid approach encompassing the best of breed between 3NF and Star Schemas. The design is flexible, scalable, consistent and adaptable to the needs of the enterprise."

The newest iteration of the Data Vault methodology Data Vault 2.0 improves massively to align with many leaps technology advancement and compute such as removing the need for lookup surrogate keys, now using a Hash Key concept which we at DLH.io use in all of our data modeling designs.

The Data Vault Hub, Link, and Satellite concept allow for integration of multiple data sources into single or multiple structures that help define and democratize data across the enterprise. In so doing the Data Warehouse becomes a near idempotent system of data in a Raw Vault with the ability to layer on more business centric transformed data in a Business or Information Vault. Ultimately, the ability to building a traditional dimensional model Data Warehouse or Data Mart is available with the consistency of having a reliable and massively scalable DV 2.0 Raw Vault at its core.


This article was sourced from DLH.io Documentation.

    • Related Articles

    • What is a Data Warehouse?

      Learn The Basic Concepts What is a Data Warehouse? DLH.io documentation for What is a Data Warehouse? All true business analysts or executive management leadership that has worked effectively with data in the last two decades understands that a ...
    • What are the DLH.io Pre-Built Data Models?

      Learn The Basic Concepts What are the DLH.io Pre-Built Data Models? DLH.io documentation for What are the DLH.io Pre-Built Data Models? Analytics models are a accelerators for data warehouse and data vault models that allow any organization to start ...
    • Data Warehouse Clouds

      Data Warehouse Clouds DLH.io documentation for Data Warehouse Clouds Cloud Data Warehousing is a means for an organization to store and retrieve curated business decision making information, quickly, accurately, and with high levels of confidence, ...
    • SQL Data Query

      SQL Data Query DLH.io documentation for SQL Data Query Many of our business customers solve their one off data sharing needs by using a simple sql data query connection. A SQL Data Query connection allows a SQL query to query data from their source ...
    • What is a Data Catalog?

      Learn The Basic Concepts What is a Data Catalog? DLH.io documentation for What is a Data Catalog? A Data Catalog, also known as a Metadata Dictionary, or a Data Glossary, is a system which provides your data workers and business analytics users with ...