Abstract:
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).
Note: This material is presented to ensure timely dissemination of scholarly and technical work. Copyright and all rights therein are retained by authors or by other copyright holders. All persons copying this information are expected to adhere to the terms and constraints invoked by each author's copyright. In most cases, these works may not be reposted without the explicit permission of the copyright holder.