HardDesign: E-Commerce System (Amazon)

How do you shard the orders database to support efficient queries by both user_id and order_id?

— Tests your understanding of this concept.

Answer Options

AShard by order_id only
BShard by user_id; maintain a lookup table order_id → shard for direct order access
CShard by date
DDon't shard — use read replicas only

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 22+ more Design: E-Commerce System (Amazon) questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the Design: E-Commerce System (Amazon) topic (System Design Cases).

Learn Design: E-Commerce System (Amazon)→Browse All Questions

More Design: E-Commerce System (Amazon) Questions

Why is Redis preferred for shopping cart storage over a relational database?

Hard

A product has 10 units in stock. 100 users all click 'Buy' simultaneously. How do you prevent overselling?

Hard

What is an idempotency key in payment processing?

Hard

Why should raw credit card numbers never be stored in your e-commerce database?

Hard

During Amazon Prime Day, your checkout service gets 10,000 orders/sec (normally 100/sec). How do you handle this?

Hard