Estudo de viabilidade de paralelização de códigos de análise de dados em PROOF

Dissertação de mestrado em Engenharia Informática

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.

Using a domain-specific language to enrich ETL schemas

Today it is easy to find a lot of tools to define data migration schemas among different types of information systems. Data migration processes use to be implemented on a very diverse range of applications, ranging from conventional operational systems to data warehousing platforms. The implementation of a data migration process often involves a serious planning, considering the development of conceptual migration schemas at early stages. Such schemas help architects and engineers to plan and discuss the most adequate way to migrate data between two different systems. In this paper we present and discuss a way for enriching data migration conceptual schemas in BPMN using a domain-specific language, demonstrating how to convert such enriched schemas to a first correspondent physical representation (a skeleton) in a conventional ETL implementation tool like Kettle.

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.

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.

Segmentação do tecido tumoral cerebral em imagens de ressonância magnética

Dissertação de mestrado integrado em Engenharia Biomédica (área de especialização em Eletrónica Médica)

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

Effect of acid or alkaline catalyst and of different capping agents on the optical properties of CdS nanoparticles incorporated within a diureasil hybrid matrix

CdS nanoparticles (NPs) were synthesized using colloidal methods and incorporated within a diureasil hybrid matrix. The surface capping of the CdS NPs by 3-mercaptopropyltrimethoxysilane (MPTMS) and 3-aminopropyltrimethoxysilane (APTMS) organic ligands during the incorporation of the NPs within the hybrid matrix has been investigated. The matrix is based on poly(ethylene oxide)/poly(propylene oxide) chains grafted to a siliceous skeleton through urea bonds and was produced by sol–gel process. Both alkaline and acidic catalysis of the sol–gel reaction were used to evaluate the effect of each organic ligand on the optical properties of the CdS NPs. The hybrid materials were characterized by absorption, steady-state and time-resolved photoluminescence spectroscopy and High Resolution Transmission Electron Microscopy (HR-TEM). The preservation of the optical properties of the CdS NPs within the diureasil hybrids was dependent on the experimental conditions used. Both organic ligands (APTMS and MPTMS) demonstrated to be crucial in avoiding the increase of size distribution and clustering of the NPs within the hybrid matrix. The use of organic ligands was also shown to influence the level of interaction between the hybrid host and the CdS NPs. The CdS NPs showed large Stokes shifts and long average lifetimes, both in colloidal solution and in the xerogels, due to the origin of the PL emission in surface states. The CdS NPs capped with MPTMS have lower PL lifetimes compared to the other xerogel samples but still larger than the CdS NPs in the original colloidal solution. An increase in PL lifetimes of the NPs after their incorporation within the hybrid matrix is related to interaction between the NPs and the hybrid host matrix.

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

Bioactive ceramics for tissue engineering and regenerative medicine derived from marine sponges

Publicado em "Journal of tissue engineering and regenerative medicine". Vol. 8, suppl. s1 (2014)

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