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

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.

Form tutors in the joint teaching of music: perspectives and experiences

In the Portuguese school system, form tutors (FTs) are an intermediate education management structure. The form tutor is responsible for a position of coordination and orientation with a «threefold function»: a relationship with students, relationship with the student’s family and relationship with other class teachers. The joint teaching of music is a part of the educational system in basic education. It is optional and provides musical and instrumental training to students who are interested in taking it. In order to achieve this, there is a system, subject to protocols, between general education schools and schools specializing in teaching music. There is also the position of FT in specialized schools and it also includes a «threefold function». However, these FTs have the additional role of representing music teachers at the class council, which is held at the general education school. Thus, in these cases, both FTs have a fourth joint area, between the music school and the general education school, which makes the relationship between them even more complex. This paper is based on the analysis of empirical data obtained from the testimonies of FTs regarding their representations and experiences in leadership and the coordination of teachers among schools in which there is a joint teaching system. The aim of collecting narratives is to look into some of the main challenges and confrontations related to leadership issues, which we assume to be the focus of those who have the role of form tutor in that specific context.

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.

Biographical narratives in teaching: a study of rofessors on postgraduate courses

Literature and research have shown that professional development constitutes an essential dimension in constructing both work and professional identity. An important aspect in such development is training. In the field of adult education, different authors (Pratt, 1993; Mezirow, 1985; Schön, 1996; Silva, 2007) emphasize the importance of placing trainees at the center of the learning and cognitive processes and within their corresponding social and historical contexts. Training is supported by a comprehensive adult learning theory. Therefore, the acquired knowledge is not only the result of an external and objective reality but also of a complex construction in which the appropriation of experience plays a relevant role. This paper reveals the findings obtained through biographical narratives in a five-year work program with teachers at different levels (from pre-school to higher education) on postgraduate courses. The core issue is the importance of biographical narratives, as an identification strategy for personal experience, knowledge construction and professional identity. This strategy provided the opportunity for recognition of practical experience, as a provider of learning, as well as his/her own authorship, which are important conditions in the understanding of professional identity.