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.

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.

Variation of the physicochemical and morphological characteristics of solvent casted poly(vinylidene fluoride) along its binary phase diagram with dimethylformamide

Poly(vinylidene fluoride), PVDF, films and membranes were prepared by solvent casting from dimethylformamide, DMF, by systematically varying polymer/solvent ratio and solvent evaporation temperature. The effect of the processing conditions on the morphology, degree of porosity, mechanical and thermal properties and crystalline phase of the polymer were evaluated. The obtained microstructure is explained by the Flory-Huggins theory. For the binary system, the porous membrane formation is attributed to a spinodal decomposition of the liquid-liquid phase separation. The morphological features were simulated through the correlation between the Gibbs total free energy and the Flory-Huggins theory. This correlation allowed the calculation of the PVDF/DMF phase diagram and the evolution of the microstructure in different regions of the phase diagram. Varying preparation conditions allow tailoring polymer 2 microstructure while maintaining a high degree of crystallinity and a large β crystalline phase content. Further, the membranes show adequate mechanical properties for applications in filtration or battery separator membranes.

Composition and structure variation for magnetron sputtered tantalum oxynitride thin films, as function of deposition parameters

Tantalum oxynitride thin films were produced by magnetron sputtering. The films were deposited usinga pure Ta target and a working atmosphere with a constant N2/O2ratio. The choice of this constant ratiolimits the study concerning the influence of each reactive gas, but allows a deeper understanding of theaspects related to the affinity of Ta to the non-metallic elements and it is economically advantageous.This work begins by analysing the data obtained directly from the film deposition stage, followed bythe analysis of the morphology, composition and structure. For a better understanding regarding theinfluence of the deposition parameters, the analyses are presented by using the following criterion: thefilms were divided into two sets, one of them produced with grounded substrate holder and the otherwith a polarization of −50 V. Each one of these sets was produced with different partial pressure of thereactive gases P(N2+ O2). All the films exhibited a O/N ratio higher than the N/O ratio in the depositionchamber atmosphere. In the case of the films produced with grounded substrate holder, a strong increaseof the O content is observed, associated to the strong decrease of the N content, when P(N2+ O2) is higherthan 0.13 Pa. The higher Ta affinity for O strongly influences the structural evolution of the films. Grazingincidence X-ray diffraction showed that the lower partial pressure films were crystalline, while X-rayreflectivity studies found out that the density of the films depended on the deposition conditions: thehigher the gas pressure, the lower the density. Firstly, a dominant -Ta structure is observed, for lowP(N2+ O2); secondly a fcc-Ta(N,O) structure, for intermediate P(N2+ O2); thirdly, the films are amorphousfor the highest partial pressures. The comparison of the characteristics of both sets of produced TaNxOyfilms are explained, with detail, in the text.

Gestão integrada dos recursos hídricos da região de Fafe: caracterização da qualidade das águas superficiais, potencial hidrogeológico das rochas fraturadas

Dissertação de mestrado em Geociências (área de especialização em Recursos Geológicos)