##### 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.

This question evaluates a candidate's ability to design scalable analytics schemas and event-driven data flows for high-throughput, near-real-time tracking, testing competencies in data modeling, ingestion architecture, and query performance.

How do I approach System Design interview questions?

System Design questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master system design interviews.

What difficulty level is this interview question?

This is a medium difficulty System Design question, commonly asked during Technical Screen rounds at Axon.

What role is this question designed for?

This question is commonly asked for Software Engineer candidates at Axon during technical interviews.

Design analytical tracking database | Axon Interview Question

Design an Analytical Database for User Actions

Context

You are building an analytics data store to track user behavior and commerce events so that product and business teams can run reliable, fast queries. Assume web and mobile clients emit events at scale (millions/day). Latency target for analytics is minutes, not milliseconds.

Events to Track

login
search_item
view_item
add_to_cart
view_cart
purchase
view_order

Example Queries to Support

How many users from Asia viewed item A this month?
What are the three highest-value orders at present?

Task

Describe the schema, event model, and data flow for an analytical database that can efficiently answer the above and similar pre-written queries.

Design an Analytical Database for User Actions

Context

Events to Track

login
search_item
view_item
add_to_cart
view_cart
purchase
view_order

Example Queries to Support

How many users from Asia viewed item A this month?
What are the three highest-value orders at present?

Task

Describe the schema, event model, and data flow for an analytical database that can efficiently answer the above and similar pre-written queries.

Design analytical tracking database

Quick Overview

Design an Analytical Database for User Actions

Context

Events to Track

Example Queries to Support

Task

Solution

Comments (0)

Design analytical tracking database

Quick Overview

Design an Analytical Database for User Actions

Context

Events to Track

Example Queries to Support

Task

Solution

Comments (0)