Data vault modelling

Data vault modelling is like building a really big Lego structure.

Imagine you have lots and lots of Lego pieces - some are blue, some are yellow, and some are red. Each color represents different types of data like names, ages, and addresses.

Now, imagine you want to build a big structure with these Lego pieces, but you don't want it to fall apart easily. You want it to be strong and easy to modify later on.

That's where data vault modelling comes in.

You start by creating a blueprint, which is like a plan for your Lego structure. This blueprint is called a Data Vault diagram. It shows how all the Lego pieces fit together and what types of data they represent.

Next, you build the foundation of your structure. This is called the Data Vault schema. It's like the base plate for your Lego structure. It's made up of three types of components: hubs, links, and satellites.

Hubs are like the Lego pieces that have the same color. They represent the main entities in your data like customers, products, or sales transactions.

Links are like the connectors that hold the Lego pieces together. They represent the relationships between the entities in your data.

Satellites are like the extra pieces that give more information about the entities in your data. They represent the details like dates, times, or descriptions.

Once you've built your foundation, you can start adding more Lego pieces to your structure. These Lego pieces are like your data from different sources. You can add them to your Data Vault schema without worrying about breaking anything.

And if you need to modify your structure later on, you can easily take out or add more Lego pieces without affecting the rest of your structure.

That's essentially what Data Vault modelling is - it's a way to build a strong and flexible structure for all your data.