E-LT与ETL方法在数据仓库实现中的比较:一个定性研究

2020 International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS) Pub Date : 2020-11-19 DOI:10.1109/ICIMCIS51567.2020.9354284

E. Haryono, Fahmi, Adi Setiawan Tri W, I. Gunawan, Achmad Nizar Hidayanto, U. Rahardja

{"title":"E-LT与ETL方法在数据仓库实现中的比较:一个定性研究","authors":"E. Haryono, Fahmi, Adi Setiawan Tri W, I. Gunawan, Achmad Nizar Hidayanto, U. Rahardja","doi":"10.1109/ICIMCIS51567.2020.9354284","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":441670,"journal":{"name":"2020 International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS)","volume":"127 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2020-11-19","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"10","resultStr":"{\"title\":\"Comparison of the E-LT vs ETL Method in Data Warehouse Implementation: A Qualitative Study\",\"authors\":\"E. Haryono, Fahmi, Adi Setiawan Tri W, I. Gunawan, Achmad Nizar Hidayanto, U. Rahardja\",\"doi\":\"10.1109/ICIMCIS51567.2020.9354284\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":441670,\"journal\":{\"name\":\"2020 International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS)\",\"volume\":\"127 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2020-11-19\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"10\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2020 International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICIMCIS51567.2020.9354284\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2020 International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICIMCIS51567.2020.9354284","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 10

摘要

数据仓库是将来自各主要系统的各种数据进行归档并集成到一个地方的企业系统。在实现数据仓库时，有两种数据处理方法，即ETL(提取、转换、加载)和E-LT(提取、加载、转换)。在确定数据仓库的实现时，通常很难选择合适的方法。因为这关系到公司的成本、流程、绩效和持续改进。本文通过进行一项调查来比较ETL和E-LT方法的使用，讨论了数据仓库在各个行业中的实现。这项调查是对来自不同行业的数据仓库相关工作背景的人进行的。在此基础上，希望能找到一种更好的实现数据仓库的方法。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Comparison of the E-LT vs ETL Method in Data Warehouse Implementation: A Qualitative Study

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.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

2020 International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS)

自引率

0.00%

发文量