How to implement multidimensional security into OLAP tools

Blanco, Carlos; Fernandez-Medina, E.; Trujillo, Juan; Piattini, Mario

doi:10.1504/ijbidm.2008.022136

Cited by 3 publications

(1 citation statement)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Previously to the construction of our metamodel, the security capabilities provided by OLAP tools and how secure DWs could be implemented into them were studied in [26]. The SECMDDW metamodel has been developed based on the CWM metamodel [24] which is the OMG proposal for representing and interchanging metadata for data warehousing and business intelligence.…”

Section: Logical Metamodel For Secure Olap Applicationsmentioning

confidence: 99%

An architecture for automatically developing secure OLAP applications from models

Blanco

Guzmán

Fernández‐Medina

et al. 2015

Information and Software Technology

Self Cite

View full text Add to dashboard Cite

Please cite this article as: C. Blanco, I.G. de Guzmán, E. Fernández-Medina, J. Trujillo, An architecture for automatically developing Secure OLAP applications from models, Information and Software Technology (2014), doi: http://dx.doi.org/10.1016/j.infsof. 2014.10.008 This is a PDF file of an unedited manuscript that has been accepted for publication. As a service to our customers we are providing this early version of the manuscript. The manuscript will undergo copyediting, typesetting, and review of the resulting proof before it is published in its final form. Please note that during the production process errors may be discovered which could affect the content, and all legal disclaimers that apply to the journal pertain. AbstractDecision 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 modelling. Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized accesses. In previous work we have defined a ModelDriven 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 incorporates a proposal to develop secure OLAP applications into our previous approach: improves a UML profile for conceptual modelling; defines a logical metamodel for OLAP applications; and * Corresponding author Email addresses: Carlos.Blanco@unican.es (Carlos Blanco), Ignacio.GRodriguez@uclm.es (Ignacio García-Rodríguez de Guzmán), Eduardo.Fdezmedina@uclm.es (Eduardo Fernández-Medina), jtrujillo@dlsi.ua.es (Juan Trujillo) Preprint submitted to Information and Software Technology November 4, 2014 defines and implements transformations from conceptual to logical models, and from logical models to the secure implementation into a specific OLAP tool (SQL Server Analysis Services).

show abstract

Section: Logical Metamodel For Secure Olap Applicationsmentioning

confidence: 99%