Preview
IB DP Computer Science — A3 Databases — Alternative databases and data warehouses | HL | A3.4.2
📋 What You Will Learn
- Explain why organisations keep a data warehouse separate from their operational databases
- Explain the six defining characteristics: subject-oriented, integrated, time-variant, non-volatile, append-only, optimised for query performance
- Describe how ETL (extract, transform, load) integrates data from multiple sources
- Show, with a worked example, how append-only history enables analysis an operational database cannot support
- Evaluate a data warehouse as the foundation of business intelligence
🏛️ Why This Matters A shop's till is built for speed: ring up a sale, move on. The company's archive room is built for questions: "how did winter sales change over five years?" You would never make customers queue while an analyst rummages through the till. A data warehouse is the archive room