On a related note to this discourse post, I’m interested to hear what resources people recommend for developing a strong theoretical grounding in DW design.
I’m after a book or a few long and in-depth blog posts to explain the pros and cons of different models so that I can then make informed decisions given a particular use case. I’ve previously enjoyed Martin Fowler’s lengthy posts on software architecture, but he hasn’t done much on data architecture (and what is there is laden with buzzwords and light on technical detail for my liking).
I know The DW Toolkit by Kimball would be a standard reference, but following on from the discussion on this discourse post it seems like there is some debate about its relevance in the MPP database age (although it still seems like a good starting point to me).
Can anyone recommend any favourite DW design books? Or books / long blog posts in general that are must-reads for a technical data lead?
In return, I recommend my favourite technical data architecture book, Designing Data-Intensive Applications by Martin Kleppman, which is AMAZING as a foundation for understanding and combining all kinds of different data systems.