A domain-specific language for ETL patterns specification in Data Warehousing Systems

During the last few years many research efforts have been done to improve the design of ETL (Extract-Transform-Load) systems. ETL systems are considered very time-consuming, error-prone and complex involving several participants from different knowledge domains. ETL processes are one of the most important components of a data warehousing system that are strongly influenced by the complexity of business requirements, their changing and evolution. These aspects influence not only the structure of a data warehouse but also the structures of the data sources involved with. To minimize the negative impact of such variables, we propose the use of ETL patterns to build specific ETL packages. In this paper, we formalize this approach using BPMN (Business Process Modelling Language) for modelling more conceptual ETL workflows, mapping them to real execution primitives through the use of a domain-specific language that allows for the generation of specific instances that can be executed in an ETL commercial tool.

Modulation of the secretome of hBMSCs by tailoring the macromolecular gradient in hydrogels to generate tissue-to-tissue interfaces

Tissue-to-tissue interfaces are commonly present in all tissues exhibiting structural, biological and chemical gradients serving a wide range of physiological functions. These interfaces are responsible for mediation of load transfer between two adjacent tissues. They are also important structures in sustaining the cellular communications to retain tissueâ s functional integration and homeostasis. [1] All cells have the capacity to sense and respond to physical and chemical stimulus and when cultured in three-dimensional (3D) environments they tend to perform their function better than in two-dimensional (2D) environments. Spatial and temporal 3D gradient hydrogels better resemble the natural environment of cells in mimicking their extracellular matrix. [2] In this study we hypothesize that differential functional properties can be engineered by modulation of macromolecule gradients in a cell seeded threedimensional hydrogel system. Specifically, differential paracrine secretory profiles can be engineered using human Bone Marrow Stem Cells (hBMSCâ s). Hence, the specific objectives of this study are to: assemble the macromolecular gradient hydrogels to evaluate the suitablity for hBMSCâ s encapsulation by cellular viability and biofunctionality by assessing the paracrine secretion of hBMSCâ s over time. The gradient hydrogels solutions were prepared by blend of macromolecules in one solution such as hyaluronic (HA) acid and collagen (Col) at different ratios. The gradient hydrogels were fabricated into cylindrical silicon moulds with higher ratio solutions assembled at the bottom of the mould and adding the two solutions consecutively on top of each other. The labelling of the macromolecules was performed to confirm the gradient through fluorescence microscopy. Additionally, AFM was conducted to assess the gradient hydrogels stiffness. Gradient hydrogels characterization was performed by HA and Col degradation assay, degree of crosslinking and stability. hBMSCâ s at P3 were encapsulated into each batch solution at 106 cells/ml solution and gradient hydrogels were produced as previously described. The hBMSCâ s were observed under confocal microscopy to assess viability by Live/Dead® staining. Cellular behaviour concerning proliferation and matrix deposition was also performed. Secretory cytokine measurement for pro-inflammatory and angiogenesis factors was carried out using ELISA. At genomic level, qPCR was carried out. The 3D gradient hydrogels platform made of different macromolecules showed to be a suitable environment for hBMSCâ s. The hBMSCâ s gradient hydrogels supported high cell survival and exhibited biofunctionality. Besides, the 3D gradient hydrogels demonstrated differentially secretion of pro-inflammatory and angiogenic factors by the encapsulated hBMSCâ s. References: 1. Mikos, AG. et al., Engineering complex tissues. Tissue Engineering 12,3307, 2006 2. Phillips, JE. et al., Proc Natl Acad Sci USA, 26:12170-5, 2008

Workplace ergonomics in lean production environments: A literature review

BACKGROUND: Lean Production Systems (LPS) have become very popular among manufacturing industries, services and large commercial areas. A LPS must develop and consider a set of work features to bring compatibility with workplace ergonomics, namely at a muscular, cognitive and emotional demands level. OBJECTIVE: Identify the most relevant impacts of the adoption of LPS from the ergonomics point of view and summarizes some possible drawbacks for workplace ergonomics due to a flawed application of the LPS. The impacts identified are focused in four dimensions: work pace, intensity and load; worker motivation, satisfaction and stress; autonomy and participation; and health outcome. This paper also discusses the influence that the work organization model has on workplace ergonomics and on the waste elimination previewed by LPS. METHODS: Literature review focused LPS and its impact on occupational ergonomics conditions, as well as on the Health and Safety of workers. The main focus of this research is on LPS implementations in industrial environments and mainly in manufacturing industry workplaces. This is followed by a discussion including the authors’ experience (and previous research). RESULTS: From the reviewed literature it seems that there is no consensus on how Lean principles affect the workplace ergonomics since most authors found positive (advantages) and negative (disadvantages) impacts. CONCLUSIONS: The negative impacts or disadvantages of LPS implementations reviewed may result from the misunderstanding of the Lean principles. Possibly, they also happen due to partial Lean implementations (when only one or two tools were implemented) that may be effective in a specific work context but not suitable to all possible situations as the principles of LPS should not lead, by definition, to any of the reported drawbacks in terms of workplace ergonomics.

Out-of-plane behavior of masonry infill walls

In order to investigate the out-of-plane behaviour of masonry infill walls, quasi-static testing was performed on a masonry infill walls built inside a reinforced concrete frame by means of an airbag system to apply the uniform out-of-plane load to each component of the infill. The main advantage of this testing setup is that the out-of-plane loading can be applied more uniformly in the walls, contrarily to point load configuration. The test was performed under displacement control by selecting the mid-point of the infill as control point. Input and output air in the airbag was controlled by using a software to apply a specific displacement in the control point of the infill wall. The effect of the distance between the reaction frame of the airbag and the masonry infill on the effective contact area was previously analysed. Four load cells were attached to the reaction frame to measure the out-of-plane force. The effective contact area of the airbag was calculated by dividing the load measured in load cells by the pressure inside the airbag. When the distance between the reaction walls and the masonry infill wall is smaller, the effective area is closer to the nominal area of the airbag. Deformation and crack patterns of the infill confirm the formation of arching mechanism and two-way bending of the masonry infill. Until collapse of the horizontal interface between infill and upper beam in RC frame, the infill bends in two directions but the failure of that interface which is known as weakest interface due to difficulties in filling the mortar between bricks of last row and upper beam results in the crack opening trough a well-defined path and the consequent collapse of the infill.

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.

A relational algebra approach to ETL modeling

The MAP-i Doctoral Programme in Informatics, of the Universities of Minho, Aveiro and Porto

Myeloid Sirtuin 2 expression does not impact long-term Mycobacterium tuberculosis control

Sirtuins (Sirts) regulate several cellular mechanisms through deacetylation of several transcription factors and enzymes. Recently, Sirt2 was shown to prevent the development of inflammatory processes and its expression favors acute Listeria monocytogenes infection. The impact of this molecule in the context of chronic infections remains unknown. We found that specific Sirt2 deletion in the myeloid lineage transiently increased Mycobacterium tuberculosis load in the lungs and liver of conditional mice. Sirt2 did not affect long-term infection since no significant differences were observed in the bacterial burden at days 60 and 120 post-infection. The initial increase in M. tuberculosis growth was not due to differences in inflammatory cell infiltrates in the lung, myeloid or CD4+ T cells. The transcription levels of IFN-?, IL-17, TNF, IL-6 and NOS2 were also not affected in the lungs by Sirt2-myeloid specific deletion. Overall, our results demonstrate that Sirt2 expression has a transitory effect in M. tuberculosis infection. Thus, modulation of Sirt2 activity in vivo is not expected to affect chronic infection with M. tuberculosis.

Development of high specific strength components, with internal cellular structure, for several applications

Dissertação de mestrado em Engenharia Mecânica

Comparing different methods to measure biofilm thickness: the techniques are: optical coherence tomography, confocal laser scanning microscopy and low load compression test

Dissertação de mestrado integrado em Engenharia Biomédica (área de especialização em Engenharia Clínica)

Assessment of innovative solutions for non-load bearing masonry enclosures

This paper presents some of the results of the research project “Masonry Enclosures” developed in the framework of the transnational access (TA) to LNEC’s triaxial shake table within the FP7 project SERIES.

Organic load of substrata for wastewater treatment constructed wetlands

In Portugal the use of Constructed Wetlands (CW) for wastewater treatment has been increasing. However a number of these facilities need new strategies to achieve better efficiency. Keeping the culms of reeds on the CW beds not always results as desired, but the use of widely available agro-forest wastes, may be suitable as CW support matrix. This study was performed at lab-scale with dried culms of Phragmites and eucalyptus bark maintained in tap water, to assess them as CW substrata. With a 7 days residence time in water, Phragmites culms added a high organic load (about 400 mg L-1 BOD5) to the medium, while the eucalyptus bark added only, about 60 mg L-1 BOD5. However, by lixiviation, the organic load decreased to about 25 mg L-1 BOD5 in 5 weeks. With the organic load reduction of the leachate water, its surface tension increased, approaching the surface tension of tap water.

Regulation of human mesenchymal stem cell osteogenesis by specific surface density of fibronectin: a gradient study

 The success of synthetic bone implants requires good interface between the material and the host tissue. To study the biological relevance of fi bronectin (FN) density on the osteogenic commitment of human bone marrow mesenchymal stem cells (hBMMSCs), human FN was adsorbed in a linear density gradient on the surface of PCL. The evolution of the osteogenic markers alkaline phosphatase and collagen 1 alpha 1 was monitored by immunohistochemistry, and the cytoskeletal organization and the cell-derived FN were assessed. The functional analysis of the gradient revealed that the lower FN-density elicited stronger osteogenic expression and higher cytoskeleton spreading, hallmarks of the stem cell commitment to the osteoblastic lineage. The identifi cation of the optimal FN density regime for the osteogenic commitment of hBM-MSCs presents a simple and versatile strategy to signifi cantly enhance the surface properties of polycaprolactone as a paradigm for other synthetic polymers intended for bone-related applications.

Integração da área de negócio de retalho do grupo Riopele no Data Warehouse corporativo

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

Nanotechnological approaches using curcumin and Withania somnifera: neuroprotection and antimicrobial activities

Tese de Doutoramento em Biologia de Plantas

Searching for therapeutic strategies in a mouse modelo of Machado-Joseph disease: targeting proteostases

Tese de Doutoramento em Ciências da Saúde