Global Commerce Data Platform Blueprint

Design data architecture for global commerce. Orders require sub-second operational reads, analytics needs hourly freshness, and compliance needs immutable audit history. Propose ingestion-storage-serving flow, one key trade-off, and one validation metric.

orders_oltp(order_id, tenant_id, status, amount, created_at), order_events(event_id, order_id, event_type, event_ts), analytics_orders_hourly(order_hour, tenant_id, revenue)