Extending UML for designing secure data warehouses

Eduardo Fernández-Medina, Juan Trujillo, Rodolfo Villarroel, Mario Piattini

Research output: Chapter in Book/Report/Conference proceedingChapterpeer-review

14 Scopus citations

Abstract

Data Warehouses (DW), Multidimensional (MD) Databases, and On-Line Analytical Processing Applications are used as a very powerful mechanism for discovering crucial business information. Considering the extreme importance of the information managed by these kinds of applications, it is essential to specify security measures from early stages of the DW design in the MD modeling process, and enforce them. In the past years, there have been some proposals for representing main MD modeling properties at the conceptual level. Nevertheless, none of these proposals considers security measures as an important element in their models, so they do not allow us to specify confidentiality constraints to be enforced by the applications that will use these MD models. In this paper, we discuss the confidentiality problems regarding DW's and we present an extension of the Unified Modeling Language (UML) that allows us to specify main security aspects in the conceptual MD modeling, thereby allowing us to design secure DW's. Then, we show the benefit of our approach by applying this extension to a case study. Finally, we also sketch how to implement the security aspects considered in our conceptual modeling approach in a commercial DBMS.

Original languageEnglish
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
EditorsPaolo Atzeni, Wesley Chu, Hongjun Lu, Shuigeng Zhou, Tok Wang Ling
PublisherSpringer Verlag
Pages217-230
Number of pages14
ISBN (Print)3540237232, 9783540237235
DOIs
StatePublished - 2004
Externally publishedYes

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume3288
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Keywords

  • Multidimensional modeling
  • OCL
  • Secure data warehouses
  • UML extension

Fingerprint

Dive into the research topics of 'Extending UML for designing secure data warehouses'. Together they form a unique fingerprint.

Cite this