Databases
- Flash Sale / Ticketmaster
—
concurrency
,
consistency
,
databases
and +2 more
A high-resiliency architecture for extreme traffic bursts, utilizing virtual waiting rooms and atomic inventory management to ensure fair distribution under load.
- Payment System
—
consistency
,
data-flows
,
databases
and +2 more
A high-integrity architecture for global payment gateways and internal ledgers, emphasizing rigorous idempotency, eventual consistency, and deterministic recovery.
- Proximity Service for Maps
—
caching
,
databases
,
geospatial
and +1 more
An optimized system design for discovering nearby points of interest with ultra-low latency; deeply focusing on efficient spatial indexing via Geohashing, Quadtrees, and read-heavy caching tiers.
- SQL vs. NoSQL
—
consistency
,
databases
,
replication
A decision-making framework for choosing between SQL (relational, strict ACID) and NoSQL (distributed, flexible schemas) databases, evaluating data structures, horizontal scalability needs, and tunable consistency requirements.