A UML profile for designing secure data warehouses

Data Warehouses (DW´s), Multidimensional 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 the main MD modeling properties at the conceptual level. Nevertheless, none of these proposals, considers security issues 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 regarding DW´s and their corresponding MD modeling properties and we propose an UML profile that allows us to specify main security aspects in the conceptual MD modeling. We show the benefit of our approach by applying this profile to an example. Finally, we also sketch how to implement the security aspects considered in our conceptual modeling approach in a commercial DBMS