Representing security and audit rules for data warehouses at the logical level by using the common warehouse metamodel

  • Soler E
  • Villarroel R
  • Trujillo J
 et al. 
  • 19


    Mendeley users who have this article in their library.
  • 15


    Citations of this article.


Data warehouses (DWs) contained high sensitive data, and therefore, it is essential to specify security measures from the early stages of the DW design and enforce them. Access control models for transactional (relational) databases, based on tables, columns and rows, are not appropriate for DWs. Instead, security and audit rules defined for DWs must be specified based on the multidimensional (MD) modeling used to design data warehouses. So far, very few approaches represent security measures in the conceptual modeling of data warehouses form the early stages of a DW project. Moreover these security measures cannot be directly represented in the relational model for data warehouses, thereby having a semantic gap between the conceptual and logical schemas. In this paper, we present an extension of the relational model to consider security and audit measures represented in the conceptual modeling. To accomplish this, we based on the relational package of the common warehouse metamodel (CWM) and extend it to properly represent all security and audit rules defined in the conceptual modelling of data warehouses. Finally, to show the benefit of our approach, we apply our proposal to a health care case study.

Get free article suggestions today

Mendeley saves you time finding and organizing research

Sign up here
Already have an account ?Sign in

Find this document


  • Emilio Soler

  • Rodolfo Villarroel

  • Juan Trujillo

  • Eduarde Fernández-Medina

  • Mario Piattini

Cite this document

Choose a citation style from the tabs below

Save time finding and organizing research with Mendeley

Sign up for free