An Open Source BI Approach: Concept Proof Tracking Fleet

É possível assistir nos dias de hoje, a um processo tecnológico evolutivo acentuado por toda a parte do globo. No caso das empresas, quer as pequenas, médias ou de grandes dimensões, estão cada vez mais dependentes dos sistemas informatizados para realizar os seus processos de negócio, e consequentemente à geração de informação referente aos negócios e onde, muitas das vezes, os dados não têm qualquer relacionamento entre si. A maioria dos sistemas convencionais informáticos não são projetados para gerir e armazenar informações estratégicas, impossibilitando assim que esta sirva de apoio como recurso estratégico. Portanto, as decisões são tomadas com base na experiência dos administradores, quando poderiam serem baseadas em factos históricos armazenados pelos diversos sistemas. Genericamente, as organizações possuem muitos dados, mas na maioria dos casos extraem pouca informação, o que é um problema em termos de mercados competitivos. Como as organizações procuram evoluir e superar a concorrência nas tomadas de decisão, surge neste contexto o termo Business Intelligence(BI). A GisGeo Information Systems é uma empresa que desenvolve software baseado em SIG (sistemas de informação geográfica) recorrendo a uma filosofia de ferramentas open-source. O seu principal produto baseia-se na localização geográfica dos vários tipos de viaturas, na recolha de dados, e consequentemente a sua análise (quilómetros percorridos, duração de uma viagem entre dois pontos definidos, consumo de combustível, etc.). Neste âmbito surge o tema deste projeto que tem objetivo de dar uma perspetiva diferente aos dados existentes, cruzando os conceitos BI com o sistema implementado na empresa de acordo com a sua filosofia. Neste projeto são abordados alguns dos conceitos mais importantes adjacentes a BI como, por exemplo, modelo dimensional, data Warehouse, o processo ETL e OLAP, seguindo a metodologia de Ralph Kimball. São também estudadas algumas das principais ferramentas open-source existentes no mercado, assim como quais as suas vantagens/desvantagens relativamente entre elas. Em conclusão, é então apresentada a solução desenvolvida de acordo com os critérios enumerados pela empresa como prova de conceito da aplicabilidade da área Business Intelligence ao ramo de Sistemas de informação Geográfica (SIG), recorrendo a uma ferramenta open-source que suporte visualização dos dados através de dashboards.

Long-Term Lamivudine Treatment of Children with Chronic Hepatitis B: Durability of Therapeutic Responses and Safety

Lamivudine has been demonstrated safe and efficacious in the short term in a large cohort of children with chronic hepatitis B (CHB), but optimal duration of treatment has not been elucidated and limited data on the safety of long-term lamivudine administration have been reported. In addition, the durability of favourable therapeutic outcomes after lamivudine therapy in children has not been well characterized. The aim of this study was to examine the safety of lamivudine and the durability of clinical responses in a group of children who received up to 3 years of treatment for CHB. One hundred and fifty-one children from centres in nine countries who had previously received lamivudine in a large prospective trial were enrolled. During the first year, children had been randomized to either lamivudine or placebo treatment. Subsequently, in a separate extension study, those who remained hepatitis B e antigen (HBeAg) positive were given lamivudine for up to 2 years and those who were HBeAg negative were observed for additional 2 years. Results of these studies have been previously reported. In this study, these children were followed for 2 additional years. Data gathered from medical record review included weight, height, signs and symptoms of hepatitis, alanine aminotransferase (ALT) levels, serologic markers, hepatitis B virus (HBV) DNA levels and serious adverse events (SAEs). Other pharmacological treatments for CHB were allowed according to the practices of individual investigators and were documented. Subjects were divided into two groups for analysis, those who had achieved virological response (VR), defined as HBeAg negative and undetectable HBV DNA by the bDNA assay by the end of the extension study at 3 years, and those who had not. In those who had achieved VR by the end of the extension study, long-term durability of HBeAg seroconversion was 82% and >90% in those who had received lamivudine for 52 weeks and at least 2 years respectively. This compares to 75% for those who had achieved seroconversion after placebo. In those who had not achieved VR by the end of the extension study, an additional 11% did so by the end of the study; they had all received lamivudine in the previous trial, and none had received further treatment during the study. Eight children lost hepatitis B surface antigen during the study and all had received lamivudine at some point during the previous trials. Evaluation of safety data revealed no SAEs related to lamivudine. There was no effect of treatment on weight or height z scores. Clinically benign ALT flares (>10 times normal) were seen in 2% of children. Favourable outcomes from lamivudine treatment of CHB in children are maintained for at least several years after completion of treatment. Up to 3 years of lamivudine treatment is safe in children.

Development and Characterization of bioactive, edible whey protein films and coatings to improve quality and safety of Food products

Dissertação para a obtenção de grau de doutor em Ciências da Engenharia e Tecnologia

Psychological safety, authentic leadership and social networks : A psycho-structural approach to the study of groups

Tese de Doutoramento em Psicologia na área de especialização de Psicologia das Organizações apresentada ao ISPA - Instituto Universitário

The World Health Organization Multi-Professional Patient Safety Curriculum : implementation of key modules and its impact on patient safety knowledge, skills, and attitudes of medical students at the University of Algarve

ABSTRACT - Objectives: We attempted to show how the implementation of the key elements of the World Health Organization Patient Safety Curriculum Guide Multi-professional Edition in an undergraduate curriculum affected the knowledge, skills, and attitudes towards patient safety in a graduate entry Portuguese Medical School. Methods: After receiving formal recognition by the WHO as a Complementary Test Site and approval of the organizational ethics committee , the validated pre-course questionnaires measuring the knowledge, skills, and attitudes to patient safety were administered to the 2nd and3rd year students pursuing a four-year course (N = 46). The key modules of the curriculum were implemented over the academic year by employing a variety of learning strategies including expert lecturers, small group problem-based teaching sessions, and Simulation Laboratory sessions. The identical questionnaires were then administered and the impact was measured. The Curriculum Guide was evaluated as a health education tool in this context. Results: A significant number of the respondents, 47 % (n = 22), reported having received some form of prior patient safety training. The effect on Patient Safety Knowledge was assessed by using the percentage of correct pre- and post-course answers to construct 2 × 2 contingency tables and by applying Fishers’ test (two-tailed). No significant differences were detected (p < 0.05). To assess the effect of the intervention on Patient Safety skills and attitudes, the mean and standard deviation were calculated for the pre and post-course responses, and independent samples were subjected to Mann-Whitney’s test. The attitudinal survey indicated a very high baseline incidence of desirable attitudes and skills toward patient safety. Significant changes were detected (p < 0.05) regarding what should happen if an error is made (p = 0.016), the role of healthcare organizations in error reporting (p = 0.006), and the extent of medical error (p = 0.005). Conclusions: The implementation of selected modules of the WHO Patient Safety Curriculum was associated with a number of positive changes regarding patient safety skills and attitudes, with a baseline incidence of highly desirable patient safety attitudes, but no measureable change on the patient safety knowledge, at the University of Algarve Medical School. The significance of these results is discussed along with implications and suggestions for future research.

Genetic algorithm for shipping route estimation with long-range tracking data : automatic reconstruction of shipping routes based on the historical ship positions for maritime safety applications

Ship tracking systems allow Maritime Organizations that are concerned with the Safety at Sea to obtain information on the current location and route of merchant vessels. Thanks to Space technology in recent years the geographical coverage of the ship tracking platforms has increased significantly, from radar based near-shore traffic monitoring towards a worldwide picture of the maritime traffic situation. The long-range tracking systems currently in operations allow the storage of ship position data over many years: a valuable source of knowledge about the shipping routes between different ocean regions. The outcome of this Master project is a software prototype for the estimation of the most operated shipping route between any two geographical locations. The analysis is based on the historical ship positions acquired with long-range tracking systems. The proposed approach makes use of a Genetic Algorithm applied on a training set of relevant ship positions extracted from the long-term storage tracking database of the European Maritime Safety Agency (EMSA). The analysis of some representative shipping routes is presented and the quality of the results and their operational applications are assessed by a Maritime Safety expert.

Safety and immunogenicity of the M72/AS01 candidate tuberculosis vaccine in HIV-infected adults on combination antiretroviral therapy: a phase I/II, randomized trial.

OBJECTIVE: Tuberculosis (TB) is highly prevalent among HIV-infected people, including those receiving combination antiretroviral therapy (cART), necessitating a well tolerated and efficacious TB vaccine for these populations. We evaluated the safety and immunogenicity of the candidate TB vaccine M72/AS01 in adults with well controlled HIV infection on cART. DESIGN: A randomized, observer-blind, controlled trial (NCT00707967). METHODS: HIV-infected adults on cART in Switzerland were randomized 3 : 1 : 1 to receive two doses, 1 month apart, of M72/AS01, AS01 or 0.9% physiological saline (N = 22, N = 8 and N = 7, respectively) and were followed up to 6 months postdose 2 (D210). Individuals with CD4⁺ cell counts below 200 cells/μl were excluded. Adverse events (AEs) including HIV-specific and laboratory safety parameters were recorded. Cell-mediated (ICS) and humoral (ELISA) responses were evaluated before vaccination, 1 month after each dose (D30, D60) and D210. RESULTS: Thirty-seven individuals [interquartile range (IQR) CD4⁺ cell counts at screening: 438-872 cells/μl; undetectable HIV-1 viremia] were enrolled; 73% of individuals reported previous BCG vaccination, 97.3% tested negative for the QuantiFERON-TB assay. For M72/AS01 recipients, no vaccine-related serious AEs or cART-regimen adjustments were recorded, and there were no clinically relevant effects on laboratory safety parameters, HIV-1 viral loads or CD4⁺ cell counts. M72/AS01 was immunogenic, inducing persistent and polyfunctional M72-specific CD4⁺ T-cell responses [medians 0.70% (IQR 0.37-1.07) at D60] and 0.42% (0.24-0.61) at D210, predominantly CD40L⁺IL-2⁺TNF-α⁺, CD40L⁺IL-2⁺ and CD40L⁺IL-2⁺TNF-α⁺IFN-γ⁺]. All M72/AS01 vaccines were seropositive for anti-M72 IgG after second vaccination until study end. CONCLUSION: M72/AS01 was clinically well tolerated and immunogenic in this population, supporting further clinical evaluation in HIV-infected individuals in TB-endemic settings.

Pharmacokinetics and safety of panobacumab: specific adjunctive immunotherapy in critical patients with nosocomial Pseudomonas aeruginosa O11 pneumonia.

Objectives Nosocomial Pseudomonas aeruginosa pneumonia remains a major concern in critically ill patients. We explored the potential impact of microorganism-targeted adjunctive immunotherapy in such patients. Patients and methods This multicentre, open pilot Phase 2a clinical trial (NCT00851435) prospectively evaluated the safety, pharmacokinetics and potential efficacy of three doses of 1.2 mg/kg panobacumab, a fully human monoclonal anti-lipopolysaccharide IgM, given every 72 h in 18 patients developing nosocomial P. aeruginosa (serotype O11) pneumonia. Results Seventeen out of 18 patients were included in the pharmacokinetic analysis. In 13 patients receiving three doses, the maximal concentration after the third infusion was 33.9 ± 8.0 μg/mL, total area under the serum concentration-time curve was 5397 ± 1993 μg h/mL and elimination half-life was 102.3 ± 47.8 h. Panobacumab was well tolerated, induced no immunogenicity and was detected in respiratory samples. In contrast to Acute Physiology and Chronic Health Evaluation II (APACHE II) prediction, all 13 patients receiving three doses survived, with a mean clinical resolution in 9.0 ± 2.7 days. Two patients suffered a recurrence at days 17 and 20. Conclusions These data suggest that panobacumab is safe, with a pharmacokinetic profile similar to that in healthy volunteers. It was associated with high clinical cure and survival rates in patients developing nosocomial P. aeruginosa O11 pneumonia. We concluded that these promising results warrant further trials.

Safety and occlusion rates of surgical treatment of unruptured intracranial aneurysms: a systematic review and meta-analysis of the literature from 1990 to 2011.

BACKGROUND AND PURPOSE: Surgical clipping of unruptured intracranial aneurysms (UIAs) has recently been challenged by the emergence of endovascular treatment. We performed an updated systematic review and meta-analysis on the surgical treatment of UIAs, in an attempt to determine the aneurysm occlusion rates and safety of surgery in the modern era. METHODS: A detailed protocol was developed prior to conducting the review according to the Cochrane Collaboration guidelines. Electronic databases spanning January 1990-April 2011 were searched, complemented by hand searching. Heterogeneity was assessed using I(2), and publication bias with funnel plots. Surgical mortality and morbidity were analysed with weighted random effect models. RESULTS: 60 studies with 9845 patients harbouring 10 845 aneurysms were included. Mortality occurred in 157 patients (1.7%; 99% CI 0.9% to 3.0%; I(2)=82%). Unfavourable outcomes, including death, occurred in 692 patients (6.7%; 99% CI 4.9% to 9.0%; I(2)=85%). Morbidity rates were significantly greater in higher quality studies, and with large or posterior circulation aneurysms. Reported morbidity rates decreased over time. Studies were generally of poor quality; funnel plots showed heterogeneous results and publication bias, and data on aneurysm occlusion rates were scant. CONCLUSIONS: In studies published between 1990 and 2011, clipping of UIAs was associated with 1.7% mortality and 6.7% overall morbidity. The reputed durability of clipping has not been rigorously documented. Due to the quality of the included studies, the available literature cannot properly guide clinical decisions.

Efficacy and safety of certolizumab pegol induction therapy in an unselected Crohn's disease population: results of the FACTS survey.

Background: Switzerland was the first country to approve certolizumab pegol (Cimzia, CZP) for the treatment of patients with moderate to severe Crohn's disease (CD) in September 2007. This phase IV study aimed to evaluate the efficacy and safety of CZP in a Swiss multicenter cohort of practice-based patients. Methods: Baseline and Week 6 evaluation questionnaires were sent to all Swiss gastroenterologists in hospitals and private practices. Disease activity was assessed with the Harvey-Bradshaw Index (HBI) and adverse events were evaluated according to WHO guidelines. Results: Fifty patients (31 women, 19 men) were included; 56% had complicated disease (stricture or fistula) and 52% had undergone prior CD-related surgery. All patients. had prior exposure to systemic steroids, 96% to immunomodulators, 78% to infliximab, and 50% to adalimumab. A significant decrease in HBI was observed at Week 6 (versus Week 0) following induction therapy with CZP 400 mg subcutaneously at Weeks 0, 2, and 4 (12.6 +/- 4.7 Week 0 versus 6.2 +/- 4.4 Week 6, P < 0.001). Response and remission rates at Week 6 were 54% and 40%, respectively. We identified 8/11 CD patients undergoing a 50% fistula response (P = 0.021). The frequency of adverse drug reactions attributed to CZP was 6%. CZP was continued in 80% of patients beyond Week 6. Conclusions: In a population of CD patients with complicated disease behavior, CZP induced a response and remission in 54% and 40% of patients, respectively. This series provides the first evidence of the effectiveness of CZP in perianal fistulizing CD.

Streamlining the medication process improves safety in the intensive care unit.

BACKGROUND: Multiple interventions were made to optimize the medication process in our intensive care unit (ICU). 1 Transcriptions from the medical order form to the administration plan were eliminated by merging both into a single document; 2 the new form was built in a logical sequence and was highly structured to promote completeness and standardization of information; 3 frequently used drug names, approved units, and fixed routes were pre-printed; 4 physicians and nurses were trained with regard to the correct use of the new form. This study was aimed at evaluating the impact of these interventions on clinically significant types of medication errors. METHODS: Eight types of medication errors were measured by a prospective chart review before and after the interventions in the ICU of a public tertiary care hospital. We used an interrupted time-series design to control the secular trends. RESULTS: Over 85 days, 9298 lines of drug prescription and/or administration to 294 patients, corresponding to 754 patient-days were collected and analysed for the three series before and three series following the intervention. Global error rate decreased from 4.95 to 2.14% (-56.8%, P < 0.001). CONCLUSIONS: The safety of the medication process in our ICU was improved by simple and inexpensive interventions. In addition to the optimization of the prescription writing process, the documentation of intravenous preparation, and the scheduling of administration, the elimination of the transcription in combination with the training of users contributed to reducing errors and carried an interesting potential to increase safety.

A safety run-in and randomized phase 2 study of cilengitide combined with chemoradiation for newly diagnosed glioblastoma (NABTT 0306).

BACKGROUND: Cilengitide is a selective integrin inhibitor that is well tolerated and has demonstrated biologic activity in patients with recurrent malignant glioma. The primary objectives of this randomized phase 2 trial were to determine the safety and efficacy of cilengitide when combined with radiation and temozolomide for patients with newly diagnosed glioblastoma multiforme and to select a dose for comparative clinical testing. METHODS: In total, 112 patients were accrued. Eighteen patients received standard radiation and temozolomide with cilengitide in a safety run-in phase followed by a randomized phase 2 trial with 94 patients assigned to either a 500 mg dose group or 2000 mg dose group. The trial was designed to estimate overall survival benefit compared with a New Approaches to Brain Tumor Therapy (NABTT) Consortium internal historic control and data from the published European Organization for Research and Treatment of Cancer (EORTC) trial EORTC 26981. RESULTS: Cilengitide at all doses studied was well tolerated with radiation and temozolomide. The median survival was 19.7 months for all patients, 17.4 months for the patients in the 500 mg dose group, 20.8 months for patients in the 2000 mg dose group, 30 months for patients who had methylated O6-methylguanine-DNA methyltransferase (MGMT) status, and 17.4 months for patients who had unmethylated MGMT status. For patients aged ≤70 years, the median survival and survival at 24 months was superior to what was observed in the EORTC trial (20.7 months vs 14.6 months and 41% vs 27%, respectively; P = .008). CONCLUSIONS: Cilengitide was well tolerated when combined with standard chemoradiation and may improve survival for patients newly diagnosed with glioblastoma multiforme regardless of MGMT methylation status. The authors concluded that, from an efficacy and safety standpoint, future trials of this agent in this population should use the 2000 mg dose. Cancer 2012. © 2012 American Cancer Society.

Safety and feasibility of NeuroFlo use in eight- to 24-hour ischemic stroke patients.

BACKGROUND: Acute treatment of ischemic stroke patients presenting more than eight-hours after symptom onset remains limited and largely unproven. Partial aortic occlusion using the NeuroFlo catheter can augment cerebral perfusion in animals. We investigated the safety and feasibility of employing this novel catheter to treat ischemic stroke patients eight-hours to 24 h following symptom onset. METHODS: A multicenter, single-arm trial enrolled ischemic stroke patients at nine international academic medical centers. Eligibility included age 18-85 years old, National Institutes of Health stroke scale (NIHSS) score between four and 20, within eight-hours to 24 h after symptom onset, and perfusion-diffusion mismatch confirmed by magnetic resonance imaging. The primary outcome was all adverse events occurring from baseline to 30 days posttreatment. Secondary outcomes included stroke severity on neurological indices through 90 days. This study is registered with ClinicalTrials.gov, number NCT00436592. RESULTS: A total of 26 patients were enrolled. Of these, 25 received treatment (one excluded due to aortic morphology); five (20%) died. Favorable neurological outcome at 90 days (modified Rankin score 0-2 vs. 3-6) was associated with lower baseline NIHSS (P < 0·001) and with longer duration from symptom discovery to treatment. There were no symptomatic intracranial hemorrhages or parenchymal hematomas. Asymptomatic intracranial hemorrhage was visible on computed tomography in 32% and only on microbleed in another 20%. CONCLUSIONS: Partial aortic occlusion using the NeuroFlo catheter, a novel collateral therapeutic strategy, appears safe and feasible in stroke patients eight-hours to 24 h after symptom onset.

A Transportation Safety Planning Tool for the City of Ames, August 2011

The historically-reactive approach to identifying safety problems and mitigating them involves selecting black spots or hot spots by ranking locations based on crash frequency and severity. The approach focuses mainly on the corridor level without taking the exposure rate (vehicle miles traveled) and socio-demographics information of the study area, which are very important in the transportation planning process, into consideration. A larger study analysis unit at the Transportation Analysis Zone (TAZ) level or the network planning level should be used to address the needs of development of the community in the future and incorporate safety into the long-range transportation planning process. In this study, existing planning tools (such as the PLANSAFE models presented in NCHRP Report 546) were evaluated for forecasting safety in small and medium-sized communities, particularly as related to changes in socio-demographics characteristics, traffic demand, road network, and countermeasures. The research also evaluated the applicability of the Empirical Bayes (EB) method to network-level analysis. In addition, application of the United States Road Assessment Program (usRAP) protocols at the local urban road network level was investigated. This research evaluated the applicability of these three methods for the City of Ames, Iowa. The outcome of this research is a systematic process and framework for considering road safety issues explicitly in the small and medium-sized community transportation planning process and for quantifying the safety impacts of new developments and policy programs. More specifically, quantitative safety may be incorporated into the planning process, through effective visualization and increased awareness of safety issues (usRAP), the identification of high-risk locations with potential for improvement, (usRAP maps and EB), countermeasures for high-risk locations (EB before and after study and PLANSAFE), and socio-economic and demographic induced changes at the planning-level (PLANSAFE).