Conceptual-physical bridging – From BPMN models to physical implementations on kettle

Developing and implementing data-oriented workflows for data migration processes are complex tasks involving several problems related to the integration of data coming from different schemas. Usually, they involve very specific requirements - every process is almost unique. Having a way to abstract their representation will help us to better understand and validate them with business users, which is a crucial step for requirements validation. In this demo we present an approach that provides a way to enrich incrementally conceptual models in order to support an automatic way for producing their correspondent physical implementation. In this demo we will show how B2K (Business to Kettle) system works transforming BPMN 2.0 conceptual models into Kettle data-integration executable processes, approaching the most relevant aspects related to model design and enrichment, model to system transformation, and system execution.

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.

Avaliação de programas de inovação: a importância dos impactos indiretos

Programa Doutoral em Engenharia Industrial e de Sistemas

Da prova: na atuação policial e no âmbito da infração tributária

Relatório de atividade profissional de mestrado em Direito Judiciário

Hemispheric dorsolateral prefrontal cortex lateralization in the regulation of empathy for pain

The dorsolateral prefrontal cortex (DLPFC) is involved in the cognitive appraisal and modulation of the pain experience. In this sham-controlled study, with healthy volunteers, we used bi-hemispheric transcranial direct current stimulation (tDCS) over the DLPFC to assess emotional reactions elicited by pain observation. Left-cathodal/right-anodal tDCS decreased valence and arousal evaluations compared to other tDCS conditions. Compared to sham condition, both left-cathodal/right-anodal and left-anodal/right-cathodal tDCS decreased hostility, sadness and self-pain perception. These decreased sensations after both active tDCS suggest a common role for left and right DLPFC in personal distress modulation. However, the differences in arousal and valence evaluations point to distinct roles of lateralized DLPFC in cognitive empathy, probably through distinct emotion regulation mechanisms.

Metabolic profiling and classification of propolis samples from Southern Brazil: an NMR-based platform coupled with machine learning

The chemical composition of propolis is affected by environmental factors and harvest season, making it difficult to standardize its extracts for medicinal usage. By detecting a typical chemical profile associated with propolis from a specific production region or season, certain types of propolis may be used to obtain a specific pharmacological activity. In this study, propolis from three agroecological regions (plain, plateau, and highlands) from southern Brazil, collected over the four seasons of 2010, were investigated through a novel NMR-based metabolomics data analysis workflow. Chemometrics and machine learning algorithms (PLS-DA and RF), including methods to estimate variable importance in classification, were used in this study. The machine learning and feature selection methods permitted construction of models for propolis sample classification with high accuracy (>75%, reaching 90% in the best case), better discriminating samples regarding their collection seasons comparatively to the harvest regions. PLS-DA and RF allowed the identification of biomarkers for sample discrimination, expanding the set of discriminating features and adding relevant information for the identification of the class-determining metabolites. The NMR-based metabolomics analytical platform, coupled to bioinformatic tools, allowed characterization and classification of Brazilian propolis samples regarding the metabolite signature of important compounds, i.e., chemical fingerprint, harvest seasons, and production regions.

Chitosan-based scaffolds for tissue regeneration: preparation and microstructure characterization

Scaffolds are porous three-dimensional supports, designed to mimic the extracellular environment and remain temporarily integrated into the host tissue while stimulating, at the molecular level, specific cellular responses to each type of body tissues. The major goal of the research work entertained herein was to study the microstructure of scaffolds made from chitosan (Ch), blends of chitosan and sodium alginate (Ch/NaAlg), blends of chitosan, sodium alginate and calcium chloride (Ch/NaAlg/CaCl2) and blends of chitosan, sodium alginate and hydroxyapatite (Ch/NaAlg/HA). Scaffolds possessing ideal physicochemical properties facilitate cell proliferation and greatly increase the rate of recovery of a damaged organ tissue. Using CT three-dimensional images of the scaffolds, it was observed that all scaffolds had a porosity in the range 64%-92%, a radius of maximum pore occurrence in the range 95m-260m and a permeability in the range 1×10-10-18×10-10 m2. From the results obtained, the scaffolds based on Ch, Ch/NaAlg and Ch/NaAlg/CaCl2 would be most appropriate both for the growth of osteoid and for bone tissue regeneration, while the scaffold made with a blend of Ch/NaAlg/HA, by possessing larger pores size, might be used as a support for fibrovascular tissue.

Desenvolvimento de um protótipo didático de uma máquina de corte de pedra por fio diamantado

Dissertação de mestrado integrado em Engenharia Mecânica

Data analytics: abordagem para visualização da informação

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

A modernidade para além da utopia tecnológica

Dissertação de mestrado em Ciências da Comunicação (área de especialização em Comunicação, Cidadania e Educação)

Deposição não eletrolítica de filmes plasmónicos de ouro para biossensores

Dissertação de mestrado em Biofísica e Bionanossistemas

Sensitive label-free electron chemical capacitive transducer signal for D-dimer electroanalyses

Supplementary data associated with this article can be found, in the online version, at: http://dx.doi.org/10.1016/j.electacta.2015.09.169.

A design of experiments to assess phosphorous removal and crystal properties in struvite precipitation of source separated urine using different Mg sources

Supplementary data associated with this article can be found, in the online version, at: http://dx.doi.org/10.1016/j.cej.2016.03.148.

Modelo de gestão integrada dos contratos públicos eletrónicos orientados ao valor público

Tese de Doutoramento em Tecnologias e Sistemas de Informação.