Requirement-Driven Creation and Deployment of Multidimensional and ETL Designs

0
103

Authors: Alberto Abelló, Alkis Simitsis, Oscar Romero, Petar Jovanovic

Tags: 2012, conceptual modeling

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.

Read the full paper here: https://link.springer.com/chapter/10.1007/978-3-642-33999-8_47