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 lifecycle management

Data lifecycle management

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

Start my 1-month free trial

Data lifecycle management

- [Tutor] When we're designing databases, we naturally spend a lot of time thinking about how do we get data in? How do we organize the data and lay it out efficiently? How do we cash it? How do we query it? How do we tune our queries and things like that. We don't often spend as much time thinking about what are we going to do with the data after we're done using it at least actively using it? Well, one of the things we need to address with highly scalable and high availability databases is data lifecycle management, which is basically a discussion about what do we do with this data over time, because we don't have infinite resources? So how are we going to respond to data as the data ages and becomes maybe less useful? So we have to be able to do several things. We have to understand how we're going to categorize different data. And given those different categories, how do we store each of those different categories?…

Contents