top of page
Laptop keyboard, coffee, sticky notes, and pencils on wood background

What is Data Vault?

Data Vault 2.0 is a modern approach to data warehousing that supplies an efficient, secure, and flexible way to store and manage substantial amounts of data. It was developed by Dan Linstedt in the early 2000s as an alternative to traditional, relational databases for storing structured business intelligence (BI) information.


Data Vault 2.0 combines the best aspects of both traditional database technologies with newer concepts such as No-SQL databases and big data analytics tools like Hadoop or Spark into one integrated system architecture that can manage vast amounts of enterprise-level BI information – while still providing scalability, security, flexibility, and performance benefits over other solutions in its class.

Dan Linstedt, creator of the Data Vault method, describes it as “Data Vault 2.0: A system of Business Intelligence containing the necessary components needed to accomplish enterprise vision in Data Warehousing and Information Delivery.”


DATA VAULT CORE CONCEPTS

The core concept behind Data Vault 2.0 is its hub-and-spoke model which uses multiple “hubs” (or tables) connected together via “links” instead of just one single table used in most relational database models today. This allows for easier integration between different systems within a company’s IT infrastructure without relying on expensive ETL processes or complex coding requirements typically associated with integrating disparate datasets from varied sources into one unified viewable format through SQL queries alone—a process known as Extract Transform Load (ETL).


Additionally, it also enables more granular control over how certain pieces of information are stored since each hub has access only to those links necessary for creating meaningful relationships between related items. This helps reduce clutter caused by unnecessary redundancies or irrelevant connections when dealing with larger datasets compared against using conventional RDBMS (relational database management system) solutions where all rows must be joined together regardless of if they are relevant or not before being able to generate any useful insights from them.


HOW WE CAN HELP

At Datavault, we offer a range of different services to support, consult, and govern your organisation’s data using the Data Vault method. Visit our website or contact us to find out more about what we do, and how we can solve your business problems.

bottom of page