Data warehouse e cruscotto direzionale per l'analisi del personale in un'azienda di servizi

Obiettivo della tesi è la progettazione e lo sviluppo di un sistema di BI e di relativa reportistica per un'azienda di servizi. Il tutto realizzato mediante la suite Microsoft Business Intelligence.

Progettazione ed implementazione di un data warehouse di supporto alla profilazione dei consumi energetici domestici

Sviluppo e analisi di un dataset campione, composto da circa 3 mln di entry ed estratto da un data warehouse di informazioni riguardanti il consumo energetico di diverse smart home.

Progettazione di Data Warehouse di dati genomici su piattaforma Hadoop

Negli ultimi anni la biologia ha fatto ricorso in misura sempre maggiore all’informatica per affrontare analisi complesse che prevedono l’utilizzo di grandi quantità di dati. Fra le scienze biologiche che prevedono l’elaborazione di una mole di dati notevole c’è la genomica, una branca della biologia molecolare che si occupa dello studio di struttura, contenuto, funzione ed evoluzione del genoma degli organismi viventi. I sistemi di data warehouse sono una tecnologia informatica che ben si adatta a supportare determinati tipi di analisi in ambito genomico perché consentono di effettuare analisi esplorative e dinamiche, analisi che si rivelano utili quando si vogliono ricavare informazioni di sintesi a partire da una grande quantità di dati e quando si vogliono esplorare prospettive e livelli di dettaglio diversi. Il lavoro di tesi si colloca all’interno di un progetto più ampio riguardante la progettazione di un data warehouse in ambito genomico. Le analisi effettuate hanno portato alla scoperta di dipendenze funzionali e di conseguenza alla definizione di una gerarchia nei dati. Attraverso l’inserimento di tale gerarchia in un modello multidimensionale relativo ai dati genomici sarà possibile ampliare il raggio delle analisi da poter eseguire sul data warehouse introducendo un contenuto informativo ulteriore riguardante le caratteristiche dei pazienti. I passi effettuati in questo lavoro di tesi sono stati prima di tutto il caricamento e filtraggio dei dati. Il fulcro del lavoro di tesi è stata l’implementazione di un algoritmo per la scoperta di dipendenze funzionali con lo scopo di ricavare dai dati una gerarchia. Nell’ultima fase del lavoro di tesi si è inserita la gerarchia ricavata all’interno di un modello multidimensionale preesistente. L’intero lavoro di tesi è stato svolto attraverso l’utilizzo di Apache Spark e Apache Hadoop.

Oral mucosal findings related to tobacco use and alcohol consumption: a study on Swiss army recruits involving self-reported and clinical data

PURPOSE: The aim of the present study was to assess the oral mucosal health status of young male adults (aged 18 to 24 years) in Switzerland and to correlate their clinical findings with self-reported risk factors such as tobacco use and alcohol consumption. MATERIALS AND METHODS: Data on the oral health status of 615 Swiss Army recruits were collected using a standardised self-reported questionnaire, followed by an intraoral examination. Positive clinical findings were classified as (1) common conditions and anatomical variants, (2) reactive lesions, (3) benign tumour lesions and (4) premalignant lesions. The main locations of the oral mucosal findings were recorded on a topographical classification chart. Using correlational statistics, the findings were further associated with the known risk factors such as tobacco use and alcohol consumption. RESULTS: A total of 468 findings were diagnosed in 327 (53.17%) of the 615 subjects. In total, 445 findings (95.09%) were classified as common conditions, anatomical variants and reactive soft-tissue lesions. In the group of reactive soft-tissue lesions, there was a significantly higher percentage of smokers (P < 0.001) and subjects with a combination of smoking and alcohol consumption (P < 0.001). Eight lesions were clinically diagnosed as oral leukoplakias associated with smokeless tobacco. The prevalence of precursor lesions in the population examined was over 1%. CONCLUSIONS: Among young male adults in Switzerland, a significant number of oral mucosal lesions can be identified, which strongly correlate with tobacco use. To improve primary and secondary prevention, young adults should therefore be informed more extensively about the negative effects of tobacco use on oral health.

Patients' awareness of the potential benefit of smoking cessation. A study evaluating self-reported and clinical data from patients referred to an oral medicine unit

The present study analyzed history of smoking and willingness to quit smoking in patients referred for diagnosis and treatment of different oral mucosal lesions. Prior to the initial clinical examination, patients filled in a standardized questionnaire regarding their current and former smoking habits and willingness to quit. Definitive diagnoses were classified into three groups (benign/reactive lesions, premalignant lesions and conditions, and malignant diseases) and correlated with the self-reported data in the questionnaires. Of the 980 patients included, 514 (52%) described themselves as never smokers, 202 (21%) as former smokers, and 264 (27%) as current smokers. In the group of current smokers, 23% thought their premalignant lesions/conditions were related to their smoking habit, but only 15% of the patients with malignant mucosal diseases saw that correlation. Only 14% of the smokers wanted to commence smoking cessation within the next 30 days. Patients with malignant diseases (31%) showed greater willingness to quit than patients diagnosed with benign/reactive lesions (11%). Future clinical studies should attempt (1) to enhance patients' awareness of the negative impact of smoking on the oral mucosa and (2) to increase willingness to quit in smokers referred to a dental/oral medicine setting.

Acinetobacter baumannii isolates from pets and horses in Switzerland: molecular characterization and clinical data

OBJECTIVES: We investigated whether Acinetobacter baumannii isolates of veterinary origin shared common molecular characteristics with those described in humans. METHODS: Nineteen A. baumannii isolates collected in pets and horses were analysed. Clonality was studied using repetitive extragenic palindromic PCR (rep-PCR) and multilocus sequence typing (MLST). PCR and DNA sequencing for various beta-lactamase, aminoglycoside-modifying enzyme, gyrA and parC, ISAba1 and IS1133, adeR and adeS of the AdeABC efflux pump, carO porin and class 1/2/3 integron genes were performed. RESULTS: Two main clones [A (n = 8) and B (n = 9)] were observed by rep-PCR. MLST indicated that clone A contained isolates of sequence type (ST) ST12 (international clone II) and clone B contained isolates of ST15 (international clone I). Two isolates of ST10 and ST20 were also noted. Seventeen isolates were resistant to gentamicin, 12 to ciprofloxacin and 3 to carbapenems. Isolates of ST12 carried bla(OXA-66), bla(ADC-25), bla(TEM-1), aacC2 and IS1133. Strains of ST15 possessed bla(OXA-69), bla(ADC-11), bla(TEM-1) and a class 1 integron carrying aacC1 and aadA1. ISAba1 was found upstream of bla(ADC) (one ST10 and one ST12) and/or bla(OXA-66) (seven ST12). Twelve isolates of different STs contained the substitutions Ser83Leu in GyrA and Ser80Leu or Glu84Lys in ParC. Significant disruptions of CarO porin and overexpressed efflux pumps were not observed. The majority of infections were hospital acquired and in animals with predisposing conditions for infection. CONCLUSIONS: STs and the molecular background of resistance observed in our collection have been frequently described in A. baumannii detected in human patients. Animals should be considered as a potential reservoir of multidrug-resistant A. baumannii.

[Survival, clinical data and quality of life 10 years after heart transplantation: a prospective study]

AIM: To study prospectively patients after heart transplantation with respect to quality of life, mortality, morbidity, and clinical parameters before and up to 10 years after the operation. METHODS: Sixty patients (47.9 +/- 10.9 years, 57 men, 3 women) were transplanted at the University of Vienna Hospital, Department for Heart and Thorax Surgery and were included in this study. They were assessed when set on the waiting list, then exactly one, 5 and 10 years after the transplantation. The variables evaluated included physical and emotional complaints, well-being, mortality and morbidity. In the sample of patients who survived 10 years (n = 23), morbidity (infections, malignancies, graft arteriosclerosis, and rejection episodes) as well as quality of life were evaluated. RESULTS: Actuarial survival rates were 83.3, 66.7, 48.3% at 1, 5, and 10 years after transplantation, respectively. During the first year, infections were the most important reasons for premature death. As a cause of mortality, malignancies were found between years 1 and 5, and graft arteriosclerosis between years 5 and 10. Physical complaints diminished significantly after the operation, but grew significantly during the period from 5 to 10 years (p < 0.001). However, trembling (p < 0.05) and paraesthesies (p < 0.01) diminished continuously. Emotional complaints such as depression and dysphoria (both p < 0.05) increased until the tenth year after their nadir at year 1. In long-time survivors, 3 malignancies (lung, skin, thyroidea) were diagnosed 6 to 9 years postoperatively. Three patients (13%) had signs of graft arteriosclerosis at year 10; 9 (40%) patients suffered from rejection episodes during the course of 10 years. There were no serious rejection episodes deserving immediate therapy. Quality of life at 10 years is good in these patients. CONCLUSIONS: Heart transplantation is a successful therapy for patients with terminal heart disease. Long-term survivors feel well after 10 years and report a good quality of life.

Prevalence of halitosis in the population of the city of Bern, Switzerland: a study comparing self-reported and clinical data

Epidemiological data on halitosis are rare. In this study we evaluated the prevalence of halitosis in the population of the city of Bern, Switzerland, using a standardized questionnaire and clinical examination. First of all, a standardized questionnaire was filled out by all 419 participants. In the clinical examination, 'objective' values for halitosis were gathered through two different organoleptic assessments and by the measurement of volatile sulfur compounds (VSC). Additionally, tongue coating and the modified periodontal screening index (PSI) were evaluated for each participant. The questionnaire revealed that 32% of all subjects sometimes or often experienced halitosis. The organoleptic evaluation (grade 0-5) identified 48 persons with grade 3 and higher. Measurement of VSC identified 117 subjects (28%) with readings of >or= 75 parts per billion (ppb). Tongue coating, modified PSI, and smoking were significantly associated with higher organoleptic scores, and tongue coating and smoking were associated with higher VSC values. For about one-third of the Bernese city population, halitosis seems to pose an oral health problem. Only a weak correlation between self-reported halitosis and either organoleptic or VSC measurements could be detected.

Prevalence of halitosis in young male adults: a study in swiss army recruits comparing self-reported and clinical data

BACKGROUND: Sound epidemiologic data on halitosis are rare. We evaluated the prevalence of halitosis in a young male adult population in Switzerland using a standardized questionnaire and clinical examination. METHODS: Six hundred twenty-six Swiss Army recruits aged 18 to 25 years (mean: 20.3 years) were selected as study subjects. First, a standardized questionnaire focusing on dental hygiene, self-reported halitosis, smoking, and alcohol consumption was filled out by all participants. In the clinical examination, objective values for the presence of halitosis were gathered through an organoleptic assessment of the breath odor and the measurement of volatile sulfur compounds (VSCs). Additionally, tongue coating, plaque index, and probing depths were evaluated for each recruit. RESULTS: The questionnaire revealed that only 17% of all included recruits had never experienced halitosis. The organoleptic evaluation (grades 0 to 3) identified eight persons with grade 3, 148 persons with grade 2, and 424 persons with grade 1 or 0. The calculation of the Pearson correlation coefficient to evaluate the relationship among the three methods of assessing halitosis revealed little to no correlation. The organoleptic score showed high reproducibility (kappa = 0.79). Tongue coating was the only influencing factor found to contribute to higher organoleptic scores and higher VSC values. CONCLUSIONS: Oral malodor seemed to pose an oral health problem for about one-fifth of 20-year-old Swiss males questioned. No correlation between self-reported halitosis and organoleptic or VSC measurements could be detected. Although the organoleptic method described here offers a high reproducibility, the lack of correlation between VSC values and organoleptic scores has to be critically addressed. For further studies assessing new organoleptic scores, a validated index should always be included as a direct control.

An analysis of variance type method to describe and compare steady states in clinical data

Identifying and comparing different steady states is an important task for clinical decision making. Data from unequal sources, comprising diverse patient status information, have to be interpreted. In order to compare results an expressive representation is the key. In this contribution we suggest a criterion to calculate a context-sensitive value based on variance analysis and discuss its advantages and limitations referring to a clinical data example obtained during anesthesia. Different drug plasma target levels of the anesthetic propofol were preset to reach and maintain clinically desirable steady state conditions with target controlled infusion (TCI). At the same time systolic blood pressure was monitored, depth of anesthesia was recorded using the bispectral index (BIS) and propofol plasma concentrations were determined in venous blood samples. The presented analysis of variance (ANOVA) is used to quantify how accurately steady states can be monitored and compared using the three methods of measurement.

Modelling spatial decisión support systems focused on the development of a data warehouse: applying software engineering

Nowadays, organizations have plenty of data stored in DB databases, which contain invaluable information. Decision Support Systems DSS provide the support needed to manage this information and planning médium and long-term ?the modus operandi? of these organizations. Despite the growing importance of these systems, most proposals do not include its total evelopment, mostly limiting itself on the development of isolated parts, which often have serious integration problems. Hence, methodologies that include models and processes that consider every factor are necessary. This paper will try to fill this void as it proposes an approach for developing spatial DSS driven by the development of their associated Data Warehouse DW, without forgetting its other components. To the end of framing the proposal different Engineering Software focus (The Software Engineering Process and Model Driven Architecture) are used, and coupling with the DB development methodology, (and both of them adapted to DW peculiarities). Finally, an example illustrates the proposal.