Graph-based modeling of ETL activities with multi-level transformations and updates (Journal article)
Simitsis, A./ Vassiliadis, P./ Terrovitis, M./ Skiadopoulos, S.
Extract-Transform-Load (ETL) workflows are data centric workflows responsible for transferring, cleaning, and loading data from their respective sources to the warehouse. In this paper, we build upon existing graph-based modeling techniques that treat ETL workflows as graphs by (a) extending the activity semantics to incorporate negation, aggregation and self-joins, (b) complementing querying semantics with insertions, deletions and updates, and (c) transforming the graph to allow zoom-in/out at multiple levels of abstraction (i.e., passing from the detailed description of the graph at the attribute level to more compact variants involving programs, relations and queries and vice-versa).
|Institution and School/Department of submitter:||Πανεπιστήμιο Ιωαννίνων. Σχολή Θετικών Επιστημών. Τμήμα Μηχανικών Ηλεκτρονικών Υπολογιστών και Πληροφορικής|
|Appears in Collections:||Άρθρα σε επιστημονικά περιοδικά ( Ανοικτά)|
Files in This Item:
|Vassiliadis-2005-Graph-based modeling of ETL activities with multi-level transformations and updates.pdf||183.78 kB||Adobe PDF||View/Open Request a copy|
Please use this identifier to cite or link to this item:This item is a favorite for 0 people.
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.