Desenho e implementação de um data warehouse para a empresa AdClick

Esta dissertação incide sobre a problemática da construção de um data warehouse para a empresa AdClick que opera na área de marketing digital. O marketing digital é um tipo de marketing que utiliza os meios de comunicação digital, com a mesma finalidade do método tradicional que se traduz na divulgação de bens, negócios e serviços e a angariação de novos clientes. Existem diversas estratégias de marketing digital tendo em vista atingir tais objetivos, destacando-se o tráfego orgânico e tráfego pago. Onde o tráfego orgânico é caracterizado pelo desenvolvimento de ações de marketing que não envolvem quaisquer custos inerentes à divulgação e/ou angariação de potenciais clientes. Por sua vez o tráfego pago manifesta-se pela necessidade de investimento em campanhas capazes de impulsionar e atrair novos clientes. Inicialmente é feita uma abordagem do estado da arte sobre business intelligence e data warehousing, e apresentadas as suas principais vantagens as empresas. Os sistemas business intelligence são necessários, porque atualmente as empresas detêm elevados volumes de dados ricos em informação, que só serão devidamente explorados fazendo uso das potencialidades destes sistemas. Nesse sentido, o primeiro passo no desenvolvimento de um sistema business intelligence é concentrar todos os dados num sistema único integrado e capaz de dar apoio na tomada de decisões. É então aqui que encontramos a construção do data warehouse como o sistema único e ideal para este tipo de requisitos. Nesta dissertação foi elaborado o levantamento das fontes de dados que irão abastecer o data warehouse e iniciada a contextualização dos processos de negócio existentes na empresa. Após este momento deu-se início à construção do data warehouse, criação das dimensões e tabelas de factos e definição dos processos de extração e carregamento dos dados para o data warehouse. Assim como a criação das diversas views. Relativamente ao impacto que esta dissertação atingiu destacam-se as diversas vantagem a nível empresarial que a empresa parceira neste trabalho retira com a implementação do data warehouse e os processos de ETL para carregamento de todas as fontes de informação. Sendo que algumas vantagens são a centralização da informação, mais flexibilidade para os gestores na forma como acedem à informação. O tratamento dos dados de forma a ser possível a extração de informação a partir dos mesmos.

Antibody response to heat-inactivated hepatitis B vaccine (CLB-3mg) in hemodialysis patients and occupational risk personnel: a one year follow-up

Immune response against hepatitis B vaccine (CLB 3mg) was evaluated in 59 hemodialysis patients and 20 occupational risk personnel. Seroconversion was induced in 52.5% and 70.0% respectively. Twelve months after the first dose, 37.5% of patients and 60.0% of occupational risk personnel had detectable anti-HBs level. Antibody level was expressed in sample ratio units (SRU). Considering only the responders, in the patients group 38.7% had a low anti-HBs response (2.1-9.9 SRU) 32.3% a medium response (10-99.9 SRU) and 29.0% a high response (>100 SRU) while in occupational risk personnel these values were 14.3%, 64.3% and 21.4% respectively. The authors suggest the use of HBV vaccines with more elevated HBsAg concentration or a reinforced immunization schedule to improve the anti-HBs response not only for patients but also for healthy persons.

Approaches to tuberculosis mucosal vaccine development using nanoparticles and microparticles: a review

Next-generation vaccines for tuberculosis should be designed to prevent the infection and to achieve sterile eradication of Mycobacterium tuberculosis. Mucosal vaccination is a needle-free vaccine strategy that provides protective immunity against pathogenic bacteria and viruses in both mucosal and systemic compartments, being a promising alternative to current tuberculosis vaccines. Micro and nanoparticles have shown great potential as delivery systems for mucosal vaccines. In this review, the immunological principles underlying mucosal vaccine development will be discussed, and the application of mucosal adjuvants and delivery systems to the enhancement of protective immune responses at mucosal surfaces will be reviewed, in particular those envisioned for oral and nasal routes of administration. An overview of the essential vaccine candidates for tuberculosis in clinical trials will be provided, with special emphasis on the potential different antigens and immunization regimens.

Prevention of electrocardiographic and histopathologic alterations in the murine model of Chagas' disease by preinoculation of an attenuated Trypanosoma cruzi strain

The effects of infection with Trypanosoma cruzi on the electrocardiographic tracings of mice were studied in 4.groups of animals: (1) normal; (2) infected with a pathogenic T. cruzi strain (TS COB); (3) immunized with 3 intraperitoneal inocula of 10(6) attenuated T. cruzi epimastigotes (TCC) and (4) immunized-infected, which sequentially received the treatments of groups 3 and 2. Infection and protection were confirmed by xenodiagnosis and histopathology. Isolated alterations such as extrasystolia, 1st degree atrioventricular block, arrhythmia and ST elevation were observed in normal as well as infected mice. However, tracings taken repeatedly on each mouse over a 293 day period revealed a set of alterations which were more frequently seen in infected (14/22) than in normal (4/27) animals (p = 0.00048). These alterations consisted of supraventricular tachycardia, sinus bradycardia and persisting, first degree AV blocks, often associated to pacemaker changes. Inoculation of attenuated T. cruzi (group 3) did not increase these alterations (2/27 mice) but significantly prevented their development after challenge with the pathogenic strain (1/19 versus 14/22 mice, p = 0.000095). Thus, preimmunization reduced not only parasitemia but also a pathogenic consequence of T. cruzi infection. This evidence is relevant for immunoprevention studies against Chagas' disease.

Motivations to participate in international trade fairs: the Portuguese experience

Motivations/barriers to participate in ITF

Measles vaccination: influence of age on its efficacy

The authors compare the serologic efficacy and the clinical protection afforded by three different measles vaccination schemes in adequately nourished children in São Paulo city, Brazil. Two hundred forty two children were divided into three groups. Group A, comprising 117 children who had received the vaccine before 12 months of age and a second dose at 12 months of age or more. Group B, comprising 46 children who had received only one dose, before 12 months of age. Group C, comprising 79 children who had received only one dose, at 12 months of age or more. The geometric mean titer of antibodies in Group A was 790.1; in Group B, 251.1; and in Group C, 550.3. There was no statistically significant difference between Groups A and C. The exposure to the measles virus was probably similar in all groups, and the children in Groups A and C had similar chances of acquiring the disease after vaccination whereas in Group B the chances were higher when compared to the other two groups. The results obtained in this study favor the use, in developing countries, of a vaccination program against measles that includes an early first dose at eight months of age and revaccination after 12 months of age.

Fast mobility support in low-power wireless networks: smart-HOP over RPL/6LoWPAN

With the emergence of low-power wireless hardware new ways of communication were needed. In order to standardize the communication between these low powered devices the Internet Engineering Task Force (IETF) released the 6LoWPAN stand- ard that acts as an additional layer for making the IPv6 link layer suitable for the lower-power and lossy networks. In the same way, IPv6 Routing Protocol for Low- Power and Lossy Networks (RPL) has been proposed by the IETF Routing Over Low power and Lossy networks (ROLL) Working Group as a standard routing protocol for IPv6 routing in low-power wireless sensor networks. The research performed in this thesis uses these technologies to implement a mobility process. Mobility management is a fundamental yet challenging area in low-power wireless networks. There are applications that require mobile nodes to exchange data with a xed infrastructure with quality-of-service guarantees. A prime example of these applications is the monitoring of patients in real-time. In these scenarios, broadcast- ing data to all access points (APs) within range may not be a valid option due to the energy consumption, data storage and complexity requirements. An alternative and e cient option is to allow mobile nodes to perform hand-o s. Hand-o mechanisms have been well studied in cellular and ad-hoc networks. However, low-power wireless networks pose a new set of challenges. On one hand, simpler radios and constrained resources ask for simpler hand-o schemes. On the other hand, the shorter coverage and higher variability of low-power links require a careful tuning of the hand-o parameters. In this work, we tackle the problem of integrating smart-HOP within a standard protocol, speci cally RPL. The simulation results in Cooja indicate that the pro- posed scheme minimizes the hand-o delay and the total network overhead. The standard RPL protocol is simply unable to provide a reliable mobility support sim- ilar to other COTS technologies. Instead, they support joining and leaving of nodes, with very low responsiveness in the existence of physical mobility.

Reinfection after treatment of schistosomiasis: environment or "predisposition"?

Although very efficient for the control of morbidity due to S. mansoni in individual patients, chemotherapy has not proven successful in the management of transmission within hyperendemic areas when used alone, even if repeated at short intervals. Consequently, a great deal of effort has been expended toward immunologic investigation and development of a specific vaccine. Based upon a study of a group of children (5-14 years) from the state of Alagoas, the author demonstrates that the outcome one year after chemotherapy depends essentially on the "risk rating" of the area of domicile. A regression analysis did not reveal significant correlation to neither age, sex or initial egg counts. Although the study was not designed to reveal individual variations in the immune status, it is postulated that putative differences in genetic make-up are irrelevant in terms of large-scale intervention. Since morbidity due to S. mansoni has substantially declined during the last two or three decades, a control policy based on vaccination can only be justified if high levels of protective immunity can be attained. At any rate, such a vaccine will have to be administered in early childhood (preferably below the age of three). It can also be demonstrated that immunization in adolescence or adulthood serves no purpose whatsoever. The author is convinced that environmental intervention, usually dismissed as unrealistic in terms of the developing countries, is not only feasible, if done on a selective basis, but prioritary.

O líder enquanto dinamizador da comunicação interna nas organizações

Dissertação apresentada à Escola Superior de Comunicação Social como parte dos requisitos para obtenção de grau de mestre em Gestão Estratégica das Relações Públicas.

Transient Spaces: unsettling boundaries and norms at the cultural event Noc Noc, Guimarães, Portugal

Cities are increasingly expected to be creative, inventive and to exhibit intense expressivity. In the past decades many cities have experienced growing pressure to produce and stage cultural events of different sorts and to develop new strategies that optimize competitive advantages, in order to promote themselves and to boost and sell their image. Often these actions have relied on heavy public investment and major private corporation sponsoring, but it is not always clear or measured how successful and reproductive these investments have been. In the context of strained public finances and profound economic crisis of European peripheral countries, events that emerge from local communities and have low budgets, which manage to create significant fluxes of visitors and visibility, assume an increased interest. In order to reflect and sketch possible answers, we look to an emerging body of literature concerning creative cities, and we focus on the organisation of a particular cultural event and its impact and assimilation into a medium size Portuguese city. This paper looks at the two editions (2011 and 2012) of one of such events – Noc Noc – organized by a local association in the city of Guimarães, Portugal. Inspired by similar events, Noc Noc is based on creating transient spaces of culture which are explored by artists and audiences, by transforming numerous homes into ephemeral convivial and playful social ‘public’ environments. The event is based on a number of cultural venues/homes scattered around the old and newer city, which allows for an informal urban exploration and an autonomous rambling and getting lost along streets. This strategy not only disrupts the cleavages between public and private space permitting for various transgressions, but it also disorders normative urban experiences and unsettles the dominant role of the city council as the culture patron of the large majority of events. Guimarães, an UNESCO World Heritage City was the European Capital of Culture in 2012, with a public investment of roughly 73 million euro. By interviewing a sample of people who have hosted these transitory art performances and exhibitions, sometimes doubling as artists, the events’ organizers and by experience both editions of the event, this paper illustrates how urban citizens’ engagement and motivations in a low budget cultural event can strengthen community ties. Furthermore, it also questions the advantages of large scale high budget events, and how this event may be seen as unconscious counter movement against a commodification of cultural events and everyday urban experience at large, engaging with the concepts of staging and authenticity.

Immune response in mice immunized with acidic antigenic fractions from Trypanosoma cruzi cytosol

The humoral and cellular immune responses as well as the resistance to infection with bloodstream forms of T. cruzi were studied in mice immunized with acidic antigenic fractions from parasite cytosol, F III and F IV, plus Bordetella pertussis as adjuvant. The immunization with F III induced positive ITH and DTH responses to homologous antigens. In mice immunized with F IV, the ITH was negative and four out of six animals presented positive DTH reactions. In both groups of mice the analysis of IgG aginst T. cruzi showed that the major isotype elicited was IgG1. Specific IgE was also detected in sera from F III immunized mice, thus confirming the presence of homocytothropic antibodies. The parasitemias reached by F III and F IV immunized mice after challenge were lower than those of the controls showing in this way a partial protection against the acute infection. The histological studies of heart and skeletal muscle performed two months after the infection revealed variable mononuclear infiltration in all infected mice despite immunization.

A Força Aérea Portuguesa e o voo nas redes sociais

Trabalho de projeto apresentado à Escola Superior de Comunicação Social como parte dos requisitos para obtenção de grau de mestre em Publicidade e Marketing.

PV systems linked to the grid: parameter identification with a heuristic procedure

This paper focuses on a PV system linked to the electric grid by power electronic converters, identification of the five parameters modeling for photovoltaic systems and the assessment of the shading effect. Normally, the technical information for photovoltaic panels is too restricted to identify the five parameters. An undemanding heuristic method is used to find the five parameters for photovoltaic systems, requiring only the open circuit, maximum power, and short circuit data. The I- V and the P- V curves for a monocrystalline, polycrystalline and amorphous photovoltaic systems are computed from the parameters identification and validated by comparison with experimental ones. Also, the I- V and the P- V curves under the effect of partial shading are obtained from those parameters. The modeling for the converters emulates the association of a DC-DC boost with a two-level power inverter in order to follow the performance of a testing commercial inverter employed on an experimental system. © 2015 Elsevier Ltd.

O projeto de literacia da informação numa biblioteca da saúde: o caso da Biblioteca da ESTeSL

Introdução – Ao aumento exponencial de informação, sobretudo a científica, não corresponde obrigatoriamente a melhoria de qualidade na pesquisa e no uso da mesma. O conceito de literacia da informação ganha pertinência e destaque, na medida em que abarca competências que permitem reconhecer quando é necessária a informação e de atuar de forma eficiente e efetiva na sua obtenção e utilização. A biblioteca académica assume, neste contexto, o papel de parceiro privilegiado, preparando o momento em que o estudante se sente capaz de produzir e registar novo conhecimento através da escrita. Objectivo – A Biblioteca da ESTeSL reestruturou as sessões desenvolvidas desde o ano lectivo 2002/2003 e deu início a um projecto mais formal denominado «Saber usar a informação de forma eficiente e eficaz». Objectivos: a) promover a melhoria da qualidade dos trabalhos académicos e científicos; b) contribuir para a diminuição do risco de plágio; c) aumentar a confiança dos estudantes nas suas capacidades de utilização dos recursos de informação; d) incentivar uma participação mais ativa em sala de aulas; e) colaborar para a integração dos conteúdos pedagógicos e das várias fontes de informação. Método – Dinamizaram-se várias sessões de formação de curta duração, versando diferentes temas associados à literacia de informação, designadamente: 1) Pesquisa de informação com sessões dedicadas à MEDLINE, RCAAP, SciELO, B-ON e Scopus; 2) Factor de impacto das revistas científicas: Journal Citation Reports e SciMAGO; 3) Como fazer um resumo científico?; 4) Como estruturar o trabalho científico?; 5) Como fazer uma apresentação oral?; 6) Como evitar o plágio?; 7) Referenciação bibliográfica usando a norma de Vancouver; 8) Utilização de gestores de referências bibliográficas: ZOTERO (primeira abordagem para os estudantes de 1º ano de licenciatura) e a gestão de referências e rede académica de informação com o MENDELEY (direcionado para estudantes finalistas, mestrandos, docentes e investigadores). O projecto foi apresentado à comunidade académica no site da ESTeSL; cada sessão foi divulgada individualmente no site e por email. Em 2015, a divulgação investiu na nova página da Biblioteca (https://estesl.biblio.ipl.pt/), que alojava informações e recursos abordados nas formações. As inscrições eram feitas por email, sem custos associados ou limite mínimo ou máximo de sessões para participar. Resultados – Em 2014 registaram-se 87 inscrições. Constatou-se a presença de, pelo menos, um participante em cada sessão de formação. Em 2015, o total de inscrições foi de 190. Foram reagendadas novas sessões a pedido dos estudantes cujos horários não eram compatíveis com os inicialmente agendados. Foram então organizados dois dias de formação seguida (cerca de 4h em cada dia) com conteúdos selecionados pelos estudantes. Registou-se, nestas sessões, a presença contante de cerca de 30 estudantes em sala. No total, as sessões da literacia da informação contaram com estudantes de licenciatura de todos os anos, estudantes de mestrado, docentes e investigadores (internos e externos à ESTeSL). Conclusões – Constata-se a necessidade de introdução de novos conteúdos no projeto de literacia da informação. O tempo, os conteúdos e o interesse demonstrado por aqueles que dele usufruíram evidenciam que este é um projeto que está a ganhar o seu espaço na comunidade da ESTeSL e que a literacia da informação contribui de forma efetiva para a construção e para a produção de conhecimento no meio académico.

The semigroup ring of a restriction semigroup with an inverse skeleton

In this paper we investigate some classes of semigroup rings with respect to (semi)primeness and (semi)primitivity. We do so by extending the techniques developed by Munn in (Proc R Soc Edinbur Sect A 107:175-196, 1987) and (Proc R Soc Edinbur Sect A 115:109-117, 1990) for the study of semigroup rings of inverse semigroups. Restriction, weakly ample and ample semigroups are considered.