Optimistic Concurrency Control

设计一套 eBay 式的竞拍系统——竞拍者在活跃的商品上激烈竞价，尤其在临近结束时竞争最凶，而系统绝不能把落标的出价当成中标，也不能让竞拍以不一致的价格结束。

设计票务系统。请覆盖Seat inventory model and seat-map representation for a venue/event, including seat status transitions, Reservation hold with TTL: reserve then confirm two-phase flow, and auto-release when...

设计Uber (Ride Hailing)。请覆盖Geospatial indexing trade-off: geohash vs quadtree vs S2/H3 cells for storing and querying driver locations, High-frequency driver location ingestion: update interval vs GPS...