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.

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.

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.

Evolution of Teeth and Quadrate in Non-avian Theropoda (Dinosauria: Saurischia), with the Description of Torvosaurus Remains from Portugal

Theropods form a highly successful and morphologically diversified group of dinosaurs that gave rise to birds. They include most, if not all, carnivorous dinosaurs, yet many theropod clades were secondarily adapted to piscivory, omnivory and herbivory, and theropods show a large array of skull and dentition morphologies. This work aims to investigate aspects of the evolution of theropod dinosaurs by analyzing in detail both the anatomy and ontogeny of teeth and quadrates in non-avian theropods, and by studying embryonic and adult material of a new species of theropod. A standardized list of terms and notations for each anatomical entity of the tooth, quadrate, and maxilla is here proposed with the goal of facilitating descriptions of these important cranial and dental elements. The distribution of thirty dental characters among 113 theropod taxa is investigated, and a list of diagnostic dental characters is proposed. As an example, four isolated theropod teeth from the Lourinhã Formation (Kimmeridgian‒Tithonian) of Portugal are described and identified based on a cladistic analysis performed on a data matrix of 141 dentition-based characters coded in 60 taxa. Two shed teeth are referred to an abelisaurid, providing the first record of Abelisauridae in the Jurassic of Laurasia and the one of the oldest records of this clade in the world, suggesting a possible radiation of Abelisauridae in Europe well before the Upper Cretaceous. The consensus tree resulting from this phylogenetic analysis, the most extensive on theropod teeth, indicates that theropod teeth provide reliable data for identification at approximately family level, and this method will help identifying theropod teeth with more confidence. A detailed description of the dentition of Megalosauridae is also provided, and a discriminant analysis performed on a dataset of numerical data collected on the teeth of 62 theropod taxa reveals that megalosaurid teeth are hardly distinguishable from other theropod clades with ziphodont dentition. This study highlights the importance of detailing anatomical descriptions and providing additional morphometric data on teeth with the purpose of helping to identify isolated theropod teeth. In order to evaluate the phylogenetic potential and investigate the evolutionary transformations of the quadrate, a phylogenetic morphometric analysis as well as a cladistic analysis using 98 discrete quadrate related characters were conducted. The quadrate morphology by its own provides a wealth of data with strong phylogenetic signal, and the phylogenetic morphometric analysis reveals two main morphotypes of the mandibular articulation of the quadrate linked to function. As an example, six isolated quadrates from the Kem Kem beds (Cenomanian) of Morocco are determined to be from juvenile and adult individuals of Spinosaurinae based on phylogenetic, morphometric, and phylogenetic morphometric analyses. Morphofunctional analysis of the spinosaurid mandibular articulation has shown that the posterior parts of the two mandibular rami displaced laterally when the jaw was depressed due to a mediolaterally oriented intercondylar sulcus of the quadrate. Such lateral movement of the mandibular ramus was possible due to a movable mandibular symphysis in spinosaurids, allowing the pharynx to be widened. A new species of theropod from the Lourinhã Formation of Portugal, Torvosaurus gurneyi, is erected based on a right maxilla and an incomplete caudal centrum. This taxon supports the mechanism of vicariance that occurred in the Iberian Meseta during the Late Jurassic when the proto-Atlantic was already well formed. A theropod clutch containing several crushed eggs and embryonic material is also assigned to this new species of Torvosaurus. Investigation on the maxilla ontogeny in basal tetanurans reveals that crown denticles, elongation of the anterior ramus, and fusion of interdental plates appear at a posthatchling stage. On the other hand, maxillary pneumaticity is already present at an embryonic stage in non-avian theropods.

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

Análise da eficiência na gestão do risco de fornecedores: aplicação de um modelo Data Envelopment Analysis

Atualmente a tendência dos negócios leva a cadeias de abastecimento complexas e dinâmicas, que consequentemente levanta questões relativas ao aumento do risco de fornecimento em torno dessas mesmas cadeias; pelo que existe cada vez mais uma necessidade dos gestores identificarem e gerirem o risco de um modo mais diversificado. Associado às cadeias de abastecimento estão os fornecedores. A maioria dos riscos relativos a estes, está incluída no contexto de risco de fornecimento, resultando assim numa problemática de seleção e avaliação de fornecedores. Riscos como baixa qualidade, atrasos na entrega, falha ou interrupção de fornecimento, são exemplos de fatores de risco associados. Neste contexto, um dos maiores desafios para as organizações atualmente é trabalharem com os melhores fornecedores do mercado, procurando garantir a estabilidade em termos de fornecimento, com as melhores condições possíveis, quer a nível de preço, qualidade, entre outros, exigindo cada vez mais relações comerciais eficientes com os fornecedores. Assim, este trabalho tem como objetivo o desenvolvimento de um modelo baseado no método Data Envelopment Analysis (DEA), que permite às organizações avaliar e melhorar a eficiência das suas relações comerciais na gestão de risco de fornecimento nas suas cadeias de abastecimento. Como tal, o modelo proposto é divido em dois casos, que diferem pela origem da obtenção dos seus valores. Ou seja, num dos casos é aplicada uma avaliação externa à organização, e no outro é utilizada uma avaliação interna, o que permitirá discutir a sua utilização. Segundo o modelo proposto verificou-se que a eficiência média foi de 93% no caso I e 94% no caso II. Concluindo-se ainda ambos os casos necessitam de melhorias nos fornecimentos ao nível de: Qualidade, Logística e Tecnologia, ou seja, melhorar a qualidade dos serviços prestados, diminuir os seus prazos de execução dos serviços/fornecimento de material e aumento do conhecimento tecnológico.

Grande panorama de Lisboa em azulejo: Novos contributos para a fixação da data, encomenda e autoria

O Grande panorama de Lisboa, obra maior da azulejaria nacional e hoje à guarda do Museu Nacional do Azulejo, pertenceu outrora a um palácio situado na freguesia de Santiago, propriedade da família Ferreira de Macedo no final do século XVII. A investigação apresentada procura esclarecer alguns aspectos relacionados com a execução do grandioso painel e com o perfil sócio-cultural do encomendador. À luz de novos elementos documentais, o artigo discute ainda a questão da autoria do painel, dada há muito ao pintor barroco Gabriel del Barco.

Um modelo Data Envelopment Analysis para avaliação da eficiência dos terminais de contentores do grupo TERTIR

O transporte marítimo tem vindo a adquirir uma considerável importância na economia mundial desde o século XV. O transporte marítimo é visto como um dos meios de transporte mais viáveis, que engloba um largo número de destinos no mundo e representa, para uma determinada distância a percorrer, o menor custo por tonelada. É, também, comparativamente com o transporte aéreo e rodoviário, o meio de transporte menos poluente, tornando-o, assim, uma alternativa “amiga do ambiente”. Em particular, o transporte via contentores tem vindo a ser cada vez mais utilizado devido às suas inúmeras vantagens. O contentor permite o transporte de qualquer tipo de mercadoria em boas condições de acondicionamento e permitiu otimizar as operações efetuadas através da redução de tempo de trabalho, custos e espaço. Ademais, com a globalização, a evolução do mercado, a construção de navios de maiores dimensões e a maior tecnologia investida no setor, a competição entre os portos alcançou níveis que exigem uma maior eficiência de toda a estrutura portuária. Neste contexto, a presente dissertação visa avaliar a eficiência dos terminais de contentores do grupo TERTIR, nomeadamente os de Lisboa, Leixões e Setúbal, utilizando o método Data Envelopment Analaysis (DEA). De um modo geral, o método DEA avalia a capacidade dos terminais em converter inputs em outputs. Mais especificamente os inputs selecionados nesta dissertação dizem respeito às infraestruturas e equipamentos dos terminais em estudo, e o output considera a carga movimentada por cada terminal, sendo neste caso representada pelo número de TEUs movimentados. O modelo proposto é aplicado a um conjunto de 30 terminais de contentores Europeus de 6 países diferentes, nomeadamente, Alemanha, Bélgica, Espanha, França, Holanda e Portugal. De um modo geral, os terminais TERTIR apresentam níveis de eficiência baixos quando comparados com outros terminais Europeus. Os resultados contribuem, também, para auxiliar o grupo TERTIR no debate de algumas questões atuais com as autoridades portuárias, nomeadamente no que se refere à descida dos tarifários praticados aos seus clientes e à enunciada construção do terminal de contentores do Barreiro.

Genetic algorithm for shipping route estimation with long-range tracking data : automatic reconstruction of shipping routes based on the historical ship positions for maritime safety applications

Ship tracking systems allow Maritime Organizations that are concerned with the Safety at Sea to obtain information on the current location and route of merchant vessels. Thanks to Space technology in recent years the geographical coverage of the ship tracking platforms has increased significantly, from radar based near-shore traffic monitoring towards a worldwide picture of the maritime traffic situation. The long-range tracking systems currently in operations allow the storage of ship position data over many years: a valuable source of knowledge about the shipping routes between different ocean regions. The outcome of this Master project is a software prototype for the estimation of the most operated shipping route between any two geographical locations. The analysis is based on the historical ship positions acquired with long-range tracking systems. The proposed approach makes use of a Genetic Algorithm applied on a training set of relevant ship positions extracted from the long-term storage tracking database of the European Maritime Safety Agency (EMSA). The analysis of some representative shipping routes is presented and the quality of the results and their operational applications are assessed by a Maritime Safety expert.

Modelos de negócios para a internet das coisas baseados em big data : Muzzley, um estudo de caso

A Internet das Coisas tal como o Big Data e a análise dos dados são dos temas mais discutidos ao querermos observar ou prever as tendências do mercado para as próximas décadas, como o volume económico, financeiro e social, pelo que será relevante perceber a importância destes temas na atualidade. Nesta dissertação será descrita a origem da Internet das Coisas, a sua definição (por vezes confundida com o termo Machine to Machine, redes interligadas de máquinas controladas e monitorizadas remotamente e que possibilitam a troca de dados (Bahga e Madisetti 2014)), o seu ecossistema que envolve a tecnologia, software, dispositivos, aplicações, a infra-estrutura envolvente, e ainda os aspetos relacionados com a segurança, privacidade e modelos de negócios da Internet das Coisas. Pretende-se igualmente explicar cada um dos “Vs” associados ao Big Data: Velocidade, Volume, Variedade e Veracidade, a importância da Business Inteligence e do Data Mining, destacando-se algumas técnicas utilizadas de modo a transformar o volume dos dados em conhecimento para as empresas. Um dos objetivos deste trabalho é a análise das áreas de IoT, modelos de negócio e as implicações do Big Data e da análise de dados como elementos chave para a dinamização do negócio de uma empresa nesta área. O mercado da Internet of Things tem vindo a ganhar dimensão, fruto da Internet e da tecnologia. Devido à importância destes dois recursos e á falta de estudos em Portugal neste campo, com esta dissertação, sustentada na metodologia do “Estudo do Caso”, pretende-se dar a conhecer a experiência portuguesa no mercado da Internet das Coisas. Visa-se assim perceber quais os mecanismos utilizados para trabalhar os dados, a metodologia, sua importância, que consequências trazem para o modelo de negócio e quais as decisões tomadas com base nesses mesmos dados. Este estudo tem ainda como objetivo incentivar empresas portuguesas que estejam neste mercado ou que nele pretendam aceder, a adoptarem estratégias, mecanismos e ferramentas concretas no que diz respeito ao Big Data e análise dos dados.