Automatic generation of ETL physical systems from BPMN conceptual models

ETL conceptual modeling is a very important activity in any data warehousing system project implementation. Owning a high-level system representation allowing for a clear identification of the main parts of a data warehousing system is clearly a great advantage, especially in early stages of design and development. However, the effort to model conceptually an ETL system rarely is properly rewarded. Translating ETL conceptual models directly into something that saves work and time on the concrete implementation of the system process it would be, in fact, a great help. In this paper we present and discuss a hybrid approach to this problem, combining the simplicity of interpretation and power of expression of BPMN on ETL systems conceptualization with the use of ETL patterns to produce automatically an ETL skeleton, a first prototype system, which has the ability to be executed in a commercial ETL tool like Kettle.

Using relational algebra on the specification of real world ETL processes

Modeling Extract-Transform-Load (ETL) processes of a Data Warehousing System has always been a challenge. The heterogeneity of the sources, the quality of the data obtained and the conciliation process are some of the issues that must be addressed in the design phase of this critical component. Commercial ETL tools often provide proprietary diagrammatic components and modeling languages that are not standard, thus not providing the ideal separation between a modeling platform and an execution platform. This separation in conjunction with the use of standard notations and languages is critical in a system that tends to evolve through time and which cannot be undermined by a normally expensive tool that becomes an unsatisfactory component. In this paper we demonstrate the application of Relational Algebra as a modeling language of an ETL system as an effort to standardize operations and provide a basis for uncommon ETL execution platforms.

Step towards a patient timeline in intensive care units

In Intensive Medicine, the presentation of medical information is done in many ways, depending on the type of data collected and stored. The way in which the information is presented can make it difficult for intensivists to quickly understand the patient's condition. When there is the need to cross between several types of clinical data sources the situation is even worse. This research seeks to explore a new way of presenting information about patients, based on the timeframe in which events occur. By developing an interactive Patient Timeline, intensivists will have access to a new environment in real-time where they can consult the patient clinical history and the data collected until the moment. The medical history will be available from the moment in which patients is admitted in the ICU until discharge, allowing intensivist to examine data regarding vital signs, medication, exams, among others. This timeline also intends to, through the use of information and models produced by the INTCare system, combine several clinical data in order to help diagnose the future patients’ conditions. This platform will help intensivists to make more accurate decision. This paper presents the first approach of the solution designed

A relational algebra approach to ETL modeling

The MAP-i Doctoral Programme in Informatics, of the Universities of Minho, Aveiro and Porto

Pervasive patient timeline

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

Business intelligence no suporte às autarquias locais e à sua gestão orçamental

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

Scarless laparoscopic repair of epigastric hernia in children

Background Despite the small size of the incision, the scar left by open repair of epigastric hernia in children is unaesthetic. Few laparoscopic approaches to epigastric hernia repair have been previously proposed, but none has gain wide acceptance from pediatric surgeons. In this study, we present our experience with a scarless laparo- scopic approach using a percutaneous suturing technique for epigastric hernia repair in children. Methods Ten consecutive patients presenting with epi- gastric hernia 15 mm or further from the umbilicus were submitted to laparoscopic hernia repair. A 5-mm 308-angle laparoscope is introduced through a umbilical trocar and a 3-mm laparoscopic dissector is introduced through a stab incision in the right flank. After opening and dissecting the parietal peritoneum, the fascial defect is identified and closed using 2–0 polyglactin thread through a percutaneous suturing technique. Intraoperative and postoperative clinical data were collected. Results All patients were successfully submitted to la- paroscopic epigastric hernia repair. Median age at surgery was 79 months old and the median distance from the um- bilicus to the epigastric defect was 4 cm. Operative time ranged from 35 to 75 min. Every hernia was successfully closed without any incidents. Follow-up period ranges from 2 to 12 months. No postoperative complications or recurrence was registered. No scar was visible in these patients. Conclusion This scarless laparoscopic technique for epi- gastric hernia repair is safe and reliable. We believe this technique might become gold standard of care in the near future.

HPV DNA testing with cytology triage in cervical cancer screening: Influence of revealing HPV infection status

BACKGROUND: Knowledge of cervical human papillomavirus (HPV) status might influence a cytotechnician's assessment of cellular abnormalities. The authors compared original cytotechnicians' Papanicolaou (Pap) readings for which HPV status was concealed with Pap rereads for which HPV status was revealed separately for 3 screening populations. METHODS: Previously collected cervical Pap smears and clinical data were obtained from the Canadian Cervical Cancer Screening Trial (study A), the Democratic Republic of Congo Community-Based Screening Study (study B), and the Brazilian Investigation into Nutrition and Cervical Cancer Prevention (study C). Smears were reread with knowledge of HPV status for all HPV-positive women as well as a sample of HPV-negative women. Diagnostic performance of Pap cytology was compared between original readings and rereads. RESULTS: A total of 1767 Pap tests were reread. Among 915 rereads for HPV-positive women, the contrast between "revealed" and "concealed" Pap readings demonstrated revisions from negative to positive results for 109 women (cutoff was atypical squamous cells of undetermined significance or worse) and 124 women (cutoff was low-grade squamous intraepithelial lesions [LSIL] or worse). For a disease threshold of cervical intraepithelial neoplasia of grade 2 or worse, specificity significantly declined at the atypical squamous cells of undetermined significance cutoff for studies A (86.6% to 75.3%) and C (42.5% to 15.5%), and at the LSIL cutoff for study C (61.9% to 37.6%). Sensitivity remained nearly unchanged between readings, except in study C, in which reread performance was superior (91.3% vs 71.9% for the LSIL cutoff). CONCLUSIONS: A reduction in the diagnostic accuracy of Pap cytology was observed when revealing patients' cervical HPV status, possibly due to a heightened awareness of potential abnormalities, which led to more false-positive results. Cancer (Cancer Cytopathol) 2015. (c) 2015 American Cancer Society.

Assessing treatment response to prophylactic lithium use in patients with bipolar disorder

ABSTRACT Objetive To identify potential clinical and epidemiological predictors of long-term response to lithium treatment. Methods A total of 40 adult outpatients followed in an university hospital, with confirmed diagnosis of bipolar disorder and with history of lithium use for at least a six months period, had their response to this medication assessed through the use of a standardized instrument. The ALDA scale is based on retrospective clinical data, in our study assessed through a thoroughly reviewed of the medical charts, and is used to evaluate the clinical improvement with the treatment (Criterion A), corrected by the acknowledgement of possible confounding factors, such as duration of the treatment, compliance and concomitant use of additional medications (Criterion B), in order to estimate the response that can be specifically attributable to lithium. Results Our study found an inverse relation between the number of mood episodes with psychotic symptoms and lithium treatment outcome. Conclusion The results reinforce the hypothesis that lithium seems to be less efficacious in patients with bipolar disorder who present psychotic symptoms.

Real-time monitoring of progression towards renal failure in primary care patients

First published online: December 16, 2014.

ProBNP for stratifying patients with heart failure

OBJECTIVE: To verify whether the serum levels of N-Terminal ProBNP fraction (ProBNP) allow us to identify with accuracy the clinical functional status of patients with heart failure (HF), because the clinical diagnosis of this syndrome is based basically on clinical data when the complementary tests have lower specificity. METHODS: Sixty-nine patients with a history of HF were studied. Their mean age of was 53.5 years and 78.3% were males. All underwent clinical and echocardiographic evaluations and a test to determine the serum dosage of ProBNP. According to clinical manifestation, patients were in the following functional classes (FC), 14% FC I, 40.6% FC II, 28.1% FC III, and 23.4% FC IV. The mean ejection fraction (EF) was 0.28. RESULTS: ProBNP did not differ according to age, sex, and cause of cardiopathy. No correlation existed between EF and the ProBNP serum level. ProBNP levels were significantly lower in patients in FC I than those in FC II (42 vs 326.7 pmol/L; P=0.0001), and in FC II than those in FC III (P=0.01). ProBNP levels did not differ statically between FC III and IV patients (888.1 vs 1082.8 pmol/L; P=0.25). ProBNP values greater than 100 pmol/L identify patients with decompensated HF with a sensitivity of 98%. CONCLUSION: ProBNP values over 100 pmol/L were indicative of HF, and patients with advanced HF had values over 270 pmol/L. A ProBNP dosage test was an excellent auxiliary in the clinical characterization of patients with HF.

Comparative study of smokers, ex-smokers, and nonsmokers who have experienced myocardial infarction

OBJECTIVE: To assess the impact of smoking on in-hospital morbidity and mortality in patients who have experienced acute myocardial infarction and to assess the association between smoking and other cardiovascular risk factors and clinical data. METHODS: A prospective cohort study analyzed 121 patients, including 54 smokers, 35 ex-smokers, and 32 nonsmokers. RESULTS: Using the chi-square test (P<0.05), an association between smoking and the risk factors sex, age, and diabetes was documented. Among the morbidity and mortality variables, only acute pulmonary edema showed a statistically significant difference (OR=9.5; 95% CI), which was greater in the ex-smoker group than in the nonsmoker group. CONCLUSION: An association between smoking and some cardiovascular risk factors was observed, but no statistical difference in morbidity and mortality was observed in the groups studied, except for the variable acute pulmonary edema.

Cardiac Surgery Costs According to the Preoperative Risk in the Brazilian Public Health System

AbstractBackground:Heart surgery has developed with increasing patient complexity.Objective:To assess the use of resources and real costs stratified by risk factors of patients submitted to surgical cardiac procedures and to compare them with the values reimbursed by the Brazilian Unified Health System (SUS).Method:All cardiac surgery procedures performed between January and July 2013 in a tertiary referral center were analyzed. Demographic and clinical data allowed the calculation of the value reimbursed by the Brazilian SUS. Patients were stratified as low, intermediate and high-risk categories according to the EuroSCORE. Clinical outcomes, use of resources and costs (real costs versus SUS) were compared between established risk groups.Results:Postoperative mortality rates of low, intermediate and high-risk EuroSCORE risk strata showed a significant linear positive correlation (EuroSCORE: 3.8%, 10%, and 25%; p < 0.0001), as well as occurrence of any postoperative complication EuroSCORE: 13.7%, 20.7%, and 30.8%, respectively; p = 0.006). Accordingly, length-of-stay increased from 20.9 days to 24.8 and 29.2 days (p < 0.001). The real cost was parallel to increased resource use according to EuroSCORE risk strata (R$ 27.116,00 ± R$ 13.928,00 versus R$ 34.854,00 ± R$ 27.814,00 versus R$ 43.234,00 ± R$ 26.009,00, respectively; p < 0.001). SUS reimbursement also increased (R$ 14.306,00 ± R$ 4.571,00 versus R$ 16.217,00 ± R$ 7.298,00 versus R$ 19.548,00 ± R$935,00; p < 0.001). However, as the EuroSCORE increased, there was significant difference (p < 0.0001) between the real cost increasing slope and the SUS reimbursement elevation per EuroSCORE risk strata.Conclusion:Higher EuroSCORE was related to higher postoperative mortality, complications, length of stay, and costs. Although SUS reimbursement increased according to risk, it was not proportional to real costs.

The Benefits of Prone SPECT Myocardial Perfusion Imaging in Reducing Both Artifact Defects and Patient Radiation Exposure

AbstractBackground:Prone imaging has been demonstrated to minimize diaphragmatic and breast tissue attenuation.Objectives:To determine the role of prone imaging on the reduction of unnecessary rest perfusion studies and coronary angiographies performed, thus decreasing investigation time and radiation exposure.Methods:We examined 139 patients, 120 with an inferior wall and 19 with an anterior wall perfusion defect that might represented attenuation artifact. Post-stress images were acquired in both the supine and prone position. Coronary angiography was used as the “gold standard” for evaluating coronary artery patency. The study was terminated and rest imaging was obviated in the presence of complete improvement of the defect in the prone position. Quantitative interpretation was performed. Results were compared with clinical data and coronary angiographic findings.Results:Prone acquisition correctly revealed defect improvement in 89 patients (89/120) with inferior wall and 12 patients (12/19) with anterior wall attenuation artifact. Quantitative analysis demonstrated statistically significant difference in the mean summed stress scores (SSS) of supine and mean SSS of prone studies in patients with disappearing inferior wall defect in the prone position and patent right coronary artery (true negative results). The mean difference between SSS in supine and in prone position was higher with disappearing than with remaining defects.Conclusion:Technetium-99m (Tc-99m) tetrofosmin myocardial perfusion imaging with the patient in the prone position overcomes soft tissue attenuation; moreover it provides an inexpensive, accurate approach to limit the number of unnecessary rest perfusion studies and coronary angiographies performed.

Anxiety, Depression, and General Psychological Distress in Patients with Coronary Slow Flow

AbstractBackground:The relationship between psychiatric illness and heart disease has been frequently discussed in the literature. The aim of the present study was to investigate the relationship between anxiety, depression and overall psychological distress, and coronary slow flow (CSF).Methods:In total, 44 patients with CSF and a control group of 50 patients with normal coronary arteries (NCA) were prospectively recruited. Clinical data, admission laboratory parameters, and echocardiographic and angiographic characteristics were recorded. Symptom Checklist 90 Revised (SCL-90-R), Beck Depression Inventory (BDI), and Beck Anxiety Inventory (BAI) scales were administered to each patient.Results:The groups were comparable with respect to age, sex, and atherosclerotic risk factors. In the CSF group, BAI score, BDI score, and general symptom index were significantly higher than controls (13 [18.7] vs. 7.5 [7], p = 0.01; 11 [14.7] vs. 6.5 [7], p = 0.01; 1.76 [0.81] vs. 1.1[0.24], p = 0.01; respectively). Patients with CSF in more than one vessel had the highest test scores. In univariate correlation analysis, mean thrombolysis in myocardial infarction (TIMI) frame counts were positively correlated with BAI (r = 0.56, p = 0.01), BDI (r = 0.47, p = 0.01), and general symptom index (r = 0.65, p = 0.01). The psychiatric tests were not correlated with risk factors for atherosclerosis.Conclusion:Our study revealed higher rates of depression, anxiety, and overall psychological distress in patients with CSF. This conclusion warrants further studies.