To search, Click below search items.


All Published Papers Search Service


DW Access Control Model


Attia El Sayed, Ali El Bastawissy, Ibrahim El Imam


Vol. 10  No. 10  pp. 197-201


Data warehouse collects and integrates critical data of organization from multiple sources and stores them for a long time in multidimensional model. This nature motivates researchers to propose set of models to secure these data. In this paper, we present an enhanced authorization model in order to close open security holes in Data Warehouse (DW) and On-Line Analytical Process (OLAP). We focus on adding much flexibility to formats of security rules besides controlling access to combination of fact and dimension to grant user the required permissions to perform his work only. As an integral part of this model, we present new methodology to avoid bad security impacts which are result from using Slowly Changing Dimension (SCD) techniques which track time-variant dimension modifications.


Security, Data Warehouse, OLAP, SCD Techniques