The scenario
A financial services firm needs to standardize data models across trading systems, centralizing instruments, market data, trades, and counterparty info to ensure regulatory compliance and consistent reporting.
What is in this drawing
Read the decisions behind it.
01
Use LEI code as unique identifier for counterparties
02
Separate buyer and seller accounts via foreign keys from Trade table
03
Store market data with timestamps for historical analysis
When integrating multiple trading systems or building a data warehouse for financial analysis.
More like this