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.

Modification of microfiltration membranes by hydrogel impregnation for pDNA purification

The huge efforts for the achievement of highly purified biomolecules are growing every day. A great number of efficient techniques, such as chromatography, are already available in laboratory for separation processes. However, membrane-based technologies are the best match to assure simplicity, efficiency and easy scale-up procedures. Herein we report the modification of a commercial microfiltration membrane for plasmid DNA purification by agarose gel impregnation. The membrane was characterized by SEM, ATR-FTIR, EDS, contact angle, and porosity measurements. Additionally, the membrane pore radius was estimated from observed rejections of different proteins and with that information the rejection of a 6050 bp plasmid DNA (pDNA) molecule was estimated for different values of flux using a theoretical model of large flexible molecules in membranes with parallel cylindrical pores, which is applicable to pDNA ultrafiltration in conventional membranes, as recently shown in the literature. The experimental results show that the modified membrane has higher pDNA rejections than the predicted by the model, suggesting that the different type of porous structure that a hydrogel has, may have a positive effect on pDNA rejections as compared to other biomolecules with more rigid structures, making this type of modified membranes potential better candidates to be used for the selective recovery of pDNA in this type of bioprocesses.

Multi-stacks of epitaxial GeSn self-assembled dots in Si: Structural analysis

We report on the growth and structural and morphologic characterization of stacked layers of self-assembled GeSn dots grown on Si (100) substrates by molecular beam epitaxy at low substrate temperature T = 350 °C. Samples consist of layers (from 1 up to 10) of Ge0.96Sn0.04 self-assembled dots separated by Si spacer layers, 10 nm thick. Their structural analysis was performed based on transmission electron microscopy, atomic force microscopy and Raman scattering. We found that up to 4 stacks of dots could be grown with good dot layer homogeneity, making the GeSn dots interesting candidates for optoelectronic device applications.

Sustentabilidade no Design: uma abordagem aos resíduos limpos das indústrias do calçado

Dissertação de mestrado em Design e Marketing

Laccase-catalyzed synthesis of conducting polyaniline-lignosulfonate composite

Enzymatic polymerization of aniline was first performed in lignosulfonate (LGS) template system. High-redox-potential catalyst laccase, isolated from Aspergillus, was used as a biocatalyst in the synthesis of conducting polyaniline/lignosulfonate (PANI-ES-LGS) complex using atmospheric oxygen as the oxidizing agent. The linear templates (LGS), also serving as the dopants, could facilitate the directional alignment of the monomer and improve the solubility of the conducting polymer. The process of the polymerization was monitored using UV-Vis spectroscopy, by which the conditions for laccase-catalyzed synthesis of PANI-ES-LGS complex were also optimized. The structure characterizations and solubility of the complex were carried out using corresponding characterization techniques respectively. The PANI-ES-LGS suspensions obtained was used as coating for cotton with a conventional padder to explore the applications of the complex. The variable optoelectronic properties of the coated cotton were confirmed by cyclic voltammetry and color strength test. The molecular weight changes of LGS treated by laccase were also studied to discuss the mechanism of laccase catalyzed aniline polymerization in LGS template system.

Potencial geopolítico da língua portuguesa para Timor-Leste

Dissertação de mestrado em Relações Internacionais

A realização do sujeito em complementos infinitivos de verbos causativos e percetivos no português língua de herança

Dissertação de mestrado em Ciências da Linguagem