Why don't you investigate in Materialized Views?
It could help.