FYI, there's no reason to use MySQL. tilly said he was using PostgreSQL, and views exist there, as well as in numerous other databases.

But if views do the job, then that may be the way to go. I'd also think about how often the data really needs to be "refreshed", and then maybe just generate the data daily/weekly/monthly/whatever.