Abstract
Data Warehouses (DW) manage enterprise information for the decision making process, and the establishment of security measures at all stages of the DW development process is also highly important as unauthorized users may discover vital business information. Model Driven Architecture (MDA) based approaches allow us to define models at different abstraction levels, along with the automatic transformations between them. This has thus led to the definition of an MDA architecture for the development of secure DWs. This paper uses an example of a hospital to show the benefits of applying the MDA approach to the development of secure DWs. The paper is focused on transforming secure multidimensional Platform Independent Models (PIM) at the conceptual level into Platform Specific Models (PSM) at the logical level by defining the necessary set of Query/Views/Transformations (QVT) rules. This PSM model is therefore used to obtain the corresponding secure multidimensional code for a specific On-Line Analytical Processing (OLAP) platform such as SQL Server Analysis Services (SSAS).
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Dhillon, G., Backhouse, y.J.: Information system security management in the new millennium. Communications of the ACM 43(7), 125–128 (2000)
Mouratidis, H., Giorgini, y.P.: An Introduction. In: Integrating Security and Software Engineering: Advances and Future Visions. Idea Group Publishing (2006)
MDA, O.M.G., Model Driven Architecture Guide (2003)
OMG, MOF QVT final adopted specification (2005)
OMG, Meta Object Facility (MOF) specification (2002)
Fernández-Medina, E., Trujillo, J., Piattini, y.M.: Model Driven Multidimensional Modeling of Secure Data Warehouses. European Journal of Information Systems 16, 374–389 (2007)
Katic, N., Quirchmayr, G., Schiefer, J., Stolba, M., Tjoa, y.A.: A Prototype Model for DW Security Based on Metadata. In: en 9th Int. Workshop on DB and Expert Systems Applications, Vienna, Austria (1998)
Kirkgöze, R., Katic, N., Stolda, M., Tjoa, y.A.: A Security Concept for OLAP. In: en 8th Int. Workshop on Database and Expert System Applications, Toulouse, France (1997)
Priebe, T., Pernul, y.G.: A Pragmatic Approach to Conceptual Modeling of OLAP Security. In: en 20th Int. Conference on Conceptual Modeling, Yokohama, Japan (2001)
Mazón, J.-N., Trujillo, y.J.: An MDA approach for the development of data warehouses. Decision Support Systems 45(1), 41–58 (2008)
Soler, E., Stefanov, V., Mazón, J.-N., Trujillo, J., Fernández-Medina, E., Piattini, y.M.: Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements. In: en Proccedings of The Third International Conference on Availability, Reliability and Security (ARES). IEEE Computer Society, Barcelona (2008)
Yu, E.: Towards modelling and reasoning support for early-phase requirements engineering. In: en 3rd IEEE International Symposium on Requirements Engineering (RE 1997), Washington, DC (1997)
Fernández-Medina, E., Trujillo, J., Villarroel, R., Piattini, y.M.: Developing secure data warehouses with a UML extension. Information Systems 32(6), 826–856 (2007)
Soler, E., Trujillo, J., Fernández-Medina, E., Piattini, y.M.: SECRDW: An Extension of the Relational Package from CWM for Representing Secure Data Warehouses at the Logical Level. In: en International Workshop on Security in Information Systems, Funchal, Madeira, Portugal (2007)
Luján-Mora, S., Trujillo, J., Song, y.I.-Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering 59(3), 725–769 (2006)
Fernández-Medina, E., Trujillo, J., Villarroel, R., Piattini, y.M.: Access control and audit model for the multidimensional modeling of data warehouses. Decision Support Systems 42(3), 1270–1289 (2006)
Blanco, C., Fernández-Medina, E., Trujillo, J., Piattini, y.M.: Implementing Multidimensional Security into OLAP Tools. In: en Third International Workshop Dependability Aspects on Data WArehousing and Mining applications (DAWAM 2008). IEEE Computer Society, Barcelona (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Blanco, C., García-Rodríguez de Guzmán, I., Fernández-Medina, E., Trujillo, J., Piattini, M. (2008). Automatic Generation of Secure Multidimensional Code for Data Warehouses: An MDA Approach. In: Meersman, R., Tari, Z. (eds) On the Move to Meaningful Internet Systems: OTM 2008. OTM 2008. Lecture Notes in Computer Science, vol 5332. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-88873-4_9
Download citation
DOI: https://doi.org/10.1007/978-3-540-88873-4_9
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-88872-7
Online ISBN: 978-3-540-88873-4
eBook Packages: Computer ScienceComputer Science (R0)