SchemaWright
LearnExercisesLecturesPricing
lectures/Analytics at scale

Distributed databases

Track 3 of 5 · Analytics at scale · 8 of 8
  1. 1. OLTP and OLAP (in preparation)
  2. 2. The star schema (in preparation)
  3. 3. Column stores (in preparation)
  4. 4. From MapReduce to the lakehouse (in preparation)
  5. 5. Streams and change data capture (in preparation)
  6. 6. Time-series data (in preparation)
  7. 7. Counting with sketches (in preparation)
  8. 8. Distributed databases (in preparation)
← PreviousNext →
In preparationLecture III.8

The question it answers

What do you give up when one database becomes many machines?

This lecture is being written. Like every lecture here, each claim in it is read in its primary source and cited to the page before it is published. See what you can read now.

Track 3 of 5 · Analytics at scale · 8 of 8
  1. 1. OLTP and OLAP (in preparation)
  2. 2. The star schema (in preparation)
  3. 3. Column stores (in preparation)
  4. 4. From MapReduce to the lakehouse (in preparation)
  5. 5. Streams and change data capture (in preparation)
  6. 6. Time-series data (in preparation)
  7. 7. Counting with sketches (in preparation)
  8. 8. Distributed databases (in preparation)
← PreviousNext →

Write the schema.
Let the tests decide.

Business scenarios, answered in DDL, graded by hidden tests on a real Postgres.

Start for free See the plans
SchemaWright

Database design, practised.
Graded on a real Postgres.

devgabmasantos@gmail.com

Practise

  • Lessons
  • All exercises
  • The first exercise
  • Pricing
  • Sign in

Tracks

  • Fundamentals
  • Deletion & History
  • Multi-tenancy
  • Time
  • Normalization
  • Performance
© SchemaWright. All rights reserved.Privacy policyTerms of service
!