A quick entry about the value and positioning of PIT and Bridge Tables in virtualizing data marts, providing equal joins against the DV model, and improving join performance against the Data Vault 2.0 solution.
Ok, so you’re using SQLServer2008 R2, but you can’t afford, or haven’t invested in the Enterprise Edition (which by the way, I think is an awesome product). So in other words, you can’t take advantage of compression, and you can’t take advantage of partitioning. If you are struggling for SQLServer performance, what do you do?
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.