Adopting Privacy Regulations in a Data Warehouse A Case of the Anonimity versus Utility Dilemma
This paper investigates how privacy can be protected in a data warehouse while, at the same time, an organisation tries to be as open as possible. First, we perform a literature review on relevant techniques and methods to preserve privacy and show that k anonimity can be applied to comply with an organisation's requirements. Then, we propose two design strategies to adopt privacy regulations within a data warehouse. The first proposal shows that during the ETL process a data transformation can be performed to effectively realise anonimised records in a business intelligence environment. The second proposal shows that with views and a having clause, anonimisation can be arranged as well.
KDIR