From the course: Designing Highly Scalable and Highly Available SQL Databases
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Data modeling for scale: Event sourcing
From the course: Designing Highly Scalable and Highly Available SQL Databases
Data modeling for scale: Event sourcing
- [Instructor] So by now it's clear there are a number of factors that can limit our scalability and one of those that we haven't discussed yet in any depth is our data model, like how we actually produce our logical model and physical model and what I want to take a look at here is the limits of the CRUD model and then introduce another design pattern called event sourcing. So, when we talk about CRUD again, we're talking about create, read, update and delete operations and this is a common pattern typical of most enterprise kind of applications. And basically the idea is that an application reads some data from the database, updates it, modifies it, uses it for some processing and then writes back some new values. Now, when we're working on the data and processing it, we wouldn't want somebody to go in and change that same data on disk. So, what we do is we use locks and locks prevent someone else from writing that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Human-scale and machine-scale data6m 13s
-
Different data ingestion strategies5m 6s
-
Designing scalable user interfaces6m 45s
-
Message queues to buffer ingested data4m 10s
-
Data modeling for scale: Event sourcing5m 17s
-
Distributing workload: Command Query Response Separation (CQSR)4m 26s
-
Challenge: Services and APIs for a scable user interface46s
-
Solution: Services and APIs for a scable user interface1m 10s
-
-
-