CSE Roadmap

Common tier · about 2 hours · 5 parts

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.