Extract transformation loading from OLTP to OLAP data using pentaho data integration

International Conference on Innovation in Engineering and Vocational Education

自然科学;教育

Salaki, R.J.^1 ; Waworuntu, J.^1 ; Tangkawarow, I.R.H.T.^1

Pendidikan Teknologi Informasi Dan Komunikasi, UNIMA, Manado, Indonesia^1

关键词: Data-sources;    Dimension tables;    Fact tables;    Grade point average;    Multidimensional database;    Warehouse design;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/128/1/012020/pdf
DOI  :  10.1088/1757-899X/128/1/012020

来源: IOP

【 摘 要 】

The design of the data warehouse in this case is expected to solve the problem of evaluation of learning results as well as the relevance of the information received to support decision-making by the leader. Data warehouse design is very important, which is designed to utilize the existing resources of information. GPA (Grade Point Average) data warehouse can be used for the process of evaluation, decision making and even further planning of the study program of PTIK. The diversity of data sources in the course PTIK make decisionmaking and evaluation process becomes not easier. Pentaho Data Integration is used to integrate data in PTIK easy. CPI data warehouse design with multidimensional database modeling approach using the dimension tables and fact tables.