Using UML packages for designing secure data warehouses

Authors:
Rodolfo Villarroel;Emilio Soler;Eduardo Fernández-Medina;Juan Trujillo;Mario Piattini
Affiliations:
Departamento de Computación e Informática., Catholic University of Maule, Talca, Chile;Departamento de Informática., University of Matanzas, Matanzas, Cuba;Alarcos Research Group. Information Systems and Technologies Department, UCLM-Soluziona Research and Development Institute, University of Castilla-La Mancha, Ciudad Real, Spain;Departamento de Lenguajes y Sistemas Informáticos., University of Alicante, Alicante, Spain;Alarcos Research Group. Information Systems and Technologies Department, UCLM-Soluziona Research and Development Institute, University of Castilla-La Mancha, Ciudad Real, Spain
Venue:
ICCSA'06 Proceedings of the 2006 international conference on Computational Science and Its Applications - Volume Part III
Year:
2006

Citing 9
Cited 0

starER: a conceptual model for data warehouse design

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Software engineering for security: a roadmap

Proceedings of the Conference on The Future of Software Engineering
Technical opinion: Information system security management in the new millennium

Communications of the ACM
Towards OLAP security design — survey and research issues

Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
Designing Data Warehouses with OO Conceptual Models

Computer
Multidimensional Modeling with UML Package Diagrams

ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
Extending the E/R Model for the Multidimensional Paradigm

ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
A Prototype Model for Data Warehouse Security Based on Metadata

DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Applying MDA to the development of data warehouses

Proceedings of the 8th ACM international workshop on Data warehousing and OLAP

Quantified Score

Hi-index	0.00

Visualization

Abstract

Due to the sensitive data contained in Data Warehouses (DWs), it is essential to specify security measures from the early stages of the DWs design and enforce them. In this paper, we will present a UML profile to represent multidimensional and security aspects of our conceptual modeling. Our approach proposes the use of UML packages in order to group classes together into higher level units creating different levels of abstraction, and therefore, simplifying the final model. Furthermore, 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 modeling of DWs. Finally, we will show an example to illustrate the applicability of our proposal.