Ontology-based representation and generation of workflows for micro-task human-machine computation

Doctoral Program in Computer Science

Task clustering on ETL systems – A pattern-oriented approach

Usually, data warehousing populating processes are data-oriented workflows composed by dozens of granular tasks that are responsible for the integration of data coming from different data sources. Specific subset of these tasks can be grouped on a collection together with their relationships in order to form higher- level constructs. Increasing task granularity allows for the generalization of processes, simplifying their views and providing methods to carry out expertise to new applications. Well-proven practices can be used to describe general solutions that use basic skeletons configured and instantiated according to a set of specific integration requirements. Patterns can be applied to ETL processes aiming to simplify not only a possible conceptual representation but also to reduce the gap that often exists between two design perspectives. In this paper, we demonstrate the feasibility and effectiveness of an ETL pattern-based approach using task clustering, analyzing a real world ETL scenario through the definitions of two commonly used clusters of tasks: a data lookup cluster and a data conciliation and integration cluster.

Conceptual-physical bridging – From BPMN models to physical implementations on kettle

Developing and implementing data-oriented workflows for data migration processes are complex tasks involving several problems related to the integration of data coming from different schemas. Usually, they involve very specific requirements - every process is almost unique. Having a way to abstract their representation will help us to better understand and validate them with business users, which is a crucial step for requirements validation. In this demo we present an approach that provides a way to enrich incrementally conceptual models in order to support an automatic way for producing their correspondent physical implementation. In this demo we will show how B2K (Business to Kettle) system works transforming BPMN 2.0 conceptual models into Kettle data-integration executable processes, approaching the most relevant aspects related to model design and enrichment, model to system transformation, and system execution.

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.

Metodologias facilitadoras da criatividade em design de moda: uma experiência académica

Este artigo descreve a experiência prática de um trabalho realizado em sala de aula, que trata de agregar técnicas facilitadoras do desenvolvimento da criatividade, num processo de criação de moda. O método usado foi adaptado para o design de moda, através da utilização das técnicas de “brainstorming”, “mapas mentais” e “painéis semânticos” conjugados num exercício prático-experimental de criatividade. O objetivo deste estudo consiste em analisar o desempenho criativo dos alunos e as possibilidades resultantes da utilização e adaptação de tais metodologias de criatividade em design de moda.

Redes sociais e semânticas: Investigação e educação, novas literacias e metodologias

Investigação e educação: novas literacias e metodologias. Redes sociais e semânticas: Introdução; Web 2.0; Sociedade da investigação e Web 3.0; Aprendizagem descentralizada das literacias; O cidadão-investigador e o cidadão-aprendente; A vida social enquanto aprendizagem da investigação e investigação da aprendizagem; Escrita comum e autores leigos; As novas configurações do saber na Web 3.0 para o ensino e a pesquisa; Conclusão: literacia e metodologias 2.0 (sociais) e/ou literacias e metodologias 3.0 (sociais-semânticas)? Exemplos de sites sociais-semânticos.

Escritas da utopia na literatura contemporânea – da utopia à distopia

Tese de Doutoramento em Ciências da Literatura (Especialidade em Literatura Comparada)

Planeamento e controlo de projetos em ambiente colaborativo com recurso a ferramentas BIM

Dissertação de mestrado integrado em Engenharia Civil