Financial Services Logical Data Model (FS LDM)

This is a reference model of the Financial Services domain that covers Banking and Capital Markets. This model captures the business processes of a typical Financial Services institution in detail. These business processes primarily include core banking business activities such as Retail Banking, Corporate or Merchant Banking, Wealth Management, Trading, and Securities Services.

This is a logical data model, which means that it cannot be readily used. The structures modeled in the OFSDF LDM provide an abstract, graphical model of the Financial Services domain using Entity-Relationship modeling. Consider LDM as a detailed blueprint for organizing data within a Financial Services institution. It provides a reference guide for institutions to understand the salient data related to a specific business process.

To use OFSDF, customers must deploy OFSDF Analytical Warehouse Model derived from LDM (blueprint).

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, unlike OFSDF LDM. 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 Analytical Application Infrastructure (OFSAAI). AAI is a separate product, and is a prerequisite for OFSDF. For more information on AAI, see Infrastructure.

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.