Affiliation:
1. National Technical University of Athens, Greece
2. University of Ioannina, Greece
3. University of Peloponnese, Greece
Abstract
In the early stages of a data warehouse project, the designers/administrators have to come up with a decision concerning the design and deployment of the back-stage architecture. The possible options are (a) the usage of a commercial ETL tool, or (b) the development of an in-house ETL prototype. Both cases have advantages and disadvantages. However, in both cases the design and modeling of the ETL workflows have the same characteristics. The scope of this chapter is to indicate the main challenges, issues, and problems concerning the manufacturing of ETL workflows, in order to assist the designers/administrators to decide which solution suits better to their data warehouse project and to help them construct an efficient, robust and evolvable ETL workflow that implements the refreshment of their warehouse.
Cited by
7 articles.
订阅此论文施引文献
订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献
1. The Method of Forming Contents for a NoSQL Storage of Configurable Information System;Advances in Intelligent Systems and Computing;2018-05-17
2. Methodology of Big Data Integration from A Priori Unknown Heterogeneous Data Sources;Proceedings of the 2018 2nd International Conference on Computer Science and Artificial Intelligence - CSAI '18;2018
3. ETLR—Effective DWH Design Paradigm;Proceedings of the International Conference on Data Engineering and Communication Technology;2016-08-25
4. Towards a Framework for Conceptual Modeling of ETL Processes;Communications in Computer and Information Science;2011
5. Benchmarking ETL Workflows;Lecture Notes in Computer Science;2009