Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain how row-oriented storage physically lays out a table's data.
- Explain how column-oriented storage differs, and why that helps analytical queries.
- Explain why column-oriented storage compresses far better than row-oriented storage.
- Decide which layout fits a transactional workload versus an analytical one.
Every table discussed so far was implicitly row-oriented. This page names that choice directly. It introduces the alternative that Level 12's analytics modules depend on: storing data by column instead.