Data Warehouses



1.1 Business Intelligence (BI)


1.2 What is a Data Warehouse?

From Oracle Manual:

"A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organisation to consolidate data from several sources."


1.3 Inmon's characteristics of data warehouses


1.4 Data warehouses are materialised views

Data warehouses typically have

than OLTP databases.

Furthermore, data warehouses need not be normalised!


1.5 Features of data warehouses

Data warehouses are


2.1 Data Warehousing Schemas


2.2 OLAP Operations