DESIGN OF DATA WAREHOUSE ARCHITECTURE FOR TRACER STUDY DATA MANAGEMENT BASED ON OLAP

Authors

  • Fathrial Muhamad Hamdani Faculty Of Engineering, Widyatama University, Bandung, Indonesia Author
  • Nauval Faksi Erlansyah Faculty Of Engineering, Widyatama University, Bandung, Indonesia Author
  • Azizah Nurul Waqiah Faculty Of Engineering, Widyatama University, Bandung, Indonesia Author
  • Fatimah Azzahra Faculty Of Engineering, Widyatama University, Bandung, Indonesia Author
  • Arvia Kinan Faculty Of Engineering, Widyatama University, Bandung, Indonesia Author
  • Murnawan Faculty Of Engineering, Widyatama University, Bandung, Indonesia Author

Keywords:

Data Warehouse, Multidimensional, OLAP, Snowflake, Tracer Study

Abstract

The university conducts a tracer study to obtain information about job search and the work situation of alumni after graduating from university. So the university will collect tracer study data from year to year. Therefore, the data integration is carried out so that the use of tracer study alumni data as material for analysis becomes more effective. By using the concept of a data warehouse, it will simplify the process of integrating tracer study data. With the implementation of OLAP technology can generate data analysis reports as a basis for decision-making. The data in data warehouse tracer study will be input data in the OLAP (online analytical processing) application. This study designs a multidimensional schema model with a snowflake schema for a data warehouse tracer study. By determining a sample attribute based on predetermined criteria, it can be a measure for making dimensions. Based on the results of the analysis obtained one fact table and nine dimension tables.

Downloads

Download data is not yet available.

References

Agapito, G., C. Zucco, and M. Cannataro, COVID-warehouse: A data warehouse of Italian COVID-19, pollution, and climate data. International Journal of Environmental Research and Public Health, 2020. 17(15): p. 5596.DOI: https://doi.org/10.3390/ijerph17155596.

Akbar, R. and M. Mukhtar, Perancangan E-Tracer Study berbasis Sistem Cerdas. Jurnal Sisfokom (Sistem Informasi dan Komputer), 2020. 9(1): p. 8-12.DOI: https://doi.org/10.32736/sisfokom.v9i1.631.

Tutal, N. and I. Yalcin, The Role of Schemas in the Relationships between Family Function and Well-Being. Eurasian Journal of Educational Research, 2021. 93: p. 115-134.DOI: https://doi.org/10.14689/ejer.2021.93.6

Han, J., J. Pei, and M. Kamber, Data mining: concepts and techniques. 2011: Elsevier.

Dasci Sonmez, E. and N. Cemaloglu, The Effect of Education as a Component of Human Capital on Economic Growth: A Panel VAR Analysis. Eurasian Journal of Educational Research, 2021. 93: p. 135-164.DOI: https://doi.org/10.14689/ejer.2021.93.7.

Khotimah, K., Design and Implementation of Data Warehouse to Support Academic System (Case Study at STKIP Muhammadiyah Kotabumi). Jurnal Teknologi Informasi Magister, 2016. 2(01): p. 94-107.

Kumar, R., Research methodology: A step-by-step guide for beginners. 2018: Sage.

Fajaryati, N., et al., Tracer Study of Alumni of Informatics Engineering Education Department of Electronic Engineering Education Faculty of Engineering Yogyakarta State University. Elinvo (Electronics, Informatics, and Vocational Education), 2015. 1(1): p. 44-45.DOI: https://doi.org/10.21831/elinvo.v1i1.10878.

Helmud, E., OPTIMIZATION OF ORACLE DATABASE USING COMPLEX VIEW CASE STUDY: PT. THANKS TO OPTIMIST PROSPER (PT. BOS) PANGKALPINANG. INFORMANIKA, 2021. 7(01).

Subuh, D. and W. Yasman, Data Warehouse Implementation And Its Application In Magnifique Clothes Stores Using Pentaho Tools. Prosiding SENIATI, 2019: p. 29-36.

Chan, S.H. and Y.F. Lay, Effects of Attitude, Self-Efficacy Beliefs, and Motivation on Behavioural Intention in Teaching Science. Eurasian Journal of Educational Research, 2021. 93: p. 219-262.DOI: https://doi.org/10.14689/ejer.2021.93.11.

Sagala, M., Implementasi Data Warehouse Pada Perpustakaan Universitas Katolik Santo Thomas.Jurnal Teknik Informatika UNIKA Santo Thomas, 2018. 3(1): p. 33-39.

Putra, E.P., et al., Modelling of Data Warehouse on Food Distribution Center and Reserves in the Ministry of Agriculture. ComTech: Computer, Mathematics and Engineering Applications, 2015. 6(3): p. 422-434.DOI: https://doi.org/10.21512/comtech.v6i3.2251.

Yangui, R., A. Nabli, and F. Gargouri, Automatic transformation of data warehouse schema to NoSQL data base: comparative study. Procedia Computer Science, 2016. 96: p. 255-264.DOI: https://doi.org/10.1016/j.procs.2016.08.138.

Rusman, A., Model of Performance Improvement of Certified Teachers in Private Vocational Schools. Eurasian Journal of Educational Research, 2020. 20(86): p. 25-38.DOI: https://doi.org/10.14689/ejer.2020.86.2.

Salem, S.B. and S. Naouali, Reducing the multidimensionality of OLAP cubes with Genetic Algorithms and Multiple Correspondence Analysis. Procedia Computer Science, 2015. 73: p. 452- 459.DOI: https://doi.org/10.1016/j.procs.2015.12.026.

Ozgenel, M., The role of charismatic leader in school culture. Eurasian Journal of Educational Research, 2020. 20(86): p. 85-114.DOI: https://doi.org/10.14689/ejer.2020.86.5.

Zainatul, F. and M. Murnawan, Performance Comparison of K-Nearest Neighbor and Decision Tree C4. 5 by Utilizing Particle Swarm Optimization for Prediction of Liver Disease. International Journal of Open Information Technologies, 2021. 9(10): p. 9-15.

Nurmalasari, D., et al. Data Modeling with Galactic Schematics on Graduate Data.

Ardiyanti, N.P.M., A.S. Kusuma, and I.K.B. Sandika, IMPLEMENTATION OF OLAP (ON-LINE ANALYTICAL PROCESSING) FOR WEB-BASED SALES TRANSACTION PROCESSING (CASE STUDY: LILOLA BOUTIQUE). Jurnal Teknologi Informasi dan Komputer, 2018. 4(1).DOI: https://doi.org/10.36002/jutik.v4i1.398.

Kartal, S.K. and O. Kutlu, Analyzing the Dimensionality of Academic Motivation Scale Based on the Item Response Theory Models. Eurasian Journal of Educational Research, 2020. 20(86): p. 157- 174.DOI: https://doi.org/10.14689/ejer.2020.86.8.

Maulana, M.A.A., et al., Analysis and design of data warehouse evaluation of case study students in the Department of Informatics UMM. Jurnal Repositor, 2020. 1(1): p. 59-68.DOI: https://doi.org/10.22219/repositor.v1i1.376.

Yakupogullari, A. and S.Y. Guder, The Role of Parents’ Empathic Tendencies in Children Value Acquisition. Eurasian Journal of Educational Research, 2020. 20(86): p. 223-248.DOI: https://doi.org/10.14689/ejer.2020.86.11.

Downloads

Published

2022-01-30

How to Cite

Hamdani, F. M., Erlansyah, N. F., Waqiah, A. N., Azzahra, F., Kinan, A., & Murnawan. (2022). DESIGN OF DATA WAREHOUSE ARCHITECTURE FOR TRACER STUDY DATA MANAGEMENT BASED ON OLAP. CENTRAL ASIA AND THE CAUCASUS, 23(1), 3158-3171. https://ca-c.org/CAC/index.php/cac/article/view/277

Plaudit

Similar Articles

11-20 of 632

You may also start an advanced similarity search for this article.

Most read articles by the same author(s)