How to implement multidimensional security into OLAP tools

  • Authors:
  • Carlos Blanco;Eduardo Fernandez-/Medina;Juan Trujillo;Mario Piattini

  • Affiliations:
  • Dept of Information Technologies and Systems, Escuela Superior de Informatica, Alarcos Research Group - Institute of Information Technologies and Systems, Univ of Castilla-/La Mancha, Paseo de ...;Dept of Information Technologies and Systems, Escuela Superior de Informatica, Alarcos Research Group - Institute of Information Technologies and Systems, Univ of Castilla-/La Mancha, Paseo de ...;Department of Software and Computing Systems, LUCENTIA Research Group, University of Alicante, San Vicente s&#/#/47/n, 03690, Alicante, Spain.;Dept of Information Technologies and Systems, Escuela Superior de Informatica, Alarcos Research Group - Institute of Information Technologies and Systems, Univ of Castilla-/La Mancha, Paseo de ...

  • Venue:
  • International Journal of Business Intelligence and Data Mining
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data Warehouses (DWs) manage historical information for the decision-making process and for enterprises. Online Analytical Processing Applications (OLAP) tools are the most used tools for implementing and consulting DWs and it is necessary to define security measures to avoid the accessing of unauthorised information by users by executing queries. It is vitally important to consider security requirements from the earliest stages of the development process. We have created a Model-Driven Architecture (MDA) to develop a secure DW and in this paper, we propose how to implement the security measures that are defined at upper abstraction levels using our approach to SQL Server Analysis Services (SSAS).