advancedTop 15 System Design Questions

Design an e-commerce platform (Amazon) order management system.

Product catalog: MongoDB (variable attributes per product type) Inventory: Redis for real-time count + PostgreSQL for ACID stock management Orders: PostgreSQL for ACID transactions (payment + order + inventory must be atomic) Order history: MongoDB or Cassandra for fast retrieval by userId Cart: Redis Hash per user with TTL; persist to DB on checkout Sessions: Redis with HttpSession (Spring Sessio

Ready to master this question?

Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.

Sign in to generate a response

Next Step

Continue to Design a real-time chat application (WhatsApp/Slack).← Back to all NoSQL questions