Welcome to the InfoSci Platform
Reference Hub2
An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts

An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts

Jesús Pardillo, Jose-Norberto Mazón, Juan Trujillo
Copyright: © 2011 |Volume: 22 |Issue: 1 |Pages: 26
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781613509913|DOI: 10.4018/jdm.2011010103
Cite Article Cite Article

MLA

Pardillo, Jesús, et al. "An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts." JDM vol.22, no.1 2011: pp.43-68. http://doi.org/10.4018/jdm.2011010103

APA

Pardillo, J., Mazón, J., & Trujillo, J. (2011). An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts. Journal of Database Management (JDM), 22(1), 43-68. http://doi.org/10.4018/jdm.2011010103

Chicago

Pardillo, Jesús, Jose-Norberto Mazón, and Juan Trujillo. "An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts," Journal of Database Management (JDM) 22, no.1: 43-68. http://doi.org/10.4018/jdm.2011010103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

To customize a data warehouse, many organizations develop concrete data marts focused on a particular department or business process. However, the integrated development of these data marts is an open problem for many organizations due to the technical and organizational challenges involved during the design of these repositories as a complete solution. In this article, the authors present a design approach that employs user requirements to build both corporate data warehouses and data marts in an integrated manner. The approach links information requirements to specific data marts elicited by using goal-oriented requirement engineering, which are automatically translated into the implementation of corresponding data repositories by means of model-driven engineering techniques. The authors provide two UML profiles that integrate the design of both data warehouses and data marts and a set of QVT transformations with which to automate this process. The advantage of this approach is that user requirements are captured from the early development stages of a data-warehousing project to automatically translate them into the entire data-warehousing platform, considering the different data marts. Finally, the authors provide screenshots of the CASE tools that support the approach, and a case study to show its benefits.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.