Repairs of databases with null values

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

Effects of quantitative easing on the USA economy: A test for policy effectiveness

The catastrophic disruption in the USA financial system in the wake of the financial crisis prompted the Federal Reserve to launch a Quantitative Easing (QE) programme in late 2008. In line with Pesaran and Smith (2014), I use a policy effectiveness test to assess whether this massive asset purchase programme was effective in stimulating the economic activity in the USA. Specifically, I employ an Autoregressive Distributed Lag Model (ARDL), in order to obtain a counterfactual for the USA real GDP growth rate. Using data from 1983Q1 to 2009Q4, the results show that the beneficial effects of QE appear to be weak and rather short-lived. The null hypothesis of policy ineffectiveness is not rejected, which suggests that QE did not have a meaningful impact on output growth.

The cellular basis of a congenital heart defect Drosophila

RESUMO: Mutações em genes envolvidos na formação do coração e anomalias em qualquer etapa deste processo causam frequentemente malformações cardíacas, que representam o tipo mais comum de defeitos em neonatais, afetando cerca de 1% dos nascimentos por ano. Assim, estima-se que 20 milhões de pessoas sejam portadoras de um defeito cardíaco congénito. O coração da Drosophila melanogaster (mosca-da-fruta), denominado vaso dorsal, é um órgão relativamente simples que actua como uma bomba muscular, contraindo automaticamente para permitir a circulação da hemolinfa através do corpo. A formação do vaso dorsal na mosca é muito semelhante ao desenvolvimento do coração em vertebrados, representando por isso, um poderoso modelo para estudar a rede de genes e os padrões regulatórios relacionados com o desenvolvimento deste órgão. Anteriormente, nós identificámos um gene em Drosophila, darhgef10, fortemente expresso no coração em desenvolvimento e cuja deleção induz anormalidades cardíacas subtis mas prevalentes. Os mutantes para darhgef10 são viáveis e férteis no ambiente controlado de laboratório. Este trabalho teve como objectivos caracterizar fenotipicamente os mutantes nulos para darhgef10, determinar a localização subcelular da proteína dArhgef10 e investigar a base celular subjacente ao defeito no alinhamento dos cardioblastos observado nos mutantes. Os nossos resultados revelaram que a deleção de darhgef10 provoca uma severa redução da viabilidade, sem no entanto comprometer o tempo de desenvolvimento e a longevidade. Por outro lado, o aumento da expressão de darhgef10 em músculos, glândulas salivares e no disco imaginal do olho afeta drasticamente a integridade destes tecidos. A expressão ectópica de darhgef10 in vitro e in vivo revelou que a proteína está localiza no citoplasma com enriquecimento junto à membrana celular, com associação à actina F. Live imaging de embriões mutantes para darhgef10 revelou que os defeitos observados no coração podem estar associados a um defeito na adesão dos músculos alary e/ou das células pericardiais ao vaso dorsal. O homólogo humano de darhgef10, ARHGEF10, também é expresso no coração e está associação a uma maior susceptibilidade para a ocorrência de acidentes vasculares cerebrais aterotrombóticos, sugerindo que o que aprendemos sobre darhgef10 em Drosophila pode ter implicações do ponto de vista clínico para a saúde humana. ----------------------------- ABSTRACT: Mutations in genes controlling heart development and abnormalities in any of its steps frequently cause cardiac malformations, the most common type of birth defects in humans, affecting nearly 1% of births per year. Hence around 20 million adults are expected to live with a congenital heart defect. The Drosophila melanogaster heart, called dorsal vessel, is a relatively simple organ that acts as a muscular pump contracting automatically to allow the circulation of hemolymph. Drosophila heart formation shares many similarities with heart development in vertebrates providing a powerful system to study gene networks and regulatory pathways involved in heart development. We have previously identified a Drosophila gene, darhgef10, which is strongly expressed in the developing heart and when deleted, leads to flies with highly prevalent yet subtle heart abnormalities, compatible with unchallenged life in the laboratory. Our aims were to phenotypically characterize homozygous null darhgef10 mutants, characterize the subcellular localization of dArhgef10 and to study the cellular basis of the misaligned cardioblasts defect. We found that about half of darhgef10 mutants die during development. However, the survivors surprisingly have a nearly normal developmental time, adult locomotor behavior and total lifespan. Detection of transgene-derived dArhgef10 protein in vitro and in vivo using custom antibodies revealed a cytosolic protein slightly enriched in the cellular membranes and associated with F-actin. Tissue-specific darhgef10 expression disrupts the normal morphology of developing muscles, salivary glands and the eye. Live imaging of darhgef10 mutant embryos revealed that heart defect could be caused by a reduced capacity of attachment of pericardial cells and/or alary muscle to dorsal vessel. The human homolog of darhgef10 is also expressed in the heart and is a susceptibility gene for atherothrombotic stroke, suggesting that what we learn about the function of this gene and its phenotypes in Drosophila could have implications to human health.

Improving retail banking staff incentive systems

This Work Project seeks to analyze the viability, utility and best way of implementing mechanisms of double accounting and of insertion of low (or null) sales objectives in an incentives program. The main findings are that both processes are possible and to a certain extent advisable, although in very specific ways and with some limitations. Double accounting processes are especially effective between different segments and networks and should have a greater impact in the first evaluation periods of each case and the null objectives, albeit usable, are recommended to be always substituted by positive objectives, even if quite small. Moreover, it is concluded that the formal structure of the incentives program influences significantly these concepts, namely concerning the duration of the evaluation periods and the interaction of the objectives of different entities for both the vertical (hierarchic) and horizontal (individual and collective) levels.