JITK (Jurnal Ilmu Pengetahuan dan Komputer)
Vol 5 No 2 (2020): JITK Issue February 2020

DATA MART DESIGN IN BKPP BANDUNG USING FROM ENTERPRISE MODELS TO DIMENSIONAL MODELS METHOD

Amalia Utami (Magister of Information System STMIK LIKMI)
Bayu Rimba Pratama (Magister of Information System STMIK LIKMI)
Septian Rheno Widianto (Magister of Information System STMIK LIKMI)



Article Info

Publish Date
01 Feb 2020

Abstract

The data warehouse is a single data storage that is complete and consistent with subject-oriented, integrated, non-volatile, and time-variant characteristics that can be used to support decisions. While Data mart is a subset of a data warehouse that supports the information needs of certain departments or business process functions. Badan Kepegawaian, Pendidikan Pelatihan (BKPP) of Bandung Municipality has a history of employee mutation transactions that have not been optimally utilized so it will be very useful if the data can be made into a data mart. This data mart development method uses the From Enterprise Models to Dimensional Models method as its design method and the Bottom-Up Approach as an approach in developing a data mart. This data mart developed using the PostgreSQL database and the PHP language. The purpose of this research is to develop human resource data mart by optimizing the utilization of historical data from employee mutation transactions. The results of this research are human resources data mart that accommodates historical data on employee mutation transactions and produces information that is useful for the Top Management to support the making decision.

Copyrights © 2020






Journal Info

Abbrev

jitk

Publisher

Subject

Computer Science & IT

Description

Kegiatan menonton film merupakan salah satu cara sederhana untuk menghibur diri dari rasa gundah gulana ataupun melepas rasa lelah setelah melakukan aktivitas sehari-hari. Akan tetapi, karena berbagai alasan terkadang seseorang tidak ada waktu untuk menonton film di bioskop. Dengan bantuan media ...