Components of OFSDF

2.2 Components of OFSDF

OFSDF consists of these components, which are described in additional detail in the following sections:

Table 2-1 The Components of OFSDF and their description

Criteria	Description
Financial Services Analytical Warehouse Data Model	This is a physical data model that supports data sourcing and reporting related to key analytical use cases in the Financial Services industry. Analytical Warehouse Data Model or Warehouse Model is a physical data model. Warehouse Model is readily deployable. It consists of database object definitions, and additional supporting scripts. Warehouse Model is classified into two distinct sets of tables based on purpose: Staging Model: This model facilitates data sourcing from the internal operational systems of the banks such as Lending Systems, Trading Systems, Collateral Management Systems, and Master Data Management Systems. Reporting Model: This model facilitates the storage of outputs from analytical tools, applications, and engines in a manner that is conducive to BI reporting. The Warehouse Model is typically deployed into production through a set of management tools called the Oracle Financial Services Advanced Analytical Application Infrastructure (OFSAAAI). AAI is a separate product, and is a prerequisite for OFSDF. For more information on AAI, see Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.2.0.0
Supporting scripts	As part of the OFSDF package, there are additionally a number of scripts provided for basic operations such as internal data movement between the staging and reporting areas.

Criteria

Description

Financial Services Analytical Warehouse Data Model

This is a physical data model that supports data sourcing and reporting related to key analytical use cases in the Financial Services industry.

Analytical Warehouse Data Model or Warehouse Model is a physical data model. Warehouse Model is readily deployable. It consists of database object definitions, and additional supporting scripts.

Warehouse Model is classified into two distinct sets of tables based on purpose:

Staging Model: This model facilitates data sourcing from the internal operational systems of the banks such as Lending Systems, Trading Systems, Collateral Management Systems, and Master Data Management Systems.

Reporting Model: This model facilitates the storage of outputs from analytical tools, applications, and engines in a manner that is conducive to BI reporting.

The Warehouse Model is typically deployed into production through a set of management tools called the Oracle Financial Services Advanced Analytical Application Infrastructure (OFSAAAI). AAI is a separate product, and is a prerequisite for OFSDF. For more information on AAI, see Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.2.0.0

Supporting scripts

As part of the OFSDF package, there are additionally a number of scripts provided for basic operations such as internal data movement between the staging and reporting areas.