Database Engineering

Advanced database system designs: data storage strategies, indexing, caching, and stream replication.

Advanced6 steps~1.2 hours
Progress0/6
01Hash IndexesFoundations

Designing hash tables and uniform lookup key systems.

10 min read

02SSTable Bloom FiltersDatabase Systems

Skipping empty search blocks before hitting disk files.

10 min read

03B-Tree IndexesDatabase Systems

In-place modifications, query search logs, and disk seeks.

12 min read

04LSM Write-PipesDatabase Systems

Batching memory writes, sequential flushes, and background merges.

12 min read

05Active Cache InvalidationCaching Infrastructure

Cache eviction policies and write-behind buffering.

16 min read

06CDC ReplicationsDatabase Systems

Streaming transactional commits to external replica logs.

12 min read