Evaluation of approaches for designing secure data warehouse

• Authors: Indu Singh;Manoj Kumar
• Venue: Proceedings of the International Conference on Advances in Computing, Communications and Informatics
• Year: 2012

Data Warehouse (DW) systems maintain sensitive and crucial information integrated from various heterogeneous sources of the organization, that needs to be protected from unauthorized users. This motivates researchers to consider the issue of information security during the design and development of DW systems. It has also been recognized by the researchers that the information security issue must be considered from the early stages of DW systems development life cycle. In this paper, we survey different relevant approaches for DW design considering issues of information security. Having surveyed the various approaches in the DW literature, we observed that most of the approaches consider security issue right from the conceptual model and moves towards subsequent logical and physical model. However, very little work is seen in the DW literature that considers security aspect from requirements level, which is very important to arrive at subsequent models of DW. Further, we evaluated different approaches for DW design on various security specific parameters like confidentiality, integrity, availability, access control and audit measures, inference control, traceability, interoperability, etc. The proposed evaluation will help the designers while selecting the appropriate approach for designing a secure DW. This will also motivate readers to explore the possibility of proposing new approach for DW design considering security issues into account.