View and Materialized views
View
- Derived relation defined in terms of base (stored) relations
Materialized views
- Materialize by storing the view tuples in database
- Index structures built on materialized view
Maintenance an issue for materialized views
- re-computation
- incremental updating