I answer a customers question about Operational Data Vault, triggers, and staging areas.
I’ve found some software that I like that allows us to manage, edit, enter, and maintain business & technical metadata in one place.
Table of contents for the upcoming Data Vault Modeling book, also a list of current figures in the book.
Where to find the Data Vault Business Modeling book
In this entry I dive into Operational Data Vaults, introduce the concept – where it fits, and what types of things to expect from a system such as this.
In this entry I describe parts of MPP and parts of SMP, and how they relate to the Data Vault Architecture. I also discuss some of the finer points of the MPP scalability mathematical principles that are applied within the Data Vault Model.
I’ve long maintained that the Data Vault architecture is backed by mathematics, well, here’s a post that explains briefly the architectures and principles at work, including MPP, vertical and horizontal partitioning, and shared nothing components. We discuss WHY the number of joins in the model are a MOOT POINT.
A short bit about Data Vault Modeling, the origins of the hub-and-spoke model, and the origins of the Data Vault Model entities themselves.
Short YouTube piece about Data Vault Loading and Informatica
Covering the Frameworks, Architectures, and Data Modeling designs – basic overview of where you can compare/contrast, and how you can talk about these issues