SRS Document

[ats1999]

Features

• [x] 1. API Service for users to send events (Dimension & Values)
• [x] 2. API Service for users to query data (Dimension, Filter & Metric)
• [x] #5
• [ ] 4. Alert Engine
• [x] 5. Authentication Support
• [ ] 6. Sharing of report
• [x] #6
• [ ] 8. Rate Limit(Based on sender id(ip, user id,etc))?
• [ ] 9. System should be database agnostic, I should be able to use click house, mysql, oracle etc? Users can plug in their databases as and when they want.
• [ ] 10. System should be message queue agnostic, it should be able to use kafka, rabbitMQ, etc
• [x] #8
• [x] 12. Should we use schema evolution?
• [x] #7
• [x] #9

---

• User specified Time Zone Support?

  Request

  Users will request this API service using key/value pairs, for example POST /api/event

  {
  "url":"https://dsabyte.com/blog/dsabyte/news/dsabyte-Open-Graph-Image-Generator-26384f92-83da-4da6-92fd-a8e5ccd73dc1",
  "domain":"dsabyte.com",
  "path":"/blog/dsabyte/news/dsabyte-Open-Graph-Image-Generator-26384f92-83da-4da6-92fd-a8e5ccd73dc1",
  "country":"IN",
  "device":"DESKTOP",
  "ip":"127.0.0.1",
  "browser":"Chrome",
  "os":"linux",
  "ts":"1706380834215"
  }

Query Data

GET /api/query?...

{
    "from":"today",
    "to":"3 days before",
    "dimensions": ["device","country"],
    "filters":{
        "country":"IN",
        "domain":"ogp.dsabyte.com" 
   },
  "metric":"....??"
}

[ats1999]

References Design Document

• https://github.com/southernkasaist/ga-system-design
• https://www.youtube.com/watch?v=kIcq1_pBQSY&pp=ygUeZ29vZ2xlIGFuYWx5dGljcyBzeXN0ZW0gZGVzaWdu
• learn from grafana visulation

[ats1999]

Sales Data

{
    "user":"u1",
    "product":"p1",
    "price":25
}

// QUERY
// user wants to get total price and avg price of products sold within specific date range for any particular product or set of products
dimension = price
filter
      - date range
      - product=P[x]
metric
     - avg(price)
     - sum(price)

[ats1999]

Compatation of Data

We need to aggregate data of 1 hour, or day to reduce data size. How can we compact age property? It should be always absolute