Data Vault modeling and star schema modeling are often presented as opposing approaches, as if one had to be chosen over the other. In reality, this opposition is artificial. These two approaches do not address the same use cases, do not pursue the same objectives,...
Data Vault and BI legacy: why Data Vault doesn’t “replace” BI (and how to decommission safely) Table of contents Context: starting from scratch is rare Let’s put our foot in it: Data Vault is not a BI replacement BI vs Data Vault: different objectives, complementary...
There are similarities between the approach to implementing an MDM system and the approach to implementing an EDWH with Data Vault, especially speaking about the business key concept. This for a very simple reason: these 2 subjects are complementary! Why MDM and Data...
No, this is not the sequel of Little House on the Prairie, but rather the continuation of our articles related to the buzz words wandering in the world of Data… So now that the implementation of Datalakes has been completed – or is in progress, or even starting… –...
Table of contents Limitations Possible enhancements The “Same-As” Link Implementation conditions Limitations One of the fundamental assumptions of this methodology, and so one the crucial points during the design phase lies in determining the Business Keys (BKs) and...
Table of contents Core principle: business objects first Key stakes for a Data Vault project Study phase: define objects, BKs, and relationships From Raw Data Vault to Business Data Vault Other topics: technical optimizations Core principle: business objects first As...
