Real-time price ticks, benchmark fixings, spot assessments, forward curves — streaming continuously
Open positions, trade history, deal book, scheduled deliveries, scheduling obligations — Postgres
VaR calculations, Greeks, position P&L attribution, limit state — Postgres
Counterparty exposure, credit limits, active collateral, netting agreements — Postgres
Pipeline nominations, vessel positions, storage inventory, delivery capacity — operational DB
CDC from Postgres ETRM, risk engine, credit system, and logistics DB — positions, limits, credit state — YAML pipelines, sub-second lag, 0 custom ETL
Real-time price ticks, benchmark updates, position changes — streaming into Redis RAM as they occur
Hot live context — current market prices, open position counters, active limit state, in-flight pre-trade checks
Full deal history, P&L attribution archive, historical exposure records, counterparty transaction history at tiered cost
Regulatory context vectors, similar trade pattern library, compliance reference data
Atomic open position counters, VaR contribution, directional limit checks — Redis atomic operations
Position headroom, VaR headroom, stop-loss proximity, net limit compliance
Live counterparty exposure, credit limit consumption, collateral netting state
Spread vs. break-even, order sizing, execution routing
Execute / Resize / Pass — returned in under 7ms
Live position update, VaR contribution, limit consumption
Pre-trade audit trail, limit check results, execution rationale
Real-time price ticks, benchmark fixings, spot assessments, forward curves — streaming continuously
Open positions, trade history, deal book, scheduled deliveries, scheduling obligations — Postgres
VaR calculations, Greeks, position P&L attribution, limit state — Postgres
Counterparty exposure, credit limits, active collateral, netting agreements — Postgres
Pipeline nominations, vessel positions, storage inventory, delivery capacity — operational DB
CDC from Postgres ETRM, risk engine, credit system, and logistics DB — positions, limits, credit state — YAML pipelines, sub-second lag, 0 custom ETL
Real-time price ticks, benchmark updates, position changes — streaming into Redis RAM as they occur
Hot live context — current market prices, open position counters, active limit state, in-flight pre-trade checks
Full deal history, P&L attribution archive, historical exposure records, counterparty transaction history at tiered cost
Regulatory context vectors, similar trade pattern library, compliance reference data
Atomic open position counters, VaR contribution, directional limit checks — Redis atomic operations
Position headroom, VaR headroom, stop-loss proximity, net limit compliance
Live counterparty exposure, credit limit consumption, collateral netting state
Spread vs. break-even, order sizing, execution routing
Execute / Resize / Pass — returned in under 7ms
Live position update, VaR contribution, limit consumption
Pre-trade audit trail, limit check results, execution rationale