Efficient middleware for database replication

Dissertação de Mestrado em Engenharia Informática

Atuação do fisioterapeuta dermatofuncional e seu reconhecimento pelos profissionais de saúde da região de Lisboa

Mestrado em Fisioterapia

Legal and health variations in drug litigation injunctions granted in Minas Gerais

OBJECTIVE To investigate the factors related to the granting of preliminary court orders [injunctions] in drug litigations. METHODS A retrospective descriptive study of drug lawsuits in the State of Minas Gerais, Southeastern Brazil, was conducted from October 1999 to 2009. The database consists of 6,112 lawsuits, out of which 6,044 had motions for injunctions and 5,167 included the requisition of drugs. Those with more than one beneficiary were excluded, which totaled 5,072 examined suits. The variables for complete, partial, and suppressed motions were treated as dependent and assessed in relation to those that were independent – lawsuits (year, type, legal representation, defendant, court in which it was filed, adjudication time), drugs (level five of the anatomical therapeutic chemical classification), and diseases (chapter of the International Classification of Diseases). Statistical analyses were performed using the Chi-square test. RESULTS Out of the 5,072 lawsuits with injunctions, 4,184 (82.5%) had the injunctions granted. Granting varied from 95.8% of the total lawsuits in 2004 to 76.9% in 2008. Where there was legal representation, granting exceeded 80.0% and in lawsuits without representation, it did not exceed 66.9%. In public civil actions (89.1%), granting was higher relative to ordinary lawsuits (82.8%) and injunctions (80.1%). Federal courts granted only 68.6% of the injunctions, while the state courts granted 84.8%. Diseases of the digestive system and neoplasms received up to 87.0% in granting, while diseases of the nervous system, mental and behavioral disorders, and diseases of the skin and subcutaneous tissue received granting below 78.6% and showed a high proportion of suspended injunctions (10.9%). Injunctions involving paroxetine, somatropin, and ferrous sulfate drugs were all granted, while less than 54.0% of those involving escitalopram, sodium diclofenac, and nortriptyline were granted. CONCLUSIONS There are significant differences in the granting of injunctions, depending on the procedural and clinical variances. Important trends in the pattern of judicial action were observed, particularly, in the reduced granting [of injunctions] over the period.

Towards a GIS-T database design and implementation for public transit planning: the case study of Dar-Es-salaam metropolitan city, Tanzania.

Dissertation submitted in partial fulfilment of the requirements for the Degree of Master of Science in Geospatial Technologies

INbreast: Toward a Full-field Digital Mammographic Database

Rationale and Objectives Computer-aided detection and diagnosis (CAD) systems have been developed in the past two decades to assist radiologists in the detection and diagnosis of lesions seen on breast imaging exams, thus providing a second opinion. Mammographic databases play an important role in the development of algorithms aiming at the detection and diagnosis of mammary lesions. However, available databases often do not take into consideration all the requirements needed for research and study purposes. This article aims to present and detail a new mammographic database. Materials and Methods Images were acquired at a breast center located in a university hospital (Centro Hospitalar de S. João [CHSJ], Breast Centre, Porto) with the permission of the Portuguese National Committee of Data Protection and Hospital's Ethics Committee. MammoNovation Siemens full-field digital mammography, with a solid-state detector of amorphous selenium was used. Results The new database—INbreast—has a total of 115 cases (410 images) from which 90 cases are from women with both breasts affected (four images per case) and 25 cases are from mastectomy patients (two images per case). Several types of lesions (masses, calcifications, asymmetries, and distortions) were included. Accurate contours made by specialists are also provided in XML format. Conclusion The strengths of the actually presented database—INbreast—relies on the fact that it was built with full-field digital mammograms (in opposition to digitized mammograms), it presents a wide variability of cases, and is made publicly available together with precise annotations. We believe that this database can be a reference for future works centered or related to breast cancer imaging.

Implementation of a new reference values database for semiquantification in123I-FP-CIT brain single emission tomography

Brain dopamine transporters imaging by Single Emission Tomography (SPECT) with 123I-FP-CIT (DaTScanTM) has become an important tool in the diagnosis and evaluation of Parkinson syndromes.This diagnostic method allows the visualization of a portion of the striatum – where healthy pattern resemble two symmetric commas - allowing the evaluation of dopamine presynaptic system, in which dopamine transporters are responsible for dopamine release into the synaptic cleft, and their reabsorption into the nigrostriatal nerve terminals, in order to be stored or degraded. In daily practice for assessment of DaTScan TM, it is common to rely only on visual assessment for diagnosis. However, this process is complex and subjective as it depends on the observer’s experience and it is associated with high variability intra and inter observer. Studies have shown that semiquantification can improve the diagnosis of Parkinson syndromes. For semiquantification, analysis methods of image segmentation using regions of interest (ROI) are necessary. ROIs are drawn, in specific - striatum - and in nonspecific – background – uptake areas. Subsequently, specific binding ratios are calculated. Low adherence of semiquantification for diagnosis of Parkinson syndromes is related, not only with the associated time spent, but also with the need of an adapted database of reference values for the population concerned, as well as, the examination of each service protocol. Studies have concluded, that this process increases the reproducibility of semiquantification. The aim of this investigation was to create and validate a database of healthy controls for Dopamine transporters with DaTScanTM named DBRV. The created database has been adapted to the Nuclear Medicine Department’s protocol, and the population of Infanta Cristina’s Hospital located in Badajoz, Spain.

Validation of a new reference values’s database for semiquantification of 123I‐FP‐CIT SPECT scans in one nuclear medicine department

The DatScanTM and its Semiquantification (SQ) can provide advantages in the diagnosis of Parkinsonian Syndromes (PS). To improve the SQ is recommended the creation of adapted database (DB) with reference values for the Nuclear Medicine Departments. Previously to this work was created a adapted database (DBRV) to Nuclear Medicine Department's protocol and population of Infanta Cristina's Hospital located in Badajoz, for patients between the ages of 60 and 75, and reference values of the SQ were calculated. Aim: To evaluate the discrimination capacity of a department's adapted DB reference's values of healthy controls for DatScanTM.

Cooperative memory and database transactions

Dissertação apresentada na Faculdade de Ciências e Tecnologia da Universidade Nova de Lisboa para a obtenção do Grau de Mestre em Engenharia Informática

Towards a flexible and transparent database evolution

Applications refactorings that imply the schema evolution are common activities in programming practices. Although modern object-oriented databases provide transparent schema evolution mechanisms, those refactorings continue to be time consuming tasks for programmers. In this paper we address this problem with a novel approach based on aspect-oriented programming and orthogonal persistence paradigms, as well as our meta-model. An overview of our framework is presented. This framework, a prototype based on that approach, provides applications with aspects of persistence and database evolution. It also provides a new pointcut/advice language that enables the modularization of the instance adaptation crosscutting concern of classes, which were subject to a schema evolution. We also present an application that relies on our framework. This application was developed without any concern regarding persistence and database evolution. However, its data is recovered in each execution, as well as objects, in previous schema versions, remain available, transparently, by means of our framework.

Evolution of the application and database with aspects

Generally, the evolution process of applications has impact on their underlining data models, thus becoming a time-consuming problem for programmers and database administrators. In this paper we address this problem within an aspect-oriented approach, which is based on a meta-model for orthogonal persistent programming systems. Applying reflection techniques, our meta-model aims to be simpler than its competitors. Furthermore, it enables database multi-version schemas. We also discuss two case studies in order to demonstrate the advantages of our approach.

Ostracoda: database for the Neogene of Portugal

The "Ostracoda: database for the Neogene of Portugal", prepared under the Project "POCTl/36531/PAL/2000 - Studies on Portuguese Palaeontology / Post-Paleozoic", is presented. It provides information about 158 especies that have been recognized in sections and boreholes concerning Neogene units in Portugal.

Abordagem farmacoepidemiológica da terapêutica no idoso: um ensaio em meio hospitalar

Introdução: O envelhecimento demográfico e o aumento da esperança de vida, criam condições para uma maior incidência de doenças degenerativas. Vários aspectos críticos envolvem a medicação no idoso, tais como: polimedicação frequente, com risco acrescido de ocorrência de reacções adversas, relacionadas com interacções medicamentosas e eventual medicação desaconselhada, em que o risco pode ser superior ao benefício. Estes aspectos são particularmente críticos no idoso hospitalizado. Objectivo: Este estudo teve como objectivo estimar a prevalência da polimedicação em idosos hospitalizados e analisar a medicação considerada inadequada nesta população. Participantes e metodologia: Seguiu-se um modelo retrospectivo descritivo transversal, reportando-se os dados a um período de um ano e meio, incidindo sobre o último internamento. A natureza da medicação, foi analisada de acordo com o Formulário Terapêutico Nacional, Resumo das Caracteristicas do Medicamento e com critérios de Beers-2002.Englobou 100 idosos (>65 anos) utentes do Hospital Cuf Descobertas, em regime de internamento. Os dados pessoais e clínicos e respectivo mapa farmacoterapêutico, foram introduzidos em base de dados construída para este estudo, em Access 2003 SP2. Procedeu-se à analise estatística (SPSS 13,0), descritiva, com cálculo de medidas de tendência central; análise univariada para todas as variáveis relevantes e análise bi-variada para quantificar a prevalência da polimedicação por sexo e grupo etário. Resultados:Dos doentes estudados (65-98 anos), maioritariamente femininos, 7 apresentavam 4 patologias em simultâneo, 13:3 patologias, 27:2 patologias e 30:1 patologia. Em 23 não se verificou qualquer patologia crónica. A hipertensão (n=49:27,5%) e a patologia cardiovascular (n=41:23%) foram as mais frequentemente encontradas na amostra em estudo sendo as de menor frequência a patologia reumática (n=1:0,56%), a osteoporose e os problemas psíquicos (n=2:1,12%. A prevalência de polimedicação foi de 84% e nº de medicamentos prescrito em simultâneo variou entre 2 e 23.Não se observou associação entre a polimedicação, a idade: e o sexo. Em apenas um caso foi identificado um medicamento desaconselhado em função do diagnóstico (metoclopramida:Parkinson), e independentemente do diagnóstico a amiodariona foi o mais frequente (25%), hidroxizina (22%), ticlopidina (2%) e cetorolac (1%). Conclusões: A polimedicação é um fenómeno muito frequente nos idosos hospitalizados; o número de medicamentos envolvidos pode ser elevado e a prevalência de medicamentos que requerem uma ponderação sobre o risco/benefício no idoso, indicia a vantagem da revisão da terapêutica, impondo-se a implementação de estratégias informativas sobre os mesmos. Background: The demographic aging and expansion of life expectancy create conditions for increased occurrence of degenerative illnesses. Several critical aspects involve the medication of the elderly, such as: frequent polipharmacy with increased occurrence of adverse drug reactions, related to medication interactions and inappropriate prescribing, in which the benefits can be inferior to the risks.These aspects are particularly critical in the hospitalized elderly. Aim: This study aimed to estimate the prevalence of polipharmacy in hospitalized elderly and to analyze the medication considered inappropriate in this population. Participants and Methodology: A cross sectional model was followed, in which the data used relate to a period of a year and a half, focussing on the last hospitalization. The nature of the medication was analysed according to National Therapeutic Formulary, Drug Characteristics Summary and according to Beers-2002.It considered 100 elderly (>65 years) hospitalized at Hospital Cuf Descobertas. The personal and clinical data and the corresponding pharmacotherapeutic registration were introduced in a database created for this study in Access 2003 SP2. Descriptive statistics was calculated trough SPSS 13,0,.Exploraty analysis consisted in measures of average and spread for all variable considered relevant and univariate and bivariate analysis to quantify the prevalence of polipharmacy by sex and age and to relate polipharmacy with inappropriate medication. Results: Of the patients studied (65-98 years), the majority were women, 7 presented 4 pathologies, 13:3 pathologies, 27:2 pathologies and 30:1 pathology. In 23 patients there was any chronic pathology. Hypertension (n=49:27,5%) and cardiovascular disease (n=41:23%) were the most frequent disease in our study, and the minimal values were observed in rheumatism (n=1:0,56%), osteoporosis and psychic disorders (n=2:1,12%. The prevalence of polipharmacy was of 84% and the amount of medication simultaneously prescribed varied between 2 and 23.No association was observed between polipharmacy and age or gender. In only one case inappropriate medication was identified concerning diagnosis (metoclopramid: Parkinson), and independent of diagnosis the amiodaron was the most frequent (25%), hydroxyzin (22%), ticlopidin (2%). and ketorolac (1%). Conclusions: Polipharmacy is very prevalent among elderly people admitted to the hospital; the number of inappropriate medication can also be very high and this evidence should be collected in order to accomplish good drug use reviews and informative strategies in the hospital setting.

Geospatial database generation from digital newspapers: use case for risk and disaster domains.

Dissertation submitted in partial fulfilment of the requirements for the Degree of Master of Science in Geospatial Technologies.

Analysis of early synthetic dyes with HPLC-DAD-MS: an important database for analysis of colorants used in cultural heritage

Presented thesis at Faculdade de Ciências e Tecnologias, Universidade de Lisboa, to obtain the Master Degree in Conservation and Restoration of Textiles

Desigualdades socioeconómicas na doença cardiovascular em Portugal : estudo baseado no 4º Inquérito Nacional de Saúde

RESUMO - Em Portugal, as doenças cardiovasculares (DCV), incluindo o acidente vascular cerebral (AVC) e a doença cardíaca isquémica (DCI), são das principais causas de morbi-mortalidade e invalidez. Sabe-se que o nível socioeconómico (NSE) influencia o estado de saúde, todavia são escassas as evidências sobre as desigualdades socioeconómicas na DCV em Portugal. O objectivo deste estudo foi analisar a distribuição da DCV de acordo com o NSE na população portuguesa. Foi realizado um estudo transversal exploratório-descritivo usando a base de dados do 4º Inquérito Nacional de Saúde, 2005/06. As desigualdades socioeconómicas nas DCV, AVC e DCI, factores de risco [sedentarismo, hipertensão arterial (HTA), diabetes mellitus (DM), tabagismo, obesidade e sofrimento psicológico (Mental Health Inventory ≤ 52)] e número de consultas médicas, foram analisadas através dos odds ratio por NSE (rendimento familiar equivalente, escala modificada da OCDE) com intervalo de confiança de 95% e dos índices e curvas de concentração. Dos 21 807 indivíduos, 53,34% são do sexo feminino, a idade média é de 54±11 e entre 35 e 74 anos. A DCV, a DCI, o AVC, a HTA, a DM e a obesidade estão associados com NSE mais baixos, o tabagismo está associado aos NSE mais elevados, enquanto o sedentarismo, o número de consultas médicas e o sofrimento psicológico não apresentam associação significativa com o NSE. Os resultados revelam a associação entre os estilos de vida, morbilidade e NSE e demonstram que são necessárias políticas de saúde mais abrangentes, de acordo com as características individuais, culturais e socioeconómicas e dirigidas à promoção da saúde e prevenção da doença. -------------------------------------------- ABSTRACT - Cardiovascular diseases (CVD), including stroke and ischemic heart disease (IHD), are the leading causes of morbidity, mortality and disability in Portugal. It is known that socioeconomic status (SES) influences health status; however there is little evidence about socioeconomic inequalities in CVD in Portugal. The aim of this study was to analyze the distribution of CVD according to SES in the Portuguese population. We conducted a cross-sectional descriptive exploratory study using the database of the 4th National Survey of Health, 2005/06. Socioeconomic inequalities in CVD, stroke, IHD, risk factors [physical inactivity, arterial hypertension (AHT), diabetes mellitus (DM), smoking, obesity and psychological distress (Mental Health Inventory ≤ 52)], as well as the number of medical visits, were analyzed by SES (family income using the OECD modified equivalent scale) using odds ratio (confidence interval = 95%), and concentration curves and indices. Of the 21 807 individuals, 53.34% are female, aged between 35 and 74 with mean 54 ± 11 years. CVD, IHD, stroke, AHT, MD and obesity are associated with lower SES, smoking is associated with higher SES, while physical inactivity, number of medical visits and psychological distress showed no significant association with SES. Results suggest an association between lifestyle, morbidity and SES. They also demonstrate the need for comprehensive health strategies, involving health promotion and disease prevention, that incorporate individual, cultural and socioeconomic characteristics.