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.

Interdisciplinary knowledge transfer and technological applications for assessment, strengthening and monitoring of timber structures in Europe

COST (European Co-operation in the field of scientific and technical research) is the longest running framework for research co-operation iri Europe, having been established in 1971 by a Ministerial Conference attended by Ministers for Science and Technology from 19 countries. Today COST is used by the scientific communities of 35 European countries to cooperate in exchanging knowledge and technology developed within research projects supported by national or European funds. The main objective of COST is to contribute to the realization of the European Research Área (ERA) anticipating and complementing the activities of the' Framework Programmes, constituting a "bridge" towards the scientific communities of emerging countries, increasing the mobility of researchers across Europe and fostering the establishment of "Networks of Excelience". Another essential objective is the knowledge transfer between the scientific soc'iety and industry. It is widely acknowledged that European scientific performance in relation to investment in science is excellent but technological and commercial performance has steadily worsened. The present paper discusses how the COST Action's instruments, from training schools to short scientific missions and workshops have been used within The COST ACTION FP11O1 Assessment, Reinforcement and Monitoring of Timber Structures to achieve such objectives.

A leitura e interpretação de imagens pictóricas e de gráficos na aula de História e Geografia: um estudo com alunos do 3º ciclo do Ensino Básico

Relatório de estágio de mestrado em Ensino de História e de Geografia no 3º Ciclo do Ensino Básico e no Ensino Secundário

Occupational Ergonomics and Safety, Part 1

[Excerpt] It seems that significant progress has been made in last years in what concerns the scientific knowledge about work and its impact on workers’ wellbeing and health, which includes but it is not limited to occupational ergonomics and safety. Even considering that this domain is very transversal and comprehensive, as it may include researchers from multidisciplinary teams, research in this domain has clearly increased and we have now a larger number of scientific events, a higher number of researchers publishing their works, and a high emergence rate of research groups at universities and other research institutions, which was also followed by an increasing concern about these issues by governments and other regulators. Even though it is strikingly difficult to demonstrate it in an unequivocal way, this appears to have had a clear effect on companies and on their ability to implement plans and measures to prevent and control occupational risk factors. But despite these advances, occupational risk prevention is still a domain for which solutions are neither complete nor permanent, since the evolution of work systems gives rise to new challenges.

[An editorial to] Recent Advances on Knowledge Discovery and Business Intelligence

Special issue guest editorial, June, 2015.

Child abuse monitor system model: a health care critical knowledge monitor system

The Childhood protection is a subject with high value for the society, but, the Child Abuse cases are difficult to identify. The process from suspicious to accusation is very difficult to achieve. It must configure very strong evidences. Typically, Health Care services deal with these cases from the beginning where there are evidences based on the diagnosis, but they aren’t enough to promote the accusation. Besides that, this subject it’s highly sensitive because there are legal aspects to deal with such as: the patient privacy, paternity issues, medical confidentiality, among others. We propose a Child Abuses critical knowledge monitor system model that addresses this problem. This decision support system is implemented with a multiple scientific domains: to capture of tokens from clinical documents from multiple sources; a topic model approach to identify the topics of the documents; knowledge management through the use of ontologies to support the critical knowledge sensibility concepts and relations such as: symptoms, behaviors, among other evidences in order to match with the topics inferred from the clinical documents and then alert and log when clinical evidences are present. Based on these alerts clinical personnel could analyze the situation and take the appropriate procedures.

Using a domain-specific language to enrich ETL schemas

Today it is easy to find a lot of tools to define data migration schemas among different types of information systems. Data migration processes use to be implemented on a very diverse range of applications, ranging from conventional operational systems to data warehousing platforms. The implementation of a data migration process often involves a serious planning, considering the development of conceptual migration schemas at early stages. Such schemas help architects and engineers to plan and discuss the most adequate way to migrate data between two different systems. In this paper we present and discuss a way for enriching data migration conceptual schemas in BPMN using a domain-specific language, demonstrating how to convert such enriched schemas to a first correspondent physical representation (a skeleton) in a conventional ETL implementation tool like Kettle.

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

Doctor of Philosophy in Marketing and Strategy

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.

Para uma pedagogia das literacias: das conceções e práticas docentes aos conceitos e competências discentes. Um estudo da aula de língua portuguesa no 2º ciclo do ensino básico

Tese de Doutoramento em Ciências da Educação (Especialidade em Literacias e Ensino do Português)

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.

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.

Os social media como parte integrante da comunicação empresarial

Relatório de estágio de mestrado em Ciências da Comunicação (área de especialização Publicidade e Relações Públicas)

Ontological representation of tumor-node-metastasis classification and an ontology-driven classifier: a study on colorectal cancer

Dissertação de mestrado integrado em Engenharia Biomédica (área de especialização em Informática Médica)