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.

Fractional pennes' bioheat equation: theoretical and numerical studies

In this work we provide a new mathematical model for the Pennes’ bioheat equation, assuming a fractional time derivative of single order. Alternative versions of the bioheat equation are studied and discussed, to take into account the temperature-dependent variability in the tissue perfusion, and both finite and infinite speed of heat propagation. The proposed bioheat model is solved numerically using an implicit finite difference scheme that we prove to be convergent and stable. The numerical method proposed can be applied to general reaction diffusion equations, with a variable diffusion coefficient. The results obtained with the single order fractional model, are compared with the original models that use classical derivatives.

Fractional bioheat equation

In this work we develop a new mathematical model for the Pennes’ bioheat equation assuming a fractional time derivative of single order. A numerical method for the solu- tion of such equations is proposed, and, the suitability of the new model for modelling real physical problems is studied and discussed

Comparison of different numerical methods for the solution of the time-fractional reaction-diffusion equation with variable diffusion coefficient

In this work we perform a comparison of two different numerical schemes for the solution of the time-fractional diffusion equation with variable diffusion coefficient and a nonlinear source term. The two methods are the implicit numerical scheme presented in [M.L. Morgado, M. Rebelo, Numerical approximation of distributed order reaction- diffusion equations, Journal of Computational and Applied Mathematics 275 (2015) 216-227] that is adapted to our type of equation, and a colocation method where Chebyshev polynomials are used to reduce the fractional differential equation to a system of ordinary differential equations

A relational algebra approach to ETL modeling

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

Da modelação matemática à simulação computacional: a experimentação matemática no ensino

Tese de Doutoramento em Ciências (área de especialização em Matemática).

Da modelação matemática à simulação computacional: a experimentação matemática no ensino

Tese de Doutoramento em Ciências (área de especialização em Matemática).

Recurrence relations for Clifford algebra-valued orthogonal polynomials

The theory of orthogonal polynomials of one real or complex variable is well established as well as its generalization for the multidimensional case. Hypercomplex function theory (or Clifford analysis) provides an alternative approach to deal with higher dimensions. In this context, we study systems of orthogonal polynomials of a hypercomplex variable with values in a Clifford algebra and prove some of their properties.

A linear algebra approach to OLAP

Inspired by the relational algebra of data processing, this paper addresses the foundations of data analytical processing from a linear algebra perspective. The paper investigates, in particular, how aggregation operations such as cross tabulations and data cubes essential to quantitative analysis of data can be expressed solely in terms of matrix multiplication, transposition and the Khatri–Rao variant of the Kronecker product. The approach offers a basis for deriving an algebraic theory of data consolidation, handling the quantitative as well as qualitative sides of data science in a natural, elegant and typed way. It also shows potential for parallel analytical processing, as the parallelization theory of such matrix operations is well acknowledged.

Historical analysis of the Brazilian cervical cancer screening program from 2006 to 2013: a time for reflection

BACKGROUND: The Cervical Cancer Database of the Brazilian National Health Service (SISCOLO) contains information regarding all cervical cytological tests and, if properly explored, can be used as a tool for monitoring and managing the cervical cancer screening program. The aim of this study was to perform a historical analysis of the cervical cancer screening program in Brazil from 2006 to 2013. MATERIAL AND METHODS: The data necessary to calculate quality indicators were obtained from the SISCOLO, a Brazilian health system tool. Joinpoint analysis was used to calculate the annual percentage change. RESULTS: We observed important trends showing decreased rates of low-grade squamous intraepithelial lesions (LSIL) and high-grade squamous intraepithelial lesions (HSIL) and an increased rate of rejected exams from 2009 to 2013. The index of positivity was maintained at levels below those indicated by international standards; very low frequencies of unsatisfactory cases were observed over the study period, which partially contradicts the low rate of positive cases. The number of positive cytological diagnoses was below that expected, considering that developed countries with low frequencies of cervical cancer detect more lesions annually. CONCLUSIONS: The evolution of indicators from 2006 to 2013 suggests that actions must be taken to improve the effectiveness of cervical cancer control in Brazil.

Rheological characterization of EVA and HDPE polymer modified bitumens under large deformation at 20 º C

Large amplitude oscillatory shear (LAOS) coupled with Fourier transform rheology (FTR) was used for the first time to characterize the large deformation behavior of selected bituminous binders at 20 C. Two polymer modified bitumens (PMB) containing recycled EVA and HDPE and two unmodified bitumens were tested with LAOS-FTR. The LAOS-FTR response of all binders was compared at same frequency, at same Deborah number (by tuning the frequency to the relaxation time of each binder) and at same phase shift angle d (by tuning the frequency to the one corresponding to d = 50 in the SAOS response of each sample). In all the approaches, LAOS-FTR results allowed to differentiate between all the nonlinear mechanical characteristics of the tested binders. All binders show LAOS-FTR patterns reminiscent from colloidal dispersions and emulsions. EVA PMB was less prone to strain-induced microstructural changes when compared to HDPE PMB which showed larger values of nonlinear FTR parameters for the range of shear strains tested in LAOS.

Enzymatic hydrophobic modification of jute fibers via grafting to reinforce composites

Horseradish peroxidase (HRP)/H2O2 system catalyzes the free-radical polymerization of aromatic compounds such as lignins and gallate esters. In this work, dodecyl gallate (DG) was grafted onto the surfaces of lignin-rich jute fabrics by HRP-mediated oxidative polymerization with an aim to enhance the hydrophobicity of the fibers. The DG-grafted jute fibers and reaction products of their model compounds were characterized by matrix-assisted laser desorption/ionization mass spectrometry (MALDI-TOF MS), attenuated total reflection Fourier transform infrared spectroscopy (ATR-FTIR), X-ray photoelectron spectroscopy (XPS), scanning electron microscopy (SEM), thermogravimetric analysis (TGA), and differential scanning calorimetry (DSC). The results clearly indicated the grafting of DG to the jute fiber by HRP. Furthermore, the hydrophobicity of jute fabrics was determined by measuring the wetting time and static contact angle. Compared to the control sample, the wetting time and static contact angle of the grated fabrics changed from ~1 s to 1 h and from ~0° to 123.68°, respectively. This clearly proved that the hydrophobicity of jute fabrics improved considerably. Conditions of the HRP-catalyzed DG-grafting reactions were optimized in terms of the DG content of modified jute fabrics. Moreover, the results of breaking strength and elongation of DG-grafted jute/ polypropylene (PP) composites demonstrated improved reinforcement of the composite due to enzymatic hydrophobic modification of jute fibers.

On modified simple reacting spheres kinetic model for chemically reactive gases

Versão dos autores para esta publicação.

K-invariantes en el algebra universal de un grupo de Lie semisimple

Tarea (A):(...) Trataremos de extender a Sp(n,1) los resultados conseguidos sobre la imagen del homomorfismo de Lepowsky cuando G es SO(n,1) ó SU(n,1). (...) Tarea (B): (...) Para todo grupo de Lie de rango uno, con rango (G) = rango (K), los elementos del álgebra B son W-invariantes y que este resultado ya ha sido establecido para los grupos SO(2n,1) y SU(n,1); durante el período correspondiente a este subsidio esperamos extender este resultado a todo grupo de Lie de rango uno con rango (G) = rango (K). Tarea (C): Durante este período esperamos también avanzar en la determinación del dual unitario del grupo Spin (2n,C).

Diseño y desarrollo de superficies modificadas. Aplicaciones ambientales, biomédicas y farmacéuticas. Design and development of modified surfaces. Environmental, biomedical and pharmaceutical applications.

El objetivo general de este proyecto de investigación es diseñar, desarrollar y optimizar superficies con propiedades especificas para ser utilizadas como sensores y biosensores, materiales biocompatibles, columnas para separaciones por electroforesis capilar, matrices para la liberación controlada de fármacos y sorbentes para remediación ambiental. Para concretar este objetivo, se propone específicamente modificar superficies o particulas apuntando a optimizar un sistema concreto relevante en aplicaciones farmaceuticas, ambientales o biomedicas: 1. Modificacion de arcillas naturales o sinteticas para desarrollar matrices portadoras de farmacos o sorbentes para remediacion ambiental:1.1 Estudiar ilitas modificadas con Fe(III) para maximizar las propiedades adsortivas frente a aniones contaminantes como arsenico. 1.2 Sintetizar LDH de Al y Mg modificados con compuestos de interés farmacéutico para diseñar sistemas de liberación controlada.2. Modificación de canales de chips y electrodos para optimizar la separación, detección y cuantificación de compuestos farmacéutico: 2.1 Diseñar y construir microchips para la separación por EC de compuestos de base fenólica.2.2 Evaluar polímeros que mejoren la respuesta y/o estabilidad de electrodos de Carbono para ser usados como detectores amperométrico de compuestos de base fenólica en sistemas FIA y miniaturizados de análisis integrados.3. Modificación de superficies sólidas con biomoléculas para el desarrollo y optimización de superficies de bio-reconocimiento:3.1 Evaluar el comportamiento de superficies de titanio modificadas con TiO2 y depósitos inorgánicos frente a la interacción con proteínas plasmáticas (PP) para el análisis de la biocompatibilidad superficial.3.2 Diseñar y desarrollar superficies biofuncionales para el reconocimiento especifico de D-aminoácidos, anticuerpos en pacientes chagásicos y simple hebra de ADN. Las técnicas que se emplearán para llevar a cabo el proyecto dependen del tipo de sistema de estudio. En particular los estudios correspondientes al objetivo 1 se realizarán mediante análisis químicos, térmico, DXR, SEM, IR, BET así como mediante titulaciones ácido-base potenciométricas, movilidades electroforéticas, cinética e isotermas de adsorción.En general para desarrollar el objetivo 2 se utilizarán técnicas electroquímicas clásicas para la caracterización de los electrodos, los que luego se utilizarán como detectores en un sistema FIA amperométrico, mientras que los microchips se emplearán en electroforesis capilar para la separación de diferentes compuestos de interés farmacéutico.Finalmente, el objetivo 3 se llevará a cabo por un lado modificando electrodos de titanio con distintos depósitos (electroquímicas, sol-gel, térmicas) de TiO2 e hidroxiapatita y evaluando la interacción con proteínas plasmáticas para analizar la biocompatibilidad de los materiales preparados. Por otro lado, se estudiará el proceso de adsorción-desorción de D-aminoácido oxidasa, antígenos del T. Cruzi y ADN de simple hebra para optmizar la capacidad de bio-reconocimiento superficial de D-aminoácidos, anticuerpos de chagásicos y de cadena complementaria de ADN. Para concretar este objetivo se utilizarán técnicas electroquímicas, espectroscópicas y microscopias.Debido al carácter multidisciplinario del presente proyecto de investigación, su ejecución se llevara a cabo a través de la colaboración de investigadores pertenecientes a distintas áreas de la Química y permitirá continuar con la formación de recursos humanos mediante la realización de tesis doctorales y estadías postdoctorales.