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.

Land cover mapping analysis and urban growth modeling using remote sensing techniques

The rapid growth of big cities has been noticed since 1950s when the majority of world population turned to live in urban areas rather than villages, seeking better job opportunities and higher quality of services and lifestyle circumstances. This demographic transition from rural to urban is expected to have a continuous increase. Governments, especially in less developed countries, are going to face more challenges in different sectors, raising the essence of understanding the spatial pattern of the growth for an effective urban planning. The study aimed to detect, analyse and model the urban growth in Greater Cairo Region (GCR) as one of the fast growing mega cities in the world using remote sensing data. Knowing the current and estimated urbanization situation in GCR will help decision makers in Egypt to adjust their plans and develop new ones. These plans should focus on resources reallocation to overcome the problems arising in the future and to achieve a sustainable development of urban areas, especially after the high percentage of illegal settlements which took place in the last decades. The study focused on a period of 30 years; from 1984 to 2014, and the major transitions to urban were modelled to predict the future scenarios in 2025. Three satellite images of different time stamps (1984, 2003 and 2014) were classified using Support Vector Machines (SVM) classifier, then the land cover changes were detected by applying a high level mapping technique. Later the results were analyzed for higher accurate estimations of the urban growth in the future in 2025 using Land Change Modeler (LCM) embedded in IDRISI software. Moreover, the spatial and temporal urban growth patterns were analyzed using statistical metrics developed in FRAGSTATS software. The study resulted in an overall classification accuracy of 96%, 97.3% and 96.3% for 1984, 2003 and 2014’s map, respectively. Between 1984 and 2003, 19 179 hectares of vegetation and 21 417 hectares of desert changed to urban, while from 2003 to 2014, the transitions to urban from both land cover classes were found to be 16 486 and 31 045 hectares, respectively. The model results indicated that 14% of the vegetation and 4% of the desert in 2014 will turn into urban in 2025, representing 16 512 and 24 687 hectares, respectively.

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.

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.

Perfil lipídico e fatores biológicos e ambientais : o papel da atividade física

RESUMO - Introdução: A inatividade física é um dos determinantes major das doenças crónicas não transmissíveis sendo a quarta maior causa de mortalidade no mundo, nomeadamente para as doenças vasculares. A prática regular de atividade física produz adaptações vasculares responsáveis por efeitos benéficos na prevenção e tratamento dos diferentes fatores de risco vascular, nomeadamente através do seu efeito no metabolismo das lipoproteínas. Objetivos: Analisar a interferência da atividade física no perfil lipídico de uma população residente em Portugal. Métodos: Estudo observacional descritivo transversal exploratório com 1027 indivíduos (idade: 18 aos 80 anos, 49% mulheres). Os dados foram analisados em SPSS (versão 20), tendo-se utilizado métodos de estatística descritiva e de análise bivariável entre os factores de risco vascular e as variáveis do perfil lipídico e ainda uma análise multivariável de regressão logística binária para medir a razão de riscos pelo odds ratio. O nível de significância foi estabelecido em 5%. Resultados: Na análise da relação entre atividade física e os biomarcadores do perfil lipídico verificou-se que existem benefícios no que diz respeito ao aumento dos níveis de HDL e de apoA1 e na diminuição dos níveis de TG com a prática regular de atividade física. Conclusões: A atividade física apresenta um papel importante na regulação do perfil lipídico evidenciando a necessidade de implementar estratégias multissectoriais de prevenção dos fatores de risco vascular, nomeadamente na área dos estilos de vida saudáveis que são fundamentais para a prevenção destas condições de saúde e para gerar ganhos em saúde.

Factores sociodemográficos na saúde oral : influências nos comportamentos de rotinas de saúde oral, frequências de idas a consultas, auto avaliação do estado de saúde oral e presença de dor em jovens de 12 anos

RESUMO - Introdução: A saúde oral é uma componente essencial na saúde geral e no bem-estar dos indivíduos. Sabe-se que os problemas de saúde oral afectam predominantemente os elementos de níveis socioeconómicos mais baixos, evidenciando a influência dos determinantes sociais da saúde na saúde oral das populações. Os objectivos deste estudo são caracterizar os comportamentos de rotinas diárias de higiene oral, frequências de idas a consultas de saúde oral, auto-avaliação do estado de saúde oral e percepção de dor na cavidade oral em crianças de 12 anos em Portugal e analisar a associação entre estes e os factores sociodemográficos. Métodos: Foi realizado um estudo observacional, transversal e analítico, abrangendo 1309 jovens e baseado em informação recolhida no III Estudo Nacional de Prevalência de Doenças Orais (ENPDO). Para além das estatísticas descritivas usuais, as estatísticas inferenciais basearam-se predominantemente em modelos de regressão logística binária. Resultados: Dos participantes, 70.6% (n=924) escova “duas ou mais vezes por dia” com associação com todas as variáveis sociodemográficas. Na análise multivariada, o género masculino (OR=2.088; IC95%: 1.574-2.770, em relação ao género feminino), a área de residência predominantemente rural ou mediamente urbana (OR= 1.800; IC95%: 2.587; OR=1.516; IC95%: 1.093-2.103, em relação a zonas predominantemente urbanas), a escolaridade da mãe ser o ensino básico (OR= 2.112; IC95%: 1.408-3.168, em relação ao ensino superior) e a actividade laboral do pai ser desempregado (OR= 1.938; IC95%: 1.280-2.934, em relação a ser trabalhador) foram as variáveis com mais impacto para a adopção de comportamentos de escovagem potencialmente inadequados (p<0.05). A maioria dos inquiridos (94.2%; n=1247) já tinham ido a uma consulta de saúde oral e 74.5% (n=860) nos últimos 12 meses, 95.5% (n=1250) encontram-se satisfeitos com a saúde oral e 44.5% (n=578) afirma ter tido algum tipo de dor na cavidade oral nos últimos 12 meses. Conclusão: Os resultados obtidos estão de acordo com a literatura em termos de factores de associação. Desta forma, a saúde oral nos jovens de 12 anos em Portugal, nos diversos contextos aqui analisados, pode ser considerada como satisfatória. A única excepção relevante é a componente da dor, com valores alarmantes embora de natureza mais subjectiva. A influência dos factores sociodemográficos sugere que futuras abordagens para a promoção da saúde oral tenham em conta os determinantes de saúde no delineamento de estratégias quer a nível individual quer a nível comunitário.

How can clusters help in the product type choice? The case of a specialized retail store

This work project (WP) is a study about a clustering strategy for Sport Zone. The general cluster study’s objective is to create groups such that within each group the individuals are similar to each other, but should be different among groups. The clusters creation is a mix of common sense, trial and error and some statistical supporting techniques. Our particular objective is to support category managers to better define the product type to be displayed in the stores’ shelves by doing store clusters. This research was carried out for Sport Zone, and comprises an objective definition, a literature review, the clustering activity itself, some factor analysis and a discriminant analysis to better frame our work. Together with this quantitative part, a survey addressed to category managers to better understand their key drivers, for choosing the type of product of each store, was carried out. Based in a non-random sample of 65 stores with data referring to 2013, the final result was the choice of 6 store clusters (Figure 1) which were individually characterized as the main outcome of this work. In what relates to our selected variables, all were important for the distinction between clusters, which proves the adequacy of their choice. The interpretation of the results gives category managers a tool to understand which products best fit the clustered stores. Furthermore, as a side finding thanks to the clusterization, a STP (Segmentation, Targeting and Positioning) was initiated, being this WP the first steps of a continuous process.

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.

Contributo para o estudo dos efeitos da passagem à situação (e idade) de reforma na frequência das principais doenças crónicas em Portugal

RESUMO - Introdução: A transição para a reforma é um acontecimento que pode acarretar alterações suscetíveis de afetar o estado de saúde. Vários estudos têm investigado os efeitos da reforma no estado de saúde, embora poucos o tenham investigado, especificamente, nas doenças crónicas. As recentes políticas de aumento da idade de reforma, assim como a ausência de consenso sobre os efeitos da reforma na saúde, atribuem-lhe ainda maior importância. Constituem objetivos do presente estudo quantificar a associação entre a Passagem à situação de reforma (e idade de reforma) e a frequência de cada uma das principais doenças crónicas, no sentido dos efeitos da reforma nestes indicadores de saúde (doença respiratória crónica, diabetes, doença cardiovascular, AVC, depressão e cancro). Material e Métodos: Desenvolveu-se um estudo transversal, no qual foram analisados os dados provenientes das amostras representativas da população portuguesa SHARE 2011 e ECOS 2013. As associações foram quantificadas através do cálculo do Odds ratio por Regressão Logística Binária com avaliação do confundimento e modificação de efeito. As variáveis de doença crónica foram medidas por auto-reporte. Foram considerados os reformados que se encontrassem em processo de reforma (ou seja, reformados há 5 anos ou menos) e que não se tivessem reformado por doença. Resultados: A reforma não se encontrou significativamente associada a nenhuma das doenças crónicas consideradas, excetuando-se: i) o cancro (na amostra ECOS), para o qual foi fator protetor; ii) e a doença cardiovascular (na amostra SHARE), para a qual teve um efeito prejudicial, mas apenas em não hipertensos. A reforma em idade antecipada pareceu encontrar-se associada a um pior estado de saúde, relativamente à reforma em idade legal (ou após). Tal observou-se no Cancro (nas amostras ECOS e SHARE), na Diabetes (na amostra SHARE), e no AVC em pessoas sem Doença Cardiovascular (na amostra SHARE). Pelo contrário, em pessoas com Doença Cardiovascular a reforma antecipada pareceu constituir um fator protetor. Discussão e conclusões: As diferenças observadas nos resultados entre amostras poderão, entre outros, atribuir-se às diferentes populações em estudo, dimensões amostrais e desenhos de amostragem. Os resultados obtidos não são muito diferentes dos que têm sido descritos na bibliografia, ainda que haja um número reduzido de estudos sobre esta matéria. Indicam que, eventualmente, as recentes alterações de aumento da idade de reforma poderão expandir o grupo de pessoas que se reformam antecipadamente, podendo resultar, eventualmente, num aumento da prevalência de doenças crónicas na população portuguesa. Os mecanismos através dos quais a reforma poderá influenciar a ocorrência de doenças crónicas permanecem por explicar, embora os seus principais fatores de risco pareçam representar importantes modificadores de efeito.

Building 3D City Models: Testing and Comparing Laser Scanning and Low-Cost UAV Data Using FOSS Technologies

Contém resumo

Comuns: An Open-Data Provider, Explorer and Analytic Toolbox Based on FOSS

Contém resumo