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)

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)

Family Security Insurance: A New Foundation for Economic Security

A report released by Georgetown Law\u27s Workplace Flexibility 2010 and the Berkeley Center on Health, Economic & Family Security (Berkeley CHEFS) outlining a blueprint for establishing and financing a new national insurance program to provide wage replacement for time off for health and caregiving needs. The report describes the need among working Americans for time off from work to address personal illness, to care for a new child, or to care for a loved one with a serious illness. It argues that the need for time off is no longer an issue for individual families or select industries, but a national priority that has major social and economic implications. Family Security Insurance, the national insurance program proposed in the report, would fundamentally reform social policy to address workers\u27 critical needs, and, at the same time, spread the cost fairly, protect the deficit, and keep people working

Law | Environment | Africa

Law | Environment | Africa compiles the proceedings of the 5th Symposium and the 4th Scientific Conference of the Association of Environmental Law Lecturers from African Universities (ASSELLAU) in cooperation with the Climate Policy and Energy Security Programme for Sub-Saharan Africa run by the Konrad-Adenauer-Stiftung (KAS) and the United Nations Environment Programme (UNEP). The boo

Assessment of factors influencing the adoption of public private partnerships in water infrastructure projects in selected municipalities

In this thesis titled “Assessment of factors influencing the adoption of public private partnerships in water infrastructure projects in selected municipalities” the study explores what influences the pace of adoption of municipal public private partnerships (PPPs) in water infrastructure projects. The study (i) determines whether the municipal PPPs regulatory framework in South Africa compares to international best practice and (ii) assess the factors influencing the adoption of PPPs in water infrastructure in selected municipalities in the Gauteng Province. A qualitative research method through the use of case studies anchored the study. The study identifies cumbersome regulatory environment, political dynamics, complexity of PPPs, influences of labour unions among others as contributing to the slow adoption of municipal PPPs. The study contributes towards knowledge and practice by proposing a regulatory framework to improve the municipal PPP approval process.Thesis (PhD (Public Management and Administration))--University of Pretoria, 2022.School of Public Management and Administration (SPMA)PhD (Public Management and Administration)Unrestricte