A fact based look at Hashing and Sequences and Collision Strategies in Data Vault 2.0 Standards.
All things Data Vault
Yet another dive in to Hash Keys and Data Vault 2.0
A short walk through what the Data Vault is really about. I hope you enjoy this lesson. I’ve got plenty of customers achieving / receiving real business value – monetary value, from their Data Vault 2.0 solutions, and yes, they are able to see the data as an asset as a result of this process.
A walk back through the joins, hashing, Teradata, key selection, and arguments for and against sequence numbers. While this post is specifically related to Teradata, there are some generic statements here that apply to all MPP solutions.
An executive viewpoint on why standards matter, and how you can optimize and mature your EDW / BI solution today.
Another round in the arguments as to why standards are important. Again, if there is feedback, I welcome it.
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.
A quick/ short entry discussing the end of Load End Dates and Last Seen Dates. Finally, the removal of all UPDATE processes in your EDW / Data vault 2.0
A short discussion on what a Multi-Active Satellite is and should be
It’s been a while since I blogged about features and functionality of the Data Vault, but here is an entry that discusses something I’ve been talking about since 2001. Dynamic Data Warehousing. This is the next step beyond active data warehousing / operational data vaults. (more…)