Data Warehouse Security
Akansha Rakheja, Ajay Pratap Singh · 2013
Data Warehouses (DW) manage crucial enterprise information used for the decision making process which has to be protected from unauthorized accesses. However, security constraints are not properly integrated in the complete DWs’ development process, being traditionally considered in the last stages. To ensure data privacy various solutions have been proposed and proven effective in their security purpose. One of the solutions is Log Based Security System where data masking approach have been proposed. Log Analysis for intrusion detection is the process use to detect attacks on a specific environment using logs as the primary source of information. It will be beneficial as we will come to know whether it is simple access or attack. Another solution we have proposed a model driven architecture (MDA) for secure DWs which takes into account security issues from the early stages of development and provides automatic transformations between models. Also, the Data Warehouse Striping (DWS) technique is a round-robin data partitioning approach especially designed for affordable data warehousing environments uses data encryption, spurious data, signatures, and redundancy to guarantee full data protection even when an attacker gets administrative access to one or more cluster nodes.