An architecture for automatically developing secure OLAP applications from models
Por favor, use este identificador para citar o enlazar este ítem:
http://hdl.handle.net/10045/42560
Título: | An architecture for automatically developing secure OLAP applications from models |
---|---|
Autor/es: | Blanco Bueno, Carlos | García Rodríguez de Guzmán, Ignacio | Fernández-Medina Patón, Eduardo | Trujillo, Juan |
Grupo/s de investigación o GITE: | Lucentia |
Centro, Departamento o Servicio: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Palabras clave: | Security | Confidentiality | Model driven development | Data warehouse | OLAP | SQL Server Analysis Services |
Área/s de conocimiento: | Lenguajes y Sistemas Informáticos |
Fecha de publicación: | mar-2015 |
Editor: | Elsevier |
Cita bibliográfica: | Information and Software Technology. 2015, 59: 1-16. doi:10.1016/j.infsof.2014.10.008 |
Resumen: | Context: Decision makers query enterprise information stored in Data Warehouses (DW) by using tools (such as On-Line Analytical Processing (OLAP) tools) which use specific views or cubes from the corporate DW or Data Marts, based on the multidimensional modeling. Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized accesses. Objective: In previous work we have defined a Model-Driven based approach for developing a secure DWs repository by following a relational approach. Nevertheless, is also important to define security constraints in the metadata layer that connects the DWs repository with the OLAP tools, that is, over the same multidimensional structures that final users manage. This paper defines a proposal to develop secure OLAP applications and incorporates it into our previous approach. Method: Our proposal is composed of models and transformations. Our models have been defined using the extension capabilities from UML (conceptual model) and extending the OLAP package of CWM with security (logical model). Transformations have been defined by using a graphical notation and implemented into QVT and MOFScript. Finally, this proposal has been evaluated through case studies. Results: A complete MDA architecture for developing secure OLAP applications. The main contributions of this paper are: improvement of a UML profile for conceptual modeling; definition of a logical metamodel for OLAP applications; and definition and implementation of transformations from conceptual to logical models, and from logical models to the secure implementation into a specific OLAP tool (SSAS). Conclusion: Our proposal allows us to develop secure OLAP applications, providing a complete MDA architecture composed of several security models and automatic transformations towards the final secure implementation. Security aspects are early identified and fitted into a most robust solution that provides us a better information assurance and a saving of time in maintenance. |
Patrocinador/es: | This research is part of the following Projects: SIGMA-CC (TIN2012-36904), GEODAS-BC (TIN2012-37493-C01) and GEODAS-BI (TIN2012-37493-C03) funded by the Ministerio de Economía y Competitividad and Fondo Europeo de Desarrollo Regional FEDER. SERENIDAD (PEII11-037-7035) and MOTERO (PEII11- 0399-9449) funded by the Consejería de Educación, Ciencia y Cultura de la Junta de Comunidades de Castilla La Mancha, and Fondo Europeo de Desarrollo Regional FEDER. |
URI: | http://hdl.handle.net/10045/42560 |
ISSN: | 0950-5849 (Print) | 1873-6025 (Online) |
DOI: | 10.1016/j.infsof.2014.10.008 |
Idioma: | eng |
Tipo: | info:eu-repo/semantics/article |
Revisión científica: | si |
Versión del editor: | http://dx.doi.org/10.1016/j.infsof.2014.10.008 |
Aparece en las colecciones: | INV - LUCENTIA - Artículos de Revistas |
Archivos en este ítem:
Archivo | Descripción | Tamaño | Formato | |
---|---|---|---|---|
2014_Blanco_etal_Inf&SoftTech.pdf | Accepted Manuscript (acceso abierto) | 3,9 MB | Adobe PDF | Abrir Vista previa |
2014_Blanco_etal_Inf&SoftTech_final.pdf | Versión final (acceso restringido) | 7,25 MB | Adobe PDF | Abrir Solicitar una copia |
Todos los documentos en RUA están protegidos por derechos de autor. Algunos derechos reservados.