Machine Process Event Log Schema

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We collect structured logs from a fleet of machines. Each machine runs many processes, and we need to track when each process runs and how long it takes. Data scientists need to query metrics like average elapsed time per process and plot process timelines across machines. Design the data model, and describe how you'd load this data via an ETL.

Summary

Machines fire events. Pair them up before they bury you.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.