Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Learn Harvard CS 165
·
Module 1
Database Architecture and Storage
1
DBMS Architecture and Components
Describe the layered architecture of a modern DBMS and the roles of its key components.
2
Storage Performance for Database Workloads
Compare the performance characteristics of HDDs, SSDs, and main memory for database workloads.
3
Slotted Page Design for Fixed and Variable Records
Design a page layout for storing fixed-length and variable-length records (slotted pages).
4
Heap File: Implementation and I/O Analysis
Implement a heap file structure supporting record insertion and full scans, analyzing its I/O cost.
5
Buffer Pool's Role in Data Page Management
Explain the role of the buffer pool in managing data pages in memory.
6
CLOCK Buffer Pool Manager
Implement a buffer pool manager using a CLOCK replacement policy.
7
Optimizing Query Performance: Buffer Pool & Page Pinning
Analyze the impact of buffer pool size and page pinning on query performance.
Previous module
Next module
Indexing Structures: B+ Trees and Hashing