A Pragmatic Approach to Conceptual Modeling of OLAP Security

  • Authors:
  • Torsten Priebe;Günther Pernul

  • Affiliations:
  • -;-

  • Venue:
  • ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

Traditionally data warehouses were queried by high level users (executive management, business analysts) only. As the range of potential users with data warehouse access is steadily growing, this assumption is no longer appropriate and the necessity of proper access control mechanisms arises. The security capabilities of available commercial OLAP systems are highly proprietary and the syntax of their security constraints is not suitable for design and documentation purposes. Also, approaches trying to derive the access control policies from the operational data sources have not been very successful, as the relational model is predominate in operational systems while OLAP systems make use of the non-traditional multidimensional model. Access control schemes do not map easily. We approach the issue from the application side by introducing a methodology and a language for conceptual OLAP security design.