System Design · Oracle · Hard
Required Clarifications Before committing to capacity, I would clarify: Peak arrival rate and burst factor — total records per day is not enough. Need peak records per second and worst-case burst. Average and maximum record size — drives transfer, storage, and per-message overhead. Freshness target — how quickly a record must be queryable after acceptance: p95, p99, hard deadline. Retention requirements — raw records, processed data, audit logs, and dead-letter records.…
Checking your access…