Towards OLAP Security Design - Survey and Research Issues

With the use of data warehousing and online analytical processing (OLAP) for decision support applications new security issues arise. The goal of this paper is to introduce an OLAP security design methodology, pointing out fields that require further research work. We present possible access control requirements categorized by their complexity. OLAP security mechanisms and their implementations in commercial systems are presented and checked for their suitability to address the requirements. Traditionally data warehouses were queried by high level users (executive management, business analysts) only. As the range of potential users with data warehouse access is steadily growing, this assumption is no longer appropriate and the necessity of proper access control mechanisms arises. However, a data warehouse is primarily built as an open system. Especially exploratory OLAP analysis requires this open nature; security controls may hinder the analytical discovery process. Keywords Data war...

• Type: Conference
• Year: 2000
• Where: DOLAP
• Authors: Torsten Priebe, Günther Pernul
• Keywords: Access Control, Data Warehouse, DOLAP 2000, Information Management, OLAP Security