Data Warehouses (DWs), 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 the early stages of the
DW design in the MD modeling process, and enforce them. In the past years, some proposals for representing main MD
modeling properties at the conceptual level have been stated. Nevertheless, none of these proposals considers security
issues as an important element in its model, 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 will discuss the specific confidentiality problems regarding
DWs as well as present an extension of the Unified Modeling Language for specifying security constraints in the
conceptual MD modeling, thereby allowing us to design secure DWs. One key advantage of our approach is that we
accomplish the conceptual modeling of secure DWs independently of the target platform where the DW has to be
implemented, allowing the implementation of the corresponding DWs on any secure commercial database management
system. Finally, we will present a case study to show how a conceptual model designed with our approach can be directly
implemented on top of Oracle 10g
Data Warehouses (DWs), 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 the early stages of the
DW design in the MD modeling process, and enforce them. In the past years, some proposals for representing main MD
modeling properties at the conceptual level have been stated. Nevertheless, none of these proposals considers security
issues as an important element in its model, 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 will discuss the specific confidentiality problems regarding
DWs as well as present an extension of the Unified Modeling Language for specifying security constraints in the
conceptual MD modeling, thereby allowing us to design secure DWs. One key advantage of our approach is that we
accomplish the conceptual modeling of secure DWs independently of the target platform where the DW has to be
implemented, allowing the implementation of the corresponding DWs on any secure commercial database management
system. Finally, we will present a case study to show how a conceptual model designed with our approach can be directly
implemented on top of Oracle 10g
การแปล กรุณารอสักครู่..
