SD
System design: sheet register
Every topic the design round can reach, one drawing sheet each. Transactions and locking come first.
Part IThe round3/3
- R1The 60 minutes →issued
- R2Estimation →issued
- R3Requirements to API →issued
Part IIData and storage4/4
- D1Storage engines →issued
- D2Indexes →issued
- D3Data modeling →issued
- D4Choosing a database →issued
Part IIITransactions, isolation and locking9/9
- T1ACID, the log and durability →issued
- T2Isolation levels and anomalies →issued
- T3MVCC →issued
- T4Locks inside the database →issued
- T5Concurrency control strategies →issued
- T6Distributed locks and fencing →issued
- T7Distributed transactions and sagas →issued
- T8Booking: hold and confirm several nights →issued
- T9Money: ledgers and exactly-once →issued
Part IVDistribution7/7
- X1Replication →issued
- X2Partitioning and sharding →issued
- X3Consistency models →issued
- X4Time and order →issued
- X5Consensus →issued
- X6Membership and failure →issued
- X7Conflicts and CRDTs →issued
Part VBuilding blocks12/12
- B1Networking →issued
- B2Load balancing →issued
- B3API gateway and rate limiting →issued
- B4Caching →issued
- B5CDN and edge →issued
- B6Queues and logs →issued
- B7Stream and batch →issued
- B8Search →issued
- B9Blob storage →issued
- B10Probabilistic structures →issued
- B11Geo indexes →issued
- B12Time series and analytics →issued
Part VIReliability, security, operations6/6
- O1Availability →issued
- O2Resilience patterns →issued
- O3Observability →issued
- O4Change and migrations →issued
- O5Security →issued
- O6Multi-tenant SaaS →issued
Part VIICase studies9/27
- C1URL shortener →issued
- C2Rate limiter →issued
- C3Key-value store →issued
- C4Unique ID generator →issued
- C5News feed →issued
- C6Chat and presence →issued
- C7Notificationsplanned
- C8Search autocompleteplanned
- C9Video upload and streamingplanned
- C10File syncplanned
- C11Object storage →issued
- C12Distributed cache →issued
- C13Message queueplanned
- C14Metrics and alertingplanned
- C15Ad-click aggregationplanned
- C16Stream processingplanned
- C17Job schedulerplanned
- C18Web crawlerplanned
- C19Paymentsplanned
- C20Digital walletplanned
- C21Leaderboardplanned
- C22Ride matchingplanned
- C23Stock exchangeplanned
- C24Payroll run →issued
- C25Expense-policy violationsplanned
- C26Approval workflow engineplanned
- C27Employee directory and permissionsplanned