We present our tool 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.
CitationJovanovic, P., Romero, O., Simitsis, A., Abello, A. Requirement-driven creation and deployment of multidimensional and ETL designs. A: International Conference on Conceptual Modeling. "Conceptual Modeling. Proceedings of the 31st International Conference, ER 2012. Florence, Italy, October 15-18, 2012.". Florencia: Springer, 2012, p. 391-395.
All rights reserved. This work is protected by the corresponding intellectual and industrial property rights. Without prejudice to any existing legal exemptions, reproduction, distribution, public communication or transformation of this work are prohibited without permission of the copyright holder. If you wish to make any use of the work not provided for in the law, please contact: firstname.lastname@example.org