the Data Warehouse Design for the Bank X with Inmon Approach
Abstract
Various activities related to financial transactions such as the process of deposit and loan funds require the role of the Bank. Along with a large number of customer needs in current technological developments, the banking industry is undergoing many changes. The products offered by the Bank are becoming more diverse. Customers needs for services offered by banks are becoming increasingly high for example internet banking needs. Banks require high data storage so that the bank's business processes can run efficiently. High data requirements by banks also require ease of exchanging data. One concept that can be applied is Data Warehouse. There are various approaches in developing Data Warehouse, one of which is Inmon. This study aims to build a database design from Bank X Data Warehouse with the Inmon approach. The results of the design of the Data Warehouse Bank X database design consists of three fact tables, namely loan fact, saving fact, and portfolio fact, and two data marts, namely loans and saving.
Downloads
Download data is not yet available.
References
[1] A. Premchand and A. Choudhry, “Open Banking & APIs for Transformation in Banking,” in 2018 International Conference on Communication, Computing and Internet of Things (IC3IoT), 2018, pp. 25–29.
[2] M. Shirali-Shahreza and M. H. Shirali-Shahreza, “Mobile banking services in the bank area,” in SICE Annual Conference 2007, 2007, pp. 2682–2685.
[3] P. Subsorn and S. Limwiriyakul, “A Case Study of Internet Banking Security of Mainland Chinese Banks: A Customer Perspective,” in 2012 Fourth International Conference on Computational Intelligence, Communication Systems and Networks, 2012, pp. 189–195.
[4] R. R. W. Giri, B. R. Santoso, A. Mustikasari, and M. K. Bratawisnu, “Consumer perceptual mapping towards e-banking channel: (A study of bank BRI customer in Indonesia),” in 2017 5th International Conference on Information and Communication Technology (ICoIC7), 2017, pp. 1–4.
[5] O. J. Keuangan, “Bank Umum,” www.ojk.go.id. [Online]. Available: https://www.ojk.go.id/id/kanal/perbankan/Pages/Bank-Umum.aspx. [Accessed: 18-May-2020].
[6] H. Zhu and Y. Zou, “Analysis of E-bank Innovation in China Using a Hypercube Model,” in Seventh IEEE/ACIS International Conference on Computer and Information Science (icis 2008), 2008, pp. 678–683.
[7] Shao Mingxing, “Study on the diffusion of standardized online banking: Super-Internet-Bank system,” in 2014 11th International Conference on Service Systems and Service Management (ICSSSM), 2014, pp. 1–4.
[8] M. K. Harma and R. Dubey, “Prospects of Technological Advancements in Banking Sector Using Mobile Banking and Position of India,” in 2009 International Association of Computer Science and Information Technology - Spring Conference, 2009, pp. 291–295.
[9] A. Safari and A. Khalaf, “Banks and information technology: Marketability vs. relationships (Case study: Sarmayeh bank),” in 7th International Conference on e-Commerce in Developing Countries:with focus on e-Security, 2013, pp. 1–12.
[10] I. N. D. Kotama, A. A. G. O. K. Adnyana, and K. O. Saputra, “Design of Data Warehouse for University Library using Kimball and Ross 9 Steps Methodology,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, 2019.
[11] S. U. Khan, “Data warehouse enhancement manipulating materialized view hierarchy,” in Eighth International Conference on Digital Information Management (ICDIM 2013), 2013, pp. 369–372.
[12] L. Yessad and A. Labiod, “Comparative study of data warehouses modeling approaches: Inmon, Kimball and Data Vault,” in 2016 International Conference on System Reliability and Science (ICSRS), 2016, pp. 95–99.
[13] I. M. A. Bhaskara, L. G. P. Suardani, and M. Sudarma, “Data Warehouse Implemantation To Support Batik Sales Information Using MOLAP,” IJEET (International J. Eng. Emerg. Technol., vol. 3, no. 1, pp. 45–51, 2018.
[14] I. B. L. M. Suta, I. G. N. A. S. Mahendra, and Y. P. Sudarmojo, “Design General Hospital Data Warehouse Base on Nine Step Methodology,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, pp. 15–19, 2019.
[15] I. N. A. Prabawa, D. A. K. Arimbawa, and I. G. N. Janardana, “Analysis and Design Data Warehouse For E-Travel Business Optimization,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, 2019.
[16] A. Sumichan, I. M. G. Yudiana, M. R. Satrio, and I. M. Sudarma, “Designing a Virtual Data Warehouse in Supporting Sales Information Needs (Case Study: National Scale Building Material Store X),” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, pp. 2–5, 2019.
[17] A. . N. Narendra, S. I. Murpratiwi, and M. Sudarma, “Design of E-Grant Application Data Warehouse,” IJEET (International J. Eng. Emerg. Technol., vol. 2, no. 1, pp. 11–15, 2017.
[18] I. G. W. Darma, K. S. Utami, and N. W. S. Aryani, “Data Warehouse Analysis to Support UMKM Decisions using the Nine-step Kimball Method,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, pp. 1–4, 2019.
[19] P. V. Andreyana, P. A. Widya, and M. Suartika, “Designing Data Warehouse at the Impatient and Outpatient (Case Study: Sanglah Hospital),” IJEET (International J. Eng. Emerg. Technol., vol. 2, no. 1, p. 40, 1970.
[20] B. Inmon, Building The Data Warehouse, 2nd ed. New York: John Wiley & Sons, 1996.
[21] B. Inmon and H. W. Inmon, Building The Data Warehouse. John Wiley &Ssons, 2005.
[22] S. Rangarajan, “Data Warehouse Design – Inmon versus Kimball,” tdan.com, 2016. [Online]. Available: https://tdan.com/data-warehouse-design-inmon-versus-kimball/20300. [Accessed: 18-May-2020].
[23] O. J. Keuangan, “Lembaga Perbankan,” ojk.go.id. [Online]. Available: https://www.ojk.go.id/id/kanal/perbankan/ikhtisar-perbankan/Pages/Lembaga-Perbankan.aspx. [Accessed: 18-May-2020].
[2] M. Shirali-Shahreza and M. H. Shirali-Shahreza, “Mobile banking services in the bank area,” in SICE Annual Conference 2007, 2007, pp. 2682–2685.
[3] P. Subsorn and S. Limwiriyakul, “A Case Study of Internet Banking Security of Mainland Chinese Banks: A Customer Perspective,” in 2012 Fourth International Conference on Computational Intelligence, Communication Systems and Networks, 2012, pp. 189–195.
[4] R. R. W. Giri, B. R. Santoso, A. Mustikasari, and M. K. Bratawisnu, “Consumer perceptual mapping towards e-banking channel: (A study of bank BRI customer in Indonesia),” in 2017 5th International Conference on Information and Communication Technology (ICoIC7), 2017, pp. 1–4.
[5] O. J. Keuangan, “Bank Umum,” www.ojk.go.id. [Online]. Available: https://www.ojk.go.id/id/kanal/perbankan/Pages/Bank-Umum.aspx. [Accessed: 18-May-2020].
[6] H. Zhu and Y. Zou, “Analysis of E-bank Innovation in China Using a Hypercube Model,” in Seventh IEEE/ACIS International Conference on Computer and Information Science (icis 2008), 2008, pp. 678–683.
[7] Shao Mingxing, “Study on the diffusion of standardized online banking: Super-Internet-Bank system,” in 2014 11th International Conference on Service Systems and Service Management (ICSSSM), 2014, pp. 1–4.
[8] M. K. Harma and R. Dubey, “Prospects of Technological Advancements in Banking Sector Using Mobile Banking and Position of India,” in 2009 International Association of Computer Science and Information Technology - Spring Conference, 2009, pp. 291–295.
[9] A. Safari and A. Khalaf, “Banks and information technology: Marketability vs. relationships (Case study: Sarmayeh bank),” in 7th International Conference on e-Commerce in Developing Countries:with focus on e-Security, 2013, pp. 1–12.
[10] I. N. D. Kotama, A. A. G. O. K. Adnyana, and K. O. Saputra, “Design of Data Warehouse for University Library using Kimball and Ross 9 Steps Methodology,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, 2019.
[11] S. U. Khan, “Data warehouse enhancement manipulating materialized view hierarchy,” in Eighth International Conference on Digital Information Management (ICDIM 2013), 2013, pp. 369–372.
[12] L. Yessad and A. Labiod, “Comparative study of data warehouses modeling approaches: Inmon, Kimball and Data Vault,” in 2016 International Conference on System Reliability and Science (ICSRS), 2016, pp. 95–99.
[13] I. M. A. Bhaskara, L. G. P. Suardani, and M. Sudarma, “Data Warehouse Implemantation To Support Batik Sales Information Using MOLAP,” IJEET (International J. Eng. Emerg. Technol., vol. 3, no. 1, pp. 45–51, 2018.
[14] I. B. L. M. Suta, I. G. N. A. S. Mahendra, and Y. P. Sudarmojo, “Design General Hospital Data Warehouse Base on Nine Step Methodology,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, pp. 15–19, 2019.
[15] I. N. A. Prabawa, D. A. K. Arimbawa, and I. G. N. Janardana, “Analysis and Design Data Warehouse For E-Travel Business Optimization,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, 2019.
[16] A. Sumichan, I. M. G. Yudiana, M. R. Satrio, and I. M. Sudarma, “Designing a Virtual Data Warehouse in Supporting Sales Information Needs (Case Study: National Scale Building Material Store X),” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, pp. 2–5, 2019.
[17] A. . N. Narendra, S. I. Murpratiwi, and M. Sudarma, “Design of E-Grant Application Data Warehouse,” IJEET (International J. Eng. Emerg. Technol., vol. 2, no. 1, pp. 11–15, 2017.
[18] I. G. W. Darma, K. S. Utami, and N. W. S. Aryani, “Data Warehouse Analysis to Support UMKM Decisions using the Nine-step Kimball Method,” IJEET (International J. Eng. Emerg. Technol., vol. 4, no. 1, pp. 1–4, 2019.
[19] P. V. Andreyana, P. A. Widya, and M. Suartika, “Designing Data Warehouse at the Impatient and Outpatient (Case Study: Sanglah Hospital),” IJEET (International J. Eng. Emerg. Technol., vol. 2, no. 1, p. 40, 1970.
[20] B. Inmon, Building The Data Warehouse, 2nd ed. New York: John Wiley & Sons, 1996.
[21] B. Inmon and H. W. Inmon, Building The Data Warehouse. John Wiley &Ssons, 2005.
[22] S. Rangarajan, “Data Warehouse Design – Inmon versus Kimball,” tdan.com, 2016. [Online]. Available: https://tdan.com/data-warehouse-design-inmon-versus-kimball/20300. [Accessed: 18-May-2020].
[23] O. J. Keuangan, “Lembaga Perbankan,” ojk.go.id. [Online]. Available: https://www.ojk.go.id/id/kanal/perbankan/ikhtisar-perbankan/Pages/Lembaga-Perbankan.aspx. [Accessed: 18-May-2020].
Published
2020-12-13
How to Cite
AMERTHA, Lanang Bagus; HARTATI, Rukmi Sari; SUDARMA, Made.
the Data Warehouse Design for the Bank X with Inmon Approach.
International Journal of Engineering and Emerging Technology, [S.l.], v. 5, n. 2, p. 19-23, dec. 2020.
ISSN 2579-5988.
Available at: <https://ojs.unud.ac.id/index.php/ijeet/article/view/60010>. Date accessed: 24 nov. 2024.
doi: https://doi.org/10.24843/IJEET.2020.v05.i02.p04.
Section
Articles
Indexed By
