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.

Plastic-damage smeared crack model to simulate the behaviour of structures made by cement based materials

This work proposes a constitutive model to simulate nonlinear behaviour of cement based materials subjected to different loading paths. The model incorporates a multidirectional fixed smeared crack approach to simulate crack initiation and propagation, whereas the inelastic behaviour of material between cracks is treated by a numerical strategy that combines plasticity and damage theories. For capturing more realistically the shear stress transfer between the crack surfaces, a softening diagram is assumed for modelling the crack shear stress versus crack shear strain. The plastic damage model is based on the yield function, flow rule and evolution law for hardening variable, and includes an explicit isotropic damage law to simulate the stiffness degradation and the softening behaviour of cement based materials in compression. This model was implemented into the FEMIX computer program, and experimental tests at material scale were simulated to appraise the predictive performance of this constitutive model. The applicability of the model for simulating the behaviour of reinforced concrete shear wall panels submitted to biaxial loading conditions, and RC beams failing in shear is investigated.

Evaluation of the performance of recycled textile fibres in the mechanical behaviour of a gypsum and cork composite material

Given the need for using more sustainable constructive solutions, an innovative composite material based on a combination of distinct industrial by-products is proposed aiming to reduce waste and energy consumption in the production of construction materials. The raw materials are thermal activated flue-gas desulphurization (FGD) gypsum, which acts as a binder, granulated cork as the aggregate and recycled textile fibres from used tyres intended to reinforce the material. This paper presents the results of the design of the composite mortar mixes, the characterization of the key physical properties (density, porosity and ultrasonic pulse velocity) and the mechanical validation based on uniaxial compressive tests and fracture energy tests. In the experimental campaign, the influence of the percentage of the raw materials in terms of gypsum mass, on the mechanical properties of the composite material was assessed. It was observed that the percentage of granulated cork decreases the compressive strength of the composite material but contributes to the increase in the compressive fracture energy. Besides, the recycled textile fibres play an important role in the mode I fracture process and in the fracture energy of the composite material, resulting in a considerable increase in the mode I fracture energy.

Carbonation front progress in mortars containing fly ash considering the presence of chloride ions

The incorporation of fly ash (FA) in cementitious matrices have been frequently used in order to make the matrix more resistant to the action of chlorides. On the other hand, it is known that Ca (OH)2 existing in the matrix is partially consumed by the pozzolanic reactions, which facilitates the advancement of carbonation. Given that the combined action between carbonation and chloride penetration is a fact little known, we speculate about the behaviour of the matrix in this context. This study investigates the influence of the presence of chlorides on the carbonation in mortars with FA. Samples with 0% and 40% replacement of cement CEM I 42.5 R for FA were molded with water/binder 0.56 and 0.52 respectively. After 90 days of curing the specimens were subjected to cycles of immersion/drying for 56 days. Half of the samples was subjected to the following cycle: two days in a solution containing NaCl (concentration equal to 3.5 %); 12 days in the carbonation chamber (4% of CO2). The other half was: two days in water; 12 days in the carbonation chamber. Then, the development of carbonation was evaluated. The results indicate that the presence of chlorides influences the carbonation. The specimens submitted to the exclusive action of CO2 showed a greater depth of carbonation compared to that presented by the specimens subjected to combined action. This may be related to changes in properties of the matrix which may lead to further refinement of the pores and related to the presence of the salt that can lead to partial filling of the pores and the increase in moisture content.

Adolescent parents’ values: the role played by retrospective perceptions of the family-of-origin

Family-of-origin is an important system in individual’s lives, and its influence is extensive over the life cycle. The aim of this study was to investigate, in a sample of adolescents’ parents, whether their retrospective perceptions of parenting and relationship qualities within their families-of-origin during adolescence predicted their current collectivist and individualist values. Participants included 110 Portuguese adults with a mean age of 46.86 years old. The results of structural equation modeling supported that retrospective perceptions of parenting and relationship qualities in the family-of-origin predicted the adults’ collectivist values but not their individualist values. This study highlights the importance of retrospective perceptions of supporting and non-rejecting parenting for value acquisition. The results also suggest that values that preserve and protect family connections and collaborations are more likely to be socialized by families. Implications for practice and for the theories on parenting, values, family-of-origin influences and family intergenerational transmission are discussed.

The role of IFNγ in higher brain function: in health and under chronic stress

Tese de Doutoramento em Ciências da Saúde

Postpartum Depression: Is it a condition affecting the mother-infant interaction and the development of the child across the first year of life?

Noting that maternal depression is common during a baby's first year, this study examined the interaction of depressed and non-depressed mother-child dyads. A sample of 26 first-time mothers with postpartum depression at the third month after birth and their 3-month-old infants was compared to a sample of 25 first-time mothers with no postpartum depression at the third month after birth and their 3-month-old infants. The observations were repeated at 6 months and again at 12 months postpartum. The samples were compared for differences in mother interaction behavior, mother's infant care, mother's concern with the baby, infant behavioral difficulties, infant mental and motor development, and infant behavior with the observer. Among the findings are the following: (1) depressed mothers' interaction behavior and care of their infants are less adequate than the non-depressed mothers' interaction behavior and care of their infants at 3, 6, and 12 months postpartum; (2) infants' interaction behaviors during feeding and face-to-face interaction with depressed mothers are less adequate than infants' interactions with non-depressed mothers at 3, 6, and 12 months postpartum; (3) mother-infant interactions are less adequate in the depressed mother dyads than the non-depressed dyads at 3, 6, and 12 months postpartum; (4) depressed mothers are less concerned about their infants than non-depressed mothers at 3, 6, and 12 months postpartum; (5) infants of depressed mothers have more behavioral difficulties at 3, 6, and 12 months postpartum than infants of non-depressed mothers; (6) infants of depressed mothers had lower mental and motor development rates at 6 and 12 months postpartum than infants of non-depressed mothers; and (7) infants of non-depressed mothers behaved in a more positive way with the observer than the infants of depressed mothers. (AS)