An extension of the Relational Metamodel of CWM to represent Secure Data Warehouses at the Logical Level

Generally, security and audit measures for Data Warehouses (DWs) are defined in the final implementation on top of commercial systems because there is not a standard for the exchange and the operability of metadata. The Common Warehouse Metamodel (CWM) proposal is broadly accepted as the standard for the interchange and the interoperability of metadata. Nevertheless, it does not allow us to specify security measures. In this paper, we make use of the extension mechanisms provided by the CWM to extend the relational package to specify, at the logical level, the security and audit rules captured during the conceptual modeling phase of the DWs design. Moreover, in order to show the benefits of our extension, we apply it to a case study related to the management of the pharmacies consortium businesses.