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.

Automatic generation of ETL physical systems from BPMN conceptual models

ETL conceptual modeling is a very important activity in any data warehousing system project implementation. Owning a high-level system representation allowing for a clear identification of the main parts of a data warehousing system is clearly a great advantage, especially in early stages of design and development. However, the effort to model conceptually an ETL system rarely is properly rewarded. Translating ETL conceptual models directly into something that saves work and time on the concrete implementation of the system process it would be, in fact, a great help. In this paper we present and discuss a hybrid approach to this problem, combining the simplicity of interpretation and power of expression of BPMN on ETL systems conceptualization with the use of ETL patterns to produce automatically an ETL skeleton, a first prototype system, which has the ability to be executed in a commercial ETL tool like Kettle.

O ensino em grupo de instrumentos musicais: um estudo de caso múltiplo em Portugal e no Brasil

Tese de Doutoramento em Estudos da Criança (área de especialização em Educação Musical)

Alcohol sponsored events: the impact on attitudes and intentions, and the mitigating impact of persuasion knowledge

Doctor of Philosophy in Marketing and Strategy

Ethnoveterinary knowledge of the inhabitants of Marajó Island, Eastern Amazonia, Brazil

There have been ethnoveterinary reports from around the world investigating plant usage in therapeutic protocols; however, there is no information regarding the ethnoveterinary practices in Brazilian Amazonia. The objective of this work was to register and document the ethnoveterinary knowledge of the inhabitants of the Island of Marajó, eastern Amazonia, Brazil. In the study, interviews were conducted with 50 individuals, with the application of semi-structured questionnaires that were quantitatively analyzed using descriptive statistic methods of frequency distribution. Use-value was calculated to determine the most important species. Samples of plants that were reported to have medicinal value were collected and identified by botanical classification. Fifty plants, distributed among 48 genera and 34 families, were indicated for 21 different medicinal uses. The family Asteraceae had the largest number of reported species; Carapa guianensis Aubl., Copaifera martii Hayne, Crescentia cujete L., Caesalpinia ferrea Mart., Chenopodium ambrosioides L., Jatropha curcas L. and Momordica charantia L. were species with highest use- value. The plant parts that were more commonly utilized for the preparation of ethnoveterinary medicines were the leaves (56%), bark (18%), roots (14%), seeds (14%) and fruit (8%). With regard to usage, tea was reported as a usage method by 56% of the informants; most preparations (90.9%) utilized only a single plant. In addition to medicinal plants, informants reported using products of animal and mineral origin. The present study contributed to the construction of an inventory of Marajó Island's ethnoveterinary plants, which might be the basis for future scientific validation studies.

Postcolonial co-ordinary literature and the Web 2.0/3.0: "Thinking Back" within transmediatic knowledge

Pedro Andrade destaca o papel que as literacias híbridas preenchem numa redefinição pós-colonial da Europa. Em sua opinião, as literacias híbridas constituem uma condição necessária para a desconstrução do discurso colonial e a posterior reconstrução de literacias e literaturas pós-coloniais. Como parte deste processo, o autor argumenta a necessidade de vários tipos de competências que enfatizem a leitura e escrita não apenas dentro de sua própria cultura, mas também nas culturas dos outros. A literacia digital desempenha um papel particularmente importante neste processo, o que nos permite enfatizar as multivocalidades desta alteridade, igualmente na interação entre diferentes tradições de literacia: Ocidental e Oriental, nacional e transnacional, verbal e mediática. Andrade exemplifica o conceito de literatura transmediática com uma série de projetos em que esteve envolvido, por exemplo a Web 3.0 Novel enquanto modalidade daquilo que ele nomeia "GeoNeoLogic Novel". Este género de novel experimental mistura a narrativa com a teoria e a recolha de dados no campo empírico, promovendo uma abordagem que se apresenta simultaneamente regional e global. Em suma, o autor sugere diversos conceitos em primeira mão que classifica de ‘origem Lusófona’, e que representam diversas estratégias pós-coloniais globais também visíveis na área social, política e cultural da Lusofonia: o ‘pensamento-réplica’ (thinking back); o 'conhecimento transmediático' (transmediatic knowledge); a ‘sociedade da escrita comum’ (common writing society); as ‘redes comuns de conflito/significado’ (common webs of conflict and meaning); a literatura co-ordinária (co-ordinary literature).

Impact of an educational hands-on project on the antimicrobial, antitumor and anti-inflammatory properties of plants on Portuguese students' awareness, knowledge, and competences

Promoting environmental and health education is crucial to allow students to make conscious decisions based on scientific criteria. The study is based on the outcomes of an Educational Project implemented with Portuguese students and consisted of several activities, exploring pre-existent Scientific Gardens at the School, aiming to investigate the antibacterial, antitumor and anti-inflammatory properties of plant extracts, with posterior incorporation in soaps and creams. A logo and a webpage were also created. The effectiveness of the project was assessed via the application of a questionnaire (pre- and post-test) and observations of the participants in terms of engagement and interaction with all individuals involved in the project. This project increased the knowledge about autochthonous plants and the potential medical properties of the corresponding plant extracts and increased the awareness about the correct design of scientific experiments and the importance of the use of experimental models of disease. The students regarded their experiences as exciting and valuable and believed that the project helped to improve their understanding and increase their interest in these subjects and in science in general. This study emphasizes the importance of raising students’ awareness on the valorization of autochthonous plants and exploitation of their medicinal properties.

Modelação de governo electrónico para países emergentes: O caso de São Tomé e Príncipe

Tese de Doutoramento em Tecnologias e Sistemas de Informação

On trust, knowledge, sharing and innovation

Organisations continuously innovate, create, and are competitive if they improve their performance through continuous intellectual capital development, a key resource for value creation and organisational performance driver. Apart from sustaining competitive advantage, intellectual capital is increasingly important due to its ability to increase shareholder value, especially in public organisations. Employee learning, talent development, and knowledge creation allow the organisation to generate innovative ideas due to the quickness of knowledge obsolescence. The organisation's dynamic capabilities create and re-ignite organisational competencies for business sustainability being co-ordinated by well-structured organisational strategic routines ensuring continuous value creation streams into the business. This chapter focuses on the relationship between notions of knowledge sharing and trust in organisations. Lack of trust can impact negatively organisational knowledge sharing, dependent on trust, openness, and communication. The research sample included graduates and postgraduate students from two universities in Portugal. The findings revealed different perceptions according to the age group.

A cooperação transfronteiriça como oportunidade de desenvolvimento das regiões de fronteira. Da Raia Ibérica à euroregião Galiza-Norte de Portugal

Tese de Doutoramento em Geografia Humana.

Longitudinal evaluation, acceptability and long-term retention of knowledge on a horizontally integrated organic and functional systems course

Undergraduate medical education is moving from traditional disciplinary basic science courses into more integrated curricula. Integration models based on organ systems originated in the 1950s, but few longitudinal studies have evaluated their effectiveness. This article outlines the development and implementation of the Organic and Functional Systems (OFS) courses at the University of Minho in Portugal, using evidence collected over 10 years. It describes the organization of content, student academic performance and acceptability of the courses, the evaluation of preparedness for future courses and the retention of knowledge on basic sciences. Students consistently rated the OFS courses highly. Physician tutors in subsequent clinical attachments considered that students were appropriately prepared. Performance in the International Foundations of Medicine examination of a self-selected sample of students revealed similar performances in basic science items after the last OFS course and 4 years later, at the moment of graduation. In conclusion, the organizational and pedagogical approaches of the OFS courses achieve high acceptability by students and result in positive outcomes in terms of preparedness for subsequent training and long-term retention of basic science knowledge.

Encontros e desencontros da educação de adultos numa associação de teatro amador

Dissertação de mestrado em Ciências da Educação (área de especialização em Educação de Adultos)

Metodologia para o ensino da química no 3.º ciclo do ensino básico: Química para todos: um estudo centrado na estrutura da matéria, transformações químicas e físicas, Lei de Lavoisier e velocidade das reações

Dissertação de mestrado em Ciências – Formação Contínua de Professores (área de especialização em Física e Química)

Envolvimento parental no desporto

O presente conjunto de investigações pretendeu estudar o envolvimento parental na competição desportiva de crianças e jovens. Baseado no modelo do envolvimento parental no desporto (Teques & Serpa, 2009), o estudo permitiu concretizar dois objectivos fundamentais. Primeiro, desenvolver um conjunto de escalas válidas e fidedignas para aceder aos constructos incluídos no modelo teórico. Segundo, testar as hipóteses fundamentadas na estrutura conceptual do modelo com o propósito de compreender (1) a razão porque os pais se envolvem no desporto dos filhos, (2) quais os comportamentos utilizados pelos pais durante o envolvimento, e (3) como é que o envolvimento influencia o contexto de realização do jovem atleta. No total, participaram voluntariamente 1620 pais e 1665 jovens atletas de vários desportos individuais e coletivos, com idades compreendidas entre os 9 e os 18 anos. A prossecução dos objectivos teve por base uma série de três estudos independentes. Os resultados do primeiro estudo sugerem que as crenças do papel parental, a auto-eficácia, a perceção das invocações oriundas do treinador e do jovem atleta, o tempo e energia disponíveis, e os conhecimentos e competências relacionam-se com as atividades de envolvimento dos pais. No segundo estudo, os resultados demonstraram que as perceções dos comportamentos parentais de encorajamento, reforço, instrução, e modelagem medeiam a relação entre os comportamentos reportados pelos pais e as variáveis psicológicas de auto-eficácia, auto-eficácia social, motivação intrínseca, e estratégias de autorregulação dos jovens. Os resultados do terceiro estudo indicam que as perceções dos comportamentos dos pais relacionam-se com a realização desportiva através dos efeitos de mediação da auto-eficácia, autoeficácia social e das estratégias de autorregulação. Implicações para a intervenção, limitações e direções futuras para a investigação são também discutidas.