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.

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.

Selective three-dimensional visualization of the coronary arterial lumen using arterial spin tagging.

Conventional coronary magnetic resonance angiography (MRA) techniques display the coronary blood-pool along with the surrounding structures, including the myocardium, the ventricular and atrial blood-pool, and the great vessels. This representation of the coronary lumen is not directly analogous to the information provided by x-ray coronary angiography, in which the coronary lumen displayed by iodinated contrast agent is seen. Analogous "luminographic" data may be obtained using MR arterial spin tagging (projection coronary MRA) techniques. Such an approach was implemented using a 2D selective "pencil" excitation for aortic spin tagging in concert with a 3D interleaved segmented spiral imaging sequence with free-breathing, and real-time navigator technology. This technique allows for selective 3D visualization of the coronary lumen blood-pool, while signal from the surrounding structures is suppressed.

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.

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.

Comparing methods for dimensionality reduction when data are density functions

Functional Data Analysis (FDA) deals with samples where a whole function is observedfor each individual. A particular case of FDA is when the observed functions are densityfunctions, that are also an example of infinite dimensional compositional data. In thiswork we compare several methods for dimensionality reduction for this particular typeof data: functional principal components analysis (PCA) with or without a previousdata transformation and multidimensional scaling (MDS) for diferent inter-densitiesdistances, one of them taking into account the compositional nature of density functions. The difeerent methods are applied to both artificial and real data (householdsincome distributions)

Validation of the spanish version of the multiple sclerosis international quality of life (musiqol) questionnaire

BACKGROUND: The Multiple Sclerosis International Quality Of Life (MusiQoL) questionnaire, a 31-item, multidimensional, self-administrated questionnaire that is available in 14 languages including Spanish, has been validated using a large international sample. We investigated the validity and reliability of the Spanish version of MusiQoL in Spain. METHODS: Consecutive patients with different types and severities of multiple sclerosis (MS) were recruited from 22 centres across Spain. All patients completed the MusiQoL questionnaire, the 36-Item Short Form (SF-36) health survey, and a symptoms checklist at baseline and 21 days later. External validity, internal consistency, reliability and reproducibility were tested. RESULTS: A total of 224 Spanish patients were evaluated. Dimensions of MusiQoL generally demonstrated a high internal consistency (Cronbach's alpha: 0.70-0.92 for all but two MusiQoL domain scores). External validity testing revealed that the MusiQoL index score correlated significantly with all SF-36 dimension scores (Pearson's correlation: 0.46-0.76), reproducibility was satisfactory (intraclass correlation coefficient: 0.60-0.91), acceptability was high, and the time taken to complete the 31-item questionnaire was reasonable (mean [standard deviation]: 9.8 [11.8] minutes). CONCLUSIONS: The Spanish version of the MusiQoL questionnaire appears to be a valid and reliable instrument for measuring quality of life in patients with MS in Spain and constitutes a useful instrument to measure health-related quality of life in the clinical setting.

An iterative Multiscale Finite-Volume algorithm converging to the exact solution

The multiscale finite volume (MsFV) method has been developed to efficiently solve large heterogeneous problems (elliptic or parabolic); it is usually employed for pressure equations and delivers conservative flux fields to be used in transport problems. The method essentially relies on the hypothesis that the (fine-scale) problem can be reasonably described by a set of local solutions coupled by a conservative global (coarse-scale) problem. In most cases, the boundary conditions assigned for the local problems are satisfactory and the approximate conservative fluxes provided by the method are accurate. In numerically challenging cases, however, a more accurate localization is required to obtain a good approximation of the fine-scale solution. In this paper we develop a procedure to iteratively improve the boundary conditions of the local problems. The algorithm relies on the data structure of the MsFV method and employs a Krylov-subspace projection method to obtain an unconditionally stable scheme and accelerate convergence. Two variants are considered: in the first, only the MsFV operator is used; in the second, the MsFV operator is combined in a two-step method with an operator derived from the problem solved to construct the conservative flux field. The resulting iterative MsFV algorithms allow arbitrary reduction of the solution error without compromising the construction of a conservative flux field, which is guaranteed at any iteration. Since it converges to the exact solution, the method can be regarded as a linear solver. In this context, the schemes proposed here can be viewed as preconditioned versions of the Generalized Minimal Residual method (GMRES), with a very peculiar characteristic that the residual on the coarse grid is zero at any iteration (thus conservative fluxes can be obtained).

Analyzing shapes as compositions of distances

We propose to analyze shapes as “compositions” of distances in Aitchison geometry asan alternate and complementary tool to classical shape analysis, especially when sizeis non-informative.Shapes are typically described by the location of user-chosen landmarks. Howeverthe shape – considered as invariant under scaling, translation, mirroring and rotation– does not uniquely define the location of landmarks. A simple approach is to usedistances of landmarks instead of the locations of landmarks them self. Distances arepositive numbers defined up to joint scaling, a mathematical structure quite similar tocompositions. The shape fixes only ratios of distances. Perturbations correspond torelative changes of the size of subshapes and of aspect ratios. The power transformincreases the expression of the shape by increasing distance ratios. In analogy to thesubcompositional consistency, results should not depend too much on the choice ofdistances, because different subsets of the pairwise distances of landmarks uniquelydefine the shape.Various compositional analysis tools can be applied to sets of distances directly or afterminor modifications concerning the singularity of the covariance matrix and yield resultswith direct interpretations in terms of shape changes. The remaining problem isthat not all sets of distances correspond to a valid shape. Nevertheless interpolated orpredicted shapes can be backtransformated by multidimensional scaling (when all pairwisedistances are used) or free geodetic adjustment (when sufficiently many distancesare used)

Helical tomotherapy (HT) for the treatment of anal canal cancer: preliminary clinical results, and dosimetric comparison between HT and intensity-modulated or 3D conformal radiotherapy

Background: To report a single-center experience in 19 patients (pts) with anal canal cancer treated with helical tomotherapy (HT) and concurrent chemotherapy, and compare the dosimetric results with fixed-field intensitymodulated radiotherapy (IMRT) and 3D conformal radiotherapy (3D RT). Materials and Methods: Between 2007 and 2008, 19 consecutive pts were treated with HT and concurrent CT for anal canal cancer. Median age was 59 years (range, 38−83), and female/male ratio was 14/5. The majority of the pts had T2 or T3 tumours (68.4%), and 52.6% had positive lymph nodes. In all 19 pts, pelvic and inguinal nodes, and tumour irradiation was given using HT upto a median dose of 36 Gy (1.8 Gy/fr) followed by a 1-week gap. A boost dose of 23.4 Gy (1.8 Gy/fr) was delivered to the tumour and involved nodes using 3DRT (n = 12), HT (n = 6), or IMRT (n = 1). Simultaneous integrated boost was used in none of the pts. All but one patient with a T1N0 tumour received concomitant mitomycin/5- fluorouracil (n = 12) or mitomycin/capecitabin (n = 7) CT. Toxicity was scored according to the Common Terminology Criteria for Adverse Events (NCICTCAE v3.0). HT plans and treatments were generated using Tomotherapy, Inc., software and hardware; and 3D or IMRT boost plans with the CMS treatment planning system (TPS), using 6−18 MV photons from a Siemens Primus accelerator. For dosimetric comparison, computed tomography data sets of 10 pts were imported into the TPS, and 3D and 5-field step-andshoot IMRT plans were generated for each case. Plans were optimized with the aim of assessing organs at risk (OAR) and healthy-tissue sparing while enforcing highly conformal target coverage, and evaluated by dose-volume histograms (DVH) of planning target volumes (PTV) and OAR. Results: With a median follow-up of 13 months (range, 3−18), all pts are alive and well; except one patient developing local recurrence at 12 months. No patient developed grade 3 or more acute toxicity. No unplanned treatment interruption was necessary because of toxicity. With 360-degree-of-freedom beam projection, HT showed an advantage over 3D or IMRT plans in terms of dose conformity around the PTV, and dose gradients were steeper outside the PTV, resulting in reduced doses to OARs. Using HT, acute toxicity was acceptable, and seemed to be better than historical standards. Conclusion: We conclude that HT combined with concurrent chemotherapy for anal canal cancer is effective and tolerable. Compared to 3DRT or 5-field IMRT, there is better conformity around the PTV, and OAR sparing.