30
Types of Views
•Virtual views:
–Used in databases
–Computed only on-demand – slower at runtime
–Always up to date
•Materialized views
–Used in data warehouses
–Precomputed offline – faster at runtime
–May have stale data