thedatamustflow

#datavault #data-vault
Visio stencils and artefacts related to data vault guru. Click the link above for the downloadable stencil for Visio. Use the art if you wish to create your own. And if you like upload your work to this repo. The art and stencils are provided under Creative Commons licensing.

This work is licensed under a Creative Commons Attribution 4.0 International License.
Find the book at Amazon, Kindle and Paperpack, click US, UK and AU
And now find your favourite book art available for purchase at RedBubble! Click https://rdbl.co/3uMEReY

Hub
Link
Satellite

Additional variations of links

Link with a dependent-child key
Hierarchy link (HAL)
Same-as link (SAL)

HAL and SAL are conceptual representations of the relationship, in truth they are simply just links and a link may include a combination of relationships all represented in a single link.

Additional variations of satellites

Satellite with dependent-child key
Multi-active satellite
Effectivity satellite

Peripheral satellites

Record tracking satellite
Status tracking satellite

Time-line correction satellite

Extended record tracking satellite

Business vault

These are no different to raw vault artefacts except that we are storing the derived output using the above raw vault loading patterns.

Hub
Link
Link with dependent child key
Exploration link
Satellite
Satellite with a dependent-child key
Multi-active satellite

Reference data

Query assistance tables

Query assistance structures are needed if direct method to get data out of data vault is slow or needs optimisation. This can be achieved by using index optimised data structures that point directly to the indexes in the data vault.

Point-in-time (PIT) tables
Bridge tables

Misc

Views
Staging

PatrickCuba-zz/thedatamustflow