Security Issues in Data Warehouse

TL;DR

This paper reviews security challenges and approaches in data warehouse environments, emphasizing the importance of protecting sensitive data stored in large, heterogeneous repositories for organizational decision-making.

Contribution

It provides a comprehensive review of existing security approaches tailored for data warehouses and discusses specific issues associated with each security method.

Findings

Identifies key security challenges in data warehouses.

Analyzes effectiveness of various security approaches.

Highlights gaps in current security measures.

Abstract

Data Warehouse provides storage for huge amounts of historical data from heterogeneous operational sources in the form of multidimensional views, thus supplying sensitive and useful information which help decision-makers to improve the organizations business processes. A data warehouse environment must ensure that data collected and stored in one big repository are not vulnerable. A review of security approaches specifically for data warehouse environment and issues concerning each type of security approach have been provided in this paper.