Deciding the physical implementation of ETL workflows

  • Authors:
  • Vasiliki Tziovara;Panos Vassiliadis;Alkis Simitsis

  • Affiliations:
  • Univ. of Ioannina, Ioannina, Greece;Univ. of Ioannina, Ioannina, Greece;IBM Almaden Research Center, San Jose, CA

  • Venue:
  • Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this paper, we deal with the problem of determining the best possible physical implementation of an ETL workflow, given its logical-level description and an appropriate cost model as inputs. We formulate the problem as a state-space problem and provide a suitable solution for this task. We further extend this technique by intentionally introducing sorter activities in the workflow in order to search for alternative physical implementations with lower cost. We experimentally assess our method based on a principled organization of test suites.