Level 2: Data · L2.1 Data models, SQL vs NoSQL, storage engines & indexing
OLTP vs OLAP and column stores
Explain why analytics uses column-oriented storage.
12 min · Pro
What you take away
- OLTP touches few rows and many of their columns; OLAP touches few columns across enormous numbers of rows.
And 3 more inside the class, in Pro.
How the class is laid out
- The problem
- The simple version
- Two workloads, two layouts
- Why a read replica is not the answer
- Check your understanding