Introducció als Sistemes d´Informació Geogràfica i creació d´una base de dades dels elements d´una xarxa de distribució d´aigua potable.

Aquest treball és una introducció als sistemes d'informació geogràfica, que consisteix en una breu descripció dels aspectes fonamentals dels sistemes d'informació geogràfica i en la creació d'una base de dades dels elements d'una xarxa de distribució d'aigua potable.

Debris flow hazard modelling on medium scale: Valtellina di Tirano, Italy

Debris flow hazard modelling at medium (regional) scale has been subject of various studies in recent years. In this study, hazard zonation was carried out, incorporating information about debris flow initiation probability (spatial and temporal), and the delimitation of the potential runout areas. Debris flow hazard zonation was carried out in the area of the Consortium of Mountain Municipalities of Valtellina di Tirano (Central Alps, Italy). The complexity of the phenomenon, the scale of the study, the variability of local conditioning factors, and the lacking data limited the use of process-based models for the runout zone delimitation. Firstly, a map of hazard initiation probabilities was prepared for the study area, based on the available susceptibility zoning information, and the analysis of two sets of aerial photographs for the temporal probability estimation. Afterwards, the hazard initiation map was used as one of the inputs for an empirical GIS-based model (Flow-R), developed at the University of Lausanne (Switzerland). An estimation of the debris flow magnitude was neglected as the main aim of the analysis was to prepare a debris flow hazard map at medium scale. A digital elevation model, with a 10 m resolution, was used together with landuse, geology and debris flow hazard initiation maps as inputs of the Flow-R model to restrict potential areas within each hazard initiation probability class to locations where debris flows are most likely to initiate. Afterwards, runout areas were calculated using multiple flow direction and energy based algorithms. Maximum probable runout zones were calibrated using documented past events and aerial photographs. Finally, two debris flow hazard maps were prepared. The first simply delimits five hazard zones, while the second incorporates the information about debris flow spreading direction probabilities, showing areas more likely to be affected by future debris flows. Limitations of the modelling arise mainly from the models applied and analysis scale, which are neglecting local controlling factors of debris flow hazard. The presented approach of debris flow hazard analysis, associating automatic detection of the source areas and a simple assessment of the debris flow spreading, provided results for consequent hazard and risk studies. However, for the validation and transferability of the parameters and results to other study areas, more testing is needed.

The alpha v beta 3 integrin as a tumor homing ligand for lymphocytes.

Despite the presence of tumor-specific effector cells in the circulation of cancer patients, the immune response of the majority of these patients is not sufficient to prevent the growth and spread of their tumors. That tumor cells can be killed in vitro by tumor-reactive cytotoxic T cells is testimony to the fact that the tumors are not inherently resistant to T cell killing, but rather that there is a failure in immune recognition and effector cell activation. Many reasons for this failure of the body's defense system have been suggested, including the inability of tumor-reactive lymphocytes to migrate to tumor tissue. Here we designed a strategy to improve homing of primary lymphocytes into vascularized tumors. As a homing molecule we selected the integrin alpha v beta 3 since it is expressed by angiogenic vascular endothelium in tumors. To promote lymphocyte adhesion to alpha v beta 3 we "painted" primary lymphocytes with a recombinant, glycosylphosphatidylinositol-linked high-affinity ligand for alpha v beta 3. These painted lymphocytes specifically bound to alpha v beta 3 in vitro and homed to vascularized, solid tumors in vivo. This novel strategy may provide a significant advance in anti-tumor treatment such as adoptive immune therapy.

GWT RAD Base : desenvolupament d'un framework JEE.Aplicació pràctica : Registre E/S de la policia local

Aquest treball consta de 2 parts, la primera consisteix en desenvolupar el framework JEE amb arquitectura MVC que he denominat GWT RAD Base (qualsevol altre nom haguésvalgut també), i la segona és una aplicació pràctica de registre de entrada i sortida de la policialocal implementada mitjançant aquest framework.

Flow-R, a model for susceptibility mapping of debris flows and other gravitational hazards at a regional scale: some case studies

Every year, debris flows cause huge damage in mountainous areas. Due to population pressure in hazardous zones, the socio-economic impact is much higher than in the past. Therefore, the development of indicative susceptibility hazard maps is of primary importance, particularly in developing countries. However, the complexity of the phenomenon and the variability of local controlling factors limit the use of processbased models for a first assessment. A debris flow model has been developed for regional susceptibility assessments using digital elevation model (DEM) with a GIS-based approach.. The automatic identification of source areas and the estimation of debris flow spreading, based on GIS tools, provide a substantial basis for a preliminary susceptibility assessment at a regional scale. One of the main advantages of this model is its workability. In fact, everything is open to the user, from the data choice to the selection of the algorithms and their parameters. The Flow-R model was tested in three different contexts: two in Switzerland and one in Pakistan, for indicative susceptibility hazard mapping. It was shown that the quality of the DEM is the most important parameter to obtain reliable results for propagation, but also to identify the potential debris flows sources.

Extracció de coneixement d'una base de dades d'explotació de màquines recreatives i d'atzar.

L'objectiu de treball ha estat mostrar les possibilitats de les aplicacions informàtiques de gestió sobre les dades amb les que treballen. Simplement mostren les dades guardades a les bases de dades d'explotació, de forma detallada o bé resumida i amb sumatoris. Sobre aquestes dades també es pot extreure coneixement.

Implementación y entrenamiento de un modelo clasificatorio de red neural sobre la base de datos IGBADAT para la clasificación de las rocas basálticas de acuerdo a las clases del sistema de clasificación tradicional de Yoder and Tiller.

Aquest treball vol implementar un projecte de mineria de dades en l'àrea de la petrologia ígnia, especialitat englobada dins la geologia clàssica.

A flow cytometry based oligotrophic pollutant exposure test to detect bacterial growth inhibition and cell injury.

Toxicity of chemical pollutants in aquatic environments is often addressed by assays that inquire reproductive inhibition of test microorganisms, such as algae or bacteria. Those tests, however, assess growth of populations as a whole via macroscopic methods such as culture turbidity or colony-forming units. Here we use flow cytometry to interrogate the fate of individual cells in low-density populations of the bacterium Pseudomonas fluorescens SV3 exposed or not under oligotrophic conditions to a number of common pollutants, some of which derive from oil contamination. Cells were stained at regular time intervals during the exposure assay with fluorescent dyes that detect membrane injury (i.e., live-dead assay). Reduction of population growth rates was observed upon toxicant insult and depended on the type of toxicant. Modeling and cell staining indicate that population growth rate decrease is a combined effect of an increased number of injured cells that may or may not multiply, and live cells dividing at normal growth rates. The oligotrophic assay concept presented here could be a useful complement for existing biomarker assays in compliance with new regulations on chemical effect studies or, more specifically, for judging recovery after exposure to fluctuating toxicant conditions.

Cardiac rotation and relaxation after anterolateral myocardial infarction.

BACKGROUND: Both systolic and diastolic dysfunction have been observed in patients with anterolateral myocardial infarction. Diastolic dysfunction is related to disturbances in relaxation and diastolic filling. OBJECTIVE: To analyse cardiac rotation, regional shortening and diastolic relaxation in patients with anterolateral infarction. METHODS: Cardiac rotation and relaxation in controls and patients with chronic anterolateral infarction were assessed by myocardial tagging. Myocardial tagging is based on magnetic resonance imaging and allows us to label specific myocardial regions for imaging cardiac motion (rotation, translation and radial displacement). A rectangular grid was placed on the myocardium (basal, equatorial and apical short-axis plane) of each of 18 patients with chronic anterolateral infarction and 13 controls. Cardiac rotation, change in area and shortening of circumference were determined in each case. RESULTS: The left ventricle in controls performs a systolic wringing motion with a clockwise rotation at the base and a counterclockwise rotation at the apex when viewed from the apex. During relaxation a rotational motion in the opposite direction (namely untwisting) can be observed. In patients with anterolateral infarction, there is less systolic rotation at the apex and diastolic untwisting is delayed and prolonged in comparison with controls. In the presence of a left ventricular aneurysm (n = 4) apical rotation is completely lost. There is less shortening of circumference in infarcted and remote regions. CONCLUSIONS: The wringing motion of the myocardium might be an important mechanism involved in maintaining normal cardiac function with minimal expenditure of energy. This mechanism no longer operates in patients with left ventricular aneurysms and operates significantly less than normal in those with anterolateral hypokinaesia. Diastolic untwisting is significantly delayed and prolonged in patients with anterolateral infarction, which could explain the occurrence of diastolic dysfunction in these patients.

Evolution of life history traits in a natural population of the shrew Crocidura russula

Abstract Life history traits encompass all the decisions concerning fitness an individual is faced with during his life. The study of these traits is crucial to understand the factors shaping the biology of living organisms. Up until now, most of the information on the evolution of life history traits comes from laboratory studies. While these studies are interesting to test the effect of specific parameters, their conclusions are difficult to extrapolate to natural populations. Investigating the evolution of life history traits in natural populations is of great interest. This may be tricky because it requires information on reproduction, survival and morphology of individuals. Mark-recapture methods allow most of this information to be obtained. However, when direct observations of a species are not possible due to its ecology, indirect methods must be used to infer lifetime reproductive success. In this case, molecular markers are particularly helpful in assessing the genetic relationships between individuals and allow the construction of a pedigree. This thesis focuses on a natural population of a small insectivorous mammal, the greater white-toothed shrew, Crocidura russula. Because of its hidden lifestyle, the two complementary techniques mentioned above were combined to gather information on this population. The data were used to explore diverse aspects of evolutionary biology. We demonstrated that the high genetic variance displayed by the species was not maintained by its mating system because this shrew was less monogamous than previously thought. The large genetic diversity was most likely promoted by gene flow from the neighborhood. Dispersal was thus a central topic in this thesis. We showed that dispersal was not driven by inbreeding avoidance. In addition, we did not find any inbreeding depression in the population. Dispersal was promoted by a high number of vacant territories in the population for both sexes, meaning that territory acquisition played an important role in driving dispersal. Moreover, dispersal propensity was shown to have a genetic basis and, once achieved, to have no effect on individual fitness. Body mass was found to be a life history trait strongly influenced by sexual and viability selection in both sexes. Larger individuals had higher access to reproduction through territory acquisition and defense than lighter ones. By contrast, intermediate size individuals were favored by viability selection presumably because of ecological constraints and metabolic costs. Finally, we demonstrated that the majority of the life history traits in our shrew population has the potential to evolve because they maintained substantial amounts of additive genetic variance. Nonetheless, life history traits had no significant heritability due to their high level of nonadditive or environmental variance. Résumé Les traits d'histoire de vie comprennent toutes les décisions auxquelles un individu est confronté au cours de sa vie et qui concernent sa valeur adaptative. L'étude de ces traits est cruciale pour comprendre les facteurs qui façonnent la biologie des êtres vivants. Jusqu'à ce jour, la majorité des informations sur l'évolution des traits d'histoire de vie provient d'études réalisées en laboratoire. Alors que ces études sont intéressantes pour tester l'effet de paramètres spécifiques, leurs conclusions sont difficilement extrapolables aux populations naturelles. Il est particulièrement intéressant d'étudier l'évolution des traits d'histoire de vie dans des populations naturelles. Toutefois, ces études peuvent se révéler difficiles parce qu'elles requièrent des informations sur la reproduction, la survie et la morphologie des individus. Des méthodes de marquage-recapture permettent d'obtenir ces informations. Cependant, lorsque l'écologie de l'espèce rend les obervations directes impossibles, des méthodes indirectes doivent être utilisées pour obtenir le succès reproducteur des individus. Dans ce cas, les marqueurs moléculaires sont particulièrement utiles pour évaluer les relations génétiques entre individus et permettre la construction d'un pedigree. Cette thèse porte sur une population naturelle d'un petit mammifère insectivore, la musaraigne musette, Crocidura russula. Parce que cette espèce présente un mode de vie souterrain, les deux techniques complémentaires mentionnées ci-dessus ont été combinées pour acquérir les informations nécessaires. Les données ont été utilisées pour explorer divers aspects de biologie evolutive. Nous avons montré que la grande quantité de variance génétique trouvée chez cette espèce n'est pas maintenue par son système d'appariement. Celle-ci s'est en effet avérée être moins monogame que ce qui était admis jusqu'ici. Sa grande diversité génétique est plutôt entretenue par le flux de gènes provenant du voisinage. La dispersion a donc été un sujet phare dans cette thèse. Nous avons montré qu'elle n'est pas provoquée par un évitement de la consanguinité et nous n'avons pas trouvé de dépression de consanguité dans notre population. L'acquisition d'un territoire joue par contre un rôle important dans la dispersion. En outre, la dispersion possède une base génétique chez cette espèce. De plus, une fois qu'ils ont dispersé, les individus n'ont pas une valeur adaptative differente d'individus philopatriques. Le poids s'est avéré être un trait d'histoire de vie fortement influencé par la sélection sexuelle et de viabilité chez les deux sexes. Les gros individus ont accès à la reproduction parce qu'ils acquièrent et défendent un territoire plus facilement que les plus légers. Au contraire, les individus de taille intermédiaire sont favorisés par la sélection de viabilité, certainement à cause de contraintes écologiques et de coûts métaboliques. Finalement, nous avons montré que la majorité des traits d'histoire de vie dans notre population a le potentiel d'évoluer parce qu'elle maintient des quantités considérables de variance génétique additive. Néanmoins, l'héritabilité de ces traits d'histoire de vie n'est pas significative à cause de la grande quantité de variance non-additive ou environmentale associée à ces traits.

ADIDAL : Base de dades de música clàssica

El projecte consisteix en el desenvolupament d'una eina que permeti gestionar peces musicals de l'anomenada música culta o clàssica. La informació es pot utilitzar per fer cerques i també per mantenir un registre d'una biblioteca de partitures i una fonoteca.

Construcció d'una base de dades històrica de projectes Informàtics

El tema del treball de final de carrera se centra en el disseny d'una base de dades històrica de projectes informàtics, concretament especialitzada en projectes informàtics relacionats amb el disseny, la construcció i la posada en marxa i el posterior manteniment de programari.

The sample processing time interval as an influential factor in flow cytometry analysis of lymphocyte subsets

The objective of this paper is to propose a protocol to analyze blood samples in yellow fever 17DD vaccinated which developed serious adverse events. We investigated whether or not the time between sample collection and sample processing could interfere in lymphocyte subset percentage, for it is often impossible to analyze blood samples immediately after collection due to transport delay from collection places to the flow cytometry facility. CD4+CD38+ T, CD8+CD38+ T, CD3+ T, CD19+ B lymphocyte subsets were analyzed by flow cytometry in nine healthy volunteers immediately after blood collection and after intervals of 24 and 48 h. The whole blood lysis method and gradient sedimentation by Histopaque were applied to isolate peripheral blood mononuclear cells for flow cytometry analyses. With the lysis method, there was no significant change in lymphocyte subset percentage between the two time intervals (24 and 48 h). In contrast, when blood samples were processed by Histopaque gradient sedimentation, time intervals for sample processing influenced the percentage in T lymphocyte subsets but not in B cells. From the results obtained, we could conclude that the whole blood lysis method is more appropriate than gradient sedimentation by Histopaque for immunophenotyping of blood samples collected after serious adverse events, due to less variation in the lymphocyte subset levels with respect to the time factor.

Disseny i implementació d'una base de dades relacional per a la gestió d'incidències de productes

El projecte suposa el disseny i construcció de diferents parts: anàlisi dels requeriments de l'empresa, el disseny de les taules de la base de dades, definició dels índexs de les taules, disseny i implementació dels procediments emmagatzemats de la base de dades. Aquests procediments emmagatzemats seran l'única forma d'entrada o sortida de la base de dades ocultant així els detalls més pesats relatius a l'estructura interna de la base de dades creada, d'aquesta manera, les consultes de les dades podran ser realitzades per part d'usuaris que no tenen coneixements específics sobre bases de dades.

Disseny i implementació d'una base de dades relacional per a la gestió d'incidències de productes

Treball Final de Grau l'objectiu del qual és proporcionar les eines de programari necessàries, implementades com procediments emmagatzemats, per a poder realitzar totes les tasques relacionades amb les incidències d'un servei post venta.