Dynamic Data Warehouse
Foundation for Enterprise-Wide Information Systems

Dynamic Data Warehouse covers all data requirements for the following applications:

• Repository of Front, Middle and Back office systems and Market Data
• Enterprise Risk Management (Market, Credit, Liquidity, Operational)
• Enterprise Application Integration (EAI) infrastructure
• Capital Allocation
• Asset Liability Management
• Portfolio Management
• Financial Control, Management reporting and Audit
• Customer Relationship Management (CRM)
• Straight Through Processing (STP).
• e-Business and WEB Services

AXIOM Software Laboratories' Dynamic Data Warehouse has been designed to handle the flow of the information specific to the needs of financial and energy firms. The system provides full access to all current and historical data available from internal operational systems and external services integrated, refined and aggregated according to the business requirements.

Axiom’s Dynamic Data Warehousing approach highlights:

• Flexible and Extendible Data Model to accommodate enterprise and external data sources
• High volume, High performance, reliability of information access and storage
• Control over Data accumulation methods for transactional, market, reference and analytical data
• Support dynamic creation and storage of multiple data marts from aggregation and analytical process
• Full enterprise data dictionary by source and data model accessible to applications via API
• Large library of data templates for third party front, middle and back office and market data systems
• Comprehensive data model for all market data, statistical matrices and financial curves historical and current
• Complete repository for Meta Data and Visual Business Rules
• Complete data warehouse API for in-house application and WEB services development

Dynamic Data Warehouse consists of a group of interrelated logical and physical databases that contain transactional information consolidated from Front, Middle and Back office systems throughout the whole enterprise, market data acquired from internal processes or external providers, institution-specific legacy data, reference data and results of the analytical processes. The physical warehouse can be on any RDBMS server, centralized or distributed.

Data Warehouse Components:

• Front/Middle/Back office database - dynamic repository for deals/transactions, cash flows, physical, financial and risk positions, accounting etc.
• Operational Database – collection of historical loss and event data, causes, incidents, key risk indicators, etc.
• Control/Reference database - repository of reference data from legacy systems: customer information, business lines, GL, products, etc.
• Business rules database - contains meta data that corresponds to business data requirements that constitutes a user-defined portfolio structures, corporate hierarchies, netting methods, limits, aggregation levels, source data dictionary etc.
• Market database - current and time series (historical) data: energy prices, spreads, electricity, petroleum, natural gas and other commodity prices, market factors, volatility's and correlations matrices, default rates, yield curves, forward commodity curves, and other calculations are also stored and maintained in this repository etc.
• Resulting Database - dynamic history of aggregations, P&L, regulatory reports, risk calculations results, exposures, distributions of losses etc.

The warehouse’s architecture has been designed to provide options for including data from numerous relational and non-relational databases, as well as the data that can be obtained only through the means of analytical applications.

The IntegrationCenter™ is a data warehouse administration system designed to provide data interfacing, data movement, data maintenance for the Dynamic Data Warehouse™ and serves as a liaison between the repository and portfolio-driven analytical applications (AXIOM’s, in-house or third party)