This section explains about Oracle Insurance Data Foundation (OIDF), its components, its relationship with Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), and the key prerequisites to run OIDF.
Topics:
· Overview
· Relationship to Oracle Financial Services Analytical Applications
· OIDF Prerequisite Components and Tools
Oracle Insurance Data Foundation (OIDF) is an analytical data warehouse platform for the Insurance industry. OIDF combines an industry data model for Financial Services along with a set of management and infrastructure tools that enables Financial Services institutions to develop, deploy, and operate analytical solutions covering key functional areas in Financial Services, including:
· Enterprise Risk Management
· Enterprise Performance Management
· Customer Insight
OIDF supports a variety of insurance business segments under Direct insurance contracts namely Life Policies, Health Policies, Annuities, Property and Casualty policies, and Retirement Policies and under indirect or reinsurance business segment it supports reinsurance held as well as reinsurance issued
OIDF is a comprehensive data management platform that helps Insurance Companies to manage the analytical data life cycle from sourcing to reporting, as a consistent platform and toolset.
OIDF consists of the following components, which are explained in additional detail in the next chapter:
Table 2: OIDF Components and their description
Criteria |
Description |
OIDF Analytical Warehouse Data Model |
· OIDF Analytical Warehouse Data Model is a Physical Data Model that supports data sourcing and reporting related to key analytical use cases in the Insurance industry. · The Warehouse Model is a Physical Data Model is readily deployable, and consists of database object definitions, and additional supporting scripts. · It is organized into two distinct sets of tables based on purpose: § The Staging Model: This model facilitates data sourcing from the Insurance provider’s internal operational systems such as Policy or Contract systems, investments, Claims systems, Master Data Management systems, and so on. § The Reporting Model: This model facilitates the storage of outputs from analytical tools, applications, and engines in a manner that is conducive to BI reporting. · OIDF Analytical Warehouse Model is typically deployed into production via a set of management tools called the Oracle Financial Services Analytical Application Infrastructure (OFSAAI). The AAI application is a separate product and is a prerequisite for OIDF (see the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.0.0.0). |
Supporting Scripts |
Supporting Scripts are scripts provided as part of the OIDF package for basic operations such as internal data movement between the staging and reporting areas. |
The OIDF is very closely related to the Oracle Financial Services Analytical Applications (OFSAA) in the following ways:
· Data Model
§ OIDF Staging Model provides the complete data sourcing foundation for OFSAA applications. All use case or application-specific input data requirements are captured as part of the Staging Data Model. OIDF Staging Model is a combination of all staging models supplied with each OFSAA application.
§ OIDF Reporting Model provides a complete reporting data model common to all the OFSAA Business Intelligence (BI) applications. This includes a single set of conformed dimensions and unified fact tables used for cross-functional reporting. OIDF Reporting Model is the superset of all the BI-application specific reporting models.
§ Synchronized Releases: Staging Model and Reporting Model, which are part of an OIDF release, are updated to reflect prior application-specific releases. This means that the latest release of OIDF (8.1.0.0.0) reflects all prior application releases across OFSAA from a data model perspective, with respect to Staging Model and Reporting Model.
· Infrastructure
§ The Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) is the same infrastructure that is used to deploy and manage an OIDF instance.
§ The same collection of tools (OFSAAI) is used to manage a deployed instance of OIDF.
These are the tools used to manage the data lifecycle in OIDF:
· Model Upload
· Unified Analytical Metadata (UAM)
· Data Quality Framework
· T2T framework
· Mart Management Framework
The key prerequisites for running the OIDF application are listed as follows:
Table 3: Prerequisites for the OIDF Application Pack
Component |
Provider |
Purpose |
Oracle Financial Services Analytical Applications Infrastructure version 8.1.0.0.0 |
Oracle |
OFSAAI is the platform on which the OIDF application is deployed and operated. It represents the OIDF 'runtime' environment and consists of a number of tools used to manage the data lifecycle within OIDF, from sourcing to reporting*. |
Oracle Database Enterprise Edition 18c |
Oracle |
OIDF is certified on Oracle Database releases 11gR2 and higher. |
erwin Data Modeler application version 9.8 |
Computer Associates (CA) |
erwin is a Data Modeler application that provides a visual environment to manage the complex enterprise data environment. |
*OFSAAI, the infrastructure platform consists of its own prerequisites and supporting documentation.