POIESIS: a Tool for Quality-aware ETL Process Redesign

Abstract

We present a tool, called POIESIS, for automatic ETL process enhancement. ETL processes are essential data-centric activities in modern business intelligence environments and they need to be examined through a viewpoint that concerns their quality characteristics (e.g., data quality, performance, manageability) in the era of Big Data. POIESIS responds to this need by providing a user-centered environment for quality-aware analysis and redesign of ETL flows. It generates thousands of alternative flows by adding flow patterns to the initial flow, in varying positions and combinations, thus creating alternative design options in a multidimensional space of di↵erent quality attributes. Through the demonstration of POIESIS we introduce the tool’s capabilities and highlight its e ciency, usability and modifiability, thanks to its polymorphic design.

Topics

    6 Figures and Tables

    Download Full PDF Version (Non-Commercial Use)