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

被引:3
作者
Salaki, R. J. [1 ]
Waworuntu, J. [1 ]
Tangkawarow, I. R. H. T. [1 ]
机构
[1] UNIMA, Pendidikan Teknol Informasi & Komunikasi, Manado, Indonesia
来源
INTERNATIONAL CONFERENCE ON INNOVATION IN ENGINEERING AND VOCATIONAL EDUCATION | 2016年 / 128卷
关键词
D O I
10.1088/1757-899X/128/1/012020
中图分类号
G40 [教育学];
学科分类号
040101 ; 120403 ;
摘要
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 decision-making 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.
引用
收藏
页数:8
相关论文
共 10 条
[1]  
Adithama Stephanie Pamela, 2013, ANALISIS DESAIN REAL
[2]  
[Anonymous], 2015, CIBIA COURS
[3]  
Feris Thia, PENTAHO KNOWLEDGE BA
[4]  
Harijanto Budi, 2013, JURNAL ELTEK, V11
[5]  
Imelda. Business Intelligence, 2015, MAJ ILM UNIKOM, V11
[6]  
Kimball R., 2013, DATA WAREHOUSE TOOLK
[7]  
Kimball R., 2004, DATA WAREHOUSE ETL T
[8]  
Mulyana JRP, 2014, PENTAHO SOLUSI OPEN
[9]  
Prastuti Sulistyorini, 2010, MAJALAH ILMIAH IC TE, V5
[10]  
Suzanam Meta, 2013, JURNAL ILMIAH DAN TE, V1