Materialized View Issues
Select a set of views to be materialized
- limited by resource, cannot materialize all the views
- issues to consider: available resources, overhead with respect to the workload
- simple algorithm works reasonably well.
Exploit the materialized views to answer queries
- Query optimization using views
Efficiently update materialized views during loading and fresh