This illustration shows the four key differences between OLTP systems and a data warehouse:
- The OLTP has few Indexes, while a data warehouse has many.
- The OLTP has many Joins, while a data warehouse has some.
- The OLTP's Duplicated Data are Normalized DBMS, and Denormalized DBMS in a data warehouse.
- Derived Data and Aggregates are Rare in OLTP, but Common in a data warehouse.