Sounds like the classic situation where a materialized view is used to me.

Cheers

Tim...