Quality measures for ETL processes: from goals to implementation

Extraction transformation loading (ETL) processes play an increasingly important role for the support of modern business operations. These business processes are centred around artifacts with high variability and diverse lifecycles, which correspond to key business entities. The apparent complexity of these activities has been examined through the prism of business process management, mainly focusing on functional requirements and performance optimization. However, the quality dimension has not yet been thoroughly investigated, and there is a need for a more human-centric approach to bring them closer to business-users requirements. In this paper, we take a first step towards this direction by defining a sound model for ETL process quality characteristics and quantitative measures for each characteristic, based on existing literature. Our model shows dependencies among quality characteristics and can provide the basis for subsequent analysis using goal modeling techniques. We showcase the use of goal modeling for ETL process design through a use case, where we employ the use of a goal model that includes quantitative components (i.e., indicators) for evaluation and analysis of alternative design decisions.Peer ReviewedPostprint (author's final draft

Living Innovation Laboratory Model Design and Implementation

Living Innovation Laboratory (LIL) is an open and recyclable way for multidisciplinary researchers to remote control resources and co-develop user centered projects. In the past few years, there were several papers about LIL published and trying to discuss and define the model and architecture of LIL. People all acknowledge about the three characteristics of LIL: user centered, co-creation, and context aware, which make it distinguished from test platform and other innovation approaches. Its existing model consists of five phases: initialization, preparation, formation, development, and evaluation. Goal Net is a goal-oriented methodology to formularize a progress. In this thesis, Goal Net is adopted to subtract a detailed and systemic methodology for LIL. LIL Goal Net Model breaks the five phases of LIL into more detailed steps. Big data, crowd sourcing, crowd funding and crowd testing take place in suitable steps to realize UUI, MCC and PCA throughout the innovation process in LIL 2.0. It would become a guideline for any company or organization to develop a project in the form of an LIL 2.0 project. To prove the feasibility of LIL Goal Net Model, it was applied to two real cases. One project is a Kinect game and the other one is an Internet product. They were both transformed to LIL 2.0 successfully, based on LIL goal net based methodology. The two projects were evaluated by phenomenography, which was a qualitative research method to study human experiences and their relations in hope of finding the better way to improve human experiences. Through phenomenographic study, the positive evaluation results showed that the new generation of LIL had more advantages in terms of effectiveness and efficiency.Comment: This is a book draf

User-centered visual analysis using a hybrid reasoning architecture for intensive care units

One problem pertaining to Intensive Care Unit information systems is that, in some cases, a very dense display of data can result. To ensure the overview and readability of the increasing volumes of data, some special features are required (e.g., data prioritization, clustering, and selection mechanisms) with the application of analytical methods (e.g., temporal data abstraction, principal component analysis, and detection of events). This paper addresses the problem of improving the integration of the visual and analytical methods applied to medical monitoring systems. We present a knowledge- and machine learning-based approach to support the knowledge discovery process with appropriate analytical and visual methods. Its potential benefit to the development of user interfaces for intelligent monitors that can assist with the detection and explanation of new, potentially threatening medical events. The proposed hybrid reasoning architecture provides an interactive graphical user interface to adjust the parameters of the analytical methods based on the users' task at hand. The action sequences performed on the graphical user interface by the user are consolidated in a dynamic knowledge base with specific hybrid reasoning that integrates symbolic and connectionist approaches. These sequences of expert knowledge acquisition can be very efficient for making easier knowledge emergence during a similar experience and positively impact the monitoring of critical situations. The provided graphical user interface incorporating a user-centered visual analysis is exploited to facilitate the natural and effective representation of clinical information for patient care

Designing and evaluating the usability of a machine learning API for rapid prototyping music technology

To better support creative software developers and music technologists' needs, and to empower them as machine learning users and innovators, the usability of and developer experience with machine learning tools must be considered and better understood. We review background research on the design and evaluation of application programming interfaces (APIs), with a focus on the domain of machine learning for music technology software development. We present the design rationale for the RAPID-MIX API, an easy-to-use API for rapid prototyping with interactive machine learning, and a usability evaluation study with software developers of music technology. A cognitive dimensions questionnaire was designed and delivered to a group of 12 participants who used the RAPID-MIX API in their software projects, including people who developed systems for personal use and professionals developing software products for music and creative technology companies. The results from the questionnaire indicate that participants found the RAPID-MIX API a machine learning API which is easy to learn and use, fun, and good for rapid prototyping with interactive machine learning. Based on these findings, we present an analysis and characterization of the RAPID-MIX API based on the cognitive dimensions framework, and discuss its design trade-offs and usability issues. We use these insights and our design experience to provide design recommendations for ML APIs for rapid prototyping of music technology. We conclude with a summary of the main insights, a discussion of the merits and challenges of the application of the CDs framework to the evaluation of machine learning APIs, and directions to future work which our research deems valuable

Computerization of workflows, guidelines and care pathways: a review of implementation challenges for process-oriented health information systems

There is a need to integrate the various theoretical frameworks and formalisms for modeling clinical guidelines, workflows, and pathways, in order to move beyond providing support for individual clinical decisions and toward the provision of process-oriented, patient-centered, health information systems (HIS). In this review, we analyze the challenges in developing process-oriented HIS that formally model guidelines, workflows, and care pathways. A qualitative meta-synthesis was performed on studies published in English between 1995 and 2010 that addressed the modeling process and reported the exposition of a new methodology, model, system implementation, or system architecture. Thematic analysis, principal component analysis (PCA) and data visualisation techniques were used to identify and cluster the underlying implementation ‘challenge’ themes. One hundred and eight relevant studies were selected for review. Twenty-five underlying ‘challenge’ themes were identified. These were clustered into 10 distinct groups, from which a conceptual model of the implementation process was developed. We found that the development of systems supporting individual clinical decisions is evolving toward the implementation of adaptable care pathways on the semantic web, incorporating formal, clinical, and organizational ontologies, and the use of workflow management systems. These architectures now need to be implemented and evaluated on a wider scale within clinical settings

A mobile tour guide app for sustainable tourism

Portugal has had a flourishing tourism sector for the past few years. In fact, Portugal’s tourism boom has made the industry one of the biggest contributors to the national economy and the largest employer. In the year 2019, Portugal had a total of 27 million tourists, surpassing once again the record established in the previous year. However, tourism also brings a series of unintended negative side effects, such as overcrowding. The Santa Maria Maior historic district in Lisbon is being particularly affected by this problem. The work undertaken in this dissertation is part of the Sustainable Tourism Crowding project, that aims to mitigate the overcrowding phenomenon in this district, by fostering a balanced distribution of visitors while promoting the visitation of sustainable points of interest. This dissertation focuses on developing a mobile app prototype targeted at tourists, through which these sustainable walking tour recommendations can be delivered. To validate the functional requirements of the prototype, more specifically the trip creation process, a series of unit tests, integration tests, and manual tests were developed. To evaluate the usability of the prototype, a user-centered approach was adopted during the design stage, in which two usability techniques were conducted with members of ISCTE’s research center ISTAR and partners from the Junta de Freguesia de Santa Maria Maior, that guided and validated the decisions made. The achieved prototype contains mechanisms for measuring tourists’ adherence to the recommended tours using the Dynamic Time Warping algorithm, which raises new research opportunities on tourists’ behaviour.O desenvolvimento próspero do setor turístico em Portugal nos últimos anos fez da indústria um dos maiores contribuintes para a economia nacional e o maior empregador do país. No ano de 2019, Portugal recebeu um total de 27 milhões de turistas, ultrapassando uma vez mais uma vez o recorde estabelecido no ano anterior. No entanto, o turismo traz também uma série de efeitos secundários negativos não intencionais, tais como overcrowding. A freguesia histórica de Santa Maria Maior em Lisboa está a ser particularmente afetada por este problema. O trabalho desenvolvido nesta dissertação faz parte do projeto de pesquisa Sustainable Tourism Crowding, que visa mitigar o fenómeno de overcrowding nesta freguesia, promovendo uma distribuição equilibrada dos visitantes e incentivando a visita de pontos de interesse sustentáveis. Esta dissertação foca-se no desenvolvimento de uma aplicação móvel protótipo destinada a turistas, através do qual recebem recomendações de visitas sustentáveis. Para validar os requisitos funcionais do protótipo, mais especificamente o processo de criação de visitas, foram desenvolvidos testes unitários, testes de integração, e testes manuais. Para avaliar a usabilidade do protótipo, foi adotada uma abordagem centrada no utilizador durante a fase de conceção, em que foram utilizadas duas técnicas de usabilidade em parceria com o ISTAR (centro de investigação do ISCTE) e com a Junta de Freguesia de Santa Maria Maior, cujos resultados guiaram e validaram as decisões tomadas. O protótipo desenvolvido contém mecanismos para medir a aderência dos turistas às recomendações sugeridas através do algoritmo Dynamic Time Warping, proporcionando novas oportunidades de pesquisa nesta área

Revisión sistemática de los métodos de evaluación de experiencia de usuario de sitios web informativos

El presente trabajo de tesis consiste en una revisión sistemática, presentada como artículo científico, sobre los métodos de evaluación que son empleados actualmente para la evaluación de la experiencia de usuario en sitios Web informativos. El trabajo de investigación consiste en una revisión de la literatura para identificar los métodos, criterios y herramientas empleadas para evaluar la experiencia de usuario en sitios web de acuerdo a la definición planteada para ambos términos en la ISO 9241. Las investigaciones consideradas para la revisión fueron encuestas, estudios de casos, estudios comparativos y experimentos que incluyan la descripción de la metodología aplicada. El artículo fue publicado en Springer como parte de la participación en el evento "HCI International 2017", realizado en Vancouver (Canadá) en el 2017.Trabajo de Investigació