International Journal of Computer
Trends and Technology

Research Article | Open Access | Download PDF

Volume 33 | Number 1 | Year 2016 | Article Id. IJCTT-V33P116 | DOI : https://doi.org/10.14445/22312803/IJCTT-V33P116

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

Nikhita Mathur

Citation :

Nikhita Mathur, "An Overview of Data Warehouse and OLAP Technology Used in Banking System," International Journal of Computer Trends and Technology (IJCTT), vol. 33, no. 1, pp. 76-79, 2016. Crossref, https://doi.org/10.14445/22312803/ IJCTT-V33P116

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.

Keywords

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

References

[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, http://www.redbook.ibm.com, 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