If the hashing Algorithm is known, there is nearly no protection. Day of birth is about 100 (yrs) x 365 (days) values possible. Generating a 365k rows lookup table is a no-cost no-brainer. Same for city, zip code, social security number and more PII attributes. Or am I wrong with these assumptions?

I‘d take the red pill and start implementing DV in the underground.

@Lorenz Kindling Absolutely correct. Business Object not driven by source systems are possible and to store in a BV Hub.

@Tim Kirschke Yes, generate hashkeys, don‘t change the patterns. For writing queries (optionally automized) it shouldn‘t be a difference to query RV or BV.

In 1983, with my Commodore 64, I coded a sequential database (state of the art in this time, this environment), to manage my Minitrix model railway‘s (9mm rail gauge) parts. It was giving me an overview about money spent in different categories (tracks, engines and coaches, landscape, buildings, …) and inventory. Later dealing with csv file, read by Microsoft Word for Windows 3 to automize spare part & service efforts for reports & invoices (mid of 90th). Continuing my data journey at Oracle‘s starting 2000 …

Fifteen years ago, I would have thought that was a correct and good explanation (but data lake was not introduced as a common term). I'm now struggling with the definition of “data warehouse”, because in Data Vault we say “maintain the granularity of the source system” and “load the sources independently and auditably”. According to Alex Analyst Data Vault would not be a data warehouse. 🤣