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

Investigations on relational control of time perception

Tese de Doutoramento em Psicologia Básica

Epidemic store for massive scale systems

The MAP-i doctoral program of the Universities of Minho, Aveiro and Porto

Monitoring and analysis of queries in distributed databases

Dissertação de Mestrado em Engenharia Informática

7to77, A new database querying experience

Nowadays, the vulgarization of information and communication technologies has reached to a level that the majority of people spend a lot of time using software to do regular tasks, ranging from games and ordinary time and weather utilities to some more sophisticated ones, like retail or banking applications. This new way of life is supported by the Internet or by specific applications that changed the image people had about using information and communication technologies. All over the world, the first cycle of studies of educational systems also has been addressed with the justification that this encourages the development of children. Taking this into consideration, we design and develop a visual explorer system for relational databases that can be used by everyone, from “7 to 77”, in an intuitive and easy way, getting immediate results – a new database querying experience. Thus, in this paper we will expose the main characteristics and features of this visual database explorer, showing how it works and how it can be used to execute the most current data manipulation operations over a database.

As perceções das famílias de crianças com necessidades especiais sobre os benefícios da intervenção precoce: um estudo qualitativo com famílias de Braga

Dissertação de mestrado em Educação Especial (área de especialização em Intervenção Precoce)

Da 'portugalidade' à lusofonia

Tese de Doutoramento em Ciências da Comunicação (Especialidade em Teoria da Cultura)

Mothers' beliefs concerning severity and need for intervention in child maltreatment

Dissertação de mestrado integrado em Psicologia Clínica e da Saúde

Adolescent parents’ values: the role played by retrospective perceptions of the family-of-origin

Family-of-origin is an important system in individual’s lives, and its influence is extensive over the life cycle. The aim of this study was to investigate, in a sample of adolescents’ parents, whether their retrospective perceptions of parenting and relationship qualities within their families-of-origin during adolescence predicted their current collectivist and individualist values. Participants included 110 Portuguese adults with a mean age of 46.86 years old. The results of structural equation modeling supported that retrospective perceptions of parenting and relationship qualities in the family-of-origin predicted the adults’ collectivist values but not their individualist values. This study highlights the importance of retrospective perceptions of supporting and non-rejecting parenting for value acquisition. The results also suggest that values that preserve and protect family connections and collaborations are more likely to be socialized by families. Implications for practice and for the theories on parenting, values, family-of-origin influences and family intergenerational transmission are discussed.

Psicoterapia de Vittorio Guidano e suas influências epistemológicas

Este artigo encontra-se estruturado basicamente em três partes. Na primeira, contextualizamos as concepções de Vittorio Guidano face às correntes psicoterapêuticas do século XX, nomeadamente quanto ao comportamentalismo, ao cognitivismo e ao construtivismo. Fazemos notar que as várias tendências da psicoterapia dessa época se autorrotulavam a partir de conceitos advindos de outras áreas, sem terem o cuidado de indagar sobre os fundamentos epistemológicos nos quais elas se alicerçavam. Num segundo momento detemo-nos no embasamento epistemológico de sua teoria e metodologia psicoterapêuticas, focalizando-nos no papel que o cognitivismo cibernético teve no seu pensamento (nomeadamente, quanto à questão da observação), bem como na teoria biológica da autopoiesis, na qual nosso autor explicitamente se inspirou. Por fim, nos debruçamos com algum pormenor sobre o seu modelo sobre o conhecimento e experiência humana, que se traduz numa nova teoria da personalidade (organização pessoal, noção de si mesmo) e um novo sistema psicoterapêutico que enfatiza o papel do vínculo afetivo como modelador da identidade pessoal.

Examining mindfulness and its relation to self-differentiation and alexithymia

Published online first in 10 July 2013

O evento levou... Comunicação de marca de uma cidade-sede

Tese de Doutoramento em Ciências da Comunicação - Especialidade em Comunicação Estratégica e Organizacional

Column-based databases: estudo exploratório no âmbito das bases de dados NoSQL

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

Sinistralidade rodoviária e o marketing relacional: perspetivas de soluções mais eficazes no seu combate em Portugal

Dissertação de mestrado em Marketing e Estratégia