PracHub
QuestionsPremiumLearningGuidesInterview PrepCoaches
|Home/System Design/Axon

Design analytical tracking database

Last updated: Mar 29, 2026

Quick Overview

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.

  • medium
  • Axon
  • System Design
  • Software Engineer

Design analytical tracking database

Company: Axon

Role: Software Engineer

Category: System Design

Difficulty: medium

Interview Round: Technical Screen

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

Quick Answer: 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.

Related Interview Questions

  • Design fulfillment truck routing and inventory system - Axon (medium)
  • Design camera-footage upload with custody chain - Axon (medium)
  • Design device logging system with offline upload - Axon (medium)
  • Design an image-to-multilanguage translator - Axon (medium)
  • Design a Test Orchestration System - Axon (medium)
Axon logo
Axon
Aug 4, 2025, 10:55 AM
Software Engineer
Technical Screen
System Design
15
0

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

  1. How many users from Asia viewed item A this month?
  2. 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.

Solution

Show

Comments (0)

Sign in to leave a comment

Loading comments...

Browse More Questions

More System Design•More Axon•More Software Engineer•Axon Software Engineer•Axon System Design•Software Engineer System Design
PracHub

Master your tech interviews with 7,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.