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.
High-level physical design
From the course: Designing Highly Scalable and Highly Available SQL Databases
High-level physical design
- [Instructor] Now, another piece of the kind of initial design is our high-level physical design. In here, what we're doing, is basically kind of thinking through how we want the data organized on our storage systems. So we're actually thinking about the physical layout of data relative to other pieces of data. Now there are a couple of things that we think about in terms of abstractions. One is called the tablespace and tablespaces are ways of grouping data. And we do that at a schema level. But then there's also something called partitions. And we use those at a table or index level. And both tablespaces and partitions allow us to take advantage of parallel operations like parallel writes and parallel reads. And what we'll find is that parallelization is a key element of scalable databases. Now, another thing we can think about at high-level design, which is often used in highly performing databases, is caching.…
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.