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.

Solution: Optimize a data model for an analytical queries

Solution: Optimize a data model for an analytical queries

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

Start my 1-month free trial

Solution: Optimize a data model for an analytical queries

“

(pleasant pulsing electronic music) - [Instructor] Now, our solution involves a star schema, so we'll have at least one fact table and multiple dimensions. Now, the fact table will contain metrics. Now, here, for example, we might be interested in the duration of interactions. Now, each of the dimensions will contain data on some aspect of the data like whether it's geolocation data or time data, and in particular, we have three different types of locations, so we're going to break those out and each of those should have their own dimension.

Contents