Construcción y explotación de un almacén de datos para el análisis de información inmobiliaria

El objetivo de este Trabajo Final de Carrera (TFC) es consolidar los conocimientos adquiridos a lo largo de nuestros estudios de Ingeniería Técnica en Informática de Sistemas. Es un documento que contiene el enunciado de un problema del mundo real, que se describe, desgrana, analiza, etc, y que al final se detalla la solución técnica final escogida. Este Trabajo Final de Carrera, a partir de ahora TFC, está enmarcado dentro del área de Almacenes de Datos, utilizando el siguiente software: ORACLE EXPRESS v10.2.0.1 y SQL DEVELOPER. La empresa inmobiliaria Un Techo para Todos, tiene un catalogo de inmuebles de España y Andorra. Necesitan un sistema de información que le permita comparar diferentes zonas, tipos de pisos y precios, para intentar ser más eficientes ajustando la oferta y la demanda, y por consiguiente obteniendo mayores beneficios. El principal problema que nos plantean es que aunque disponen de mucha información, esta no la tienen integrada en un sistema informático optimo( lo tienen en unas hojas de Excel), por lo que no pueden sacarle el rendimiento adecuado.

Construcció i explotació d'un magatzem de dades per a l'anàlisi d'informació immobiliària

Aquest treball consisteix en crear un projecte de magatzem de dades per a una empresa immobiliària. La primera etapa de la creació del magatzem consisteix en la definició del projecte, cosa que implica determinar els seus objectius i el seu abast i detallar la planificació del projecte. La segona fase consisteix en realitzar tot el seu disseny el més acuradament possible. En la tercera fase s'implementa el disseny anterior i es construeix el magatzem de dades, i també es creen els informes demanats per l'empresa mitjançant eines de Business Intelligence. Com a resultat final, s'haurà construït una base de dades en forma de cub multidimensional (data warehouse) amb les dades de tots els immobles que gestiona o ha gestionat l'empresa.

Arctic warming will promote Atlantic-Pacific fish interchange

Throughout much of the Quaternary Period, inhospitable environmental conditions above the Arctic Circle have been a formidable barrier separating most marine organisms in the North Atlantic from those in the North Pacific(1,2). Rapid warming has begun to lift this barrier(3), potentially facilitating the interchange of marine biota between the two seas(4). Here, we forecast the potential northward progression of 515 fish species following climate change, and report the rate of potential species interchange between the Atlantic and the Pacific via the Northwest Passage and the Northeast Passage. For this, we projected niche-based models under climate change scenarios and simulated the spread of species through the passages when climatic conditions became suitable. Results reveal a complex range of responses during this century, and accelerated interchange after 2050. By 2100 up to 41 species could enter the Pacific and 44 species could enter the Atlantic, via one or both passages. Consistent with historical and recent biodiversity interchanges(5,6), this exchange of fish species may trigger changes for biodiversity and food webs in the North Atlantic and North Pacific, with ecological and economic consequences to ecosystems that at present contribute 39% to global marine fish landings.

Polymédication et personne agée: ni trop ni trop peu [Polypharmacy and the elderly: neither too much nor too little].

Elderly persons are at high risk of polypharmacy. Polypharmacy has been associated with numerous adverse outcomes, such as poorer quality of life, higher morbidity and mortality. However, deciding to stop or to continue a treatment is a difficult task, which confronts the physician to complex clinical and ethical choices. Such a decision requires a geriatric multidimensional assessment of the patient, an estimation of his or her prognosis, the definition of the goals of care and a careful assessment of the time to benefit of each drug. Diverse methods and tools to support the physician in this process are discussed in this article. However these can not replace a reflexive approach of the physician that integrates the values and representations of the patient with regard to his or her health and end of life, as well as his or her needs, fears and choices.

National Alcohol Policy Ireland

The National Alcohol Policy is directed at reducing the prevalence of alcohol-related problems through an emphasis on moderation in alcohol consumption. The importance of a comprehensive alcohol policy was highlighted when Ireland endorsed the European Charter on Alcohol in December 1995 along with 48 other Member States of the WHO European Region. The alcohol-related problems are multidimensional, therefore the solutions most be multi-sectoral. This means that commitment to the National Alcohol Policy must be on the agenda of policy makers in all sectors and at all levels. An Alcohol Policy requires both environmental and individual strategies. There is strong evidence that policies which influence access to alcohol, control pricing through taxation and other public health measures, can have a positive impact on curtailing the health and social burden resulting from drinking (Edwards et al. 1994). However, a key to the effectiveness of such strategies is public support, enforcement and maintenance of the policies. In examining the rationale for a National Alcohol Policy a number of elements have been identified. Research is urgently required to identify attitudes and patterns of alcohol consumption across the population and within sub-groups of the population. Based on sound research, a sensible drinking message of Less is Better should form an educational empowerment programme with regional and local initiatives as a required and integral part of such a campaign. A health education programme in all schools should be part of the core curriculum. The availability and effectiveness of treatment services need to be established. Action to contain the availability of alcohol could be achieved by reducing the number of special exemptions for longer opening hours and controlling access to underage drinking by ID schemes nation-wide. The enforcement of drink driving legislation including random breath testing needs to be continued to reduce alcohol-related traffic accidents. All levels of the Drinks Industry should recognise that people have the right to be safeguarded from pressures to drink. Finally, a National Alcohol Policy could be co-ordinated by a wider National Substance Use Surveillance Unit.This resource was contributed by The National Documentation Centre on Drug Use.

Pluralized life courses? An exploration of the life trajectories of individuals with psychiatric disorders.

BACKGROUND: : Most of the existing research relating to the life courses of people with psychiatric symptoms focuses on the occurrence and the impact of non-normative events on the onsets of crises; it usually disregards the more regular dimensions of life, such as work, family and intimate partnerships that may be related to the timing and seriousness of psychiatric problems. An additional reason for empirically addressing life trajectories of individuals with psychiatric problems relates to recent changes of family and occupational trajectories in relation to societal trends such as individualization and pluralization of life courses.¦AIM: : This paper explores the life trajectories of 86 individuals under clinical supervision and proposes a typology of their occupational, co-residence and intimacy trajectories. The results are discussed in light of the life-course paradigm.¦METHOD: : A multidimensional optimal matching analysis was performed on a sample of 86 individuals under clinical supervision to create a typology of trajectories. The influence of these trajectories on psychiatric disorders, evaluated using a SCL-90-R questionnaire, was then assessed using linear regression modelling.¦RESULTS: : The typologies of trajectories showed that the patients developed a diversity of life trajectories. Individuals who have developed a standard life course with few institutionalization periods reported more symptoms and distress than individuals with an institutionalized life trajectory.¦CONCLUSION: : The results of this study stress that psychiatric patients are social actors who are influenced by society at large and its ongoing process of change. Therefore, it is essential to take into account the diversity of occupational and family trajectories when dealing with individuals in therapeutic settings.

Variability and genetic differentiation among Anopheles (Ano.) intermedius Chagas, 1908 and Anopheles (Ano.) mattogrossensis Lutz & Neiva, 1911 (Diptera: Culicidae) from the Brazilian Amazon

Anopheles (Anopheles) intermedius and Anopheles (Ano.) mattogrossensis are Brazilian anopheline species belonging to the scarcely studied Anopheles subgenus. Few studies have been done on the genetic differentiation of these species. Both species have been found infected by Plasmodium and are sympatric with other anopheline species from the Nyssorhynchus subgenus. Eighteen enzymatic loci were analyzed in larval specimens of An. intermedius and An. mattogrossensis aiming to estimate the variability and genetic differentiation between these species. An. mattogrossensis population showed higher genetic variability (P = 44.4 and Ho = 0.081 ± 0.031) than that of An. intermedius (P = 33.3 and Ho = 0.048 ± 0.021). Most analyzed loci showed genotypic frequencies according to Hardy-Weinberg equilibrium, except for LAP1 and LAP2 in An. intermedius, and EST1 and PGM loci in An. mattogrossensis. The genetic distance between these species (D = 0.683) was consistent with the inter-specific values reported for Anopheles subgenus. We verified that the polymorphism and heterozygosity percentile values found in both species and compared to those in the literature, showed no relation between the level of isozyme variability and geographical distribution. The low variability found in these two species is probably more related to the niche they occupy than to their geographic distribution.

Multiple refugia and barriers explain the phylogeography of the Valais shrew, Sorex antinorii (Mammalia: Soricomorpha), Sorex antinorii (Mammalia: Soricomorpha)

The aim of the present study was to investigate the genetic structure of the Valais shrew (Sorex antinorii) by a combined phylogeographical and landscape genetic approach, and thereby to infer the locations of glacial refugia and establish the influence of geographical barriers. We sequenced part of the mitochondrial cytochrome b (cyt b) gene of 179 individuals of S. antinorii sampled across the entire species' range. Six specimens attributed to S. arunchi were included in the analysis. The phylogeographical pattern was assessed by Bayesian molecular phylogenetic reconstruction, population genetic analyses, and a species distribution modelling (SDM)-based hindcasting approach. We also used landscape genetics (including isolation-by-resistance) to infer the determinants of current intra-specific genetic structure. The phylogeographical analysis revealed shallow divergence among haplotypes and no clear substructure within S. antinorii. The starlike structure of the median-joining network is consistent with population expansion from a single refugium, probably located in the Apennines. Long branches observed on the same network also suggest that another refugium may have existed in the north-eastern part of Italy. This result is consistent with SDM, which also suggests several habitable areas for S. antinorii in the Italian peninsula during the LGM. Therefore S. antinorii appears to have occupied disconnected glacial refugia in the Italian peninsula, supporting previous data for other species showing multiple refugia within southern refugial areas. By coupling genetic analyses and SDM, we were able to infer how past climatic suitability contributed to genetic divergence of populations. The genetic differentiation shown in the present study does not support the specific status of S. arunchi.

Intermediate and definitive hosts of Schistosoma mansoni in Corrientes province, Argentina

Corrientes province is located in the humid subtropical region of Argentina northeast on the left riverbank of Paraná River in the border with the South of Brazil. This is a region without schistosomiasis but planorbid and rodents that would serve as host of the life cycle of Schistosoma mansoni inhabit here. The objective of this work is to know the role of rodent as definitive host of schistosomiasis. Biomphalaria tenagophila (4 to 8 mm Ø) from Maloyas, exposed each to 10 miracidia of SJ2 strain of S. mansoni natives from Brazil were susceptible (5%). The degree of compatibility was Class II of Frandsen. Five wild rodents captured in the same ecological niche were exposed transcutaneously to infection with 40 cercariae for animal: two Olygoryzomys flavescens, two Holochilus braziliensis, and one Scapteromys tuncidus. Only one H. braziliensis eliminated eggs in feces. Prepatent period was of 83 days. With these feces, two of six (33.3%) B. tenagophila from Maloyas were infected with miracidium. It was demonstrated, in an area free of schistosomiasis, that life cycle S. mansoni is closed with planorbid and rodents that live in the same ecological niche.

TFC Magatzems de dades: construcció i explotació d'un magatzem de dades de planificació hidrològica

Aquest TFC consisteix en la creació d'un magatzem de dades que automatitzi la recollida de dades de l'estat dels embassaments de la Confederació Hidrogràfica Nord-Est mitjançant processos ETL, per posteriorment tractar aquestes dades amb processos PL/SQL amb l'objectiu de poder explotar aquestes dades mitjançant eines de Business Intelligence.

Construcció i explotació d'un magatzem de dades de planificació hidrològica

Memòria del treball de fi de carrera on s'ha construït i explotat un magatzem de dades, partint d'unes dades en un sistema OLTP a un sistema multidimensional OLAP, tot això sobre amb les eines Oracle Express Edition 10v i Oracle Discoverer.

An ecoregional classification for the state of Roraima, Brazil: the importance of landscape in malaria biology

Understanding the different background landscapes in which malaria transmission occurs is fundamental to understanding malaria epidemiology and to designing effective local malaria control programs. Geology, geomorphology, vegetation, climate, land use, and anopheline distribution were used as a basis for an ecological classification of the state of Roraima, Brazil, in the northern Amazon Basin, focused on the natural history of malaria and transmission. We used unsupervised maximum likelihood classification, principal components analysis, and weighted overlay with equal contribution analyses to fine-scale thematic maps that resulted in clustered regions. We used ecological niche modeling techniques to develop a fine-scale picture of malaria vector distributions in the state. Eight ecoregions were identified and malaria-related aspects are discussed based on this classification, including 5 types of dense tropical rain forest and 3 types of savannah. Ecoregions formed by dense tropical rain forest were named as montane (ecoregion I), submontane (II), plateau (III), lowland (IV), and alluvial (V). Ecoregions formed by savannah were divided into steppe (VI, campos de Roraima), savannah (VII, cerrado), and wetland (VIII, campinarana). Such ecoregional mappings are important tools in integrated malaria control programs that aim to identify specific characteristics of malaria transmission, classify transmission risk, and define priority areas and appropriate interventions. For some areas, extension of these approaches to still-finer resolutions will provide an improved picture of malaria transmission patterns.

Construcción y explotación de un almacén de datos de información cinematográfica

Este proyecto tiene como finalidad el diseño, el desarrollo y la puesta en marcha de un almacén de datos destinado, tanto al almacenamiento de la información que nuestro cliente la Academia de Cine Andorrana dispone de los diferentes premios de los Festivales cinematográficos más importantes, como al análisis y la explotación de los datos. El proyecto parte del conjunto de documentos en formato Microsoft Excel que la Academia de Cine Andorrana utiliza como repositorio de información cinematográfica, los cuales tras un proceso de análisis y diseño darán lugar a modelo conceptual, lógico y físico de un cubo multidimensional de procesamiento Analítico Relacional o ROLAP en esquema de copo de nieve. Así mismo, el proyecto incluye el diseño y desarrollo de los procesos necesarios de extracción, transformación y carga (ETL) de las fuentes operacionales de información, previamente exportadas a formato CSV, sobre la base de datos multidimensional. Por último, el proyecto contempla la construcción de un área de negocio que sirve como base y entorno de trabajo para el desarrollo de los informes de extracción y explotación de los datos requeridos por la Academia de Cine Andorrana.

Adolescent substance-use assessment: methodological issues in the use of the ADAD (Adolescent Drug Abuse Diagnosis).

During the past twenty years, various instruments have been developed for the assessment of substance use in adolescents, mainly in the United States. However, few of them have been adapted to, and validated in, French-speaking populations. Consequently, although increasing alcohol and drug use among teenagers has become a major concern, the various health and social programs developed in response to this specific problem have received little attention with regard to follow-up and outcome assessment. A standardized multidimensional assessment instrument adapted for adolescents is needed to assess the individual needs of adolescents and assign them to the most appropriate treatment setting, to provide a single measurement within and across health and social systems, and to conduct treatment outcome evaluations. Moreover, having an available instrument makes it possible to develop longitudinal and trans-cultural research studies. For this reason, a French version of the Adolescent Drug Abuse Diagnosis (ADAD) was developed and validated at the University Child and Adolescent Psychiatric Clinic in Lausanne, Switzerland. This paper aims to discuss the methodological issues that we faced when using the ADAD instrument in a 4-year longitudinal study including adolescent substance users. Methodological aspects relating to the content and format of the instrument, the assessment administration and the statistical analyses are discussed.

Modelling habitat-suitability using museum collections: an example with three sympatric Apodemus species from the Alps

Aim, Location Although the alpine mouse Apodemus alpicola has been given species status since 1989, no distribution map has ever been constructed for this endemic alpine rodent in Switzerland. Based on redetermined museum material and using the Ecological-Niche Factor Analysis (ENFA), habitat-suitability maps were computed for A. alpicola, and also for the co-occurring A. flavicollis and A. sylvaticus. Methods In the particular case of habitat suitability models, classical approaches (GLMs, GAMs, discriminant analysis, etc.) generally require presence and absence data. The presence records provided by museums can clearly give useful information about species distribution and ecology and have already been used for knowledge-based mapping. In this paper, we apply the ENFA which requires only presence data, to build a habitat-suitability map of three species of Apodemus on the basis of museum skull collections. Results Interspecific niche comparisons showed that A. alpicola is very specialized concerning habitat selection, meaning that its habitat differs unequivocally from the average conditions in Switzerland, while both A. flavicollis and A. sylvaticus could be considered as 'generalists' in the study area. Main conclusions Although an adequate sampling design is the best way to collect ecological data for predictive modelling, this is a time and money consuming process and there are cases where time is simply not available, as for instance with endangered species conservation. On the other hand, museums, herbariums and other similar institutions are treasuring huge presence data sets. By applying the ENFA to such data it is possible to rapidly construct a habitat suitability model. The ENFA method not only provides two key measurements regarding the niche of a species (i.e. marginality and specialization), but also has ecological meaning, and allows the scientist to compare directly the niches of different species.