Modeling ETL activities as graphs (2002)
Cached
Download Links
- [sunsite.informatik.rwth-aachen.de]
- [sunsite.informatik.rwth-aachen.de]
- [www.dbnet.ece.ntua.gr]
- [ceur-ws.org]
- DBLP
Other Repositories/Bibliography
| Venue: | In Proc. 4 th Intl. Workshop on Design and Management of Data Warehouses (DMDW |
| Citations: | 14 - 10 self |
BibTeX
@INPROCEEDINGS{Vassiliadis02modelingetl,
author = {Panos Vassiliadis and Alkis Simitsis and Spiros Skiadopoulos},
title = {Modeling ETL activities as graphs},
booktitle = {In Proc. 4 th Intl. Workshop on Design and Management of Data Warehouses (DMDW},
year = {2002},
pages = {52--61}
}
Bookmark
 |
 |
 |
 |
 |
 |
OpenURL
Abstract
Abstract. 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 focus on the logical design of the ETL scenario of a data warehouse. Based on a formal logical model that includes the data stores, activities and their constituent parts, we model an ETL scenario as a graph, which we call the Architecture Graph. We model all the aforementioned entities as nodes and four different kinds of relationships (instance-of, part-of, regulator and provider relationships) as edges. In addition, we provide simple graph transformations that reduce the complexity of the graph. Finally, in order to support the engineering of the design and the evolution of the warehouse, we introduce specific importance metrics, namely dependence and responsibility, to measure the degree to which entities are bound to each other. 1.
