TY - GEN
T1 - Comparison of the E-LT vs ETL Method in Data Warehouse Implementation
T2 - 2nd International Conference on Informatics, Multimedia, Cyber, and Information System, ICIMCIS 2020
AU - Haryono, Edward Manopo
AU - Fahmi,
AU - Tri W, Adi Setiawan
AU - Gunawan, Indra
AU - Nizar Hidayanto, Achmad
AU - Rahardja, Untung
N1 - Publisher Copyright:
© 2020 IEEE.
Copyright:
Copyright 2021 Elsevier B.V., All rights reserved.
PY - 2020/11/19
Y1 - 2020/11/19
N2 - The data warehouse is an enterprise system that archives various kinds of data from various main systems and integrates them into a place. There are two data processing methods in implementing a data warehouse, namely ETL (Extract, Transform, Load) and E-LT (Extract, Load, Transform). In determining the implementation of a data warehouse, it is often difficult to choose the appropriate method. Because this is related to Cost, Process, Performance, and Continuous Improvement in a company. This paper discusses the implementation of a data warehouse in various industries by conducting a survey to compare the use of ETL and E-LT methods. The survey was conducted on people with backgrounds in work related to data warehouses from various industries. Based on the results of this survey, it is hoped that a better method of implementing a data warehouse can be obtained.
AB - The data warehouse is an enterprise system that archives various kinds of data from various main systems and integrates them into a place. There are two data processing methods in implementing a data warehouse, namely ETL (Extract, Transform, Load) and E-LT (Extract, Load, Transform). In determining the implementation of a data warehouse, it is often difficult to choose the appropriate method. Because this is related to Cost, Process, Performance, and Continuous Improvement in a company. This paper discusses the implementation of a data warehouse in various industries by conducting a survey to compare the use of ETL and E-LT methods. The survey was conducted on people with backgrounds in work related to data warehouses from various industries. Based on the results of this survey, it is hoped that a better method of implementing a data warehouse can be obtained.
KW - data warehouse
KW - E-LT
KW - ETL
UR - http://www.scopus.com/inward/record.url?scp=85102191501&partnerID=8YFLogxK
U2 - 10.1109/ICIMCIS51567.2020.9354284
DO - 10.1109/ICIMCIS51567.2020.9354284
M3 - Conference contribution
AN - SCOPUS:85102191501
T3 - Proceedings - 2nd International Conference on Informatics, Multimedia, Cyber, and Information System, ICIMCIS 2020
SP - 115
EP - 120
BT - Proceedings - 2nd International Conference on Informatics, Multimedia, Cyber, and Information System, ICIMCIS 2020
PB - Institute of Electrical and Electronics Engineers Inc.
Y2 - 19 November 2020 through 20 November 2020
ER -