Database structures / Data Model


I would like to see the database table structures or data model for the different sets of data such as security master, portfolio structure, positions and trades, historical market data, holiday, and configuration?

Also is there a separate data model (set of tables) to facilitate the real-time analytics part? Or is it just one set of tables that facilitates both the transactional/operational part (OLTP) and the reporting/analytical part (OLAP).


The database has each primary master in an isolated set of tables. Thus the tables for the security master are separate from those of the position master. Right now we have minimal reporting/analytical tables - the real time analytics is more user facing than database oriented.