In Business Intelligence we often have complex logic for categorizing facts. We also have even more compelling reasons to use decision tables for these calculations. They make the logic behind
I’m a certified SQL Server DBA, a certified Oracle DBA, and I’ve used liquibase before, so I thought that using liquibase to migrate a schema definition from SQL Server to
Good quality code uses very few string literals or unnamed numerical constants. Wikipedia does a great job of explaining why not to use magic values. I’ll summarise: Magic values make
Dimensional Modelling is hard. It lacks both the mathematical precision and the maturity of Codd’s Normal Forms. That’s because the dimensional model is about the unknowable future needs of the
In my professional opinion, the most productive innovation of object-oriented languages is that they naturally lead to passing an entire set of data rather than a series of possibly unrelated simple
RSS - Posts