Requirement-Driven Creation and Deployment of Multidimensional and ETL Designs

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.

[1]  Peretz Shoval,et al.  Conceptual Modeling - ER 2010, 29th International Conference on Conceptual Modeling, Vancouver, BC, Canada, November 1-4, 2010. Proceedings , 2010, ER.

[2]  Jose-Norberto Mazón,et al.  Automatic generation of ETL processes from conceptual models , 2009, DOLAP.

[3]  Alberto Abelló,et al.  A framework for multidimensional design of data warehouses from ontologies , 2010, Data Knowl. Eng..

[4]  Faïez Gargouri,et al.  Automatic construction of multidimensional schema from OLAP requirements , 2005, The 3rd ACS/IEEE International Conference onComputer Systems and Applications, 2005..

[5]  Kevin Wilkinson,et al.  Leveraging Business Process Models for ETL Design , 2010, ER.

[6]  Alberto Abelló,et al.  GEM: Requirement-Driven Generation of ETL and Multidimensional Conceptual Designs , 2011, DaWaK.

[7]  Alberto Abelló,et al.  Automatic validation of requirements to support multidimensional design , 2010, Data Knowl. Eng..

[8]  Dimitrios Skoutas,et al.  Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data , 2007, Int. J. Semantic Web Inf. Syst..

[9]  Laura M. Haas,et al.  Clio grows up: from research prototype to industrial tool , 2005, SIGMOD '05.

[10]  Ritu Khare,et al.  SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram , 2007, DOLAP '07.

[11]  Panos Vassiliadis,et al.  Extraction, Transformation, and Loading , 2009, Encyclopedia of Database Systems.

[12]  Ryan Wisnesky,et al.  Orchid: Integrating Schema Mapping and ETL , 2008, 2008 IEEE 24th International Conference on Data Engineering.