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.

Adaptation and Localization of Open Source ERPs - The case of Parties in OFBiz

O software tem vindo a tornar-se uma parte importante de qualquer empresa, cobrindo várias áreas funcionais, tais como manufaturação, vendas ou recursos humanos. O facto de uma empresa possuir um software capaz de ligar todas ou a maior parte das suas áreas funcionais e de acomodar as suas regras de negócio permite que estas tenham acesso a dados em tempo real nos quais se podem basear para tomar decisões. Estes tipos de software podem ser categorizados como Enterprise resource planning (ERP). Tendo em conta que estes tipos de software têm um papel importante dentro de uma empresa, a aquisição dos mesmos é algo que deve ser bem estudado. As grandes empresas normalmente optam pela aquisição de soluções comerciais uma vez que estas tendem a ter mais funcionalidades, maior suporte e certificações. Os ERPs comerciais representam, no entanto, um esforço elevado para que a sua compra possa ser feita, o que limita a possibilidade de aquisição dos mesmos por parte de pequenas ou médias empresas. No entanto, tal como acontece com a maior parte dos tipos de software, existem alternativas open-source. Se nos colocássemos na posição de uma pequena empresa, a tentar iniciar o seu negócio em Portugal, que tipo de ERP seria suficiente para os nossos requisitos? Teríamos que optar por comprar uma solução comercial, ou uma solução open-source seria suficiente? E se optássemos por desenvolver uma solução à medida? Esta tese irá responder a estas questões focando-se apenas num dos componentes base de qualquer ERP, a gestão de entidades. O componente de gestão de entidades é responsável por gerir todas as entidades com as quais a empresa interage abrangindo colaboradores, clientes, fornecedores, etc. A nível de funcionalidades será feita uma comparação entre um ERP comercial e um ERP open-source. Como os ERPs tendem a ser soluções muito genéricas é comum que estes não implementem todos os requisitos de um negócio em particular, como tal os ERPs precisam de ser extensíveis e adaptáveis. Para perceber até que ponto a solução open-source é extensível será feita uma análise técnica ao seu código fonte e será feita uma implementação parcial de um gerador de ficheiros de auditoria requerido pela lei Portuguesa, o SAF-T (PT). Ao estudar e adaptar a solução open-source podemos especificar o que teria que ser desenvolvido para podermos criar uma solução à medida de raiz.

Primary Ciliary Dyskinesia and Hydrocephalus With Aqueductal Stenosis

We report 1 female patient with situs inversus, dextrocardia, a complex heart malformation, hydrocephalus due to aqueductal stenosis, and abnormal ultrastructure of the respiratory epithelium cilia. Several animal models of this disorder implicate abnormal ciliary function in the genesis of hydrocephalus, and 11 patients were previously reported with hydrocephalus and the syndrome of primary ciliary dyskinesia. primary ciliary dyskinesia–associated aqueductal stenosis should be considered as a possible cause for fetal or neonatal hydrocephalus if heterotaxy, heart malformations, and/or a probable genetic etiology are present.

Coreceptor Usage by HIV-1 and HIV-2 Primary Isolates: The Relevance of CCR8 Chemokine Receptor as an Alternative Coreceptor

The human immunodeficiency virus replication cycle begins by sequential interactions between viral envelope glycoproteins with CD4 molecule and a member of the seven-transmembrane, G-protein-coupled, receptors' family (coreceptor). In this report we focused on the contribution of CCR8 as alternative coreceptor for HIV-1 and HIV-2 isolates. We found that this coreceptor was efficiently used not only by HIV-2 but particularly by HIV-1 isolates. We demonstrate that CXCR4 usage, either alone or together with CCR5 and/or CCR8, was more frequently observed in HIV-1 than in HIV-2 isolates. Directly related to this is the finding that the non-usage of CXCR4 is significantly more common in HIV-2 isolates; both features could be associated with the slower disease progression generally observed in HIV-2 infected patients. The ability of some viral isolates to use alternative coreceptors besides CCR5 and CXCR4 could further impact on the efficacy of entry inhibitor therapy and possibly also in HIV pathogenesis.

Is It Possible to Simplify Risk Stratification Scores for Patients with ST-Segment Elevation Myocardial Infarction Undergoing Primary Angioplasty?

INTRODUCTION: There are several risk scores for stratification of patients with ST-segment elevation myocardial infarction (STEMI), the most widely used of which are the TIMI and GRACE scores. However, these are complex and require several variables. The aim of this study was to obtain a reduced model with fewer variables and similar predictive and discriminative ability. METHODS: We studied 607 patients (age 62 years, SD=13; 76% male) who were admitted with STEMI and underwent successful primary angioplasty. Our endpoints were all-cause in-hospital and 30-day mortality. Considering all variables from the TIMI and GRACE risk scores, multivariate logistic regression models were fitted to the data to identify the variables that best predicted death. RESULTS: Compared to the TIMI score, the GRACE score had better predictive and discriminative performance for in-hospital mortality, with similar results for 30-day mortality. After data modeling, the variables with highest predictive ability were age, serum creatinine, heart failure and the occurrence of cardiac arrest. The new predictive model was compared with the GRACE risk score, after internal validation using 10-fold cross validation. A similar discriminative performance was obtained and some improvement was achieved in estimates of probabilities of death (increased for patients who died and decreased for those who did not). CONCLUSION: It is possible to simplify risk stratification scores for STEMI and primary angioplasty using only four variables (age, serum creatinine, heart failure and cardiac arrest). This simplified model maintained a good predictive and discriminative performance for short-term mortality.

Improving search engines with open Web-based SKOS vocabularies

Dissertação para obtenção do Grau de Mestre em Engenharia Informática

Mid-Term Results of EVAR in Severe Proximal Aneurysm Neck Angulation.

OBJECTIVE: To determine if mid-term outcome following endovascular aneurysm repair (EVAR) with the Endurant Stent Graft (Medtronic, Santa Rosa, CA, USA) is influenced by severe proximal neck angulation. METHODS: A retrospective case-control study was performed using data from a prospective multicenter database. All measurements were obtained using dedicated reconstruction software and center-lumen line reconstruction. Patients with neck length >15 mm, infrarenal angle (β) >75°, and/or suprarenal angle (α) >60°, or neck length >10 mm with β >60°, and/or α >45° were compared with a matched control group. Primary endpoint was primary clinical success. Secondary endpoints were freedom from rupture, type 1A endoleak, stent fractures, freedom from neck-related reinterventions, and aneurysm-related adverse events. Morphological neck variation over time was also assessed. RESULTS: Forty-five patients were included in the study group and were compared with a matched control group with 65 patients. Median follow-up time was 49.5 months (range 30.5-58.4). The 4-year primary clinical success estimates were 83% and 80% for the angulated and nonangulated groups (p = .42). Proximal neck angulation did not affect primary clinical success in a multivariate model (hazard ratio 1.56, 95% confidence interval 0.55-4.41). Groups did not differ significantly in regard to freedom from rupture (p = .79), freedom from type 1A endoleak (p = .79), freedom from neck-related adverse events (p = .68), and neck-related reinterventions (p = .68). Neck angle reduction was more pronounced in patients with severe proximal neck angulation (mean Δα -15.6°, mean Δβ -30.6°) than in the control group (mean Δα -0.39°, mean Δβ -5.9°) (p < .001). CONCLUSION: Mid-term outcomes following EVAR with the Endurant Stent Graft were not influenced by severe proximal neck angulation in our population. Despite the conformability of the device, moderate aortic neck remodeling was identified in the group of patients with angulated neck anatomy on the first computed tomography scan after implantation with no important further remodeling afterwards. No device integrity failures were encountered.

Análise Estrutural do Segmento Anterior por Tomografia de Coerência Ótica no Glaucoma Congénito Primário

Objectivo: Analisar a morfologia do segmento anterior por tomografia de coerência ótica de segmento anterior (OCT-SA) em crianças com glaucoma congénito primário (GCP). Material e métodos: Realizou-se um estudo caso-controlo, prospetivo, em crianças com GCP e em crianças sem glaucoma (grupo controlo), seguidas em Consulta de Oftalmologia Pediátrica do Hospital Dona Estefânia, Centro Hospitalar de Lisboa Central. Efectuou-se avaliação oftalmológica completa e OCT-SA utilizando o protocolo A C biometry. Resultados: O estudo incluiu 27 olhos (17 crianças com OCP) e 22 olhos (11 crianças sem glaucoma). Detetaram-se valores significativamente superiores de profundidade central e largura da câmara anterior (CA) (p<0,001) e maiores distâncias de abertura do ângulo a 500 CP<0,001) e 750µm (p=0,00 l), áreas de espaço irido-trabecular a 500 e 750µm (p<0,001) e áreas do recesso do ângulo a 500 (p<0,00l) e 750µm (p=0,001), no grupo GCP. A espessura da íris foi significativamente mais fina a 500µm do ângulo (p=0,011), no centro da íris (p<0,001) e na região mais espessa da mesma (p=0,001) no grupo GCP, assim como o comprimento da íris foi superior (p<0,001). A largura de CA e a acuidade visual (logMAR) apresentam correlação positiva (r=0,688; p<0,001). Outros achados morfológicos: anteriorização e hipoplasia da íris, alteração da morfologia do ângulo no local de intervenção cirúrgica (goniotomia, trabeculotornia, trabeculectomia, válvula de Ahmed). Conclusão: Este primeiro estudo em crianças com GCP sugere que a OCT-SA é de aquisição relativamente fácil, poderá ajudar no seguimento clínico e cirúrgico e ser útil como fator prognóstico destes doentes.

Atheroembolic Renal Disease As a Cause of Allograft Primary Non-Function

Atheroembolic renal disease, also referred to as cholesterol crystal embolization, is a rare cause of renal failure, secondary to occlusion of renal arteries, renal arterioles and glomerular capillaries with cholesterol crystals, originating from atheromatous plaques of the aorta and other major arteries. This disease can occur very rarely in kidney allografts in an early or a late clinical form. Renal biopsy seems to be a reliable diagnostic test and cholesterol clefts are the pathognomonic finding. However, the renal biopsy has some limitations as the typical lesion is focal and can be easily missed in a biopsy fragment. The clinical course of these patients varies from complete recovery of the renal function to permanent graft loss. Statins, acetylsalicyclic acid, and corticosteroids have been used to improve the prognosis. We report a case of primary allograft dysfunction caused by an early and massive atheroembolic renal disease. Distinctive histology is presented in several consecutive biopsies. We evaluated all the cases of our Unit and briefly reviewed the literature. Atheroembolic renal disease is a rare cause of allograft primary non -function but may become more prevalent as acceptance of aged donors and recipients for transplantation has become more frequent.

Distribution and Etiology of Chronic Respiratory Diseases in Primary Healthcare Departments in Cape Verde

Data on chronic respiratory diseases (CRD) are scarce or unavailable in most African countries. We aimed to determine the prevalence of CRD and associated risk factors in Cape Verde, at the primary healthcare level.

Low Socioeconomic Status is an Independent Risk Factor for Survival After Abdominal Aortic Aneurysm Repair and Open Surgery for Peripheral Artery Disease

OBJECTIVE/BACKGROUND: The association between socioeconomic status (SES), presentation, and outcome after vascular surgery is largely unknown. This study aimed to determine the influence of SES on post-operative survival and severity of disease at presentation among vascular surgery patients in the Dutch setting of equal access to and provision of care. METHODS: Patients undergoing surgical treatment for peripheral artery disease (PAD), abdominal aortic aneurysm (AAA), or carotid artery stenosis between January 2003 and December 2011 were retrospectively included. The association between SES, quantified by household income, disease severity at presentation, and survival was studied using logistic and Cox regression analysis adjusted for demographics, and medical and behavioral risk factors. RESULTS: A total of 1,178 patients were included. Low income was associated with worse post-operative survival in the PAD cohort (n = 324, hazard ratio 1.05, 95% confidence interval [CI] 1.00-1.10, per 5,000 Euro decrease) and the AAA cohort (n = 440, quadratic relation, p = .01). AAA patients in the lowest income quartile were more likely to present with a ruptured aneurysm (odds ratio [OR] 2.12, 95% CI 1.08-4.17). Lowest income quartile PAD patients presented more frequently with symptoms of critical limb ischemia, although no significant association could be established (OR 2.02, 95% CI 0.96-4.26). CONCLUSIONS: The increased health hazards observed in this study are caused by patient related factors rather than differences in medical care, considering the equality of care provided by the study setting. Although the exact mechanism driving the association between SES and worse outcome remains elusive, consideration of SES as a risk factor in pre-operative decision making and focus on treatment of known SES related behavioral and psychosocial risk factors may improve the outcome of patients with vascular disease.

Baseline Susceptibility of Primary HIV-2 to Entry Inhibitors

BACKGROUND: The baseline susceptibility of primary HIV-2 to maraviroc (MVC) and other entry inhibitors is currently unknown. METHODS: The susceptibility of 19 HIV-2 isolates obtained from asymptomatic and AIDS patients and seven HIV-1 clinical isolates to the fusion inhibitors enfuvirtide (ENF) and T-1249, and to the coreceptor antagonists AMD3100, TAK-779 and MVC, was measured using a TZM-bl cell-based assay. The 50% inhibitory concentration (IC(50)), 90% inhibitory concentration (IC(90)) and dose-response curve slopes were determined for each drug. RESULTS: ENF and T-1249 were significantly less active on HIV-2 than on HIV-1 (211- and 2-fold, respectively). AMD3100 and TAK-779 inhibited HIV-2 and HIV-1 CXCR4 tropic (X4) and CCR5 tropic (R5) variants with similar IC(50) and IC(90) values. MVC, however, inhibited the replication of R5 HIV-2 variants with significantly higher IC(90) values (42.7 versus 9.7 nM; P<0.0001) and lower slope values (0.7 versus 1.3; P<0.0001) than HIV-1. HIV-2 R5 variants derived from AIDS patients were significantly less sensitive to MVC than variants from asymptomatic patients, this being inversely correlated with the absolute number of CD4(+) T-cells. CONCLUSIONS: T-1249 is a potent inhibitor of HIV-2 replication indicating that new fusion inhibitors might be useful to treat HIV-2 infection. Coreceptor antagonists TAK-779 and AMD3100 are also potent inhibitors of HIV-2 replication. The reduced sensitivity of R5 variants to MVC, especially in severely immunodeficient patients, indicates that the treatment of HIV-2-infected patients with MVC might require higher dosages than those used in HIV-1 patients, and should be adjusted to the disease stage.

Estimating demand for primary health care services

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Economics from the NOVA – School of Business and Economics

Open innovation and social network analysis

The present article is based on the report for the Doctoral Conference of the PhD programme in Technology Assessment, held at FCT-UNL Campus, Monte de Caparica, July 9th, 2012. The PhD thesis has the supervision of Prof. Cristina Sousa (ISCTE-IUL), and co-supervision of Prof. José Cardoso e Cunha (FCT-UNL).

Primary public health care and socioeconomic asymmetries in Portugal

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Economics from the NOVA – School of Business and Economics