A system’s approach to cache hierarchy-aware decomposition of data-parallel computations

Dissertação para obtenção do Grau de Mestre em Engenharia Informática

Report of a traineeship : audit of antidepressant prescribing in Primary and Mental Care: how to address appropriateness and keep a curb on costs. A tool suitable for all contexts?

RESUMO: Este é o relatório de um estágio realizado na Autoridade de Saúde Local de Bolonha com o objectivo de desenvolver capacidades e competências na área de projectos orientados para a avaliação com base epidemiológica. As prescrições de anti-depressivos aumentaram consideravelmente em todo o mundo durante as últimas décadas. O uso cada vez maior dos agentes mais dispendiosos desempenha um papel na subida do custo dos tratamentos. A Autoridade de Saúde Local de Bolonha implementou um processo de auditoria com o objectivo de melhorar a adequação das prescrições de pacientes externos, centrando-se em dois anti-depressivos de marca ainda protegidos por patente, Escitalopram e Duloxetine. Os Departamentos de Cuidados de Saúde Primários e de Cuidados de Saúde Mental, assim como o Departamento Farmacêutico e a Unidade de Gestão Clínica, estiveram envolvidos na fase de planeamento da auditoria. O grupo da auditoria, maioritariamente composto por médicos de clínica geral e psiquiatras, reuniu e analisou provas da eficácia e segurança dos anti-depressivos. Os dados sobre as prescrições das Unidades de Cuidados de Saúde Primários e dos Centros de Saúde Mental Comunitários da Autoridade de Saúde Local (866.294 habitantes) foram comparados, em particular as taxas de consumo de Escitalopram e Duloxetine. O grupo da auditoria definiu os standards a serem abordados, os indicadores a serem avaliados e as medidas a empreender para atingir os objectivos definidos. As directrizes do NICE sobre a depressão foram escolhidas como referência. O objectivo da auditoria foi definido como evitar o Escitalopram e Duloxetine como medicamentos de primeira escolha num tratamento anti-depressivo. De modo a verificar a eficácia das medidas empreendidas foi seleccionado um indicador, consistindo numa redução de 25% das prescrições de ambos os anti-depressivos na prática clínica de pacientes externos e numa redução de 20% da variabilidade nas Unidades de Cuidados de Saúde Primários. O relatório retrospectivo pré-auditoria (Janeiro a Abril de 2012) revelou que os tratamentos com anti-depressivos para pacientes externos eram prescritos pelos médicos de clínica geral em mais de90% dos casos. As medidas da auditoria foram implementadas entre Novembro de 2012 e Maio de 2013. Algumas medidas relevantes foram integradas com a revisão da auditoria, tais como reuniões educacionais de pequena escala com os médicos de clínica geral e psiquiatras, visitas de apoio do assessor de prescrições da Autoridade de Saúde Local aos médicos de clínica geral e Centros de Saúde Mental Comunitários, panfletos para profissionais com informação retirada das directrizes clínicas do NICE, implementação de um serviço de consulta na Web para médicos de clínica geral sobre provas relativas a anti-depressivos. O relatório de feedback é aguardado em Novembro de 2013 depois de se verificar nos standards atingidos a eficácia das medidas implementadas. Foi realizada uma análise SWOT para comprovar as forças e fraquezas, as oportunidades e ameaças do processo. Como identificação de fraquezas poderá ser útil identificar estratégias relevantes para melhoria interna, para que o conhecimento das ameaças possa amortizar factores que possam ter impactos adversos que fujam ao controlo do Departamento de Saúde Mental. Uma melhor compreensão das forças e das oportunidades facilita a consecução dos objectivos estabelecidos no projecto. O primeiro, mas não o último, resultado deste processo consistiu numa maior integração entre os Cuidados de Saúde Primários e de Saúde Mental, permitindo assim que a Autoridade de Saúde Local coloque as alterações em prática.------------ABSTRACT: This is the report of a traineeship held in the Local Health Authority of Bologna with the aim to develop skills and competencies in the field of epidemiogically based evaluation oriented projects. Antidepressants prescriptions have considerably increased all over the world in the last decades. The increasing use of the most expensive agents plays a part in the rising cost of treatments. The Local Health Authority of Bologna has implemented an audit process aimed at improving the appropriateness of outpatient prescriptions focusing on the two branded antidepressants still protected by patent, Escitalopram and Duloxetine. The Primary Care and the Mental Health Care Departments, as well as the Pharmaceutical Department and the Clinical Governance Unit, were involved in the planning phase of the audit. The audit group, mainly composed of general practitioners and psychiatrists, collected and analyzed scientific evidence on effectiveness and safety of antidepressants. Data on prescriptions of Primary Care Units and Community Mental Health Centers of the Local Health Authority (866.294 inhabitants) were compared, in particular consumption rates of Escitalopram and Duloxetine. The audit group defined the standards to be addressed, the indicators to be evaluated and the actions aimed at reaching the defined goals. NICE guidelines on depression were chosen as reference. The aim of the audit was settled as avoiding Escitalopram and Duloxetine as first choice drugs starting an AD treatment. In order to check the efficacy of the actions undertaken an indicator was selected, consisting in a reduction of 25% of prescriptions of both ADs in outpatient practice and in a 20% reduction of To develop skills and competencies across Primary Care Units. The pre-audit retrospective report (January-April 2012) showed that outpatient antidepressant treatments were prescribed by GPs in over 90% of cases. Audit actions were implemented between November 2012 and May 2013. Some relevant actions have been integrated with the audit review, such as small-scale educational meetings with GPs and psychiatrists, outreach visits of the LHA prescribing adviser to GPs and CMHCs,leaflets for professionals with information extracted from NICE clinical guidelines, implementation of a web consultation service for GPs about evidence on antidepressants. The feedback report is expected in November 2013 after checking through the standards attained the effectiveness of actions implemented. A SWOT Analysis was carried out to evidence the strengths and weaknesses, opportunities and threats of the process. As identification of weaknesses may be useful to identify relevant strategies for internal improvement, so the knowledge of threats can amortize factors that may have adverse impacts beyond the control of the Mental Health Department. Better understanding of the strengths and the opportunities facilitates the achievement of the goals set in the project. The first and not least upshot of this process has consisted in further integration between Primary and Mental Health Care, thus enabling the LHA to put the change into practice.

Combining WLAN fingerprint-based localization with sensor data for indoor navigation using mobile devices

This project proposes an approach for supporting Indoor Navigation Systems using Pedestrian Dead Reckoning-based methods and by analyzing motion sensor data available in most modern smartphones. Processes suggested in this investigation are able to calculate the distance traveled by a user while he or she is walking. WLAN fingerprint- based navigation systems benefit from the processes followed in this research and results achieved to reduce its workload and improve its positioning estimations.

Complex networks and data mining: toward a new perspective for the understanding of complex systems

Complex systems, i.e. systems composed of a large set of elements interacting in a non-linear way, are constantly found all around us. In the last decades, different approaches have been proposed toward their understanding, one of the most interesting being the Complex Network perspective. This legacy of the 18th century mathematical concepts proposed by Leonhard Euler is still current, and more and more relevant in real-world problems. In recent years, it has been demonstrated that network-based representations can yield relevant knowledge about complex systems. In spite of that, several problems have been detected, mainly related to the degree of subjectivity involved in the creation and evaluation of such network structures. In this Thesis, we propose addressing these problems by means of different data mining techniques, thus obtaining a novel hybrid approximation intermingling complex networks and data mining. Results indicate that such techniques can be effectively used to i) enable the creation of novel network representations, ii) reduce the dimensionality of analyzed systems by pre-selecting the most important elements, iii) describe complex networks, and iv) assist in the analysis of different network topologies. The soundness of such approach is validated through different validation cases drawn from actual biomedical problems, e.g. the diagnosis of cancer from tissue analysis, or the study of the dynamics of the brain under different neurological disorders.

A DSL for querying building data streams of energy, eeather and occupation data

The superfluous consumption of energy is faced by the modern society as a Socio-Economical and Environmental problem of the present days. This situation is worsening given that it is becoming clear that the tendency is to increase energy price every year. It is also noticeable that people, not necessarily proficient in technology, are not able to know where savings can be achieved, due to the absence of accessible awareness mechanisms. One of the home user concerns is to balance the need of reducing energy consumption, while producing the same activity with all the comfort and work efficiency. The common techniques to reduce the consumption are to use a less wasteful equipment, altering the equipment program to a more economical one or disconnecting appliances that are not necessary at the moment. However, there is no direct feedback from this performed actions, which leads to the situation where the user is not aware of the influence that these techniques have in the electrical bill. With the intension to give some control over the home consumption, Energy Management Systems (EMS) were developed. These systems allow the access to the consumption information and help understanding the energy waste. However, some studies have proven that these systems have a clear mismatch between the information that is presented and the one the user finds useful for his daily life, leading to demotivation of use. In order to create a solution more oriented towards the user’s demands, a specially tailored language (DSL) was implemented. This solution allows the user to acquire the information he considers useful, through the construction of questions about his energy consumption. The development of this language, following the Model Driven Development (MDD) approach, took into consideration the ideas of facility managers and home users in the phases of design and validation. These opinions were gathered through meetings with experts and a survey, which was conducted to the purpose of collecting statistics about what home users want to know.

Integrated data model and DSL modifications

Companies are increasingly more and more dependent on distributed web-based software systems to support their businesses. This increases the need to maintain and extend software systems with up-to-date new features. Thus, the development process to introduce new features usually needs to be swift and agile, and the supporting software evolution process needs to be safe, fast, and efficient. However, this is usually a difficult and challenging task for a developer due to the lack of support offered by programming environments, frameworks, and database management systems. Changes needed at the code level, database model, and the actual data contained in the database must be planned and developed together and executed in a synchronized way. Even under a careful development discipline, the impact of changing an application data model is hard to predict. The lifetime of an application comprises changes and updates designed and tested using data, which is usually far from the real, production, data. So, coding DDL and DML SQL scripts to update database schema and data, is the usual (and hard) approach taken by developers. Such manual approach is error prone and disconnected from the real data in production, because developers may not know the exact impact of their changes. This work aims to improve the maintenance process in the context of Agile Platform by Outsystems. Our goal is to design and implement new data-model evolution features that ensure a safe support for change and a sound migration process. Our solution includes impact analysis mechanisms targeting the data model and the data itself. This provides, to developers, a safe, simple, and guided evolution process.

Sistema de deteção de eventos adversos baseado num data warehouse

RESUMO - A Segurança do Doente tem assumido uma relevância crescente nas organizações de saúde, resultado da divulgação de diversos estudos que revelaram a magnitude deste problema e simultaneamente, de uma maior pressão por parte da opinião pública e da comunicação social. Este estudo pretende desenvolver e avaliar a performance de um sistema eletrónico de deteção de eventos adversos, baseado num Data Warehouse, por comparação com os resultados obtidos pela metodologia tradicional de revisão dos registos clínicos. O objetivo principal do trabalho consistiu em identificar um conjunto de triggers / indicadores de alerta que permitam detetar potenciais eventos adversos mais comuns. O sistema desenvolvido apresentou um Valor Preditivo Positivo de 18.2%, uma sensibilidade de 65.1% e uma especificidade de 68.6%, sendo constituído por nove indicadores baseados em informação clínica e 445 códigos do ICD-9-CM, relativos a diagnósticos e procedimentos. Apesar de terem algumas limitações, os sistemas eletrónicos de deteção de eventos adversos apresentam inúmeras potencialidades, nomeadamente a utilização em tempo real e em complemento a metodologias já existentes. Considerando a importância da problemática em análise e a necessidade de aprofundar os resultados obtidos neste trabalho de projeto, seria relevante a sua extensão a um universo mais alargado de instituições hospitalares, estando a sua replicabilidade facilitada, uma vez que o Data Warehouse tem por base um conjunto de aplicações disseminadas a nível nacional. O desenvolvimento e a consolidação dos sistemas eletrónicos de deteção de eventos adversos constitui inegavelmente uma área de futuro, com reflexos ao nível da melhoria da informação existente nas organizações e que contribuirá decisivamente para a melhoria dos cuidados de saúde prestados aos doentes.

SDAR: a package for plotting and analyzing stratigraphy data in R

Stratigraphic Columns (SC) are the most useful and common ways to represent the eld descriptions (e.g., grain size, thickness of rock packages, and fossil and lithological components) of rock sequences and well logs. In these representations the width of SC vary according to the grain size (i.e., the wider the strata, the coarser the rocks (Miall 1990; Tucker 2011)), and the thickness of each layer is represented at the vertical axis of the diagram. Typically these representations are drawn 'manually' using vector graphic editors (e.g., Adobe Illustrator®, CorelDRAW®, Inskape). Nowadays there are various software which automatically plot SCs, but there are not versatile open-source tools and it is very di cult to both store and analyse stratigraphic information. This document presents Stratigraphic Data Analysis in R (SDAR), an analytical package1 designed for both plotting and facilitate the analysis of Stratigraphic Data in R (R Core Team 2014). SDAR, uses simple stratigraphic data and takes advantage of the exible plotting tools available in R to produce detailed SCs. The main bene ts of SDAR are: (i) used to generate accurate and complete SC plot including multiple features (e.g., sedimentary structures, samples, fossil content, color, structural data, contacts between beds), (ii) developed in a free software environment for statistical computing and graphics, (iii) run on a wide variety of platforms (i.e., UNIX, Windows, and MacOS), (iv) both plotting and analysing functions can be executed directly on R's command-line interface (CLI), consequently this feature enables users to integrate SDAR's functions with several others add-on packages available for R from The Comprehensive R Archive Network (CRAN).

Analyzing Geospatial patterns of syrian refugee flows in southeastern Turkey by use of remote sensing and complementary data

Crisis-affected communities and global organizations for international aid are becoming increasingly digital as consequence geotechnology popularity. Humanitarian sector changed in profound ways by adopting new technical approach to obtain information from area with difficult geographical or political access. Since 2011, turkey is hosting a growing number of Syrian refugees along southeastern region. Turkish policy of hosting them in camps and the difficulty created by governors to international aid group expeditions to get information, made such international organizations to investigate and adopt other approach in order to obtain information needed. They intensified its remote sensing approach. However, the majority of studies used very high-resolution satellite imagery (VHRSI). The study area is extensive and the temporal resolution of VHRSI is low, besides it is infeasible only using these sensors as unique approach for the whole area. The focus of this research, aims to investigate the potentialities of mid-resolution imagery (here only Landsat) to obtain information from region in crisis (here, southeastern Turkey) through a new web-based platform called Google Earth Engine (GEE). Hereby it is also intended to verify GEE currently reliability once the Application Programming Interface (API) is still in beta version. The finds here shows that the basic functions are trustworthy. Results pointed out that Landsat can recognize change in the spectral resolution clearly only for the first settlement. The ongoing modifications vary for each case. Overall, Landsat demonstrated high limitations, but need more investigations and may be used, with restriction, as a support of VHRSI.

Identifying the urban communities of New York City using bikeshare data from NYC citibike

This study identifies a measure of the cultural importance of an area within a city. It does so by making use of origindestination trip data and the bike stations of the bike share system in New York City as a proxy to study the city. Rarely is movement in the city studied at such a small scale. The change in strength of the similarity of movement between each station is studied. It is the first study to provide this measure of importance for every point in the system. This measure is then related to the characteristics which make for vibrant city communities, namely highly mixed land use types. It reveals that the spatial pattern of important areas remains constant over differing time periods. Communities are then characterised by the land uses surrounding these stations with high measures of importance. Finally it identifies the areas of global cultural importance alongside the areas of local importance to the city.

Trends in antimicrobial resistance among clinical isolates of enterococci in a Brazilian tertiary hospital: a 4-year study

INTRODUCTION: In the past two decades members of the genus Enterococcus have emerged as important nosocomial pathogens worldwide. This study prospectively analyzed the distribution of species and trends in antimicrobial resistance among clinical isolates of enterococci in a Brazilian tertiary hospital from 2006-2009. METHODS: Enterococcal species were identified by conventional biochemical tests. The antimicrobial susceptibility profile was performed by disk diffusion in accordance with the Clinical and Laboratory Standards Institute (CLSI). A screening test for vancomycin was also performed. Minimal inhibitory concentration (MIC) for vancomycin was determined using the broth dilution method. Molecular assays were used to confirm speciation and genotype of vancomycin-resistant enterococci (VRE). RESULTS: A total of 324 non-repetitive enterococcal isolates were recovered, of which 87% were E. faecalis and 10.8% E. faecium. The incidence of E. faecium per 1,000 admissions increased significantly (p < 0.001) from 0.3 in 2006 to 2.3 in 2009. The VRE rate also increased over time from 2.5% to 15.5% (p < 0.001). All VRE expressed high-level resistance to vancomycin (MIC >256µg/ mL) and harbored vanA genes. The majority (89.5%) of VRE belonged to E. faecium species, which were characteristically resistant to ampicillin and quinolones. Overall, ampicillin resistance rate increased significantly from 2.5% to 21.4% from 2006-2009. Resistance rates for gentamicin, chloramphenicol, tetracycline, and erythromycin significantly decreased over time, although they remained high. Quinolones resistance rates were high and did not change significantly over time. CONCLUSIONS: The data obtained show a significant increasing trend in the incidence of E. faecium resistant to ampicillin and vancomycin.

The role of qualitative data and systems thinking in addressing service decline in market towns

Retail services are a main contributor to municipal budget and are an activity that affects perceived quality-of-life, especially for those with mobility difficulties (e.g. the elderly, low income citizens). However, there is evidence of a decline in some of the services market towns provide to their citizens. In market towns, this decline has been reported all over the western world, from North America to Australia. The aim of this research was to understand retail decline and enlighten on some ways of addressing this decline, using a case study, Thornbury, a small town in the Southwest of England. Data collected came from two participatory approaches: photo-surveys and multicriteria mapping. The interpretation of data came from using participants as analysts, but also, using systems thinking (systems diagramming and social trap theory) for theory building. This research moves away from mainstream economic and town planning perspectives by making use of different methods and concepts used in anthropology and visual sociology (photo-surveys), decision-making and ecological economics (multicriteria mapping and social trap theory). In sum, this research has experimented with different methods, out of their context, to analyse retail decline in a small town. This research developed a conceptual model for retail decline and identified the existence of conflicting goals and interests and their implications for retail decline, as well as causes for these. Most of the potential causes have had little attention in the literature. This research also identified that some of the measures commonly used for dealing with retail decline may be contributing to the causes of retail decline itself. Additionally, this research reviewed some of the measures that can be used to deal with retail decline, implications for policy-making and reflected on the use of the data collection and analysis methods in the context of small to medium towns.

Use of Poisson spatiotemporal regression models for the Brazilian Amazon Forest: malaria count data

INTRODUCTION: Malaria is a serious problem in the Brazilian Amazon region, and the detection of possible risk factors could be of great interest for public health authorities. The objective of this article was to investigate the association between environmental variables and the yearly registers of malaria in the Amazon region using Bayesian spatiotemporal methods. METHODS: We used Poisson spatiotemporal regression models to analyze the Brazilian Amazon forest malaria count for the period from 1999 to 2008. In this study, we included some covariates that could be important in the yearly prediction of malaria, such as deforestation rate. We obtained the inferences using a Bayesian approach and Markov Chain Monte Carlo (MCMC) methods to simulate samples for the joint posterior distribution of interest. The discrimination of different models was also discussed. RESULTS: The model proposed here suggests that deforestation rate, the number of inhabitants per km², and the human development index (HDI) are important in the prediction of malaria cases. CONCLUSIONS: It is possible to conclude that human development, population growth, deforestation, and their associated ecological alterations are conducive to increasing malaria risk. We conclude that the use of Poisson regression models that capture the spatial and temporal effects under the Bayesian paradigm is a good strategy for modeling malaria counts.

A segurança das infraestruturas críticas em Portugal

Portugal, having responsibilities at European level, needs to ensure compliance with European standards, particularly with regard to the European Security Plan for Critical Infrastructures. National critical infrastructures should be a focus of attention with regard to the management of public risks, since these represent "a set of services that are essential to the functioning of the country and the functioning of the forces that ensure national defense." (Soares, 2008) This contribution on national critical infrastructures (CI) has the essential objective of clarifying the development of the strategy adopted by Portugal in pursuit of the security of these fundamental infrastructures. The goal lies not only through producing a descriptive document, but also carry a brief confrontation between the legal framework related to these subjects and the reality in which the Critical Infrastructure Operators and the National Civil Protection Authority (ANPC) operate. It is intended, in this sense, to understand the development of the project for the national security program of critical infrastructures and what effects of its measures on operators. As for the methodology, we followed a methodological strategy, where we combine the literature with data obtained through semi-structured interviews. Portugal, being a geographically peripheral country and having no record of incidents capable of causing major contingencies in key services for the normal development of society, does not have a structured and regulator plan that substantiates the need for operators responsible for CI to invest in security. This same approach is expected at the State level, believing that even though this theme has be widely explored by international institutions, Portugal has not yet tried to give the attention it deserves. Without the existence of an institution and a regulatory system, CI operators can become less available to comply with the legal framework.

Relationship between national culture, democracy and environmental performance: A panel data analysis

This paper demonstrates the significance of culture in examining the relationshipbetween democratic capital and environmental performance.The aim is to examine the relationship among scores on the Environmental Performance Index and the two dimensions of cross cultural variation suggested by Ronald Inglehart and Christian Welzel. Significantional interrelationships among democracy, cultural and environmental sustaintability measures could be found, following the regression results. Firstly, higher levels of democratic capital stock are associated with better environmental performance. Secondly importance to distinguish between cultural groups could be confirmed.