Ocean Freight Forwarder · Data Architecture

The right store per workload

A hybrid analytical architecture for global ocean container logistics. OLAP and dimensional questions — schedule reliability, port congestion — are answered on a defended BigQuery star schema. Network and relationship questions — chokepoint reachability, disruption rerouting — are answered on the ArangoDB property graph. Each use case below is tagged with the store that answers it.

BigQuery

OLAP / dimensional — star schema
uc1BigQuery
ETA reliability & delay drivers
Which routes, carriers, and ports have the worst schedule reliability — and what drives the delay.
uc2BigQuery
Port dwell & turnaround trend
How congestion and dwell time at key ports trend over time and ripple downstream.

ArangoDB

Graph / network — property graph
uc3ArangoDB
Chokepoint risk exposure
What share of shipments transit Suez / Panama / Malacca, and the reachability impact of a closure.
uc4ArangoDB
Disruption rerouting
The detour path and added transit-time delta when a chokepoint closes — shortest viable reroute.