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.

Producing LFT composite parts for large consumption markets from thermoplastic powder-coated towpregs

Thermoplastic matrix composites are receiving increasing interest in last years. This is due to several advantageous properties and speed of processing of these materials as compared to their thermoset counterparts. Among thermoplastic composites, Long Fibre Thermoplastics (LFTs) have seen the fastest growth, mainly due to developments in the automotive sector. LFTs combine the (semi-)structural material properties of long (>1 cm) fibres, with the ease and speed of thermoplastic processing. This paper reports a study of a novel low-cost LFT technology and resulting composites. A patented powder-coating machine able to produce continuously pre-impregnated materials directly from fibre rovings and polymer powders was used to process glass-fibre reinforced polypropylene (GF/PP) towpregs. Such pre-impregnated materials were then chopped and used to make LFTs in a patented low-cost piston-blender developed by the Centre of Lightweight Structures, TUD-TNO, the Netherlands. The work allowed studying the most relevant towpreg production parameters and establishing the processing window needed to obtain a good quality GF/PP powder coated material. Finally, the processing window that allows producing LFTs of good quality in the piston-blender and the mechanical properties of final stamped GF/PP composite parts were also determined.

Postharvest changes and respiratory pattern of bacuri fruit (Platonia insignis Mart.) at different maturity stages during ambient storage

Bacuri (Platonia insignis, Mart.) is one of the most important among Amazonian fruits. However, little is known about its postharvest physiology, such as maturity stages, changes during ambient storage, and respiratory pattern. Fruits were harvested at three maturity stages based on epicarp colour: dark green, light green, and turning (50% yellow), in order to determine colour modification and respiratory pattern during ambient storage (25.2 ºC, 75.1 % RH). Fruit of all maturity stages showed, after three days of harvest, a non-climacteric respiratory pattern, with turning fruit presenting the highest CO2 production rate until the fourth storage day (177.63 mg.CO2.kg-1.h-1). Yellowing increased throughout storage as related to lightness, chromaticity, and hue angle reductions. Turning fruit can be stored at ambient conditions for up to 10 days without any loss in marketability.

Geographic pattern of genetic diversity in natural populations of Rosewood (Aniba rosaeodora), in the Central Amazonia

Rosewood (Aniba rosaeodora Ducke, Lauraceae) is an Amazonian evergreen tree and a source of the purest linalool, the main component of its essential oil, which is very valuable in the international perfumery market. After decades of over-exploitation it is currently considered as threatened. We evaluated the genetic diversity and its distribution in four populations in Central Amazonia. Thirty-five reliable RAPD markers were generated, of which 32 were polymorphic (91.4%). Variation was higher within the populations (76.5%; p < 0.0001) and geographic distribution contributed to population differentiation (23.4%; p < 0.0001). The Amazon River had a small influence on gene flow (3.3%; p < 0.0001), but we identified evidence of gene flow across the river. There were significant differences in marker frequencies (p < 0.05), in agreement with the low gene flow (Nm = 2.02). The correlation between genetic distance and gene flow was - 0.95 (p = 0.06) and between geographic distance and gene flow was -0.78 (p = 0.12). There was a geographic cline of variability across an East-West axis, influenced as well by the Amazon River, suggesting the river could be a barrier to gene flow. Although threatened, these Rosewood populations retain high diversity, with the highest levels in the Manaus population, which has been protected for over 42 years in a Reserve.

Consumption, wealth, stock and housing returns: evidence from emerging markets

We test the predictive ability of the transitory deviations of consumption from its common trend with aggregate wealth and labour income, cay, for both future equity and housing risk premia in emerging market economies. Using quarterly data for 31 markets, our country-level evidence shows that forecasting power of cay vis-à-vis stock returns is high for Brazil, China, Colombia, Israel, Korea, Latvia and Malaysia. As for housing returns, the empirical evidence suggests that financial and housing assets are perceived as complements in the case of Chile, Russia, South Africa and Thailand, and as substitutes in Argentina, Brazil, Hong Kong, Indonesia, Korea, Malaysia, Mexico and Taiwan. Using a panel econometric framework, we find that the cross-country heterogeneity observed in asset return predictability does not accrue to regional location, but can be attributed to differences in the degree of equity market development and in the level of income.

Synthesis, antiangiogenesis evaluation and molecular docking studies of 1-Aryl-3-[(thieno[3,2-b]pyridin-7-ylthio)phenyl]ureas: Discovery of a new substitution pattern for type II VEGFR-2 Tyr kinase inhibitors

The synthesis and biological evaluation of novel 1-aryl-3-[2-, 3- or 4-(thieno[3,2-b]pyridin-7-ylthio)phenyl]ureas 3, 4 and 5 as VEGFR-2 tyrosine kinase inhibitors, are reported. The 1-aryl-3-[3-(thieno[3,2-b]pyridin-7-ylthio)phenyl]ureas 4a-4h, with the arylurea in the meta position to the thioether, showed the lowest IC50 values in enzymatic assays (10-206 nM), the most potent compounds 4d-4h (IC50 10-28 nM) bearing hydrophobic groups (Me, F, CF3 and Cl) in the terminal phenyl ring. A convincing rationalization was achieved for the highest potent compounds 4 as type II VEGFR-2 inhibitors, based on the simultaneous presence of: (1) the thioether linker and (2) the arylurea moiety in the meta position. For compounds 4, significant inhibition of Human Umbilical Vein Endothelial Cells (HUVECs) proliferation (BrdU assay), migration (wound-healing assay) and tube formation were observed at low concentrations. These compounds have also shown to increase apoptosis using the TUNEL assay. Immunostaining for total and phosphorylated (active) VEGFR-2 was performed by Western blotting. The phosphorylation of the receptor was significantly inhibited at 1.0 and 2.5 microM for the most promising compounds. Altogether, these findings point to an antiangiogenic effect in HUVECs.

Optimal behavior of responsive residential demand considering hybrid phase change materials

Due to communication and technology developments, residential consumers are enabled to participate in Demand Response Programs (DRPs), control their consumption and decrease their cost by using Household Energy Management (HEM) systems. On the other hand, capability of energy storage systems to improve the energy efficiency causes that employing Phase Change Materials (PCM) as thermal storage systems to be widely addressed in the building applications. In this paper, an operational model of HEM system considering the incorporation of more than one type of PCM in plastering mortars (hybrid PCM) is proposed not only to minimize the customerâ s cost in different DRPs but also to guaranty the habitantsâ  satisfaction. Moreover, the proposed model ensures the technical and economic limits of batteries and electrical appliances. Different case studies indicate that implementation of hybrid PCM in the buildings can meaningfully affect the operational pattern of HEM systems in different DRPs. The results reveal that the customerâ s electricity cost can be reduced up to 48% by utilizing the proposed model.

Myocardial perfusion by contrast echocardiography. Establishment of normal pattern of intracoronary injection and safety in humans

OBJECTIVE: To establish the normal pattern and safety of echocardiographic contrast in patients with no significant obstruction of epicardial coronary arteries. METHODS: 67 patients with normal coronary arteries or obstructions < 50% were selected from 277 patients who underwent coronary angiography (CA). Mean age was 56 ± 11years and 36 were males. At the end CA, echocardiographic contrast was selectively injected into each coronary artery. The parasternal short axis of the left ventricle (LV) was divided into six segments: anterior (A), antero-lateral (AL), postero-lateral (PL), posterior (P), infero-septal (IS) and antero-septal (AS). Anterolateral (ALPM) and posteromedial papillary muscles (PMPM) were also considered. The pattern and intensity of the appearance of the myocardial contrast was visually analyzed. RESULTS: The right coronary artery (RCA) was dominant in 60 patients. Contrast appearance was sudden and simultaneous in the 3 muscle layers. All segments could be contrasted after the injection in both coronary arteries. 100% of the AS, A and AL segments, 97% of the PL and 98% of the ALPM were perfused by the left coronary artery (LCA). P and IS segments were perfused by the RCA in 85% and 82%, respectively, and by a dominant LCA in 71% of the cases. The PMPM was perfused by a dominant RCA in 77% and by a dominant LCA in 86%. There were no symptoms. CONCLUSION: Intracoronary injection of the sonicated solution is a safe procedure that allows for an excellent opacification of the myocardium and can potentially be used during routine CA.

Assessment of functional capacity through oxygen consumption in patients with asymptomatic probable heart disease

PURPOSE: To compare peak exercise oxygen consumption (VO2peak) of healthy individuals with asymptomatic individuals with probable heart disease. METHODS: Ninety-eight men were evaluated. They were divided into two groups: 1) 39 healthy individuals (group N) with an age range of 50±4.6 years; and 2) 59 asymptomatic individuals with signs of atherosclerotic and/or hypertensive heart disease (group C) with an age range of 51.9±10.4 years. In regard to age, height, body surface area, percentage of fat, lean body mass, and daily physical activity, both groups were statistically similar. Environmental conditions during the ergometric test were also controlled. RESULTS: Maximal aerobic power (watts), VO2peak, maximal heart rate, and maximal pulmonary ventilation were lower in group C (p<0.01) than in group N; weight, however, was lower in group N (p=0.031) than in group C. Differences in the respiratory gas exchange index, heart rate at rest, and the maximal double product of the two groups were not statistically significant. CONCLUSION: Signs of probable heart disease, even though asymptomatic, may reduce the functional capacity, perhaps due to the lower maximal cardiac output and/or muscle metabolic changes.

Hypertension in a female nursing staff-pattern of occurrence, diagnosis, and treatment

OBJECTIVE: To report the pattern of occurrence, diagnosis, and treatment of hypertension in a female nursing staff of an emergency hospital. METHODS: We carried out a cross-sectional study that included interviews and blood pressure measurements of 494 nursing professionals at an emergency hospital in the city of Salvador, in the state of Bahia, Brazil. We considered hypertensive all individual with blood pressure > or = 140/90 mmHg or normal pressure if on regular treatment. RESULTS: We found a prevalence of hypertension of 36.4%. Only 18.3% of the individuals ignored their hypertensive condition, and 64.2% admitted not being having regular treatment. Of those individuals who were having treatment, 69.4% had elevated blood pressure on examination. The major reasons for not being on treatment was the occasional elevation of blood pressure (22.2%) and medical counseling (20.0%). CONCLUSION: The results point to the need to introduce hypertension control measures in this occupational group, because of the magnitude of the disease and the potential impact on diffusion of knowledge and measures to control hypertension.

Palatability of the Asian clam Corbicula fluminea (Müller 1774) in an invaded system

Dissertação de mestrado em Ecology

Food consumption of adolescents. A simplified questionnaire for evaluating cardiovascular risk

OBJECTIVE: To develop a simplified questionnaire for self-evaluation by adolescents of foods associated with the risk of coronary diseases. METHODS: Frequency questionnaires about 80 foods were answered by representative samples of 256 adolescents aged 12 to 19 from Rio de Janeiro as part of the Nutrition and Health Research project. The dependent variable was the serum cholesterol predicting equation as influenced by diet, and the independent variables were the foods. The variables were normalized and, using Pearson's correlation coefficient, those with r>0.10 were selected for the regression model. The model was analyzed for sex, age, random sample, and total calories. Those food products that explained 85% of the cholesterol variation equation were present in the caloric model, and contained trans fatty acids were selected for the questionnaire. RESULTS: Sixty-five food products had a statistically significant correlation (P<0.001) with the dependent variable. The simplified questionnaire included 9 food products present in all tested models: steak or broiled meat, hamburger, full-fat cheese, French fries or potato chips, whole milk, pies or cakes, cookies, sausages, butter or margarine. The limit of the added food points for self-evaluation was 100, and over 120 points was considered excessive. CONCLUSION: The scores given to the food products and the criteria for the evaluation of the consumption limits enabled the adolescents to get to know and to balance their intake.

Perfil neuropsicológico y sesgos cognitivos de adolescentes con diferentes patrones de consumo de alcohol. Neuropsychological profile and cognitive bias in adolescents with different alcohol consumption patterns.

Identificación y caracterización del problema objeto de estudio: Diversas investigaciones señalan que el uso o consumo de alcohol comienza durante la adolescencia. En este periodo del desarrollo típicamente se han reportado deterioros asociados con el consumo de alcohol sobre diversas funciones cognitivas. Sin embargo, los hallazgos no siempre han sido concluyentes. Hipótesis: a) Existe una mayor cantidad de déficits neuropsicológicos (especialmente en los dominios asociados con la toma de decisiones) en los grupos de adolescentes que presentan patrones de consumo elevados o tipo binge y en los adolescentes bajo tratamiento; b) Existen sesgos cognitivos de tipo implícito en los adolescentes expuestos a publicidades referidas a bebidas alcohólicas; y c) Existe mayor presencia de expectativas negativas en el grupo conformado por niños, así como una mayor presencia de expectativas positivas en el grupo conformado por adolescentes. Planteo de Objetivos: se pretende lograr un perfil neuropsicológico de adolescentes de ambos sexos en función de patrones de consumo de alcohol bien diferenciados. Asimismo, se intentará determinar la presencia de sesgos cognitivos hacia estímulos asociados con el alcohol en función de las expectativas hacia el psicotrópico y el tipo de consumo del mismo que presenta la población bajo estudio. Finalmente, se buscará determinar si existen cambios evolutivos en las expectativas hacia el alcohol que pudieran indicar la presencia de mayor vulnerabilidad al consumo de alcohol. Materiales y métodos a utilizar: Se utilizarán pruebas neuropsicológicas (IGT, WCST, otras) y cognitivas (AEQ o similares). Se apelará al uso de diseños ex post facto prospectivos de tipo simple o factoriales, diseños factoriales, estudios instrumentales y estudios descriptivos de poblaciones mediante encuestas. Resultados esperados: 1) Se espera encontrar una mayor cantidad de déficits neuropsicológicos (especialmente en los dominios asociados con la toma de decisiones) en los grupos de adolescentes con patrones de consumo de alcohol elevados y binge, así como en el grupo de adolescentes bajo tratamiento. 2) Se espera encontrar la presencia de sesgos cognitivos implícitos en aquellos adolescentes expuestos a publicidades referidas a bebidas alcohólicas en contraposición a los adolescentes expuestos a publicidades de bebidas no-alcohólicas. 3) Se espera encontrar una mayor presencia de expectativas negativas en el grupo conformado por niños, y una mayor presencia de expectativas positivas en el grupo conformado por adolescentes, con lo que se verificaría el supuesto que señala que las EA se modifican a lo largo del desarrollo. Asimismo, se espera confirmar que las EA cambian en función de la experiencia de consumo de alcohol. Importancia del proyecto: En el ámbito local no se han realizado estudios sistemáticos de esta naturaleza, la información que se obtenga permitirá evaluar el impacto del uso y abuso de alcohol durante la adolescencia así como diseñar y ejecutar mejores estrategias de prevención y de rehabilitación y, al mismo tiempo, facilitará la toma de decisiones en el campo de la planificación de políticas sanitarias dirigidas a los adolescentes.

Development of a semi-automatic self learning pattern recognition system for the control of electronic boards

This project was funded under the Applied Research Grants Scheme administered by Enterprise Ireland. The project was a partnership between Galway - Mayo Institute of Technology and an industrial company, Tyco/Mallinckrodt Galway. The project aimed to develop a semi - automatic, self - learning pattern recognition system capable of detecting defects on the printed circuits boards such as component vacancy, component misalignment, component orientation, component error, and component weld. The research was conducted in three directions: image acquisition, image filtering/recognition and software development. Image acquisition studied the process of forming and digitizing images and some fundamental aspects regarding the human visual perception. The importance of choosing the right camera and illumination system for a certain type of problem has been highlighted. Probably the most important step towards image recognition is image filtering, The filters are used to correct and enhance images in order to prepare them for recognition. Convolution, histogram equalisation, filters based on Boolean mathematics, noise reduction, edge detection, geometrical filters, cross-correlation filters and image compression are some examples of the filters that have been studied and successfully implemented in the software application. The software application developed during the research is customized in order to meet the requirements of the industrial partner. The application is able to analyze pictures, perform the filtering, build libraries, process images and generate log files. It incorporates most of the filters studied and together with the illumination system and the camera it provides a fully integrated framework able to analyze defects on printed circuit boards.

SQL based frequent pattern mining

Data mining, frequent pattern mining, database mining, mining algorithms in SQL