FINACLE OPERATIONAL DATA STORE (30-Sep-2011)

FINACLE OPERATIONAL DATA STORE

FIELD OF THE DISCLOSURE

The disclosure relates generally to data warehouse system. In particular, the disclosure relates to finacle operational data store, the data warehouse product from finacle.

BACKGROUND

Banks deal with huge amount of data which are dispersed across different system in organization's environment. The challenges to banks include ability to quickly generate a report from disparate data source at minimal cost and effort, confidence on the quality of data presented in the report. Presently, there is no data model exists on top of finacle. There is no specific integration of data layer from Finacle suite of applications such as Core, CRM, e-Banking to be able to do MIS reports and generate downstream feeds on top of it.

Consequently, there is a need for an operational data store for finacle which empowers banks with a secure and reliable technology infrastructure to derive optimal value from data and meet a whole range of operational, business and strategic objectives.

ABSTRACT

The disclosure provides an operational data store (ODS) for finacle that supports a business- entity based data model for extracting data from source application such as Finacle core, Finacle CRM, Finacle treasury and Finacle eBanking. The Finacle ODS includes functional business views which acts as a business layer on top of source system base tables for the specific need of ODS. It further includes Extraction Transformation Load (ETL) program component for homogenization which enables standardization of data coming multiple data sources and also

capturing history data. The Finacle ODS again includes an error and audit management module. It also includes meta data management solution that provides descriptive information about the data that resides in the ODS and provide complete lineage across systems.

DRAWINGS

Features, aspects, and advantages of the present invention will be better understood when the following detailed description is read with reference to the accompanying drawings in which like characters represent like parts throughout the drawings, wherein:

FIG. 1 depicts the architectural diagram of Finacle Operational data store (ODS).

FIG. 2 depicts a data flow along an extraction- transformation- loading (ETL) path;

FIG. 3 depicts a downstream extracts for bank asset liability management (BALM);

FIG. 4 depicts a downstream extracts for relationship based pricing engine calculation;

FIG.5 depicts a downstream extracts for regulatory reporting;

FIG. 6 depicts a downstream extracts for analytics to Finacle Analyz (FCA).

DETAILED DESCRIPTION

Many modifications and adaptations will be apparent to those skilled in the relevant art in view of the following description and the accompanying drawings. While the system and method described herein are provided with a certain degree of specificity, the present technique may be implemented with either greater or lesser specificity, depending on th...