CSE Roadmap

Core tier · about 2 hours · 5 parts

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.