The Data Warehouse supports the data needs of your organisation.
Our Data Warehouse and Marts are implementations of our SPUD schema customised to support the needs of the organisation. Implementations are available in Oracle, SQL Server, Sybase, DB/2 and MySQL. Subject areas covered include:
- Securities, cash and pricing data
- Ratings, sectors and other classifications
- Products and product groups
- People and organisations
- Funds, structured products, investment accounts & portfolios, indices and benchmarks, models
- Asset positions and weightings
- Transactions and accruals
- Orders, allocations and executions
- Financial accounts & ledgers
- Mandates, prospectuses and investment restrictions
- Allocations and summary holdings
- Document management
- Performance and attribution analysis
- Workflow
- Compliance and Disclosure
- Risk management
- Research, estimates and fundamentals