A set of QVT relations to transform PIM to PSM in the Design of Secure Data Warehouses

Author

Soler, Emilio ; Trujillo, Juan ; Fernández-Medina, Eduardo ; Piattini, Mario

Author_Institution

Departamento de Informatica, Matanzas Univ.

fYear

2007

fDate

10-13 April 2007

Firstpage

644

Lastpage

654

Abstract

Security represents a crucial aspect in the development of data warehouses (DWs), since they contain confidential data. It becomes therefore necessary to specify security and audit requirements for the multidimensional modelling, that cannot be directly transferred to the relational model of the DW. The standard framework for software development model driven architecture (MDA) allows us to define transformations between models by proposing query/view/transformations (QVT). This proposal allows the definition of formal, elegant and unequivocal transformations between platform independent model (PIM) and platform specific model (PSM). This paper employs QVT to establish a set of relations that allows us to transform security information embedded in the DWs multidimensional conceptual model to a relational logical scheme

Keywords

data privacy; data warehouses; relational databases; security of data; confidential data; data warehouse development; data warehouse security; model driven architecture; multidimensional conceptual model; multidimensional modelling; platform independent model; platform specific model; query-view-transformation relations; relational logical scheme; security information; software development; Access control; Computer architecture; Data security; Data warehouses; Information security; Multidimensional systems; Programming; Proposals; Software standards; Standards development;

fLanguage

English

Publisher

ieee

Conference_Titel

Availability, Reliability and Security, 2007. ARES 2007. The Second International Conference on

Conference_Location

Vienna

Print_ISBN

0-7695-2775-2

Type

conf

DOI

10.1109/ARES.2007.27

Filename

4159859