AppLying QVT in order to implement secure data warehouses in SQL server analysis services

Journal of Research and Practice in Information Technology

Volumn 41, Issue 2, 2009, Pages 135-154

  Blanco, Carlos ^a   De Guzmán, Ignado García Rodríguez ^a   Rosado, David G ^a   Fernández Medina, Eduardo ^a   Trujillo, Juan ^b  

^a UNIVERSITY OF CASTILLA LA MANCHA   (Spain)

^b UNIVERSITY OF ALICANTE   (Spain)

Author keywords

Data warehouses; MDA; OLAP; QVT; Security

Indexed keywords

ABSTRACTION LEVEL; CONCEPTUAL MODEL; DECISION MAKING PROCESS; HISTORICAL INFORMATION; MDA; MDA APPROACH; OLAP; QVT; SECURE DATA; SECURITY; SECURITY CONSTRAINT; SECURITY RULES; SQL SERVERS; UNAUTHORIZED USERS;

ARCHITECTURAL DESIGN;

DATA WAREHOUSES;

EID: 68049118693     PISSN: 1443458X     EISSN: None     Source Type: Journal    
DOI: None     Document Type: Article

References (25)

1. BASIN, D., DOSER, J. and LODDERSTEDT, T. (2006): Model driven security: from UML models to access control infrastructures. ACM Transactions on Software Engineering and Methodology, 15: 39-91.
2. BLANCO, C, FERNÁNDEZ-MEDINA, E., TRUJILLO, J. and PIATTINI, M. (2008): Implementing multidimensional security into OLAP tools. Third International Workshop "Dependability Aspects on Data Warehousing and Mining applications" (DAWAM2008) Barcelona, Spain, IEEE Computer Society.
3. CWM, O.M.G. (2003): Common warehouse metamodel (CWM).
4. CZARNECKI, K. and HELSEN, S. (2003): Classification of model transformation approaches. 2nd OOPSLA Workshop on Generative Techniques in the Context of the Model Driven Architecture. Anaheim.
5. DENKER, G., KAGAL, L. and FININ, T. (2005): Security in the semantic web using OWL. Information Security Technical Report, 10:51-58.
6. DEVANBU, P. and STUBBLEBINE, S. (2000): Software engineering for security: a roadmap. ACM Press. Future of Software Engineering, 227-239.
7. DHILLON, G. (2001): Information Security Management: Global challenges in the new millennium. Idea Group Publishing.
8. FERNÁNDEZ-MEDINA, E..TRUJILLO, J. and PIATTINI, M. (2007a): Model driven multidimensional modelling of secure data warehouses. European Journal of Information Systems, 16: 374-389.
9. FERNÁNDEZ-MEDINA, E., TRUJILLO, J., VILLARROEL, R. and PIATTINI, M. (2006): Access control and audit model for the multidimensional modelling of data warehouses. Decision Support Systems, 42: 1270-1289.
10. FERNÁNDEZ-MEDINA, E., TRUJILLO, J., VILLARROEL, R. and PIATTINI, M. (2007b): Developing secure data warehouses with a UML extension. Information Systems, 32: 826-856.
11. JÜRJENS, J. (2002): UMLsec: Extending UML for secure systems development. In JÉZÉQUEL, J., HUSSMANN, H. and COOK, S. (Eds.) UML 2002 - The Unified Modeling Language, Model engineering, concepts and tools. Dresden, Germany, Springer. LNCS 2460.
12. JÜRJENS, J. (2004): Secure Systems Development with UML, Springer-Verlag.
13. KATIC, N. QUIRCHMAYR, G.,SCHIEFER, J.,STOLBA, M. and MIN TJOA, A. (1998): A prototype model for data warehouse security based on metadata. 9th International Workshop on Database and Expert Systems Applications · (DEXA'98). Vienna, Austria., IEEE Computer Society.
14. KIMBALL, R. (2002): The Data Warehouse Toolkit 2° Edition, John Wiley & Sons.
15. KIRKGÖZE, R., KATIC, N., STOLDA, M. and MIN TJOA, A. (1997): A security concept for OLAP. 8th International Workshop on Database and Expert System Applications (DEXA'97). Toulouse, France, IEEE Computer Society.
16. LODDERSTEDT, T., BASIN, D. and DOSER, J. (2002): SecureUML: A UML-based modelling language for model-driven security. UML 2002. The Unified Modeling Language. Model Engineering, Languages Concepts, and Tools. 5th International Conference. Dresden, Germany, Springer.
17. LUJÁN-MORA, S..TRUJILLO, J. and SONG, I.Y. (2006): A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering, 59: 725-769.
18. MOF, O.M.G. (2006) Meta-Object Facility (MOF) Core Specification v2.0.
19. MOURATIDIS, H. and GIORGINI, P. (2006): An Introduction. Integrating Security and Software Engineering: Advances and Future Visions. Idea Group Publishing.
20. OMG (2003): Model driven architecture guide Version 1.0.1.
21. OMG (2005): MOF QVT final adopted specification.
22. PRIEBE, T. and PERNUL, G. (2001): A pragmatic approach to conceptual modelling of OLAP security. 20th International Conference on Conceptual Modeling (ER 2001). Yokohama, Japan, Springer-Verlag.
23. SOLER, E., STEFANOV, V., MAZÓN, J-N., TRUJILLO, J., FERNÁNDEZ-MEDINA, E. and PIATTINI, M. (2008a): Towards comprehensive requirement analysis for data warehouses: Considering security requirements. Proceedings of The Third International Conference on Availability, Reliability and Security (ARES) Barcelona, Spain, IEEE Computer Society.
24. SOLER, E., TRUJILLO, J., FERNÁNDEZ-MEDINA, E. and PIATTINI, M. (2007): A set of QVT relations to transform PIM to PSM in the design of secure data warehouses. IEEE International Symposium on Frontiers on Availability, Reliability and Security (FARES 2007). Vienna, Austria.
25. SOLER, E., TRUJILLO, J., FERNÁNDEZ-MEDINA, E. and PIATTINI, M. (2008b): Building a secure star schema in data warehouses by an extension of the relational package from CWM. Computer Standard and Interfaces, 30: 341-350.