Automatic Generation of Secure Multidimensional Code for Data Warehouses: An MDA Approach

Authors:
Carlos Blanco;Ignacio García-Rodríguez De Guzmán;Eduardo Fernández-Medina;Juan Trujillo;Mario Piattini
Affiliations:
Dep. of Information Technologies and Systems. Escuela Superior de Informática Alarcos Research Group --- Institute of Information Technologies and Systems, Univ. of Castilla-La Mancha, Ciudad ...;Dep. of Information Technologies and Systems. Escuela Superior de Informática Alarcos Research Group --- Institute of Information Technologies and Systems, Univ. of Castilla-La Mancha, Ciudad ...;Dep. of Information Technologies and Systems. Escuela Superior de Informática Alarcos Research Group --- Institute of Information Technologies and Systems, Univ. of Castilla-La Mancha, Ciudad ...;Department of Information Languages and Systems. Facultad de Informática, University of Alicante, Alicante, Spain 03690;Dep. of Information Technologies and Systems. Escuela Superior de Informática Alarcos Research Group --- Institute of Information Technologies and Systems, Univ. of Castilla-La Mancha, Ciudad ...
Venue:
OTM '08 Proceedings of the OTM 2008 Confederated International Conferences, CoopIS, DOA, GADA, IS, and ODBASE 2008. Part II on On the Move to Meaningful Internet Systems
Year:
2008

Citing 12
Cited 3

Technical opinion: Information system security management in the new millennium

Communications of the ACM
A Pragmatic Approach to Conceptual Modeling of OLAP Security

ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
A Security Concept for OLAP

DEXA '97 Proceedings of the 8th International Workshop on Database and Expert Systems Applications
A Prototype Model for Data Warehouse Security Based on Metadata

DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Towards Modeling and Reasoning Support for Early-Phase Requirements Engineering

RE '97 Proceedings of the 3rd IEEE International Symposium on Requirements Engineering
A UML profile for multidimensional modeling in data warehouses

Data & Knowledge Engineering - Special issue: ER 2003
Access control and audit model for the multidimensional modeling of data warehouses

Decision Support Systems
Developing secure data warehouses with a UML extension

Information Systems
Integrating Security and Software Engineering: Advances and Future Vision

Integrating Security and Software Engineering: Advances and Future Vision
An MDA approach for the development of data warehouses

Decision Support Systems
Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements

ARES '08 Proceedings of the 2008 Third International Conference on Availability, Reliability and Security
Implementing Multidimensional Security into OLAP Tools

ARES '08 Proceedings of the 2008 Third International Conference on Availability, Reliability and Security

Modeling of security requirements for decision information systems

ACM SIGSOFT Software Engineering Notes
Evaluation of approaches for designing secure data warehouse

Proceedings of the International Conference on Advances in Computing, Communications and Informatics
Not Ready for Prime Time: A Survey on Security in Model Driven Development

International Journal of Secure Software Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

Data Warehouses (DW) manage enterprise information for the decision making process, and the establishment of security measures at all stages of the DW development process is also highly important as unauthorized users may discover vital business information. Model Driven Architecture (MDA) based approaches allow us to define models at different abstraction levels, along with the automatic transformations between them. This has thus led to the definition of an MDA architecture for the development of secure DWs. This paper uses an example of a hospital to show the benefits of applying the MDA approach to the development of secure DWs. The paper is focused on transforming secure multidimensional Platform Independent Models (PIM) at the conceptual level into Platform Specific Models (PSM) at the logical level by defining the necessary set of Query/Views/Transformations (QVT) rules. This PSM model is therefore used to obtain the corresponding secure multidimensional code for a specific On-Line Analytical Processing (OLAP) platform such as SQL Server Analysis Services (SSAS).