Requirement-driven creation and deployment of multidimensional and ETL designs

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.

URIhttp://hdl.handle.net/2117/86757

DOI10.1007/978-3-642-33999-8_47

ISBN978-3-642-33999-8

Publisher versionhttp://link.springer.com/chapter/10.1007/978-3-642-33999-8_47

Collections

View Usage Statistics

Show full item record

Files	Description	Size	Format	View
ER2012.pdf		2,137Mb	PDF	View/Open

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

UPCommons. Global access to UPC knowledge

Requirement-driven creation and deployment of multidimensional and ETL designs

View/Open

Browse