Materialized View Approach (Data Warehousing)

Filtered data from several sources is stored in a single repository (called "data warehouse"). This data is combined into a unified schema. A data warehouse often contains historical and summarized data which is used for decision support.

• Picture
• Motivation: Why would we want to materialize data?
  OLTP (On-Line Transaction Processing) vs OLAP
  • Terabytes of data
  • Workloads are query intensive; queries are complex
  • OLAP data is modeled multi-dimensionally
• What is involved in building a data warehouse?
  (** For each of this steps mention the main research issues)
  • Modeling and design
  • Maintenance (creation and refreshing)
  • Operation
• Known implementations
  - Squirrel
  - WHIPS