A domain-specific language for ETL patterns specification in Data Warehousing Systems

During the last few years many research efforts have been done to improve the design of ETL (Extract-Transform-Load) systems. ETL systems are considered very time-consuming, error-prone and complex involving several participants from different knowledge domains. ETL processes are one of the most important components of a data warehousing system that are strongly influenced by the complexity of business requirements, their changing and evolution. These aspects influence not only the structure of a data warehouse but also the structures of the data sources involved with. To minimize the negative impact of such variables, we propose the use of ETL patterns to build specific ETL packages. In this paper, we formalize this approach using BPMN (Business Process Modelling Language) for modelling more conceptual ETL workflows, mapping them to real execution primitives through the use of a domain-specific language that allows for the generation of specific instances that can be executed in an ETL commercial tool.

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.

A relational algebra approach to ETL modeling

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

Thermal–mechanical behaviour of chitosan–cellulose derivative thermoreversible hydrogel films

CH, Chitosan; HPMC, (Hydroxypropyl)methyl cellulose; FT, Freeze-thaw; SC, Solvent casting; CH:HPMC (X:Y), pH Z, FT/SC, Chitosan and (hydroxypropyl)methyl cellulose hydrogel, at X and Y proportion (0-100), at Z pH (3.0-4.0) and prepared by freeze-thaw or solvent casting techniques; DSC, Differential scanning calorimetry; MDSC, Temperature modulated Differential scanning calorimetry; Tg, glass transition temperature; ΔH, enthalpy change; TGA, Thermogravimetric Analysis; TG, Thermogravimetry; DTG, Derivative or Differential thermogravimetry; σ, Tensile strength; ε, elongation at break; DMA, Dynamic mechanical analysis; X-Ray, X-radiation, FTIR-ATR, Attenuated total reflectance Fourier transform infrared spectroscopy; SEM, Scanning electron microscopy.

Erratum to: Thermal–mechanical behaviour of chitosan–cellulose derivative thermoreversible hydrogel films

CH, Chitosan; HPMC, (Hydroxypropyl)methyl cellulose; FT, Freeze-thaw; SC, Solvent casting; CH:HPMC (X:Y), pH Z, FT/SC, Chitosan and (hydroxypropyl)methyl cellulose hydrogel, at X and Y proportion (0-100), at Z pH (3.0-4.0) and prepared by freeze-thaw or solvent casting techniques; DSC, Differential scanning calorimetry; MDSC, Temperature modulated Differential scanning calorimetry; Tg, glass transition temperature; ΔH, enthalpy change; TGA, Thermogravimetric Analysis; TG, Thermogravimetry; DTG, Derivative or Differential thermogravimetry; σ, Tensile strength; ε, elongation at break; DMA, Dynamic mechanical analysis; X-Ray, X-radiation, FTIR-ATR, Attenuated total reflectance Fourier transform infrared spectroscopy; SEM, Scanning electron microscopy.

Microencapsulation of ellagic acid from pomegranate husk and karaya gum by spray drying

Objective: The aim of this study was to obtain and characterize microcapsules with Ellagic Acid (EA) from pomegranate as core material and Karaya Gum (KG) as wall material. Methods: EA was obtained from dry pomegranate peel powder via methanolysis and quantified by HPLC. Microcapsules were obtained preparing a dispersion containing KG and EA in phosphate buffer pH 8. The dispersion was processed in a spray dryer under specific conditions (inlet temperature at 150 °C, feed flow at 30% and aspirator at 100 %) for obtaining of microcapsules. Fourier transform infrared (FTIR) spectroscopy, differential scanning calorimetry (DSC) and scanning electron microscopy (SEM) were used for characterization. Results: Obtained material contains 98.03±2.82 mg EA/g of pomegranate peel. FTIR showed that there were changes in the molecular structure of microcapsules referred to raw materials. SEM confirmed that particles obtained had micron-size (1-5 µm). DSC analysis showed that raw materials had glass transition temperatures of 79.58 and 83.41 °C and for microcapsules the value was67.25 °C. Conclusion: Methanolysis is a viable technique for the obtaining of EA from the peel of pomegranate. KG shows good potential for be used as wall material for EA microencapsulation.

Caracterização química e física de conformal coatings envolvidos na produção de PCBA's

Dissertação de mestrado integrado em Engenharia de Materiais

Enzymatic phosphorylation of hair keratin enhances fast adsorption of cationic moieties

The current study describes the in vitro phosphorylation of a human hair keratin, using protein kinase for the first time. Phosphorylation of keratin was demonstrated by 31P NMR (Nuclear Magnetic Resonance) and Diffuse Reflectance Infrared Fourier Transform (DRIFT) techniques. Phosphorylation induced a 2.5 fold increase of adsorption capacity in the first 10 minutes for cationic moiety like Methylene Blue (MB). Thorough description of MB adsorption process was performed by several isothermal models. Reconstructed fluorescent microscopy images depict distinct amounts of dye bound to the differently treated hair. The results of this work suggest that the enzymatic phosphorylation of keratins might have significant implications in hair shampooing and conditioning, where short application times of cationic components are of prime importance.

Degradação fotocatalítica de petróleo e seus derivados através da utilização de nanopartículas de dióxido de titânio puro e misturado com óxido de grafeno reduzido

Dissertação de mestrado integrado em Engenharia de Materiais

Para uma pedagogia das literacias: das conceções e práticas docentes aos conceitos e competências discentes. Um estudo da aula de língua portuguesa no 2º ciclo do ensino básico

Tese de Doutoramento em Ciências da Educação (Especialidade em Literacias e Ensino do Português)

Big data e data analysis: visualização de informação

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

Study to determine the cardiovascular risk ofthe population of Guimarães/Vizela, includingthe prevalence of arterial stiffness and early vascular aging syndrome

Tese de Doutoramento em Medicina.

Analysis of physicochemical interaction between the components of asphalt mixtures with rubber

Tese de Doutoramento em Engenharia Civil

Indicadores chave de sustentabilidade para edifícios residenciais em estrutura metálica

Dissertação de mestrado integrado em Engenharia Civil

The impact of depression on survival of Parkinson's disease patients: a five-year study

OBJECTIVE: The aim of this study is to evaluate the survival rate in a cohort of Parkinson's disease patients with and without depression. METHODS: A total of 53 Parkinson's disease subjects were followed up from 2003-2008 and 21 were diagnosed as depressed. Mean time of follow up was 3.8 (SD 95% = 1.5) years for all the sample and there was no significant difference in mean time of follow up between depressed and nondepressed Parkinson's disease patients. Survival curves rates were fitted using the Kaplan-Meier method. In order to compare survival probabilities according to the selected covariables the Log-Rank test was used. Multivariate analysis with Cox regression was performed aiming at estimating the effect of predictive covariables on the survival. RESULTS: The cumulative global survival of this sample was 83% with nine deaths at the end of the study - five in the depressed and four in the nondepressed group, and 55.6% died in the first year of observation, and none died at the fourth and fifth year of follow up. CONCLUSION: Our finding point toward incremental death risk in depressed Parkinson's disease patients.