پديدآورندگان :
P. Deshpande Shrinivas shrinivasdeshpande@gmail.com Associate Professor,P.G.D.C.S.T, D.C.P.E, H.V.P.M, Amravati, India; , R. Bhedi Vaibhav vaibhav_bhedi@rediffmail.com Assistant Professor,VMV Commerce, JMT Arts and JJP Science College, Nagpur, India; , A. Lanjewar Ujwal ualanjewar@gmail.com Assistant Professor, VMV Commerce, JMT Arts and JJP Science College, Nagpur, India; , R. Sirsat Sandeep sandeep_sirsat@rediff.com Department of Computer Science,Shri Shivaji Science Arts College, Chikhli, India;
كليدواژه :
SQL , ETL , BUID , EIS and DSS.
چكيده فارسي :
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.
