Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Distinguish the OLTP access pattern from the OLAP access pattern.
- Explain why running both workloads on one database causes contention.
- Explain what a data warehouse is, and the role ETL plays in populating it.
- Classify a described query as OLTP or OLAP.
Levels 0 through 10 covered a database answering small, targeted queries quickly. Look up one order. Update one row. Check one customer's balance. This page names that pattern precisely. It contrasts it with a very different one. It explains why most organizations run the two on separate systems.