primary key options for data vault 2.0 this entry is a candid look (technical, unbiased view) of the three alternative primary key options in a data vault 2.0 model. there are pros and cons to each selection. i hope you enjoy this factual entry. (more…)
Houses the basic standards and rules to follow when implementing Data Vault
for many years, i have built, authored and maintained the #datavault standards. this includes data vault 1.0, and data vault 2.0. there are others in the community who believe that “these standards should evolve and be changed by consensus of the general public”. (more…)
Download it here: DVModelingSpecs2-0-1 (Newer versions will be maintained only on https://dataVaultAlliance.com, but as promised, this one is free). (more…)
hello everyone, apparently there are those out there in the market place who are spreading false rumors – they believe that i am only in data vault for the money. let me put these rumors to rest right now. (more…)
a quick update of old issues, and new solutions for data vault, cdvp2, data vault system of business intelligence, and why it’s pertinent to successful enterprise data warehouses.
a fact based look at hashing and sequences and collision strategies in data vault 2.0 standards.
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.