Junk dimensions are often misunderstood and avoided. And they should not be. Junk dimensions offer a strategy to remain true to dimensional intentions and to better focus one's design and sometimes ...

Four queries and some in-app iteration on collections (joins). At my current job, we have a monolith of similar size/complexity that sits on top of a relational database. The DAOs are somewhat 1:1 ...

File-based databases have been around since the dawn of computing. We’ve always needed to have a way of storing records of the same kind of information. In the PC world, we ended up with very popular ...