Title: Defining and transforming security rules in an MDA approach for DWs

Authors: Carlos Blanco, Ignacio Garcia-Rodriguez de Guzman, Eduardo Fernandez-Medina, Juan Trujillo, Mario Piattini

Addresses: Department of Information Technologies and Systems, Escuela Superior de Informatica, Alarcos Research Group – Institute of Information Technologies and Systems, University of Castilla-La Mancha, Paseo de la Universidad, 4, 13071, Ciudad Real, Spain. ' Department of Information Technologies and Systems, Escuela Superior de Informatica, Alarcos Research Group – Institute of Information Technologies and Systems, University of Castilla-La Mancha, Paseo de la Universidad, 4, 13071, Ciudad Real, Spain. ' Department of Information Technologies and Systems, Escuela Superior de Informatica, Alarcos Research Group – Institute of Information Technologies and Systems, University of Castilla-La Mancha, Paseo de la Universidad, 4, 13071, Ciudad Real, Spain. ' Department of Software and Computing Systems, LUCENTIA Research Group, University of Alicante, San Vicente s/n, 03690, Alicante, Spain. ' Department of Information Technologies and Systems, Escuela Superior de Informatica, Alarcos Research Group – Institute of Information Technologies and Systems, University of Castilla-La Mancha, Paseo de la Universidad, 4, 13071, Ciudad Real, Spain

Abstract: Data Warehouses (DWs) store historical information which support the decision-making process. Since this information is crucial, it has to be protected from unauthorised accesses by defining security constraints in all stages of the DW development process. In previous works, we applied the Model-Driven (MDA) philosophy to define secure DWs using several security models and transformations. Nevertheless, our conceptual model makes it possible to define complex security rules with OCL expressions which are not transformed automatically. This paper deals with this problem and completes our approach improving our conceptual metamodel and defining new transformation rules. Finally, an application example is shown.

Keywords: DWs; data warehouses; OLAP; on-line analytical processing; multidimensional modelling; security rules; MDA; model-driven architecture; QVT; query-view-transformation; data warehouse security; metamodelling.

DOI: 10.1504/IJBIDM.2010.031283

International Journal of Business Intelligence and Data Mining, 2010 Vol.5 No.2, pp.116 - 133

Published online: 27 Jan 2010 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article