IMPROVING THE PERFORMANCE OF DATABASE-CENTRIC APPLICATIONS THROUGH PROGRAM ANALYSIS

Modern software applications are becoming more dependent on database management systems (DBMSs). DBMSs are usually used as black boxes by software developers. For example, Object-Relational Mapping (ORM) is one of the most popular database abstraction approaches that developers use nowadays. Using ORM, objects in Object-Oriented languages are mapped to records in the database, and object manipulations are automatically translated to SQL queries. As a result of such conceptual abstraction, developers do not need deep knowledge of databases; however, all too often this abstraction leads to inefficient and incorrect database access code. Thus, this thesis proposes a series of approaches to improve the performance of database-centric software applications that are implemented using ORM. Our approaches focus on troubleshooting and detecting inefficient (i.e., performance problems) database accesses in the source code, and we rank the detected problems based on their severity. We first conduct an empirical study on the maintenance of ORM code in both open source and industrial applications. We find that ORM performance-related configurations are rarely tuned in practice, and there is a need for tools that can help improve/tune the performance of ORM-based applications. Thus, we propose approaches along two dimensions to help developers improve the performance of ORM-based applications: 1) helping developers write more performant ORM code; and 2) helping developers configure ORM configurations. To provide tooling support to developers, we first propose static analysis approaches to detect performance anti-patterns in the source code. We automatically rank the detected anti-pattern instances according to their performance impacts. Our study finds that by resolving the detected anti-patterns, the application performance can be improved by 34% on average. We then discuss our experience and lessons learned when integrating our anti-pattern detection tool into industrial practice. We hope our experience can help improve the industrial adoption of future research tools. However, as static analysis approaches are prone to false positives and lack runtime information, we also propose dynamic analysis approaches to further help developers improve the performance of their database access code. We propose automated approaches to detect redundant data access anti-patterns in the database access code, and our study finds that resolving such redundant data access anti-patterns can improve application performance by an average of 17%. Finally, we propose an automated approach to tune performance-related ORM configurations using both static and dynamic analysis. Our study shows that our approach can help improve application throughput by 27--138%. Through our case studies on real-world applications, we show that all of our proposed approaches can provide valuable support to developers and help improve application performance significantly.

Place-Based Evaluation for Integrated Land-Use Management

This book brings together experts in the fields of spatial planning, landuse and infrastructure management to explore the emerging agenda of spatially-oriented integrated evaluation. It weaves together the latest theories, case studies, methods, policy and practice to examine and assess the values, impacts, benefits and the overall success in integrated land-use management. In doing so, the book clarifies the nature and roles of evaluation and puts forward guidance for future policy and practice.

Projections of change in key ecosystem indicators for planning and management of marine protected areas: An example study for European seas

Marine Protected Areas (MPAs) are widely used as tools to maintain biodiversity, protect habitats and ensure that development is sustainable. If MPAs are to maintain their role into the future it is important for managers to understand how conditions at these sites may change as a result of climate change and other drivers, and this understanding needs to extend beyond temperature to a range of key ecosystem indicators. This case study demonstrates how spatially-aggregated model results for multiple variables can provide useful projections for MPA planners and managers. Conditions in European MPAs have been projected for the 2040s using unmitigated and globally managed scenarios of climate change and river management, and hence high and low emissions of greenhouse gases and riverborne nutrients. The results highlight the vulnerability of potential refuge sites in the north-west Mediterranean and the need for careful monitoring at MPAs to the north and west of the British Isles, which may be affected by changes in Atlantic circulation patterns. The projections also support the need for more MPAs in the eastern Mediterranean and Adriatic Sea, and can inform the selection of sites.

Projections of change in key ecosystem indicators for planning and management of marine protected areas: An example study for European seas

Marine Protected Areas (MPAs) are widely used as tools to maintain biodiversity, protect habitats and ensure that development is sustainable. If MPAs are to maintain their role into the future it is important for managers to understand how conditions at these sites may change as a result of climate change and other drivers, and this understanding needs to extend beyond temperature to a range of key ecosystem indicators. This case study demonstrates how spatially-aggregated model results for multiple variables can provide useful projections for MPA planners and managers. Conditions in European MPAs have been projected for the 2040s using unmitigated and globally managed scenarios of climate change and river management, and hence high and low emissions of greenhouse gases and riverborne nutrients. The results highlight the vulnerability of potential refuge sites in the north-west Mediterranean and the need for careful monitoring at MPAs to the north and west of the British Isles, which may be affected by changes in Atlantic circulation patterns. The projections also support the need for more MPAs in the eastern Mediterranean and Adriatic Sea, and can inform the selection of sites.

Musicoterapia y Arteterapia. Puntos de encuentro en el camino terapéutico

En este artículo pretendemos buscar los aspectos que confluyen en el ámbito de la musicoterapia y el arteterapia, comenzando por su definición y orígenes y siguiendo con los modelos teóricos más importantes. Al analizar los trabajos de investigación elaborados a partir de proyectos en los que se combina la práctica de las dos disciplinas, observamos la necesidad de una mayor interdisciplinareidad. Esto daría lugar a un mayor enriquecimiento de las sesiones y por tanto, del trabajo terapéutico, lo que revertiría en una mejora de la calidad de la intervención.

Building public policy on shifting sands: the case of the National Asset Management Agency

Over the last thirty years, there has been an increased demand for better management of public sector organisations (PSOs). This requires that they are answerable for the inputs that they are given but also for what they achieve with these inputs (Hood 1991; Hood 1995). It is suggested that this will improve the management of the organisation through better planning and control, and the achievement of greater accountability (Smith 1995). However, such a rational approach with clear goals and the means to measure achievement can cause difficulties for many PSOs. These difficulties include the distinctive nature of the public sector due to the political environment within which the public sector manager operates (Stewart and Walsh 1992) and the fact that PSOs will have many stakeholders, each of whom will have their own specific objectives based on their own perspective (Boyle 1995). This can
result in goal ambiguity which means that there is leeway in interpreting the results of the PSO. The National Asset Management Agency (NAMA) was set up to bring stability to the financial system by buying loans from the banks (which were in most cases, non-performing loans). The intention was to cleanse the banks of these loans so that they could return to their normal business of taking deposits and making loans. However, the legislation, also gave NAMA a wide range of other responsibilities including responsibility for facilitating credit in the economy and protecting the interests of taxpayers. In more recent times, NAMA has been given responsibility for building social housing. This wide-range of activities is a clear example of a PSO being given multiple goals which may conflict and is therefore likely to lead to goal ambiguity. This makes it very difficult to evaluate NAMA’s performance as they are attempting to meet numerous goals at the same time and also highlights the complexity of policy making in the public sector. The purpose of this paper is to examine how NAMA dealt with goal ambiguity. This will be done through a thematic analysis of its annual reports over the last five years. The paper’s will contribute to the ongoing debate about the evaluation of PSOs and the complex environment within which they operate which makes evaluation difficult as they are
answerable to multiple stakeholders who have different objectives and different criteria for measuring success.

The Un-Politics of New Public Management in Ireland

Many of the principles and indeed the rhetoric of New Public Management proved attractive to both politicians and senior bureaucrats across the developed world as a remedy for problems in policy processes. Ireland shares many features of its constitutional structures and political practices with Britain, Canada, Australia, New Zealand, all of them early and enthusiastic adopters of NPM. Some of the organizational and procedural changes in Irish public administration do indeed bear similarities to those we would expect to see as a result of adopting principles of NPM. However, we contend that surface impressions are misleading. Drawing on a time-series database of Irish state institutions, we show that organizational changes were not necessarily driven by NPM. The absence of strong political drivers meant that reform initiatives did not fundamentally alter the configuration of the Irish public administration. Many of the problems that NPM was intended to address are only now coming under scrutiny.

Sustainability, creativity and innovation in project management – Model development for assessing organizational performance through projects

Today a number of studies are published on how organizational strategy is developed and how organizations contribute to local and regional development through the realization of these strategies. There are also many articles dealing with the success of a project by identifying the criteria and the factors that influence them. This article introduces the project-oriented strategic planning process that reveals how projects contribute to local and regional development and demonstrates the relationship between this approach and the regional competitiveness model as well as the KRAFT concept. There is a lot of research that focuses on sustainability in business. These studies argue that sustainability is very important to the success of a business in the future. The Project Excellence Model that analyses project success does not contain the sustainability criteria; the GPM P5 standard consists of sustainability components related either to the organizational level. To fill this gap a Project Sustainability Excellence Model (PSEM) was developed. The model was tested by interviews with managers of Hungarian for-profit and non-profit organizations. This paper introduces the PSEM and highlights the most important elements of the empirical analysis.

Sustainable Business Models – What Do Management Theories Say?

Literature describing the notion and practice of business models has grown considerably over the last few years. Innovative business models appear in every sector of the economy challenging traditional ways of creating and capturing value. However, research describing the theoretical foundations of the field is scarce and many questions still remain. This article examines business models promoting various aspects of sustainable development and tests the explanatory power of two theoretical approaches, namely the resource based view of the firm and transaction cost theory regarding their emergence and successful market performance. Through the examples of industrial ecology and the sharing economy the author shows that a sharp reduction of transaction costs (e.g. in the form of internet based systems) coupled with resources widely available but not utilised before may result in fast growing new markets. This research also provides evidence regarding the notion that these two theoretical approaches can complement each other in explaining corporate behaviour.

How to achieve gender diversity in top management : A qualitative study of gender equal companies listed on the Swedish stock exchange

Alarming statistics provides that only 10,2 percentage of companies listed on the Swedish stock exchange has achieved gender equality in their top management. The fact is that women being discriminated, since men dominates these positions of power. The study is of a qualitative nature and aims to achieve a deeper understanding and knowledge contribution of how gender equal companies´ has achieved this gender diversity in their top management. Sweden's highest ranking business leaders has been interviewed in order to obtain their view, and the companies they represent, in order to get an answer to what the most important requirements has been in the achievement. The study's main result has shown that strong core values and corporate culture are basic and required condition for a successful gender equality strategy. A deliberate or emergent strategy can then be successfully implemented, and it is mainly the impact of structural barriers that determine which strategy a company uses. At a deliberate strategy, following measures are in additional to core values and corporate cultural crucial; commitment towards gender equality, a specific plan with clear objectives, and a conscious objective recruitment process. The result found aboute these two factors and three measures also identified a required specific order to follow in order to achieve gender diversity in top management. These findings, which in a near future, aims to contribute to a more gender equal Sweden.

A Scalable Design Framework for Variability Management in Large-Scale Software Product Lines

Variability management is one of the major challenges in software product line adoption, since it needs to be efficiently managed at various levels of the software product line development process (e.g., requirement analysis, design, implementation, etc.). One of the main challenges within variability management is the handling and effective visualization of large-scale (industry-size) models, which in many projects, can reach the order of thousands, along with the dependency relationships that exist among them. These have raised many concerns regarding the scalability of current variability management tools and techniques and their lack of industrial adoption. To address the scalability issues, this work employed a combination of quantitative and qualitative research methods to identify the reasons behind the limited scalability of existing variability management tools and techniques. In addition to producing a comprehensive catalogue of existing tools, the outcome form this stage helped understand the major limitations of existing tools. Based on the findings, a novel approach was created for managing variability that employed two main principles for supporting scalability. First, the separation-of-concerns principle was employed by creating multiple views of variability models to alleviate information overload. Second, hyperbolic trees were used to visualise models (compared to Euclidian space trees traditionally used). The result was an approach that can represent models encompassing hundreds of variability points and complex relationships. These concepts were demonstrated by implementing them in an existing variability management tool and using it to model a real-life product line with over a thousand variability points. Finally, in order to assess the work, an evaluation framework was designed based on various established usability assessment best practices and standards. The framework was then used with several case studies to benchmark the performance of this work against other existing tools.

A social-ecological impact assessment for public lands management: application of a conceptual and methodological framework

According to the U.S. National Environmental Policy Act of 1969 (NEPA), federal action to manipulate habitat for species conservation requires an environmental impact statement, which should integrate natural, physical, economic, and social sciences in planning and decision making. Nonetheless, most impact assessments focus disproportionately on physical or ecological impacts rather than integrating ecological and socioeconomic components. We developed a participatory social-ecological impact assessment (SEIA) that addresses the requirements of NEPA and integrates social and ecological concepts for impact assessments. We cooperated with the Bureau of Land Management in Idaho, USA on a project designed to restore habitat for the Greater Sage-Grouse (Centrocercus urophasianus). We employed questionnaires, workshop dialogue, and participatory mapping exercises with stakeholders to identify potential environmental changes and subsequent impacts expected to result from the removal of western juniper (Juniperus occidentalis). Via questionnaires and workshop dialogue, stakeholders identified 46 environmental changes and associated positive or negative impacts to people and communities in Owyhee County, Idaho. Results of the participatory mapping exercises showed that the spatial distribution of social, economic, and ecological values throughout Owyhee County are highly associated with the two main watersheds, wilderness areas, and the historic town of Silver City. Altogether, the SEIA process revealed that perceptions of project scale varied among participants, highlighting the need for specificity about spatial and temporal scales. Overall, the SEIA generated substantial information concerning potential impacts associated with habitat treatments for Greater Sage-Grouse. The SEIA is transferable to other land management and conservation contexts because it supports holistic understanding and framing of connections between humans and ecosystems. By applying this SEIA framework, land managers and affected people have an opportunity to fulfill NEPA requirements and develop more comprehensive management plans that better reflect the linkages of social-ecological systems.

Talent Management : Utan Talent Management?

Syftet med denna studie är att kontrastera en utvald organisations strategier för att attrahera, behålla, utveckla och avveckla de viktigaste resurserna mot Talent Management och dess komponenter. Studien ämnar således mot att göra en kontrastering mellan traditionellt kompetensförsörjningsarbete mot det mer moderna konceptet Talent Management. Författarna har valt att undersöka detta genom att samla empiri från intervjuer med sex medarbetare kombinerat med analys av interna dokument. Resultatet visar att delar av myndighetens arbete med kompetensförsörjning kan likställas med Talent Management men att vissa komponenter är uteblivna. Baserat på resultatet framhålls i resultatdiskussionen att myndigheten möter stora utmaningar gällande enhetligt arbete med kompetensutveckling, kompetensförsörjning och ledarskap på grund utav det delegerade ansvaret från central nivå. I slutskedet av avsnittet för resultatdiskussion redovisas även en sammanfattande slutsats som grundar sig i ett framgångsrikt arbete inom blocken attrahera och avsluta samtidigt som arbete inom blocket behålla och utveckla varierar inom organisationen, dels på grund av delegerat ansvar. Slutligen presenteras förbättringsförslag inom organisationen och vidare forskning inom ämnet. 

Skapandet av ett webbaserat ärendehanteringssystem för affärssystemet Pyramid med Scrum : Creation of a web based case management system for the business system Pyramid with Scrum

The business system known as Pyramid does today not provide its user with a reasonable system regarding case management for support issues. The current system in place requires the customer to contact its provider via telephone to register new cases. In addition to this, current system doesn’t include any way for the user to view any of their current cases without contacting the provider.A solution to this issue is to migrate the current case management system from a telephone contact to a web based platform, where customers could easier access their current cases, but also directly through the website create new cases. This new system would reduce the time required to manually manage each individual case, for both customer and provider, resulting in an overall reduction in cost for both parties.The result is a system divided into two different sections, the first one is an API created in Pyramid that acts as a web service, and the second one a website which customers can connect to. The website will allow users to overview their current cases, but also the option to create new cases directly through the site. All the information used to the website is obtained through the web service inside Pyramid. Analyzing the final design of the system, the developers where able to conclude both positive and negative aspects of the systems’ final design. If the platform chosen was the optimal choice or not, and also what can be include if the system is further developed, will be discussed.The development process and the method used during development will also be analyzed and discussed, what positive and negative aspects that where encountered. In addition to this the cause and effect of a development team smaller than the suggested size will also be analyzed. Lastly an analysis of actions that could’ve been made in order to prevent certain issues from occurring will.

Co-exposure to mycotoxins: the case of waste management workers

Introduction - Occupational exposures are characterized by being complex and associated to co-exposure to several contaminants by different exposure routes. Even if exposure occurs to only a chemical agent, it can have different exposure routes and can result in different health effects. The waste management setting is recognized by the presence of several chemical and biologic agents in the workplaces. Recently, it was reported occupational exposure to Aflatoxin B1 (AFB1) in one Portuguese waste management industry. However, data regarding to fungal burden showed that exposure to other mycotoxins should be expected. Aim of the study - The aim of the present work was to know if workers from this waste management industry were exposed to other mycotoxins besides AFB1.