Using relational algebra on the specification of real world ETL processes

Modeling Extract-Transform-Load (ETL) processes of a Data Warehousing System has always been a challenge. The heterogeneity of the sources, the quality of the data obtained and the conciliation process are some of the issues that must be addressed in the design phase of this critical component. Commercial ETL tools often provide proprietary diagrammatic components and modeling languages that are not standard, thus not providing the ideal separation between a modeling platform and an execution platform. This separation in conjunction with the use of standard notations and languages is critical in a system that tends to evolve through time and which cannot be undermined by a normally expensive tool that becomes an unsatisfactory component. In this paper we demonstrate the application of Relational Algebra as a modeling language of an ETL system as an effort to standardize operations and provide a basis for uncommon ETL execution platforms.

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.

Improvign mixing processes with the help of numerical tools

In several industrial applications, highly complex behaviour materials are used together with intricate mixing processes, which difficult the achievement of the desired properties for the produced materials. This is the case of the well-known dispersion of nano-sized fillers in a melt polymer matrix, used to improve the nanocomposite mechanical and/or electrical properties. This mixing is usually performed in twin-screw extruders, that promote complex flow patterns, and, since an in loco analysis of the material evolution and mixing is difficult to perform, numerical tools can be very useful to predict the evolution and behaviour of the material. This work presents a numerical based study to improve the understanding of mixing processes. Initial numerical studies were performed with generalized Newtonian fluids, but, due to the null relaxation time that characterize this type of fluids, the assumption of viscoelastic behavior was required. Therefore, the polymer melt was rheologically characterized, and, a six mode Phan-Thien-Tanner and Giesekus models were used to fit the rheological data. These viscoelastic rheological models were used to model the process. The conclusions obtained in this work provide additional and useful data to correlate the type and intensity of the deformation history promoted to the polymer nanocomposite and the quality of the mixing obtained.

Ag-TiNx electrodes deposited on piezoelectric poly(vinylidene fluoride) for biomedical sensor applications

Electroactive polymers are one of the most interesting class of polymers used as smart materials in various applications, such as the development of sensors and actuators for biomedical applications in areas such as smart prosthesis, implantable biosensors and biomechanical signal monitoring, among others. For acquiring or applying the electrical signal from/to the piezoelectric material, suitable electrodes can be produced from Ti based coatings with tailored multifunctional properties, conductivity and antibacterial characteristics, through Ag inclusions. This work reports on Ag-TiNx electrodes, deposited by d. c. and pulsed magnetron sputtering at room temperature on poly(vinylidene fluoride), PVDF, the all-round best piezoelectric polymer.. Composition of the electrodes was assessed by microanalysis X-ray system (EDS - energy dispersive spectrometer). The XRD results revealed that the deposition conditions preserve the polymer structure and suggested the presence of crystalline fcc-TiN phase and fcc-Ag phase in samples with N2 flow above 3 sccm. According to the results obtained from SEM analysis, the coatings are homogeneous and Ag clusters were found for samples with nitrogen flow above 3 sccm. With increasing nitrogen flow, the sheet resistivity tend to be lower than the samples without nitrogen, leading also to a decrease of the piezoelectric response. It is concluded that the deposition conditions do significantly affect the piezoelectric polymer, which maintain its characteristics for sensor/actuator applications.

Ion exchange dependent electroactive phase content and electrical properties of poly(vinylidene fluoride)/Na(M)Y composites

Different metal-ion exchanged NaY zeolite, Na(M)Y, were used to prepare poly(vinylidene fluoride) based composites by solvent casting and melting crystallization. The effect of different metal ion-exchanged zeolites on polymer crystallization and electrical properties was reported. Cation-framework interactions and hydration energy of the cations determined that K+ is the most efficient exchanged ion in NaY zeolite, followed by Cs+ and Li+. The electroactive phase crystallization strongly depends on the ions present in the zeolite, leading to variations of the surface energy characteristics of the Na(M)Y zeolites and the polymer chain ability of penetration in the zeolite. Thus, Na(Li)Y and NaY induces the complete electroactive -phase crystallization of the crystalline phase of PVDF, while Na(K)Y only induces it partly and Na(Cs)Y is not able to promote the crystallization of the electroactive phase. Furthermore, different ion size/weigh and different interaction with the zeolite framework results in significant variations in the electrical response of the composite. In this way, iinterfacial polarization effects in the zeolite cavities and zeolite-polymer interface, leads to strong increases of the dielectric constant on the composites with lightest ions weakly bound to the zeolite framework. Polymer composite with Na(Li)Y show the highest dielectric response, followed by NaY and Na(K)Y. Zeolite Na(Cs)Y contribute to a decrease of the dielectric constant of the composite. The results show the relevance of the materials for sensor development.

Degradation of all-inkjet-printed organic thin-film transistors with TIPS-pentacene under processes applied in textile manufacturing

Printed electronics represent an alternative solution for the manufacturing of low-temperature and large area flexible electronics. The use of inkjet printing is showing major advantages when compared to other established printing technologies such as, gravure, screen or offset printing, allowing the reduction of manufacturing costs due to its efficient material usage and the direct-writing approach without requirement of any masks. However, several technological restrictions for printed electronics can hinder its application potential, e.g. the device stability under atmospheric or even more stringent conditions. Here, we study the influence of specific mechanical, chemical, and temperature treatments usually appearing in manufacturing processes for textiles on the electrical performance of all-inkjet-printed organic thin-film transistors (OTFTs). Therefore, OTFTs where manufactured with silver electrodes, a UV curable dielectric, and 6,13-bis(triisopropylsilylethynyl) pentance (TIPS-pentacene) as the active semiconductor layer. All the layers were deposited using inkjet printing. After electrical characterization of the printed OTFTs, a simple encapsulation method was applied followed by the degradation study allowing a comparison of the electrical performance of treated and not treated OTFTs. Industrial calendering, dyeing, washing and stentering were selected as typical textile processes and treatment methods for the printed OTFTs. It is shown that the all-inkjet-printed OTFTs fabricated in this work are functional after their submission to the textiles processes but with degradation in the electrical performance, exhibiting higher degradation in the OTFTs with shorter channel lengths (L=10 μm).

One-step in situ synthesis of polyamide microcapsules with inorganic payload and their transformation into responsive thermoplastic composite materials

Well-dispersed loads of finely powdered metals, metal oxides, several carbon allotropes or nanoclays are incorporated into highly porous polyamide 6 microcapsules in controllable amounts via an original one-step in situ fabrication technique. It is based on activated anionic polymerization (AAP) of ε-caprolactam in a hydrocarbon solvent performed in the presence of the respective micro- or nanosized loads. The forming microcapsules with typical diameters of 25-50 µm entrap up to 40 wt% of load. Their melt processing produces hybrid thermoplastic composites. Mechanical, electric conductivity and magnetic response measurements show that transforming of in situ loaded microcapsules into composites by melt processing (MP) is a facile and rapid method to fabricate materials with high mechanical resistance and electro-magnetic characteristics sufficient for many industrial applications. This novel concept requires low polymerization temperatures, no functionalization or compatibilization of the loads and it is easy to scale up at industrial production levels.

Towards "green" smart materials for force and strain sensors: The case of polyaniline

Stress/strain sensors constitute a class of devices with a global ever-growing market thanks to their use in many fields of modern life. They are typically constituted by thin metal foils deposited on flexible supports. However, the low inherent resistivity and limited flexibility of their constituents make them inadequate for several applications, such as measuring large movements in robotic systems and biological tissues. As an alternative to the traditional compounds, in the present work we will show the advantages to employ a smart material, polyaniline (PANI), prepared by an innovative environmentally friendly route, for force/strain sensor applications wherein simple processing, environmental friendliness and sensitivity are particularly required.

Mechanical, fatigue and wear properties of sintered Carbon Nanotube-based functionally graded materials

Tese de Doutoramento Engenharia Mecânica

Spatio-temporal modelling of environmental data

Programa Doutoral em Matemática e Aplicações.

Coagulation/flocculation/flotation/nanofiltration processes using Moringa Oleifera as coagulant of Eutrophized river

This study investigated the efficiency of Moringa oleifera (MO) seeds as natural coagulant in coagulation/flocculation/dissolved air flotation (C/F/DAF), followed by nanofiltration (NF) for Microcystis protocystis and microcystin-LR removal. The methodology adopted in this work was performed in two steps: 1) coagulation/flocculation/dissolved air flotation (C/F/DAF) process using the MO extracted in saline solution of potassium chloride (KCl-1M) and sodium chloride (NaCl-1M) in optimum dosage 50 mg·L-1; 2) nanofiltration process using NF90 and NF270 membrane provided Dow Chemical Company®. A working pressure of 8 bar was applied. In all samples were analyzed color, turbidity, pH, cyanobacterial cells count and microcystin concentration. The use of MO seeds as natural coagulant, obtained satisfactory results in the M. protocystis, color and turbidity removal. NF was able to completely remove cyanobacterial cells and microcystins (100 %) from M. protocystis (always under the quantification limit). Therefore, C/F/DAF+NF sequence is a safe barrier against M. protocystis and microcystins in drinking water.

Global warming in Amazonia: impacts and Mitigation

Global warming has potentially catastrophic impacts in Amazonia, while at the same time maintenance of the Amazon forest offers one of the most valuable and cost-effective options for mitigating climate change. We know that the El Niño phenomenon, caused by temperature oscillations of surface water in the Pacific, has serious impacts in Amazonia, causing droughts and forest fires (as in 1997-1998). Temperature oscillations in the Atlantic also provoke severe droughts (as in 2005). We also know that Amazonian trees die both from fires and from water stress under hot, dry conditions. In addition, water recycled through the forest provides rainfall that maintains climatic conditions appropriate for tropical forest, especially in the dry season. What we need to know quickly, through intensified research, includes progress in representing El Niño and the Atlantic oscillations in climatic models, representation of biotic feedbacks in models used for decision-making about global warming, and narrowing the range of estimating climate sensitivity to reduce uncertainty about the probability of very severe impacts. Items that need to be negotiated include the definition of "dangerous" climate change, with the corresponding maximum levels of greenhouse gases in the atmosphere. Mitigation of global warming must include maintaining the Amazon forest, which has benefits for combating global warming from two separate roles: cutting the flow the emissions of carbon each year from the rapid pace of deforestation, and avoiding emission of the stock of carbon in the remaining forest that can be released by various ways, including climate change itself. Barriers to rewarding forest maintenance include the need for financial rewards for both of these roles. Other needs are for continued reduction of uncertainty regarding emissions and deforestation processes, as well as agreement on the basis of carbon accounting. As one of the countries most subject to impacts of climate change, Brazil must assume the leadership in fighting global warming.

Narrative change in Gloria Films: Comparing various processes of therapeutic innovation

Aims: The present study focuses on the analysis of novelty emergence in classic Gloria Films with Rogers, Perls, and Ellis to understand how the same client formulated her own problem and if and how change occurred in those three sessions. Method: The Innovative Moments Coding System was applied to track innovative moments (IMs) and their themes. Results: The session with Rogers showed more diversity in disclosed problems and themes of IMs, as well as a higher proportion of reflection IMs. The session with Perls demonstrated a high proportion of protest IMs. The session with Ellis showed less innovation than other sessions. The changes found were based mostly on reflection and protest IMs in three sessions. Conclusion: Narrative innovations occurred in the three single sessions. The type of dominant innovation is consistent with the therapeutic model and the IMs model. The exploration of the IMs’ themes allowed a more precise identification of Gloria's new narrative positions and their development throughout those sessions.

Implementação de um sistema de gestão e monitorização de embalagens retornáveis em ambiente industrial

Dissertação de mestrado em Engenharia de Sistemas

Desenvolvimento de um modelo de rotatividade numa indútria do setor Metalomecânico

Dissertação de mestrado em Engenharia Humana