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
potential issues of using the data vault modeling techniques
list of possible data vault customers
data vault modeling and data vault methodology – defined in a very brief statement