/the_data_must_flow

Creative Commons Zero v1.0 UniversalCC0-1.0

Header

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.
Creative Commons License
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
    Hub Link Satellite

Additional variations of links

  • Link with a dependent-child key
  • Hierarchy link (HAL)
  • Same-as link (SAL)
    Link-DepKey Link-Hierarchy Link-Sameas
    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
    Satellite-DepKey Satellite-MultiActive Satellite-Effectivity

Peripheral satellites

  • Record tracking satellite
  • Status tracking satellite
    Satellite-RecordTracking Satellite-StatusTracking

Time-line correction satellite

  • Extended record tracking satellite
    Satellite-ExtendedRecordTracking

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
    BV Hub BV LINK BV LINK-DepKey BV LINK-Explore BV Satellite BV Satellite dependent-child key BV Multi-Active Satellite

Reference data

Reference data lookup

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
    PIT Bridge

Misc

  • Views
  • Staging

    Views Staging