Application of QVT for the Development of Secure Data Warehouses: A case study

  • Authors:
  • Emilio Soler;Juan Trujillo;Eduardo Fernandez-Medina;Mario Piattini

  • Affiliations:
  • University of Matanzas, Cuba;University of Alicante, Spain;University of Castilla-La Mancha, Spain;University of Castilla-La Mancha, Spain

  • Venue:
  • ARES '07 Proceedings of the The Second International Conference on Availability, Reliability and Security
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

Security is a crucial aspect for the development of Data Warehouses (DW) because they contain sensitive information. The application of the Model Driven Architecture (MDA) in the secure modeling of DWs allows obtaining the secure logical scheme from the conceptual model. In this paper, we apply the Query/View/Transformations (QVT) language to the development of a secure DW by means of a case study. First, we introduce the case study related to a typical sanitary system. Afterwards, with the application of a set of QVT relations, we transform all the captured security and audit requirements from the multidimensional conceptual model of the DW, to the logical level, by means of the construction of a snowflake model. From this scheme it turns out easier to obtain code for a specific platform that implements security and audit aspects.