1. Data Warehousing Architecture

A data warehouse is built on top of a database. Data is copied, not moved. It is more than a storage location for data. Based on Oracle, a data warehouse is a type of data management system that is designed to enable and support business intelligence activities.

Rules of Data Warehousing

  1. Integrated environment
  2. Subject oriented
  3. Contain historical data, not current data
  4. Non-volatility so data remains the same in between refreshes
  5. Restructure and reorganize to make it more useful

Why build a Data Warehouse?

  1. Support data driven decisions - need to know past, present and future
  2. One stop shop for all data

Data Virtualization

Data Virtualization reaches directly into the source applications and accesses data when it is needed for reporting or analytics. It does not do pre-staging, unlike a data warehouse.

Building a Centralized Data Warehouse