People come to me all the time complaining about the NUMBER OF JOINS in the Data Vault. I thought I might take a crack at answering this question/complaint, and provide some solid mathematical proof behind the fundamental design of the Data Vault model. I welcome your feedback (I hope you take the time to comment).
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.