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
Keywords: BKPP, Bottom-Up Approach, Data Mart, Data Warehouse, Human Resources

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.

References

Connolly, T., & Begg, C. (2005). Database System - A Practical Approach to Design, Implementation, and Management. London: Pearson Education.

Dejan Sarka, Matija Lah, G. J. (2012). Implementing a Data Warehouse with Microsoft SQL Server 2012: Dynamic Packages. London: Pearson Education. Retrieved from https://www.microsoftpressstore.com/articles/article.aspx?p=2224037

Dyah Paramita P1, Firdaus2, M. A. (2012). Penerapan Data Mart Penjualan Hypermarket XYZ Menggunakan Metode From Enterprise Models To Dimensional Models. Jurusan Sistem Informasi Fakultas Ilmu Komputer Universitas Sriwijaya, VOL. 4, NO(2355–4614), 503–515.

Inmon, W. H. (2005). Building the Data Warehouse (4th ed.). New York City: John Wiley & Sons, Inc.

LPKM Fakultas Psikologi Universitas Gadjah Mada. (2018). Talent Management. Retrieved from https://lpkm.psikologi.ugm.ac.id/talent-management/

Rodero, J. A., Toval, J. A., & Piattini, M. G. (1999). The audit of the Data warehouse framework. In S. Gatziu, M. A. Jeusfeld, M. Staudt, & Y. Vassiliou (Eds.), Proceedings of the International Workshop on Design and Management of Data Warehouses (Vol. 19, pp. 14–15). Heidelberg: CEUR-WS. Retrieved from http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.42.1091&rep=rep1&type=pdf

Utami, A., Pratama, B. R., & Widianto, S. R. (2019). Independent Research Final Report: Data Mart Design In Bkpp Bandung Using From Enterprise Models To Dimensional Models Method. Bandung.

Vidette Poe, Patricia Klauer, S. B. (1997). Building a Data Warehouse for Decision Support (2nd ed.). New Jersey: Prentice-Hall, Inc. Retrieved from https://dl.acm.org/doi/book/10.5555/550486

Published
2020-02-01
How to Cite
Utami, A., Pratama, B., & Widianto, S. (2020). DATA MART DESIGN IN BKPP BANDUNG USING FROM ENTERPRISE MODELS TO DIMENSIONAL MODELS METHOD. JITK (Jurnal Ilmu Pengetahuan Dan Teknologi Komputer), 5(2), 279-284. https://doi.org/10.33480/jitk.v5i2.1219
Article Metrics

Abstract viewed = 56 times
PDF downloaded = 0 times