Sign in to save your learning paths. Guest paths may be lost if you clear your browser data.Sign in

Topic: DBMS internals and normalization: file and disk block layout, buffer management, B+ tree, Bloom filter, LSM tree

Master database architecture and data structures for your upcoming exam

8 lessons
3 weeks
800 XP
Your progress0 / 800 XP
Click a lesson to start learning!
Lessons
1
Welcome to Database Storage and Normalization
Understand core database goals and basic normalization rules starting today
Quick winBeginnerMilestone
+50 XP
~5 min
2
File Structure and Disk Block Layout
Learn how databases physically store data blocks on storage hardware
TheoryBeginner
+75 XP
~7 min
3
Buffer Management and Paging Strategies
Discover how the buffer pool manages data between disk and memory
IntermediateTheoryMilestone
+75 XP
~10 min
4
B+ Trees: The Standard Indexing Method
Master B+ tree structures for efficient range queries and data retrieval
PracticeIntermediateMilestone
+100 XP
~12 min
5
LSM Trees for Write-Heavy Workloads
Explore Log-Structured Merge-Trees and their advantages over traditional B+ trees
AdvancedTheory
+100 XP
~14 min
6
Efficient Set Membership with Bloom Filters
Learn why Bloom filters are essential for high-performance read operations
AdvancedQuick winMilestone
+125 XP
~15 min
7
Normal Forms and Relational Database Design
Practical application of normalization from 1NF to BCNF for exams
PracticeIntermediate
+125 XP
~18 min
8
Capstone: Full DBMS Architecture Exam Prep
Connect all components into a cohesive database engine architectural overview
ProjectMilestoneMilestone
+150 XP
~20 min

Ready to start?

Jump into your first lesson and start learning.

Start Learning