System requirements

Functional:

1. Allow user to create an account and add their details.
2. Allow user to monitor daily metrics such as number of steps and calories burned.
3. Allow user to set goals for number of steps and calories burned.
4. Users should get notification for pending steps/calories for the set goals.
5. Users can view reports on weekly progress.

Non-Functional:

1. System needs to be highly available.
2. System can be eventually consistent, for metrics such as number of steps or calories burned, immediate update may not necessarily be desirable.
3. System should be fault tolerant and should continue to function in case of partial network failures.
4. Latency should be minimum for basic operations such as user account creation.
5. System should be able to scale with increased traffic and high user count.

Capacity estimation

1. We can assume that the application is being used worldwide and has a total user base of 10 million.
2. Out of which we can consider 1 million as the DAU count.
3. Write traffic can be handled asynchronously in this application, with every write being streamed to MongoDB using kafka or a messaging queue.
4. Read traffic will be mainly for getting the current metrics.
5. We can consider each user checks metrics about 5 times a day which will be 5 million read requests per day.
6. For storing user metadata such as height, weight we can consider about 3 KB of space per user hence a total storage size of 3 KB * 10 M
7. It would be difficult to measure the number of writes as writes will be streaming data directly onto a platform.

API design

1. /register - This API will be responsible for new account creation for the user.
2. /login - This API will be responsible for login of users, users will be able to login to the system by a username and password combination.
3. /loginSSO - This API will be responsible for SSO login if user wants to do that.
4. /create-goal - this API will be responsible for creating a daily/weekly goal for the users, this will be a POST call.
5. /view-metric/{metricName} : This API will be responsible for viewing the metric data for a user such as number of steps or calories burned, User will be able to view the data for the current day or for the last 1 week or 1 month.
6. /view-report : This API will be responsible for presenting a report to the user on the application UI for activities in the last 1 month, on UI reports can be limited to 1 month data to avoid a lot of computation.
7. /download-report : This API will be used by user to generate data over long duration and directly download the report.
8. /notifications : This API will trigger in-app notification to the user if they are behind on their goal.

Database design

1. We will be using postgres database in order to store user specific data such as user details. There will be a table called user which will store the basic details of the user.
2. There will be a credentials table as well which will store password in the encrypted format, this table will have an expiry_date column as well which will store the date of 3 months ahead of the date of password creation.
3. There will be a user_metric table which will store basic user details such as height, weight, age of the user for biometric purpose.
4. We will use mongoDB to store metrics for a user such as number of steps and number of calories burned, heart rate etc. A collection metrics will store documents for a user with metrics on a daily basis.

High-level design

Request flows

1. User Interface (UI): The front-end where users interact with the app.
2. Load Balancer (Incoming Requests): Balances user requests across multiple backend servers.
3. Backend Server: Processes user requests and interacts with the Kafka topic.
4. Kafka Topic: Streams data from the user's device.
5. MongoDB Database: Used for storing metrics.
6. Load Balancer (MongoDB Read Replicas): Balances read requests to MongoDB.
7. MongoDB Read Replica Instances: Instances that handle read queries from MongoDB.
8. PostgreSQL Database: Used for transactions that require complex queries and ACID compliance.
9. Load Balancer (PostgreSQL Read Replicas): Balances read requests to PostgreSQL.
10. PostgreSQL Write Instance: Dedicated instance for handling write operations for PostgreSQL.
11. PostgreSQL Read Replica Instances: Instances that handle read queries from PostgreSQL.

Detailed component design

1. For viewing the daily metrics the data will be streamed directly from the user's device to a kafka topic, from there the data would be pulled in into a mongodb database collection.
2. For further usages such as requests by user to view these metrics or for reporting, data can be pulled out directly by MongoDB.
3. User will also get notifications about 3 notifications a day can be sent to the user if the user is behind on their set goal, For each user who have set their goals in the system the notification module will pull up the goal vs the target achieved today and send a notification to the user if they are behind.

Trade offs/Tech choices

Explain any trade offs you have made and why you made certain tech choices...

Failure scenarios/bottlenecks

Try to discuss as many failure scenarios/bottlenecks as possible.

Future improvements

What are some future improvements you would make? How would you mitigate the failure scenario(s) you described above?