WSEAS Transactions on Computers
Print ISSN: 1109-2750, E-ISSN: 2224-2872
Volume 15, 2016
Implementing Security for Multidimensional Expression Queries
Authors: ,
Abstract: As the security takes center stage in the recent years, most important projects underway are those associated within security. Organizations collect and process data to operate their day-to-day business successfully. Such data is stored in enterprises data warehouses and presented so that users can make decisions more easily. Online Analytical Processing (OLAP) is the prevalent component of these systems where data is organized in the form of multidimensional representation known as a data cube. A specialized query language called multidimensional expression (MDX) is then used with specific syntax and semantics for manipulating OLAP cubes. However, MDX users can override- either intentionally or unintentionally - the security policy of the system to disclose sensitive information and breach an individual’s privacy. In this paper, we present a framework that removes security threats by re-writing MDX queries to ensure consistent data accessing. Experimental results demonstrate that security can be ensured without affecting the usefulness of OLAP systems.
Search Articles
Pages: 64-75
WSEAS Transactions on Computers, ISSN / E-ISSN: 1109-2750 / 2224-2872, Volume 15, 2016, Art. #7