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.

Exploring female mice interstrain differences relevant for models of depression

Depression is an extremely heterogeneous disorder. Diverse molecular mechanisms have been suggested to underlie its etiology. To understand the molecular mechanisms responsible for this complex disorder, researchers have been using animal models extensively, namely mice from various genetic backgrounds and harboring distinct genetic modifications. The use of numerous mouse models has contributed to enrich our knowledge on depression. However, accumulating data also revealed that the intrinsic characteristics of each mouse strain might influence the experimental outcomes, which may justify some conflicting evidence reported in the literature. To further understand the impact of the genetic background, we performed a multimodal comparative study encompassing the most relevant parameters commonly addressed in depression, in three of the most widely used mouse strains: Balb/c, C57BL/6, and CD-1. Moreover, female mice were selected for this study taken into account the higher prevalence of depression in women and the fewer animal studies using this gender. Our results show that Balb/c mice have a more pronounced anxious-like behavior than CD-1 and C57BL/6 mice, whereas C57BL/6 animals present the strongest depressive-like trait. Furthermore, C57BL/6 mice display the highest rate of proliferating cells and brain-derived neurotrophic factor (Bdnf) expression levels in the hippocampus, while hippocampal dentate granular neurons of Balb/c mice show smaller dendritic lengths and fewer ramifications. Of notice, the expression levels of inducible nitric oxide synthase (iNos) predict 39.5% of the depressive-like behavior index, which suggests a key role of hippocampal iNOS in depression. Overall, this study reveals important interstrain differences in several behavioral dimensions and molecular and cellular parameters that should be considered when preparing and analyzing experiments addressing depression using mouse models. It further contributes to the literature by revealing the predictive value of hippocampal iNos expression levels in depressive-like behavior, irrespectively of the mouse strain.

Assessment of the mechanical performance of recycled unbound materials for pavement subbase layers

The cyclic load triaxial test is a laboratory test that allows studying the mechanical behaviour of unbound granular materials used in base/subbase layers of road pavements. The resilient modulus and permanent strains are required as inputs in structural pavement design. This paper presents some results obtained for recycled materials (crushed concrete aggregate and blended crushed waste aggregate), with a view to promoting their use in pavement structures. Results relating to a reference material (limestone) are also presented, for comparison. All the test results discussed in this paper were obtained in variable cyclic radial pressure (VCP) tests. The tests performed (VCP) aim to study the influence of water content on the resilient modulus of recycled materials, as well as on the resistance to permanent deformation. Using the experimental data as a basis, further modelling work was carried out to establish the stresses developing in base/capping layers in typical Belgian road pavements. These numerical results allow to propose some simplifications of the stress paths applied in the testing procedures and to establish a new test protocol that also considers compaction during construction works. The results of this research work provide an excellent set of findings for the mechanical characterization of unbound base materials through the cyclic triaxial test, and contribute to a better understanding and correct application of recycled materials under geotechnical engineering background

Carbon materials as new generation of new electron shuttles for the anaerobic degradation of environmental xenobiotics

Tese de Doutoramento em Engenharia Química e Biológica

Modelação numérica de uma solução de reforço de solos para fundações de aerogeradores

Dissertação de mestrado integrado em Engenharia Civil