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.

Modeling separator membranes physical characteristics for optimized lithium ion battery performance

The effect of varying separator membrane physical parameters such as degree of porosity, tortuosity and thickness, on battery delivered capacity was studied in order to optimize performance of lithium-ion batteries. This was achieved by a theoretical mathematical model relating the Bruggeman coefficient with the degree of porosity and tortuosity. The inclusion of the separator membrane in the simulation model of the battery system does not affect the delivered capacity of the battery. The ionic conductivity of the separator and consequently the delivered capacity values obtained at different discharge rates depends on the value of the Bruggeman coefficient, which is related with the degree of porosity and tortuosity of the membrane. Independently of scan rate, the optimal value of the degree of porosity is above 50% and the separator thickness should range between 1 μm at 32 μm for improved battery performance.

Microfluidic based on aqueous two-phase system for plasmidic DNA purification

Dissertação de mestrado em Bioquímica Aplicada (área de especialização em Biotecnologia)

Psychosocial adjustment and physical health in children of divorce

Objective: To review the literature on the effects of parental divorce over the psychological maladjustment and physical health problems in children of divorced parents, thus contributing to the integration of existing scientific knowledge based on the biopsychosocial model of the impact of divorce on children’s physical health as proposed by Troxel and Matthews (2004). Sources: Review of the literature using MEDLINE and PsycInfo (1980-2007) databases, selecting the most representative articles on the subject. Special attention was paid to contributions by internationally renowned investigators on the subject. Summary of the findings: Divorce may be responsible for a decline of physical and psychological health in children. The developmental maladjustment of children is not triggered by divorce itself, but rather by other risk factors associated with it, such as interparental conflict, parental psychopathology, decline in socio-economic level, inconsistency in parenting styles, a parallel and conflicting co-parenting relationship between parents and low levels of social support. Such risk factors trigger maladjusted developmental pathways, marked by psychopathological symptoms, poor academic performance, worst levels of physical health, risk behavior, exacerbated psychophysiological responses to stress and weakening of the immune system. Conclusions: Clear links were observed between experiencing parental divorce and facing problems of physical and psychological maladjustment in children. Divorce is a stressor that should be considered by health professionals as potentially responsible for maladjusted neuropsychobiological responses and for decline in children’s physical health.