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.

Os efeitos do ambiente térmico: avaliação subjetiva e numérica

Dissertação de mestrado integrado em Engenharia e Gestão Industrial

Antibacterial activity of textiles for wound treatment

Major advances in the development and use of antimicrobial textiles to control bacterial proliferation on wound beds continue. However, wound dressings are, in general, not included in standardized regimens for measuring and monitoring their antimicrobial effectiveness. This work adapts these methods to assess the antibacterial activity of textiles designed for wound healing purposes. Environmental conditions representative of those present at the wound site (i.e., moisture levels, infection, and available nutrients) were evaluated. This work shows that moisture levels were the environmental factor that had the greatest influence on the antimicrobial agent activities tested. These results suggest that it is possible to use the more representative environmental conditions present on the wound bed for in vitro screening of textile antimicrobial activity.

Evaluation of antibacterial activity of caffeic acid encapsulated by -cyclodextrins

Context: Caffeic acid is described as antibacterial, but this bioactive molecule has some issues regarding solubility and stability to environmental stress. Thus, encapsulation devices are required. Objective: The aim of this work was to study the effect of the caffeic acid encapsulation by cyclodextrins on its antibacterial activity. Materials and methods: The interactions between the caffeic acid and three cyclodextrins (-cyclodextrin (CD), 2-hydroxypropyl--cyclodextrin (HPCD) and methyl--cyclodextrin were study. Results and discussion: The formation of an aqueous soluble inclusion complex was confirmed for CD and HPCD with a 1:1 stoichiometry. The CD/caffeic acid complex showed higher stability than HPCD/caffeic acid. Caffeic acid antibacterial activity was similar at pH 3 and pH 5 against the three bacteria (K. pneumoniae, S. epidermidis and S. aureus). Conclusions: The antibacterial activity of the inclusion complexes was described here for the first time and it was shown that the caffeic acid activity was remarkably enhanced by the cyclodextrins encapsulation.

Analysis of polydicyclopentadiene-metal hybrid adhesive joints for automotive exterior body applications

An exterior body panel solution containing a polydicyclopentadiene skin attached to an interior metallic reinforcement through adhesive bonding is being studied to be applied in the MobiCar bonnet. With this solution is expected to achieve lightness, adequate structural integrity and cost-efficiency. However, there is uncertainty regarding to the bonnet adhesiveness since different metallic materials and adhesive types are being considered for its development. Thus, in this paper, several samples are tested through shear loading with the aim of understanding the loading magnitude expected by using polydicyclopentadiene, steel DC04+ZE and aluminum alloy AW5754-H111 as substrates adhesively bonded by an epoxy or a methacrylate. Methacrylate adhesive have shown greater shear strength in all types of adhesive joints. PDCPD joints presented the highest displacements. Surface degradation was considered adequate over abrading once none strength difference was seen between the different surface treatments. Steel treated by cataphoresis has shown the highest joint interface strength.

Using a new developed die and different types of thermosetting resins to produce U200 profiles by pultrusion

In this work, a new steel heated pultrusion die was designed, developed and manufactured to produce U200 glass fibre reinforced thermosetting matrix (GRP) profiles. The finite element analysis (FEA) was used to predict and optimise the developed die heating by using cylindrical electrical powered cartridges. To assess the new die performance it was mounted in the 120 kN pultrusion line of the Portuguese company Vidropol SA and used to produce continuously U200 profiles able to meet all requirements specified for the E23 grade accordingly to the European Standard EN 13706: 2002. After setting up the type, orientation and sequence of layers in the U 200 laminate, different types of thermosetting resins were used in its production. Orthophthalic, isophthalic and bisphenolic unsaturated polyester as well as vinylester resins were used to produce glass fibre reinforced U 200 composite profiles. All applied resins were submitted to SPI gel tests in order to select the more appropriated catalyst system and optimise the processing variables to be used in each case, namely, pultrusion pull-speed and die temperature. The best pultrusion operational conditions were selected by varying and monitoring the pull-speed and die temperature and, at the same time, measuring the temperature on the manufactured U 200 profile during processing. Finally, the produced U200 profiles were submitted to visual inspection, calcination and mechanical tests, namely, flexural, tensional and interlaminar shear strength (ILSS) tests, to assess their accomplishment with the EN 13706 requirements.

The impact of work clothing design on workers’ comfort

Physical and physiological comfort, at work and during leisure time, is important to human health and motivation. A growing number of jobs require workers to sit. Most clothes, except those intended for wheelchair users, were designed for walking or the standing position. Clothing designs should be user-oriented and meet users’ needs. Garment design should conform to body position and posture, not just shape and size. In this paper we present the ergometric impact of a new type of trousers designed to adapt to changes in position. Concentrations of compression forces, temperature and pressure were documented in an exploratory pilot study and contrasted to traditional designs. The new trousers showed significant decreases in compression force concentration, especially in and around the knees and waist. Most participants identified comfort as an important factor when purchasing a pair of trousers and that, for working purposes, they would prefer these special trousers rather than traditional designs.

A relational algebra approach to ETL modeling

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

Measuring end-to-end delay in real-time auralisation systems

One of the major challenges in the development of an immersive system is handling the delay between the tracking of the user’s head position and the updated projection of a 3D image or auralised sound, also called end-to-end delay. Excessive end-to-end delay can result in the general decrement of the “feeling of presence”, the occurrence of motion sickness and poor performance in perception-action tasks. These latencies must be known in order to provide insights on the technological (hardware/software optimization) or psychophysical (recalibration sessions) strategies to deal with them. Our goal was to develop a new measurement method of end-to-end delay that is both precise and easily replicated. We used a Head and Torso simulator (HATS) as an auditory signal sensor, a fast response photo-sensor to detect a visual stimulus response from a Motion Capture System, and a voltage input trigger as real-time event. The HATS was mounted in a turntable which allowed us to precisely change the 3D sound relative to the head position. When the virtual sound source was at 90º azimuth, the correspondent HRTF would set all the intensity values to zero, at the same time a trigger would register the real-time event of turning the HATS 90º azimuth. Furthermore, with the HATS turned 90º to the left, the motion capture marker visualization would fell exactly in the photo-sensor receptor. This method allowed us to precisely measure the delay from tracking to displaying. Moreover, our results show that the method of tracking, its tracking frequency, and the rendering of the sound reflections are the main predictors of end-to-end delay.

Bimodal information increases spontaneous interpersonal synchronization of goal directed upper limb movements

When interacting with each other, people often synchronize spontaneously their movements, e.g. during pendulum swinging, chair rocking[5], walking [4][7], and when executing periodic forearm movements[3].Although the spatiotemporal information that establishes the coupling, leading to synchronization, might be provided by several perceptual systems, the systematic study of different sensory modalities contribution is widely neglected. Considering a) differences in the sensory dominance on the spatial and temporal dimension[5] , b) different cue combination and integration strategies [1][2], and c) that sensory information might provide different aspects of the same event, synchronization should be moderated by the type of sensory modality. Here, 9 naïve participants placed a bottle periodically between two target zones, 40 times, in 12 conditions while sitting in front of a confederate executing the same task. The participant could a) see and hear, b) see , c) hear the confederate, d) or audiovisual information about the movements of the confederate was absent. The couple started in 3 different relative positions (i.e., in-phase, anti-phase, out of phase). A retro-reflective marker was attached to the top of the bottles. Bottle displacement was captured by a motion capture system. We analyzed the variability of the continuous relative phase reflecting the degree of synchronization. Results indicate the emergence of spontaneous synchronization, an increase with bimodal information, and an influence of the initial phase relation on the particular synchronization pattern. Results have theoretical implication for studying cue combination in interpersonal coordination and are consistent with coupled oscillator models.

Sensorimotor synchronization when walking side by side with a point light walker

[Excerpt] Synchronization of periodic movements like side-by-side walking [7] is frequently modeled by coupled oscillators [5] and the coupling strength is defined quantitatively [3]. In contrast, in most studies on sensorimotor synchronization (SMS), simple movements like finger taps are synchronized with simple stimuli like metronomes [4]. While the latter paradigm simplifies matters and allows for the assessment of the relative weights of sensory modalities through systematic variation of the stimuli [1], it might lack ecological validity. Conversely, using more complex movements and stimuli might complicate the specification of mechanisms underlying coupling. We merged the positive aspects of both approaches to study the contribution of auditory and visual information on synchronization during side-by-side walking. As stimuli, we used Point Light Walkers (PLWs) and auralized steps sound; both were constructed from previously captured walking individuals [2][6]. PLWs were retro-projected on a screen and matched according to gender, hip height, and velocity. The participant walked for 7.20m side by side with 1) a PLW, 2) steps sound, or 3) both displayed in temporal congruence. Instruction to participants was to synchronize with the available stimuli. [...]

Extending the reservoir of bla IMP-5: the emerging pathogen Acinetobacter bereziniae

Acinetobacter bereziniae clinical relevance is starting to be recognized; however, very few descriptions of its carbapenem resistance currently exist. Here we characterize two carbapenem-resistant A. bereziniae isolates. Materials & methods: Isolates were obtained from environmental and clinical samples. Carbapenemases were searched by phenotypic, biochemical and PCR assays. Clonality was studied by ApaI-PFGE and genetic location for carbapenemase genes were assessed by I-CeuI and S1 hybridizations. Results: Isolates were not clonally related but both produced the exclusively Portuguese IMP-5, with the clinical isolate also producing an OXA-58. The carbapenemase genes were plasmid located. Conclusion: Our results emphasize the role of non-baumannii Acinetobacter species as important reservoirs of clinically relevant resistance genes that could also contribute to their emergence as nosocomial pathogens

Materiais de isolamento térmico de edifícios. Para além da energia operacional

The use of thermal insulation materials for the achievement of energy efficient buildings intended, in most cases, the fulfilment of the required heating and cooling needs of the operational phase. The main goal of this paper is â by using exploratory methodology, namely literature review â identify more sustainable insulating materials and, concomitantly, exposing the paradoxical effect of other insulation materials with high Global Warming Potential (GWP) highlighting the role of the Life Cycle Assessment (LCA), Ecodesign and Environmental Product Declaration (EPD) tools for the framing, comparison and selection of materials. As a main conclusion, it is noticed the lack of environmental information from the producers which, together with acquisition prices that do not internalize Life Cycle Costs (LCC), has led to the use of insulation materials with high carbon footprint and to the "isolation paradox" as well.

Effect of NaCl additive on solute-solvent interactions in aqueous polyethylene glycol-sodium sulfate two-phase systems

Abstract Partition behavior of eight small organic compounds and six proteins was examined in poly(ethylene glycol)-8000-sodium sulfate aqueous two-phase systems containing 0.215 M NaCl and 0.5 M osmolyte (sorbitol, sucrose, TMAO) and poly(ethylene glycol)-10000-sodium sulfate-0.215 M NaCl system, all in 0.01 M sodium phosphate buffer, pH 6.8. The differences between the solvent properties of the coexisting phases (solvent dipolarity/polarizability, hydrogen bond donor acidity, and hydrogen bond acceptor basicity) were characterized with solvatochromic dyes using the solvatochromic comparison method. Differences between the electrostatic properties of the phases were determined by analysis of partitioning of sodium salts of dinitrophenylated (DNP-) amino acids with aliphatic alkyl side-chain. The partition coefficients of all compounds examined (including proteins) were described in terms of solute-solvent interactions. The results obtained in the study show that solute-solvent interactions of nonionic organic compounds and proteins in polyethylene glycol-sodium sulfate aqueous two-phase system change in the presence of NaCl additive.

The importance of risk assessment in the context of investment project management: a case study

Risk management is an important component of project management. Nevertheless, such process begins with risk assessment and evaluation. In this research project, a detailed analysis of the methodologies used to treat risks in investment projects adopted by the Banco da Amazonia S.A. was made. Investment projects submitted to the FNO (Constitutional Fund for Financing the North) during 2011 and 2012 were considered for that purpose. It was found that the evaluators of this credit institution use multiple indicators for risk assessment which assume a central role in terms of decision-making and contribute for the approval or the rejection of the submitted projects; namely, the proven ability to pay, the financial records of project promotors, several financial restrictions, level of equity, level of financial indebtedness, evidence of the existence of a consumer market, the proven experience of the partners/owners in the business, environmental aspects, etc. Furthermore, the bank has technological systems to support the risk assessment process, an internal communication system and a unique system for the management of operational risk.