A model of security design for data warehouses with OLS10g semiautomatic implementation

In real world data warehouses implementations, the sensitive information that the final users can access is normally accomplished by limiting the OLAP operations that certain final users can apply on specific data. However, we deeply believe that these security aspects should also be considered together with data in the corresponding conceptual multidimensional model. In this paper, we present an approach for designing secure data warehouses, which is aligned with the MDA and the MDS approaches, because we accomplish the conceptual modeling of secure data warehouses independently from the target platform where the data warehouse has to be implemented, and because this approach considers design models and security models, which are combined, leading to a new kind of models that is called security design model. Finally, we present how the conceptual model can be implemented in a semiautomatic way with Oracle10g Label Security.