Requirement-driven creation and deployment of multidimensional and ETL designs

  • Authors:
  • Petar Jovanovic;Oscar Romero;Alkis Simitsis;Alberto Abelló

  • Affiliations:
  • Universitat Politècnica de Catalunya, BarcelonaTech, Barcelona, Spain;Universitat Politècnica de Catalunya, BarcelonaTech, Barcelona, Spain;HP Labs, Palo Alto, CA;Universitat Politècnica de Catalunya, BarcelonaTech, Barcelona, Spain

  • Venue:
  • ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

We present our tool, GEM, for assisting designers in the error-prone and time-consuming tasks carried out at the early stages of a data warehousing project. Our tool semi-automatically produces multidimensional (MD) and ETL conceptual designs from a given set of business requirements (like SLAs) and data source descriptions. Subsequently, our tool translates both the MD and ETL conceptual designs produced into physical designs, so they can be further deployed on a DBMS and an ETL engine. In this paper, we describe the system architecture and present our demonstration proposal by means of an example.