SECRDW: An Extension of the Relational Package from CWM for Representing Secure Data Warehouses at the Logical Level

Emilio Soler, Eduardo Fernández-Medina, Mario Piattini

2007

Abstract

Data Warehouses (DWs) constitute a valuable support to store extensive volumes of historical data for the decision making process. For this reason, it is vital to incorporate security requirements from the early stages of the DWs projects and enforce them in the further design phases. Very few approaches specify security and audit measures in the conceptual modeling of DWs. Furthermore, these security measures are specified in the final implementation on top of commercial systems as there is not a standard relational representation of security measures for DWs. On the other hand, the Common Warehouse Metamodel (CWM) has been accepted as the standard for the exchange and the interoperability of the metadata. Nevertheless, it does not allow us to specify security measures for DWs. In this paper, we make use of the own 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. Finally, 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.

Paper Citation

in Harvard Style

Soler E., Fernández-Medina E. and Piattini M. (2007). SECRDW: An Extension of the Relational Package from CWM for Representing Secure Data Warehouses at the Logical Level . In Proceedings of the 5th International Workshop on Security in Information Systems - Volume 1: WOSIS, (ICEIS 2007) ISBN 978-972-8865-96-2, pages 245-256. DOI: 10.5220/0002438002450256

in Bibtex Style

@conference{wosis07,
author={Emilio Soler and Eduardo Fernández-Medina and Mario Piattini},
title={SECRDW: An Extension of the Relational Package from CWM for Representing Secure Data Warehouses at the Logical Level},
booktitle={Proceedings of the 5th International Workshop on Security in Information Systems - Volume 1: WOSIS, (ICEIS 2007)},
year={2007},
pages={245-256},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002438002450256},
isbn={978-972-8865-96-2},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 5th International Workshop on Security in Information Systems - Volume 1: WOSIS, (ICEIS 2007)
TI - SECRDW: An Extension of the Relational Package from CWM for Representing Secure Data Warehouses at the Logical Level
SN - 978-972-8865-96-2
AU - Soler E.
AU - Fernández-Medina E.
AU - Piattini M.
PY - 2007
SP - 245
EP - 256
DO - 10.5220/0002438002450256