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

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

829

Lastpage

836

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

Keywords

data warehouses; formal specification; security of data; specification languages; data warehouse development; data warehouse security; model driven architecture; multidimensional conceptual model; query-view-transformations language; sensitive information; snowflake model; Application software; Computer architecture; Data security; Data warehouses; Information analysis; Information security; Multidimensional systems; Packaging; Proposals; Unified modeling language;

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.39

Filename

4159881