Course Overview
This course covers the optimization of relational databases, including the evolution of databases, differentiating between OLTP and OLAP workloads, and techniques to optimize relational databases in four aspects: hardware, architecture, application, and database engine. The course also explores Intel's capabilities in databases, including reference architecture, proof of concept validation, and hardware features. Students will learn how to optimize relational databases using various methods, such as decoupling storage and compute, using in-memory cache, and leveraging Intel technologies like Optane and SPDK. The course also discusses database engine optimization, including parallel execution, multi-version concurrency control, and row and column storage.
Share With
Chapter List
Quiz Status
Please watch the video before taking the quiz.
Once you have watched the video, please take the quiz.
Chapter Overview
This course covers the optimization of relational databases, including the evolution of databases, differentiating between OLTP and OLAP workloads, and techniques to optimize relational databases in four aspects: hardware, architecture, application, and database engine. The course also explores Intel's capabilities in databases, including reference architecture, proof of concept validation, and hardware features. Students will learn how to optimize relational databases using various methods, such as decoupling storage and compute, using in-memory cache, and leveraging Intel technologies like Optane and SPDK. The course also discusses database engine optimization, including parallel execution, multi-version concurrency control, and row and column storage.