Simulation of Secured Integrated Data warehouse Model for Financial Institute

The simulation and result analysis of integrated data warehouse for financial institute with security levels has integrated with financial transaction model, data warehouse architecture for financial institute and security model [1][2][3]. The simulation and result analysis of integrated data warehouse for financial institute with security levels has done using SQL server management studio of SQL server 2008. The data sources like Bank, Insurances, Shares, Bonds, Post Office, Income Tax, Imp/Exp and Loans data are transfer by ETL process to Data warehouse in respective data marts. The various channels like income tax department, government accountant and auditors, Government legal regulatory authority, all tax department and overall financial system will access data from data warehouse by executing SQL queries as require in simulation. The data access from various channels is nothing but results of simulated secured integrated data warehouse architecture of financial institute.

Keywords:

SQL , ETL , BUID , EIS and DSS