Comparison of Different Extraction Transformation and Loading Tools for Data Warehousing
2018 International Conference on Innovations in Science, Engineering and Technology (ICISET)(2018)
摘要
Data Warehouses (DW) are database implementations that support the storage and analysis of historical data. The key components of DWs are known as Extraction, Transformation, and Loading (ETL). Since wrong or misleading data may deliver the wrong results. Suitable ETL Tools are necessary for a DW to enhance data quality. The choice of ETL tools is difficult as well as important issue in data warehousing. This paper first describes the ETL procedure in brief and compare the features of the ETL tools. In this paper, we have compared the existing ETL tools to choose the best option in different situations. From a current industrial market, we collected feedback from the industry professional and documented it to establish the relevance of the data warehouse. We have implemented the available popular ETL tools to compare their strengths and weaknesses to choose the best among them for National Health Data Warehouse of Bangladesh.
更多查看译文
关键词
ETL,Data warehouse,Database,Data Integration
AI 理解论文
溯源树
样例
![](https://originalfileserver.aminer.cn/sys/aminer/pubs/mrt_preview.jpeg)
生成溯源树,研究论文发展脉络
Chat Paper
正在生成论文摘要