From the course: Designing Highly Scalable and Highly Available SQL Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Data modeling for scale: Event sourcing

Data modeling for scale: Event sourcing

From the course: Designing Highly Scalable and Highly Available SQL Databases

Start my 1-month free trial

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…

Contents