14 karma · joined February 26, 2022
Nonetheless if you're going to base your company's product around a database or anything else for that matter, you really had better get yourself sorted out WRT your tools, or it can become horribly expensive to fix or even fatal to your company.
Yes, it's pretty much the same as a covering index is used
> There's also materialized views
Ah yes, that's pretty much the answer (if incrementally updated). Thanks.
> In theory, the DBMS itself could directly support 'physical denormalization' and make this performance optimisation easier to implement and transparent to the application code. I think some SQL DBMSs have attempted to do things like this.
Automatically managed, application-transparent, physical denormalisation entirely managed by the database is something I am very, very interested in. Unfortunately I've been able to find pretty well nothing to describe what it would look like and how it would be done. If you can provide any links that would be so incredibly helpful!
It gets mentioned in the Date/Darwen books as being the right way to do things, but no actual information seems to be given.
Ukraine thinks otherwise.
However I disagree. To broad-brush it, I think Ukraine's war is a just war (as in morally justified).