An MDA approach for developing Secure OLAP applications: metamodels and transformations

Decision makers query enterprise information stored in Data Warehouses (DW) by using tools (such as On-Line Analytical Processing (OLAP) tools) which employ specific views or cubes from the corporate DW or Data Marts, based on multidimensional modelling. Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized access. In previous work we defined a Model-Driven based approach for developing a secure DW repository by following a relational approach. Nevertheless, it is also important to define security constraints in the metadata layer that connects the DW repository with the OLAP tools; that is, over the same multidimensional structures that end users manage. This paper incorporates a proposal for developing secure OLAP applications within our previous approach: it improves a UML profile for conceptual modelling; it defines a logical metamodel for OLAP applications; and it defines and implements transformations from conceptual to logical models, as well as from logical models to secure implementation in a specific OLAP tool (SQL Server Analysis Services).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

Showing the Benefits of Applying a Model Driven Architecture for Developing Secure OLAP Applications

Data Warehouses (DW) manage enterprise information that is queried for decision making purposes by using On-Line Analytical Processing (OLAP) tools. The establishment of security constraints in all development stages and operations of the DW is highly important since otherwise, unauthorized users may discover vital business information. The final users of OLAP tools access and analyze the information from the corporate DW by using specific views or cubes based on the multidimensional modelling containing the facts and dimensions (with the corresponding classification hierarchies) that a decision maker or group of decision makers are interested in. Thus, it is important that security constraints will be also established over this metadata layer that connects the DW's repository with the decision makers, that is, directly over the multidimensional structures that final users manage. In doing so, we will not have to define specific security constraints for every particular user, thereby reducing the developing time and costs for secure OLAP applications. In order to achieve this goal, a model driven architecture to automatically develop secure OLAP applications from models has been defined. This paper shows the benefits of this architecture by applying it to a case study in which an OLAP application for an airport DW is automatically developed from models. The architecture is composed of: (1) the secure conceptual modelling by using a UML profile; (2) the secure logical modelling for OLAP applications by using an extension of CWM; (3) the secure implementation into a specific OLAP tool, SQL Server Analysis Services (SSAS); and (4) the transformations needed to automatically generate logical models from conceptual models and the final secure implementation.This research is part of the following projects: SERENIDAD (PEII11- 037-7035) financed by the ”Viceconsejería de Ciencia y Tecnología de la Junta de Comunidades de Castilla-La Mancha” (Spain) and FEDER, and SIGMA-CC (TIN2012-36904) and GEODAS (TIN2012-37493-C03-01) financed by the ”Ministerio de Economía y Competitividad” (Spain)

An MDA approach for developing secure OLAP applications: Metamodels and transformations

Decision makers query enterprise information stored in DataWarehouses (DW) by using tools (such as On-Line Analytical Processing (OLAP) tools) which employ specific views or cubes from the corporate DW or Data Marts, based on multidimensional modelling. Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized access. In previous work we defined a Model-Driven based approach for developing a secure DW repository by following a relational approach. Nevertheless, it is also important to define security constraints in the metadata layer that connects the DW repository with the OLAP tools; that is, over the same multidimensional structures that end users manage. This paper incorporates a proposal for developing secure OLAP applications within our previous approach: it improves a UML profile for conceptual modelling; it defines a logical metamodel for OLAP applications; and it defines and implements transformations from conceptual to logical models, as well as from logical models to secure implementation in a specific OLAP tool (SQL Server Analysis Services). © 2015 ComSIS Consortium. All rights reserved.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

Speaking Together: Exploring Discourses of 'Dutchness' in Language Learning, Voluntarism, and Active Citizenship

My dissertation examines everyday understandings of citizenship as expressed by voluntary Dutch language coaches in Amsterdam, the Netherlands. Based on thirteen months of ethnographic research, the primary methods used in this study were in-depth semi-structured interviews and participant observation. These methods were complemented by archival research examining policy documents, key discussions in mainstream Dutch media, and promotional materials developed by the voluntary organizations studied. Adopting a Foucauldian approach to governmentality informed by the work of Tania Li, Mitchell Dean, Ann Laura Stoler, and Aihwa Ong, this study considers how volunteer Dutch language coaches both reproduce and challenge contemporary discourses around citizenship and belonging in Dutch society. Since the 1990s, in the Netherlands and across the European Union, concerns over increasing cultural diversity and diminishing social cohesion have centred on marginalized, non-Western (Muslim) newcomers and their descendants. These concerns have developed concurrently with neoliberal interventions that have included the downloading of social service provision including immigrant integration to lower levels of government, private and not-for-profit civil society organizations, and individual citizens as volunteers. Cross-cutting historical, colonial calculations of Dutchness and more recent expressions of neoliberal active citizenship (Ong 1996; Muehlebach 2012), the Dutch language has emerged as a key symbol of belonging, and technique for teaching the technology of government to newcomers. In this context I argue that Amsterdams Dutch language coaching volunteers fill an important role as front-line citizenship educators, offering a unique perspective through which to study citizenship. Alongside teaching newcomers the language skills required to naturalize, coaches convey their own ideas of citizenship and belonging as an everyday ethic and practice of community building. Through their voluntary work and expressions of meaningful social integration and citizenship, these research participants consent to and extend the reach of government into the private lives of (potential) citizens. The tensions, practices, and contradictions around belonging revealed by these participants underscore the awkward continuities (Dean 2010:57) with the powerful grammar of difference and Dutchness developed through the experience of empire, and how entangled discourses of cultural difference and neoliberal active citizenship shape state and everyday notions of morally and culturally attuned citizenship practice

Showing the Benefits of Applying a Model Driven Architecture for

Data Warehouses (DW) manage enterprise information that is queried for decision making purposes by using On-Line Analytical Processing (OLAP) tools. The establishment of security constraints in all development stages and operations of the DW is highly important since otherwise, unauthorized users may discover vital business information. The final users of OLAP tools access and analyze the information from the corporate DW by using specific views or cubes based on the multidimensional modelling containing the facts and dimensions (with the corresponding classification hierarchies) that a decision maker or group of decision makers are interested in. Thus, it is important that security constraints will be also established over this metadata layer that connects the DW's repository with the decision makers, that is, directly over the multidimensional structures that final users manage. In doing so, we will not have to define specific security constraints for every particular user, thereby reducing the developing time and costs for secure OLAP applications. In order to achieve this goal, a model driven architecture to automatically develop secure OLAP applications from models has been defined. This paper shows the benefits of this architecture by applying it to a case study in which an OLAP application for an airport DW is automatically developed from models. The architecture is composed of: (1) the secure conceptual modelling by using a UML profile; (2) the secure logical modelling for OLAP applications by using an extension of CWM; (3) the secure implementation into a specific OLAP tool, SQL Server Analysis Services (SSAS); and (4) the transformations needed to automatically generate logical models from conceptual models and the final secure implementation.This research is part of the following projects: SERENIDAD (PEII11- 037-7035) financed by the ”Viceconsejería de Ciencia y Tecnología de la Junta de Comunidades de Castilla-La Mancha” (Spain) and FEDER, and SIGMA-CC (TIN2012-36904) and GEODAS (TIN2012-37493-C03-01) financed by the ”Ministerio de Economía y Competitividad” (Spain)

BESTFACT Best Practice Handbook 3

The Best Practice Handbook (BPH) gives an overview about current concepts, strategies and actions in freight transport all over Europe. It is disseminating information on successful projects and practices to increase awareness and share experiences. It is enabling knowledge transfer and supporting transferability for best practices. The third and last Best Practice Handbook focuses on the work done over the entire project, with 157 inventory cases and 60 in-depth analyses. After four years of case collection a wide field of solutions is available. The main findings of the BESTFACT cases are cross-checked and summarised for each of the cluster topics. The consistent form of collection and information provision broadens the structural understanding of best practice cases. The synthesis of cases per topic shows that under consideration of barriers and framework conditions replicable impacts are achievable. Main editors are Martin Ruesch & Simon Bohne (Rapptrans) and Jacques Leonardi (UoW). Project leader is Marcel Huschebeck (PTV)

We cannot continue like this

The book is based on the view that the present trajectory of modern development cannot continue as it is now because it is ecologically unsustainable, it continues to enlarge the gap between rich and poor, and the decolonialisation movement has drawn our attention again to the specific role of religion, culture and value in human affairs and the need for a robust element of indigenisation and contextualisation. This book is strongly focused on the context of Africa, with two chapters that are written by authors from the Netherlands, for the purpose of presenting a North-South dialogue. The book contains reflection on approaches followed in building sustainable human communities in general and reflection on specific efforts to solve sustainability issues. It seeks to integrate academic reflection and insights gained from practical involvement with sustainability issues in local communities and low-income households, with contributions from Theology and Natural and Social Sciences