Part 1 of 6 · 1 min read
Why this page comes first
In this module you will
- Explain why organizations copy data into a separate warehouse instead of running analytics queries on the live operational database.
- Describe the ETL process: extract, transform, load.
- Tell a fact table from a dimension table, and a measure attribute from a dimension attribute.
- Draw a star schema for a simple sales or orders scenario.
- Explain what a snowflake schema adds, and why most teams avoid it unless they need it.
The last page showed that OLTP and OLAP want opposite things from storage. This page shows the usual fix: stop running analytics on the OLTP system at all, and build a second database shaped for analysis. That second database is the data warehouse, and its most common shape is the star schema.
Remember this
A data warehouse is a copy of the business's data, reorganized for reading large amounts at once, kept separate from the system that takes orders.