Task clustering on ETL systems – A pattern-oriented approach

Usually, data warehousing populating processes are data-oriented workflows composed by dozens of granular tasks that are responsible for the integration of data coming from different data sources. Specific subset of these tasks can be grouped on a collection together with their relationships in order to form higher- level constructs. Increasing task granularity allows for the generalization of processes, simplifying their views and providing methods to carry out expertise to new applications. Well-proven practices can be used to describe general solutions that use basic skeletons configured and instantiated according to a set of specific integration requirements. Patterns can be applied to ETL processes aiming to simplify not only a possible conceptual representation but also to reduce the gap that often exists between two design perspectives. In this paper, we demonstrate the feasibility and effectiveness of an ETL pattern-based approach using task clustering, analyzing a real world ETL scenario through the definitions of two commonly used clusters of tasks: a data lookup cluster and a data conciliation and integration cluster.

Estudo e implementação de modelos de gestão de stocks em sistemas ERP para empresas retalhistas

Dissertação de mestrado em Engenharia de Sistemas

Level of compliance in contact lens wearing medical doctors in Nepal

PURPOSES: To determine the level of compliance and major non-compliant behaviors in contact lens (CL) wearing medical doctors (MDs) and to compare it with age matched CL wearing normal subjects with no medical background (NS). METHODS: Thirty-nine current CL wearing MDs, who were prescribed CLs in Nepal Eye Hospital, Kathmandu, Nepal, between 2007 and 2011, were interviewed on ten modifiable compliant behaviors regarding lens care and maintenance. The level of compliance and the rate of non-compliance for each behavior were determined and compared with NS. RESULTS: Level of compliance was good, average and poor in 35.9%, 48.7% and 15.4% of MDs, respectively. There was no significant difference in compliance between MDs and NS (p=0.209). Level of compliance was not associated with age, gender and duration of lens wear (p>0.05). Compliance rate varied according to different behaviors, achieving a good compliance level of 95% for hand hygiene, avoidance of water contact and not sleeping with lenses. There was poor compliance for topping up solution (53.8%) and lens case replacement (15.4%). CONCLUSION: About one third of MDs had a good level of compliance. Level of compliance and compliance rate of different behaviors were similar in MDs and NS. Periodic lens case replacement was the most neglected behavior in CL wearers for this region.

Avaliação do desempenho de equipas em serviços de sistemas de informação

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

The bussola study. Final results, conclusions and proposals

OBJECTIVE: To evaluate the use of thrombolytic and acetylsalicylic acid therapies in acute myocardial infarct patients as well as the availability of technical and human resources for the care of these patients in the emergency units of the city of Rio de Janeiro. Additional objectives were the evaluation of the use of primary angioplasty and the level of acceptance of SBC /RJ as an entity responsible for programs of continued medical education. METHODS: Interviews with physicians at 46 emergency units in the city of Rio de Janeiro. RESULTS: Of the 46 emergency units inspected, a policy of encouragement to use thrombolytic therapy was only prescribed in 6.5%. In 1/3 of the public wards no thrombolytic agents were available, and in none of them was access to primary angioplasty regularly available; 45.9% did not offer the minimal conditions required for the handling of cases of acute myocardial infarction; 60% of the physicians on-call (at both public and private emergency units), appeared not to know the importance of the use of acetylsalicylic acid in acute myocardial infarct patients; all physicians interviewed would participate in programs of continued medical education organized by the SBC/RJ. CONCLUSION: The study suggests there was: 1) the low probability of the use of thrombolytic therapy in the majority of the emergency units in of the city of Rio de Janeiro due to the inadequate policy of waiting for the transfer of the patient to coronary or intensive care unit; 2) a low awareness to the importance of early use of acetylsalic acid in acute myocardial infarct; 3) half of the emergency units of the public net do not have the minimal conditions required for the handling of cases of acute myocardial infarction; 4) a high level of credibility exists that would enable the SBC/RJ to set up programs for continued medical education to change the mentality regarding the use of thrombolytic therapy and of acetylsalicylic acid.

Implementação de métodos para análise de produtos acabados e matérias-primas no laboratório da empresa TMG Automotive

Dissertação de mestrado em Técnicas de Caraterização e Análise Química

Reliability of the information about the history of diagnosis and treatment of hypertension. Differences in regard to sex, age, and educational level. The pró-saúde study

OBJECTIVE: To assess the intraobserver reliability of the information about the history of diagnosis and treatment of hypertension. METHODS: A multidimensional health questionnaire, which was filled out by the interviewees, was applied twice with an interval of 2 weeks, in July '99, to 192 employees of the University of the State of Rio de Janeiro (UERJ), stratified by sex, age, and educational level. The intraobserver reliability of the answers provided was estimated by the kappa statistic and by the coefficient of intraclass correlation (CICC). RESULTS: The general kappa (k) statistic was 0.75 (95% CI=0.73-0.77). Reliability was higher among females (k=0.88, 95% CI=0.85-0.91) than among males (k=0.62, 95% CI=0.59-0.65).The reliability was higher among individuals 40 years of age or older (k=0.79; 95% CI=0.73-0.84) than those from 18 to 39 years (k=0.52; 95% CI=0.45-0.57). Finally, the kappa statistic was higher among individuals with a university educational level (k=0.86; 95% CI=0.81-0.91) than among those with high school educational level (k=0.61; 95% CI=0.53-0.70) or those with middle school educational level (k=0.68; 95% CI=0.64-0.72). The coefficient of intraclass correlation estimated by the intraobserver agreement in regard to age at the time of the diagnosis of hypertension was 0.74. A perfect agreement between the 2 answers (k=1.00) was observed for 22 interviewees who reported prior prescription of antihypertensive medication. CONCLUSION: In the population studied, estimates of the reliability of the history of medical diagnosis of hypertension and its treatment ranged from substantial to almost perfect reliability.

Comparison of Cardiovascular Risk Factors in Different Areas of Health Care Over a 20-Year Period

Background:Cardiovascular diseases (CVDs) are the leading cause of death worldwide. Knowledge about cardiovascular risk factors (CVRFs) in young adults and their modification over time are measures that change the risks and prevent CVDs.Objectives:To determine the presence of CVRFs and their changes in different health care professionals over a period of 20 years.Methods:All students of medicine, nursing, nutrition, odontology, and pharmacy departments of Federal University of Goiás who agreed to participate in this study were evaluated when they started their degree courses and 20 years afterward. Questionnaires on CVRFs [systemic arterial hypertension (SAH), diabetes mellitus, dyslipidemia, and family history of early CVD, smoking, alcohol consumption, and sedentarism] were administered. Cholesterol levels, blood sugar levels, blood pressure, weight, height, and body mass index were determined. The Kolmogorov-Smirnov test was used to evaluate distribution, the chi-square test was used to compare different courses and sexes, and the McNemar test was used for comparing CVRFs. The significance level was set at a p value of < 0.05.Results:The first stage of the study included 281 individuals (91% of all the students), of which 62.9% were women; the mean age was 19.7 years. In the second stage, 215 subjects were reassessed (76% of the initial sample), of which 59.07% were women; the mean age was 39.8 years. The sample mostly consisted of medical students (with a predominance of men), followed by nursing, nutrition, and pharmacy students, with a predominance of women (p < 0.05). Excessive weight gain, SAH, and dyslipidemia were observed among physicians and dentists (p < 0.05). Excessive weight gain and SAH and a reduction in sedentarism (p < 0.05) were observed among pharmacists. Among nurses there was an increase in excessive weight and alcohol consumption (p < 0.05). Finally, nutritionists showed an increase in dyslipidemia (p < 0.05).Conclusion:In general, there was an unfavorable progression of CVRFs in the population under study, despite it having adequate specialized knowledge about these risk factors.

Level of Physical Activity and In-Hospital Course of Patients with Acute Coronary Syndrome

Abstract Background: Acute coronary syndrome (ACS) is one of the main causes of morbidity and mortality in the modern world. A sedentary lifestyle, present in 85% of the Brazilian population, is considered a risk factor for the development of coronary artery disease. However, the correlation of a sedentary lifestyle with cardiovascular events (CVE) during hospitalization for ACS is not well established. Objective: To evaluate the association between physical activity level, assessed with the International Physical Activity Questionnaire (IPAQ), with in-hospital prognosis in patients with ACS. Methods: Observational, cross-sectional, and analytical study with 215 subjects with a diagnosis of ACS consecutively admitted to a referral hospital for cardiac patients between July 2009 and February 2011. All volunteers answered the short version of the IPAQ and were observed for the occurrence of CVE during hospitalization with a standardized assessment conducted by the researcher and corroborated by data from medical records. Results: The patients were admitted with diagnoses of unstable angina (34.4%), acute myocardial infarction (AMI) without ST elevation (41.4%), and AMI with ST elevation (24.2%). According to the level of physical activity, the patients were classified as non-active (56.3%) and active (43.7%). A CVE occurred in 35.3% of the cohort. The occurrence of in-hospital complications was associated with the length of hospital stay (odds ratio [OR] = 1.15) and physical inactivity (OR = 2.54), and was independent of age, systolic blood pressure, and prior congestive heart failure. Conclusion: A physically active lifestyle reduces the risk of CVE during hospitalization in patients with ACS.

Estudos sôbre alimentação mineral do cafeeiro: VIII. Estudo da absorção e da translocação do radiozinco no cafeeiro (Coffea arabica L.)

WATER-CULTURE EXPERIMENTS. Two water-culture experiments were carried out to study the absorption and the translocation of radiozinc in young coffee plants as influenced by two factors, namely, concentration of heavy metals (iron, man ganese, copper and molybdenum) and method of application. Inert zinc was supplied at an uniform rate of 0. 05 p. p. m.; the levels of iron supply were 0, 1.0, and 10.0 p. p.m.; manganese was supplied in three doses 0, 0.5, and 5.0 p. p.m.; copper- 0, 0. 02, and 0. 2 p. p. m.; molybdenum- 0, 0. 01, and 0. 1 p. p. m. When applied to the nutrient solution the activity os the radiozinc (as zinc chloride) was 0. 15 microcuries per plant. In the study of the leaf absorption, Zn65 was supplied at the level of 0. 10 microcuries per plant; in this case the radioative material was brushed either on the lower or on the upper surface or both two pairs of mature leaves. The absorption period was 8 weeks. The radioactivity assay showed the following results: 1 - Among the heavy metals herein investigated the iron concentration did not affect the uptake of the radiozinc; by raising the level of Mn, Cu and Mo ten times, the absorption dropped to 50 per cent and even more when compared with the control plants; when, however, these micronutrients were omitted from the nutrient solution, an increase in the uptake of zinc was registered in the minus Cu treatment only. The effects of high levels of Mn, Cu and Mo probably indicate an interionic competition for a same site on a common binding substance in the cell surface. 2 - The absorption of the radiozinc directly applied to the leaf surface reached levels as high as 8 times that registered when the root uptake took place. Among the three methods of application which have been tried, brushing the lower surface of the leaves proved to be the most effective; this result is easily understood since the stomatal openings of the coffee leaves an preferentially located in the lower surface - in this treatment, about 40 per cent of the activity was absorved and around 12 per cent were translocated either to the old or to the newer organs. Chemical analyses for heavy metals, were carried out only in the plants received Zn65Cl2 in the nutrient solution; the results were as follows; 1 - Control plants had, per 1,000 gm, of dry weight the following amounts in mg.: Zn- 48 in the roots and 29 in the tops; Fe- 165 in the roots and 9 in the tops; Mn- 58 in the roots and 15 in the tops, Cu- 15 in the roots and 1. 2 in the tops; Mo- 2. 8 in the roots and 0. 45 in the tops. 2 - The effect of different levels of micronutrients in the composition of the plants can be summarized as follows: Fe and Zn- when omitted from the nutrient solution, the iron and zinc contents in the roots decreased, no variation being noted in the tops; the higher dosis caused an accumulation in the roots but no apparent effect in the tops; Mn- by omitting this micronutrient a decrease in its content in the roots was noted, where as the concentration in the tops was the same; Mo- no variation in roots and tops contents when molybdenum was omitted; higher dosis of manganese and molybdenum increased the amounts formed both in the roots and in the tops. 3 - The influence of the different concentrations of micronutrients heavy metals on the zinc content of the coffee plants can be described by saying that: Fe and Mo- no marked variation; Mn- no effect when omitted, reduced amount when the high dosis was supplied; Mn- when the plants did not receive manganese the zinc content in roots and tops was the same as in the control plants; a decrease in the zinc content of the total plant occurred when the high dosis was employed; Cu -the situation is similar to that described for manganese. Hence, results showed by the chemical analyses roughly correspond to those of the radioactivity assay; the use of the tracer technique, however, gave best informations along this line. SOIL-POTS EXPERIMENTS. The two types of soils which when selected support the most extensive coffee plantations in the State of São Paulo, Brazil: "arenito de Bauru", a light sandy soil and "terra roxa legitima", a red soil derived from basalt. Besides NPK containing salts, the coffee plants were given two doses of inert zinc (65 and 130 mg ZnCl2 per pot) and radiozinc at a total activity of 10(6) counts/minute. The results of the countings can be summarized as follows: 1 - When plants were grown in "arenito de Bauru" the activity absorbed as per cent of the total activity supplied was not affected by the dosis of inert zinc. The highest value found was around 0. 1 per cent. 2 - For the "terra roxa" plants, the situation is almost the same; there was, however, a slight increase in the absorption of the radiozinc when 130 mgm of ZnClg2 was given: a little above 0. 2 per cent of the activity supplied was absorbed. The results clearly show that the young coffee plants practically did not absorb none of the zinc supplied; two reasons at least could be pointed out to explain such a fact: 1 - Zinc fixation by an exchange with magnesium or by filling holes in the octahedral layer of aluminosilicates, probably kaolinite; 2 - No need for fertilizer zinc in the particular stage of life cycle under which the experiment was set up. The data from chemical analysis are roughly parallel to the above mentioned. When one attempts to compare - by taking data herein reported zinc uptake from nutrient solution, leaf brushing or from fertilizers in the soil, a practical conclusion can be drawn: the control of zinc deficiency in coffee plants should not be done by adding the zinc salts to the soil; in other words: the soil applications used so extensively in other countries seem not to be suitable for our conditions; hence zinc sprays should be used wherever necessary.

Impact of genetic SLC28 transporter and ITPA variants on ribavirin 21 serum level, hemoglobin drop and therapeutic response in patients with HCV infection

Background: T reatment o f chronic hepatitis C i s evolving, a nd direct acting antivirals ( DAAs) are now a dded to p egylated interferon-α ( Peg- INF-α) and ribavirin (RBV) for the treatment o f hepatitis C v irus ( HCV) genotype 1 infection. DAAs c ause d ifferent side effects and can even worsen RBV induced hemolytic anemia. T herefore, identifying host genetic d eterminants of R BV bioavailability and therapeutic e fficacy will remain crucial for individualized treatment. Recent d ata showed associations between R BV induced h emolytic anemia and genetic polymorphisms o f concentrative nucleoside transporters s uch as C NT3 (SLC28A3) and i nosine t riphosphatase (ITPA). T o analyze t he association of genetic variants of SLC28 transporters and ITPA with RBV induced hemolytic anemia and treatment o utcome. Methods: I n our study, 173 patients f rom t he S wiss Hepatitis C C ohort Study and 2 2 patients from Swiss Association for the Study of the Liver study 24 (61% HCV g enotype 1, 3 9% genotypes 2 o r 3) were analyzed for SLC28A2 single nucleotide p olymorphism (SNP) rs11854484, SLC28A3 rs56350726 and SLC28A3 rs10868138 as well as ITPA SNPs rs1127354 and rs7270101. RBV serum levels during treatment were measured in 49 patients. Results: SLC28A2 r s11854484 genotype TT was associated with significantly higher dosage- and body weight-adjusted RBV levels as compared to genotypes TC and CC (p=0.04 and p=0.02 at weeks 4 and 8, respectively). ITPA SNPs rs1127354 and rs7270101 were associated with h emolytic a nemia both in genotype as w ell as i n allelic a nalyses. SLC28A3 rs56350726 genotype TT (vs. AT/AA, RR=2.1; 95% CI 1.1-4.1) as well as the T allele (vs. A; RR=1.8, 95% CI 1.1-3.2) were associated with increased SVR rates. The combined analysis of overall ITPA activity and SLC28 v ariants together revealed n o significant a dditive effects on either treatment-related anemia or SVR. Conclusions: T he newly identified association between RBV serum levels a nd SLC28A2 rs11854484 genotype as well as the replicated association of ITPA and SLC28A3 g enetic p olymorphisms w ith RBV induced hemolytic anemia and treatment r esponse underpin the need for further studies on host genetic d eterminants of R BV bioavailability and therapeutic e fficacy f or individualized treatment of chronic hepatitis C.

Quantification of clenbuterol at trace level in human urine by ultra-high pressure liquid chromatography-tandem mass spectrometry.

Clenbuterol is a β2 agonist agent with anabolic properties given by the increase in the muscular mass in parallel to the decrease of the body fat. For this reason, the use of clenbuterol is forbidden by the World Anti-Doping Agency (WADA) in the practice of sport. This compound is of particular interest for anti-doping authorities and WADA-accredited laboratories due to the recent reporting of risk of unintentional doping following the eating of meat contaminated with traces of clenbuterol in some countries. In this work, the development and the validation of an ultra-high pressure liquid chromatography coupled to electrospray ionization tandem mass spectrometry (UHPLC-ESI-MS/MS) method for the quantification of clenbuterol in human urine is described. The analyte was extracted from urine samples by liquid-liquid extraction (LLE) in basic conditions using tert butyl-methyl ether (TBME) and analyzed by UHPLC-MS/MS with a linear gradient of acetonitrile in 9min only. The simple and rapid method presented here was validated in compliance with authority guidelines and showed a limit of quantification at 5pg/mL and a linearity range from 5pg/mL to 300pg/mL. Good trueness (85.8-105%), repeatability (5.7-10.6% RSD) and intermediate precision (5.9-14.9% RSD) results were obtained. The method was then applied to real samples from eighteen volunteers collecting urines after single oral doses administration (1, 5 and 10μg) of clenbuterol-enriched yogurts.

Impact of low-level viremia on clinical and virological outcomes in treated HIV-1-infected patients.

BACKGROUND: The goal of antiretroviral therapy (ART) is to reduce HIV-related morbidity and mortality by suppressing HIV replication. The prognostic value of persistent low-level viremia (LLV), particularly for clinical outcomes, is unknown. OBJECTIVE: Assess the association of different levels of LLV with virological failure, AIDS event, and death among HIV-infected patients receiving combination ART. METHODS: We analyzed data from 18 cohorts in Europe and North America, contributing to the ART Cohort Collaboration. Eligible patients achieved viral load below 50 copies/ml within 3-9 months after ART initiation. LLV50-199 was defined as two consecutive viral loads between 50 and 199 copies/ml and LLV200-499 as two consecutive viral loads between 50 and 499 copies/ml, with at least one between 200 and 499 copies/ml. We used Cox models to estimate the association of LLV with virological failure (two consecutive viral loads at least 500 copies/ml or one viral load at least 500 copies/ml, followed by a modification of ART) and AIDS event/death. RESULTS: Among 17 902 patients, 624 (3.5%) experienced LLV50-199 and 482 (2.7%) LLV200-499. Median follow-up was 2.3 and 3.1 years for virological and clinical outcomes, respectively. There were 1903 virological failure, 532 AIDS events and 480 deaths. LLV200-499 was strongly associated with virological failure [adjusted hazard ratio (aHR) 3.97, 95% confidence interval (CI) 3.05-5.17]. LLV50-199 was weakly associated with virological failure (aHR 1.38, 95% CI 0.96-2.00). LLV50-199 and LLV200-499 were not associated with AIDS event/death (aHR 1.19, 95% CI 0.78-1.82; and aHR 1.11, 95% CI 0.72-1.71, respectively). CONCLUSION: LLV200-499 was strongly associated with virological failure, but not with AIDS event/death. Our results support the US guidelines, which define virological failure as a confirmed viral load above 200 copies/ml.

Detection of micrometastases in sentinel lymph nodes from melanoma patients: direct comparison of multimarker molecular and immunopathological methods.

The technique of sentinel lymph node (SLN) dissection is a reliable predictor of metastatic disease in the lymphatic basin draining the primary melanoma. Reverse transcription-polymerase chain reaction (RT-PCR) is emerging as a highly sensitive technique to detect micrometastases in SLNs, but its specificity has been questioned. A prospective SLN study in melanoma patients was undertaken to compare in detail immunopathological versus molecular detection methods. Sentinel lymphadenectomy was performed on 57 patients, with a total of 71 SLNs analysed. SLNs were cut in slices, which were alternatively subjected to parallel multimarker analysis by microscopy (haematoxylin and eosin and immunohistochemistry for HMB-45, S100, tyrosinase and Melan-A/MART-1) and RT-PCR (for tyrosinase and Melan-A/MART-1). Metastases were detected by both methods in 23% of the SLNs (28% of the patients). The combined use of Melan-A/MART-1 and tyrosinase amplification increased the sensitivity of PCR detection of microscopically proven micrometastases. Of the 55 immunopathologically negative SLNs, 25 were found to be positive on RT-PCR. Notably, eight of these SLNs contained naevi, all of which were positive for tyrosinase and/or Melan-A/MART-1, as detected at both mRNA and protein level. The remaining 41% of the SLNs were negative on both immunohistochemistry and RT-PCR. Analysis of a series of adjacent non-SLNs by RT-PCR confirmed the concept of orderly progression of metastasis. Clinical follow-up showed disease recurrence in 12% of the RT-PCR-positive immunopathology-negative SLNs, indicating that even an extensive immunohistochemical analysis may underestimate the presence of micrometastases. However, molecular analyses, albeit more sensitive, need to be further improved in order to attain acceptable specificity before they can be applied diagnostically.

Evaluating sampling strategies and logistic regression methods for modelling complex land cover changes

The role of land cover change as a significant component of global change has become increasingly recognized in recent decades. Large databases measuring land cover change, and the data which can potentially be used to explain the observed changes, are also becoming more commonly available. When developing statistical models to investigate observed changes, it is important to be aware that the chosen sampling strategy and modelling techniques can influence results. We present a comparison of three sampling strategies and two forms of grouped logistic regression models (multinomial and ordinal) in the investigation of patterns of successional change after agricultural land abandonment in Switzerland. Results indicated that both ordinal and nominal transitional change occurs in the landscape and that the use of different sampling regimes and modelling techniques as investigative tools yield different results. Synthesis and applications. Our multimodel inference identified successfully a set of consistently selected indicators of land cover change, which can be used to predict further change, including annual average temperature, the number of already overgrown neighbouring areas of land and distance to historically destructive avalanche sites. This allows for more reliable decision making and planning with respect to landscape management. Although both model approaches gave similar results, ordinal regression yielded more parsimonious models that identified the important predictors of land cover change more efficiently. Thus, this approach is favourable where land cover change pattern can be interpreted as an ordinal process. Otherwise, multinomial logistic regression is a viable alternative.