IBM Insurance Information Warehouse
Accelerates the design of governance data warehouse and business intelligence solutions, based on insurance business requirements
Businessman and businesswoman sitting in foyer working on laptop, elevated view
Glossaries and data models for the insurance industry
IBM Insurance Information Warehouse is an industry blueprint that provides business vocabularies, data warehouse design models and analysis templates. It helps to accelerate the development of data architecture, data governance and data warehouse initiatives. The IBM Insurance Information Warehouse data model provides a comprehensive, scalable and flexible framework for strategic insurance data initiatives.
Benefits Reduce cost and project risk

Sound infrastructure techniques, data management methods, rich functional content and an implementation roadmap help to reduce data warehouse development costs and minimize project risks.

Regulatory compliance support

The solution helps address regulatory compliance issues associated with reporting by providing the right level of data granularity. Examples include the GDPR, the CCPA and Solvency II.

Data consolidation

Consolidating financial and actuarial data gives you more control, while reducing the time it takes to scope requirements, perform subsequent customization and carry out data warehouse extensions.

Key features Business terms

With no modeling or abstraction involved, business terms define in plain language the industry concepts involved in the insurance industry. Clearly defined business terms help support standardization and communication within an organization. Mapping to the data models makes it possible to create a common, enterprise-wide picture of the data requirements and transform IT data structures based on those requirements.

Dimensional warehouse model

The dimensional warehouse model provides the data design support needed to transform enterprise-level business requirements into efficient, business-specific structures dedicated to the design of a dimensional data repository. The comprehensive logical data models contain the predefined data warehouse structures required to store all financial services data in an efficient layout for analytics.

Supportive content

Supportive content captures non-reporting requirements in a particular domain and relates them to the data warehouse model entities, relationships and attributes. It provides a method of mapping both external and internal terms, from business standards and other requirements to business terms and atomic and dimensional warehouse models.

Support for data privacy and data protection (GDPR/CCPA)

The IBM solution provides an industry-specific vocabulary that can help discover and govern privacy data. It includes KPI templates for regulatory reporting and a hierarchy of General Data Protection Regulation (GDPR) and California Consumer Privacy Act (CCPA) terminology. The glossary and underlying data warehouse models help organizations ensure that their enterprise data architecture is able to provide the necessary data artifacts to report on data protection issues.

Read the white paper (2.8 MB)
Analytical requirements

Analytical requirements reflect the most common queries and analyses for business performance measurement and reporting, while supporting other analytical functions such as ad hoc reporting and decision support. Over 140 predefined business reporting requirement templates are provided, addressing the common business reporting and analysis requests from risk, finance, compliance, CRM and line-of-business users.

Solvency II

IBM Insurance Information Warehouse provides the necessary modeling tools and support for requirements gathering to accelerate Solvency II implementations and build a flexible, fit-for purpose risk management warehouse. The models make up a flexible, scalable solution and provide a unified view of critical business data for risk management. Coverage for Solvency II includes support for asset management; balance sheet; premiums, claims and expenses; and reinsurance, life and non-life technical provisions. Aligned to data point model 2.3.0.

Business data model

This is the first point where various business requirements are brought together and modeled in an entity relationship format. This component includes common design constructs that can transform into separate models for dedicated purposes, such as operational data stores, warehouses and data marts. Designed for the insurance industry, the business data model contains thousands of business definitions and provides an enterprise-wide view of data common to all insurers.

Atomic warehouse model

The atomic warehouse model is a logical model consisting of the data structures typically needed by an insurer for a data warehouse. The comprehensive logical data models contain the predefined data warehouse structures required to store all financial services data in an efficient layout for historical and atomic data.

Related products
IBM Banking and Financial Markets Data Warehouse

Accelerates the design of an enterprise data warehouse or business intelligence solution, based on financial services business requirements.

Explore IBM Banking and Financial Markets Data Warehouse
IBM Data Model for Energy and Utilities


Predefined energy and utilities-specific vocabularies, KPIs and data structures, which can help accelerate enterprise governance and analytics projects.

Explore the IBM Data Model for Energy and Utilities
IBM Unified Data Model for Healthcare

Predefined healthcare-specific vocabularies, KPIs and data structures, which can help accelerate enterprise governance and analytics projects.

Explore the IBM Unified Data Model for Healthcare
Take the next step
More ways to explore Documentation Support