This illustrates the comparisons between OLTP (complex data structures) and data warehousing (multidimensional data structure) environments:
- indexes: OLTP have few while data warehouses have many
- joins: OLTP have many while data warehouses have some
- duplicated data: OLTP have normalized data while data warehouses have denormalized data
- derived data and aggregates: OLTP is rare while data warehouses are common