Design analytical tracking database
AxonSoftware Engineer · Technical Screen
Last updated
This interview question evaluates requirements, scale assumptions, API/data design, architecture, trade-offs, failure modes, and rollout in a realistic interview setting. A strong answer for Design analytical tracking database states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.
Question
Design an analytical database for tracking user actions—search item, view item page, login, add to cart, view cart, purchase, view order—so it can efficiently answer pre-written queries such as:
How many users from Asia viewed item A this month?
What are the three highest-value orders at present?
Describe schema, event model, and data flow.
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.