Pacote de sincronização de réplicas de bases de dados

A replicação de base de dados tem como objectivo a cópia de dados entre bases de dados distribuídas numa rede de computadores. A replicação de dados é importante em várias situações, desde a realização de cópias de segurança da informação, ao balanceamento de carga, à distribuição da informação por vários locais, até à integração de sistemas heterogéneos. A replicação possibilita uma diminuição do tráfego de rede, pois os dados ficam disponíveis localmente possibilitando também o seu acesso no caso de indisponibilidade da rede. Esta dissertação baseia-se na realização de um trabalho que consistiu no desenvolvimento de uma aplicação genérica para a replicação de bases de dados a disponibilizar como open source software. A aplicação desenvolvida possibilita a integração de dados entre vários sistemas, com foco na integração de dados heterogéneos, na fragmentação de dados e também na possibilidade de adaptação a várias situações. ABSTRACT: Data replication is a mechanism to synchronize and integrate data between distributed databases over a computer network. Data replication is an important tool in several situations, such as the creation of backup systems, load balancing between various nodes, distribution of information between various locations, integration of heterogeneous systems. Replication enables a reduction in network traffic, because data remains available locally even in the event of a temporary network failure. This thesis is based on the work carried out to develop an application for database replication to be made accessible as open source software. The application that was built allows for data integration between various systems, with particular focus on, amongst others, the integration of heterogeneous data, the fragmentation of data, replication in cascade, data format changes between replicas, master/slave and multi master synchronization.

Generalities of vertebrate responses to landscape composition and configuration gradients in a highly heterogeneous Mediterranean region

Aim To examine the distributional patterns of vertebrates (including birds, bats, carnivores and lagomorphs) along landscape composition and configuration gradients to better understand the effects of landscape modification on occurrence patterns at both species and community level. Location The region of Alentejo, a forest-dominated area of southern Portugal. Methods The study area was framed using 1647 hexagonal plots, each of 259 ha in size. Composition and configuration gradients were obtained for each plot by integrating the proportions of the main land cover types and their configuration patterns using multivariate analyses. Species-specific vertebrate responses were investigated using data from 75 plots in which carnivores, bats and lagomorphs were sampled, and from 135 plots in the case of birds. Community- level responses were investigated through changes in species richness and beta-diversity in 57 plots where all vertebrate groups were simultaneously sampled. At the species-level, an information-theoretic approach was used to determine the effects of landscape gradients on species’ responses. At the community level, Mantel tests were used to determine between-plot differences in species composition using the Sørensen dissimilarity index. Results We found that the occurrence patterns of most vertebrate species were best predicted by composition-related gradients, although configuration gradients were also frequently included in species-specific occurrence models. We also found a weak correlation between species richness and most landscape gradients suggesting a turnover in the identity of species, something that was corroborated by the stronger correlation between environmental gradients and beta-diversity measures. The amount of forest cover and landscape complexity (estimated as the heterogeneity in the size and number of land cover types) were the main composition and configuration gradients determining vertebrate responses at both species and community level. Main conclusions Our work contributes to a more refined understanding of the mechanisms underlying species distributional patterns in real-world human-modified landscapes. By uncovering generalities of species with multiple ecological requirements and by describing the entire landscape mosaic through landscape gradients, we also suggest that our work greatly helps to fill the gap between existing conceptual landscape models aimed to understand species distributional patterns in human-modified landscapes.

"Portuguese Observatory of Taeniasis and Cysticercosis": A "One Health" example for epidemiological surveillance of one neglected disease in a European country

Cysticercosis results from the ingestion Taenia solium eggs directly by faecal-oral route or contaminated food or water. Human tapeworm carriers who have become infected after ingesting pork meat contaminated with cysticerci release these eggs. Cysticercosis occurs after tapeworm eggs are ingested by an intermediate host (pig or human) and then hatch, migrate, and lodge in the host's tissues, where they develop onto larval cysticerci. When they lodged in the central nervous system of humans, results in the disease condition called Neurocysticercosis (NCC), with a heterogeneous manifestations depending of the locations of cysts, number, size and their stage of evolution (1). Consequently the prognostic ranges from asymptomatic to situations leading to death in 2% to 9.8%. of cases (7) In swine’s there are few studies, but recent works have proved that animals, for the same reasons, also have neurological abnormalities, expressed by seizures, stereotypic walk in circles, chewing motions with foamy salivation included tonic muscle contractions followed by a sudden diminution in all muscle tone leading to collapse (2). Conventional domestic wastewater treatment processes may not be totally effective in inactivating parasites eggs from Taenia solium, allowing some contamination of soils and agricultural products (11). In Portugal there are some evidence of aggregation of human cysticercosis cases in specific regions, bases in ecological design studies (6). There are few information about human tapeworm carriers and social and economic factors associated with them. Success in knowledge and consequently in lowering transmission is limited by the complex network of biological and social factors that maintain the spread. Effective control of mostly zoonosis require One Health approach, after a real knowledge and transparency in the information provided by the institutions responsible for both animal and human health, allowing sustained interventions targeted at the transmission cycle's crucial nodes. In general, the model used to control, reflects a rural reality, where pigs are raised freely, poor sanitation conditions and incipient sanitary inspection. In cysticercosis, pigs are obligate intermediate hosts and so considered as first targets for control and used as sentinels to monitor environmental T. solium contamination (3). Usually environmental contamination with Taenia spp. eggs is a key issue in most of studies with landscape factors influencing presence of Taenia spp. antigens in both pigs and humans (5). Soil-related factors as well as socio-economic and behavioural factors are associated with the emergence of significant clustering human cysticercosis (4,5). However scarce studies has been produced in urban environmental and in developed countries with the finality to characterize the spatial pattern. There are still few data available regarding its prevalence and spatial distribution; Transmission patterns are likely to exhibit correlations as housing conditions, water supply, basic sanitation, schooling and birthplace of the individual or relatives, more than pigs rearing free, soil conditions (9). As a matter of fact, tapeworm carriers from endemic zones can auto-infect or transmit infection to other people or arrive already suffering NCC (as a result of travelling to or being a citizen from an endemic cysticercosis country) to a free cysticercosis country. Transmission is fecal-oral; this includes transmission through person-to-person contact, through autoinfection, or through contaminated food This has been happening in different continents as North America (5.4–18% been autochthonous), Europe and Australia (7). Recently, case reports of NCC have also emerged from Muslim countries. (10). Actually, different papers relate an epidemic situation in Spain and Portugal (7, 8). However the kind of study done does not authorize such conclusion. There are no evidence that infections were acquired in Portugal and there are not characterized the mode of transmission. Papers with these kind of information will be allow to have economic consequences resulted from artificial trade barriers with serious consequences for pig producers and pig meat trade. We need transparency in information’s that allow provide the basis to support the development and targeting of future effective control programmes (and prove we need that). So, to have a real picture of the disease, it is necessary integrate data from human, animal and environmental factors surrounding human and pig cases to characterize the pattern of the transmission. The design needs to be able to capture unexpected, and not common outcomes (routine data). We need to think “One Health” to get a genuine image of the situation.

Setting up a network of agrometeorological stations in East Timor

A developed and sustainable agriculture requires a permanent and reliable monitoring of climatic/ meteorological elements in (agro) meteorological stations which should be located close to agricultural, silvicultural or pastoral activities. An adequate network of meteorological stations is then a necessary condition to support innovation and development in any country. Developing countries, mainly those with a history of frequent conflicts, presents deficient number of weather stations, often poorly composed and improperly distributed within their territories, and without a regular operation that allows continuity of records for a sufficiently long period of time. The objective of this work was to build a network of meteorological and agro-meteorological stations in East Timor. To achieve this goal, the number and location of pre-existing stations, their structure and composition (number and type of sensors, communication system,… ), the administrative division of the country and the available agro-ecological zoning, the agricultural and forestry practices in the country, the existing centres for the agricultural research and the history of the weathers records were taken into account. Several troubles were found (some of the automatic stations were assembled incorrectly, others stations duplicated information regarding the same agricultural area, vast areas with relevant agro-ecological representativeness were not monitored …). It was proposed the elimination of 11 existing stations, the relocation of 7 new stations in places not covered until then, the automation of 3 manual meteorological stations. Two networks were then purposed, a major with 15 agro-meteorological stations (all automatized) and one other secondary composed by 32 weather stations (only two were manual). The set of the 47 stations corresponded to a density of 329 km2/station. The flexibility in the composition of each of the networks was safeguarded and intends to respond effectively to any substantive change in the conditions in a country in constant change. It was also discussed the national coverage by these networks under a “management concept for weather stations”.