An Overview of Data Warehouse and OLAP Technology Used in Banking System

International Journal of Computer Trends and Technology (IJCTT)          
© 2016 by IJCTT Journal
Volume-33 Number-2
Year of Publication : 2016
Authors : Nikhita Mathur
DOI :  10.14445/22312803/IJCTT-V33P116


Nikhita Mathur "An Overview of Data Warehouse and OLAP Technology Used in Banking System". International Journal of Computer Trends and Technology (IJCTT) V33(2):76-79, March 2016. ISSN:2231-2803. Published by Seventh Sense Research Group.

Abstract -
A data warehouse is a very large database system that collects, summarizes and stores data from multiple remote and heterogeneous information sources. The data warehouse supports an OLAP tool for the interactive analysis of multidimensional data. The user analyst abstracts the data from various resources by using the OLAP operations. The basic objective of database is to provide and share information anywhere at any time. The banking system in many countries is reorganizing the communication through internet as the way of transaction. As technology developed new computerized decision support applications were studied. This paper provides detailed picture of how data warehouse and OLAP technology used in banking sector.

[1] Paulraj Ponniah, “Data Warehousing Fundamental”, New Delhi, Jonh Wiley & Sons, 2001.
[2] IDRBT Working Paper No.4, “An Approach to Establish Data Warehouse for Banks in India” ,May 2000
[3] Chuck Ballard, Dirk Herreman, Don SchauRhonda Bell,Eunsaeng Kim, Ann Valenci, , “Data Modeling Techniques for Data Warehousing”, International Technical Support Organization,, February 1998.
[4] White Paper, “OLAP Council”
[5] Erik Thomsen, “OLAP Solutions: Building Multidimensional Information Systems”, second edition [6] M/S S. Sathnanakrishanan, “Information System for Banks”, M/S/, Taxman publication, Pvt. Ltd, 2005.
[7] Qiuju Yin, Ke Lu, “Data Mining Based Reduction on Credit Evaluation Index of Bank Personal Customer”, International Conference on Future Information Technology and Management Engineering, 2010
[8] Dr. Dev. Harsh., Mishra. Suman. Kumar., “Design of Data Cubes and Mining for Online Banking System” , International Journal of Computer Applications (0975 – 8887) Volume 30– No.3, September 2011

Data warehouse, OLAP, Data cubes, Decision Support System, Data Mining.