Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, we delve into the logical design of ETL scenarios. We describe a framework for the declarative specification of ETL scenarios with two main characteristics: genericity and customization. Moreover, we present a palette of several templates, representing frequently used ETL activities along with their semantics and their interconnection. Finally, we discuss implementation issues and we present a graphical tool, ARKTOS II that facilitates the design of ETL scenarios, based on our model. © Springer-Verlag Berlin Heidelberg 2003.
CITATION STYLE
Vassiliadis, P., Simitsis, A., Georgantas, P., & Terrovitis, M. (2003). A framework for the design of ETL scenarios. Lecture Notes in Computer Science (Including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 2681, 520–535. https://doi.org/10.1007/3-540-45017-3_35
Mendeley helps you to discover research relevant for your work.