THE DATA WAREHOUSE IMPLEMENTATION BY COMBINING KIMBALL AND INMON METHOD (Study Case In Data Warehouse Of Video Surveillance For Automated Teller Machine In Banking Industry)

Ozmar Azhari


Data warehouse is now the important parts of the organization, especially in Banking Area. Beside for the transaction issue the data warehouse can also be used in managing the transactional data which store by real time with the video surveillance in the Bank. Video Surveillance or known as CCTV ATM is used by Bank as the evidence when the fraud or other banking crime occurred. In this paper, the process of combining data warehouse method can also be implemented for transactional data in CCTV ATM. The Inmon approach is implemented in the development of Data Warehouse framework, while project scoping, and user requirement is based on Kimball. The transactional data first gathered via manual or automatic process via network, where the process begins with the ETL and staging to produce data mart, so data warehouse can produce the analytical report for decision making issue. Furthermore, one of Banking, which is regional development Bank, will become the model of implementation combination data warehouse related to the transactional data of CCTV ATM which gathered from the ATM.


Keywords: CCTV ATM, Inmon, Kimball, ETL, Staging, Metadata, Data Mart, OLAP

Full Text:



Ariyachandra, Thilini and Watson, Hugh J., 2011, Which Data Warehouse Architecture Is Most Successful; Business Intelligent Journal, pp. 4-6.

Guerra, Joseph and Andrews, David, 2013, Why Do You Need A Data Warehouse; Rapid Decision.

Kocharl, Barjesh and Chhillar, Rajender, 2012, An Effective Data Warehousing System for RFID Using Novel Data Cleaning, Data Transformation, and Loading Techniques; The International Arab Journal of Information Technology

Nguyen, Phuc V, 2011, Using Data Warehouse To Support Building Strategy Or Forecast Business Tend

Nugroho, Didik,, 2013, Design of Data Warehouse System to Support the Quality Management of Information Technology Based School; IJCSI.

Padhy, Neelamadhab and Panigrahi, Rasmita, 2012, Data Warehousing and its OLAP; MRDM Technology for Decision Support in Business Organizations of 21st.

Poole, N.R., Zhou, Q. and Abatis, P., 2009, Analysis of CCTV digital video recorder hard disk storage system; Science Direct, pp. 85-92.

Ramadhan, Hasnur and Soepriadi, Agus, 2011, Studi Kasus Pembangunan Enterprise Data Warehouse/Business Intelligence (EDW/BI) di Perusahaan Multi Finance Nasional; Seminar Nasional Aplikasi Teknologi Informasi, pp. 95-100.

Ramesh Babu Palepu; Dr K V Sambasiva Rao, 2012, Meta Data Quality Control Architetecture in Data Warehousing; International Journal of Computer Science

Rizzi, Stefano, et al., et al, 2016, Research in Data Warehouse Modeling and Design: Dead or Alive?

Sen, Arun and Sinha, Atish P, 2005, A Comparison Of Data Warehousing Methodologies.


  • There are currently no refbacks.