architecturedistributed-systemsystem-designdistributed-database

How to design a distributed write-heavy data store


It's actually an interview question I'm thinking of for 2 month and can't find a suitable architecture.

The problem

We want to build a small analytics system for fraud detection on orders.

System has the following requirements

The system needs to provide following API


Solution

  • Look at using druid database. If you time series data

    https://druid.apache.org/ - This has been used as analytics db at scale in Fortune 500 companies