The problem there would be how they fall out of date, and updating them is a heavy operation.

An alternative I've heard before is using triggers with regular tables, so updating one automatically updates the relevant other ones.

Materialized views allow insert/update mechanics on many platforms. Alternatively you can refresh them.