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

La dimensione di diritto fondamentale della maternità nel Diritto dell’Unione: politiche europee di conciliazione della vita famigliare e della vita professionale in tempo di crisi

Dissertação de mestrado em Direito da União Europeia

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.

Controlled aggregation of gold nanoparticles in a di-ureasilmatrix. Optical and micro indentation investigation

Nanocomposite materials with an organic-inorganic urea-silicate (di-ureasil) based matrix containing gold nanoparticles (NPs) were synthesized and characterized by optical (UV/Vis) spectroscopy and indentation measurement. The urea silicate gels were obtained by reaction between silicon alkoxyde modified by isocyanate group and polyethylene glycol oligomer with amine terminal groups in presence of catalyst. The latter ensures the successful incorporation of citrate-stabilized gold NPs in the matrix. It is shown that using a convenient destabilizing agent (AgNO3) and governing the preparative conditions, the aggregation degree of gold NPs can be controlled. The developed synthesis procedure significantly simplifies the preparative procedure of gold/urea silicate nanocomposites, compared to the procedure using gold NPs, preliminary covered with silica shells. Mechanical properties of the prepared sample were characterised using depth sensing indentation methods (DSI) and an idea about the type of aggregation structures was suggested.

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.