[pocketarc]

> This might mean deriving data when possible; for example, computing totals rather than storing them.

Fully agreed. This might be one of those areas where people not knowing it's possible can lead them to far worse solutions. Generated columns in databases, computing things based on row data, and things like materialized views, are so, so useful.