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.
Transactional vs. analytical queries
From the course: Designing Highly Scalable and Highly Available SQL Databases
Transactional vs. analytical queries
- [Instructor] Now we've had a good amount of discussion about ingestion, which is about getting data in to a database, but we also need to focus on querying a database 'cause querying is also just a fundamental task and it's like one of the major sources of workload on a database. So one of the things we have to keep in mind when we're thinking about querying the database and how do we make that perform and especially at scale, is we have to think about how we design our data model. Also once we decide about a particular logical data model, we have to think about the physical data model or the physical implementation, and how we're going to essentially structure the data, distribute it across different storage devices and things like that. And how we think about that and our various choices is often governed by the query patterns that we expect to see. Now, like in ingestion, we made this very crude distinction between human…
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
-
-
-
-
-
-
(Locked)
Transactional vs. analytical queries5m 41s
-
(Locked)
Indexing for transactional queries10m 11s
-
(Locked)
Materialized views for transactional queries3m 51s
-
(Locked)
Using read replicas to improve query performance2m 55s
-
(Locked)
Understanding write-ahead logging5m 6s
-
(Locked)
Denormalizing for analytical queries4m 18s
-
(Locked)
Aggregation and sampling for analytical queries5m 45s
-
(Locked)
Challenge: Optimize a data model for an analytical queries25s
-
(Locked)
Solution: Optimize a data model for an analytical queries35s
-
(Locked)
-