Highly Normalized Hybrid Model, or how we implemented the storage model

The generally accepted and time-tested approach to constructing DWH is the Star or Snowflake scheme. This approach is canonical, fundamental, waterfall, and doesn't correspond to the flexibility that Agile calls for.

To make the DWH structure flexible we have modern approaches to design: Data Vault and Anchor modeling — similar and different at the same time. Evgeny and Nikolay asked themselves which of the two methodologies to choose and came to an unexpected answer: one must not choose between approaches, one must choose the best of the two approaches.

In this talk speakers will tell:

• DV and AM: what is the difference and where are the points of contact;
• "hybrid" approach to building storage;
• "the point" of this approach, its strengths and weaknesses;
• code examples;
• further development vector of hNhM.