System designFoundations

Data modeling and storage

Easynot started
Mediumnot started
Hardnot started
ContinueRead the guideView as list
StatusFormatCompany style
Easy
URL shortener for an internal company toolDesignDesign25 minPastebin with expirationDesignDesign30 minParking lot spot assignmentDesignDesign30 minMulti-user to-do backendDesignDesign25 minUser settings storeDesignDesign25 min
Medium
Write-ahead log for OLTPDesign · Oracle styleOracle styleDesignOracle style40 minLSM vs B+tree engine choiceDesign · Meta styleMeta styleDesignMeta style40 minOpen issues sorted indexDesignDesign35 minParquet schema evolutionDesign · Databricks styleDatabricks styleDesignDatabricks style40 minStorage tiering and lifecycleDesign · Disney styleDisney styleDesignDisney style40 minDesign bloom-filter strategy for LSMDesign · Meta styleMeta styleDesignMeta style40 minComposite index designDesign · Stripe styleStripe styleDesignStripe style40 minSchema evolution governanceDesign · Databricks styleDatabricks styleDesignDatabricks style35 minMedia rights availability catalogDesign · Netflix styleNetflix styleDesignNetflix style40 minIn-memory key-value storeDesignDesign35 minBlog comment systemDesignDesign35 minCSV report generatorDesignDesign30 min
Hard
LSM-tree metrics databaseDesign · Meta styleMeta styleDesignMeta style50 minOn-disk B+tree ACID indexDesign · Oracle styleOracle styleDesignOracle style50 minLSM compaction space amplificationDesign · Meta styleMeta styleDesignMeta style45 minBlob store durability and tieringDesign · Amazon styleAmazon styleDesignAmazon style50 minEvent schema evolutionDesign · Databricks styleDatabricks styleDesignDatabricks style45 minMetrics downsampling engineDesign · Uber styleUber styleDesignUber style50 minGraph database storage layerDesign · Meta styleMeta styleDesignMeta style50 minColumnar analytics storageDesign · Snowflake styleSnowflake styleDesignSnowflake style50 minLSM compaction for TTL dataDesign · Meta styleMeta styleDesignMeta style45 minSeries indexing under cardinality explosionDesign · Uber styleUber styleDesignUber style50 minColumnar table mutationsDesign · Databricks styleDatabricks styleDesignDatabricks style50 minDesign social graph edge storageDesign · Meta styleMeta styleDesignMeta style50 min