An MDA approach for developing Secure OLAP applications: metamodels and transformations

Carlos Blanco1, Ignacio García-Rodríguez de Guzmán2, Eduardo Fernández-Medina3 and Juan Trujillo4

  1. GSyA and ISTR Research Groups. Dep. of Computer Science and Electronics. Faculty of Sciences.
    Univeristy of Cantabria. Av. de los Castros s/n. 39071. Santander. Spain.
    Carlos.Blanco@unican.es
  2. Alarcos Research Group. Institute of Information Technologies and Systems. Dep. of Information Technologies and Systems. Escuela Superior de Informatica.
    Univ. of Castilla-La Mancha. Paseo de la Universidad, 4. 13071. Ciudad Real. Spain.
    Ignacio.GRodriguez@uclm.es
  3. GSyA Research Group. Institute of Information Technologies and Systems. Dep. of Information Technologies and Systems. Escuela Superior de Informatica.
    University of Castilla-La Mancha. Paseo de la Universidad, 4. 13071. Ciudad Real, Spain.
    Eduardo.Fdezmedina@uclm.es
  4. Lucentia Research Group. Dep. of Information Languages and Systems. Facultad de Informatica.
    University of Alicante. San Vicente s/n. 03690. Alicante, Spain.
    jtrujillo@dlsi.ua.es

Abstract

Decision makers query enterprise information stored in DataWarehouses (DW) by using tools (such as On-Line Analytical Processing (OLAP) tools) which employ specific views or cubes from the corporate DW or Data Marts, based on multidimensional modelling. Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized access. In previous work we defined a Model-Driven based approach for developing a secure DWrepository by following a relational approach. Nevertheless, it is also important to define security constraints in the metadata layer that connects the DW repository with the OLAP tools; that is, over the same multidimensional structures that end users manage. This paper incorporates a proposal for developing secure OLAP applications within our previous approach: it improves a UML profile for conceptual modelling; it defines a logical metamodel for OLAP applications; and it defines and implements transformations from conceptual to logical models, as well as from logical models to secure implementation in a specific OLAP tool (SQL Server Analysis Services).

Key words

security, confidentiality, OLAP, data warehouses, MDD, MDA, QVT, MOFScript, SSAS

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS140617007B

Publication information

Volume 12, Issue 2 (June 2015)
Year of Publication: 2015
ISSN: 1820-0214 (Print) 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Blanco, C., Guzmán, I. G. d., Fernández-Medina, E., Trujillo, J.: An MDA approach for developing Secure OLAP applications: metamodels and transformations. Computer Science and Information Systems, Vol. 12, No. 2, 541-565. (2015)