To search, Click below search items.

 

All Published Papers Search Service

Title

DW Access Control Model

Author

Attia El Sayed, Ali El Bastawissy, Ibrahim El Imam

Citation

Vol. 10  No. 10  pp. 197-201

Abstract

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.

Keywords

Security, Data Warehouse, OLAP, SCD Techniques

URL

http://paper.ijcsns.org/07_book/201010/20101029.pdf