DESIGN OF DATA WAREHOUSE ARCHITECTURE FOR TRACER STUDY DATA MANAGEMENT BASED ON OLAP
Keywords:
Data Warehouse, Multidimensional, OLAP, Snowflake, Tracer StudyAbstract
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
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
Issue
Section
License
Copyright (c) 2022 Author
This work is licensed under a Creative Commons Attribution 4.0 International License.
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
