期刊名称：International Journal of Computer Science Issues
印刷版ISSN：1694-0784
电子版ISSN：1694-0814
出版年度：2011
卷号：8
期号：4
出版社：IJCSI Press
摘要：Extraction, Transformation and Loading (ETL) processes aim to extract data from data sources to targets, via a set of transformations. In many situations, an ETL process can be subject to changes for several reasons. For instance, data sources changes, new requirements and bug fixing. When changes happen, analyzing the impact of change is mandatory to avoid errors and mitigate the risk of breaking existent treatments. Several solutions have been proposed for this issue. We propose a new approach, based on matrices, for analyzing the impact of change on ETL processes. The goal of this paper is to present the theoretical fundament of our approach. We model ETL parts as matrices then we propose an algorithm which detects the affected parts in an ETL process, given an attribute deletion event. Compared with the existent solutions, our approach has the advantage of easiness.
关键词：Data warehouse; ETL processes; Conceptual modeling of ETL processes; Impact of Change
