Design a Streaming Top-Ten Sales Dashboard

Question

Design a streaming dashboard that displays the top ten sales in real-time for eBay.

Codemia · Accepted Answer

To design a streaming top-ten sales dashboard, we first need to define the requirements. The dashboard should display the top ten sales in real-time, updating dynamically as new sales occur. It will require data from eBay's sales database, and the user interface should be intuitive, allowing users to filter by categories or time frames.

The high-level architecture of the dashboard can be broken down into several components: 
1. **Data Ingestion**: Use a message broker like Apache Kafka to stream sales data in real-time. 
2. **Processing Layer**: Implement a stream processing framework such as Apache Flink or Spark Streaming to compute the top ten sales. 
3. **Storage**: Utilize a NoSQL database like MongoDB for storing sales data and a caching layer (e.g., Redis) for quick access to the top ten results. 
4. **Frontend**: Develop the user interface using React or Angular, which will subscribe to updates and render the data.

In the processing layer, we will consume messages from Kafka and maintain a running tally of sales counts. A sliding window approach can be used to ensure that we always have the top ten sales available. This involves maintaining a priority queue or a sorted list that updates as new sales data comes in. We will also implement logic to handle ties in sales amounts.

One trade-off to consider is the balance between real-time updates and system load. While real-time updates are crucial, excessive updates can overwhelm the frontend. We can mitigate this by batching updates or throttling the frequency of updates sent to the client. For scaling, we can horizontally scale our processing nodes and use sharding in our database to handle increased sales volume as eBay grows.

In summary, the streaming top-ten sales dashboard for eBay requires a robust architecture that can handle real-time data efficiently. By leveraging technologies like Kafka, Flink, and NoSQL databases, we can create a responsive and scalable solution that meets user needs while ensuring performance.

Design a Streaming Top-Ten Sales Dashboard

eBay

What the Interviewer Expects

Key Topics to Cover

How to Approach This

Possible Follow-up Questions

Sharpen Your Skills on Codemia

Sample Answer

Requirements

High-Level Design

Submit Your Answer

eBay Software Engineer Interview Guide

Related Questions

Design a high-throughput Inventory Management System

Design a low-latency Rate Limiting System

Design a fault-tolerant Payment System

Design a fault-tolerant Messaging System

Design Walmart Product Search