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).