Simulating Secure Data Extraction in Extraction Transformation Loading (ETL) Processes

As the data warehouse contains the sensitive information, which is used for decision making process, it is necessary to take precautionary measures in the data warehouse building process itself. Current approaches for the conceptual modeling of ETL do not address the security aspects in the conceptual modeling phase. In this paper, we propose a simulation model for secure data extraction in ETL processes. Simulating these types of scenarios with security constraints is crucial in producing quality software. The scenario is more complicated in case of ETL processes due to its heterogeneity and distributed nature. ETL stands for extraction, transformation and loading. These are the tools used to extract the data from heterogeneous distributed databases, clean it, transform it and load into data warehouses. We exploit mitigation use cases which are used for implementing security policies of the system. A tool has been developed for the model and the features of the tool are explained and validated with a case study.