IDS GmbH Analysis and Reporting Services – Optimizes Central Data Warehouse System for Allianz
 
 

IDS GmbH Analysis and Reporting Services – Optimizes Central Data Warehouse System for Allianz

Printer View Printer View

IDS GmbH – Analysis and Reporting Services is a subsidiary of Allianz SE and specializes in providing operative investment controlling services for the capital investments of the Allianz Group and third-party clients. Allianz’s investment controlling services apply both to investments made by its insurance companies and asset management division. For this purpose, IDS operates and maintains a financial database for Allianz.

 
 

 
 

Challenges

A word from IDS GmbH – Analysis and Reporting Services

  • “Oracle Exadata Database Machine is a cost efficient, high performance, and scalable system that has provided us with an optimal data warehouse infrastructure, not only for the next three years but for the long term.” – Holger Haun, Managing Director, IDS GmbH – Analysis and Reporting

  • Eliminate storage bottlenecks caused by performance and risk analyses of the company’s finance and insurance portfolio, as well as finance-specific reporting for the Allianz Group
  • Provide a solution able to handle the number of source systems—including stock market prices, share price indices, and inventory data—which grew from 200 to 250 since the implementation of a data warehouse
  • Perform overnight batch jobs in required time frames to provide up-to-date data for analysis
  • Ensure support for an active user base—which had doubled since the original data warehouse deployment
  • Provide capacity to reliably and efficiently handle ad hoc queries and generate financial and risk analysis reports several times daily rather than monthly—with no performance issues

Solutions

Oracle Product and Services

  • Worked with Information Systems Engineering GmbH to perform a smooth migration of the disk-based Oracle Data Warehouse to Oracle Exadata Database Machine X2-2 without coding or design modification—eliminating programming costs
  • Migrated all financial data—approximately 12 terabytes(TB)—in one day, to support continued data growth
  • Ensured high performance data consolidation from 250 source systems—including stock market prices and share price indices, as well as inventory data from more than 7,000 portfolios with more than 250,000 different active investments—within the defined timeframe for each
  • Optimized performance by a factor of four by deploying the system out-of-the-box—without any tuning or customization
  • Achieved efficient access for 1,500 active financial users
  • Tripled performance and storage capacity—from 50 TB to 150 TB—without increasing total cost of ownership

Partner

  

Resources