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.

Quality costs analysis: case study in the automotive industry

Dissertação de mestrado integrado em Engenharia e Gestão Industrial

Implementação de um sistema de customer relationship management na broaden information solutions

Dissertação de mestrado em Sistemas de Informação

Towards the design and implementation of aspect-oriented programming for spreadsheets

A spreadsheet usually starts as a simple and singleuser software artifact, but, as frequent as in other software systems, quickly evolves into a complex system developed by many actors. Often, different users work on different aspects of the same spreadsheet: while a secretary may be only involved in adding plain data to the spreadsheet, an accountant may define new business rules, while an engineer may need to adapt the spreadsheet content so it can be used by other software systems.Unfortunately,spreadsheetsystemsdonotoffermodular mechanisms, and as a consequence, some of the previous tasks may be defined by adding intrusive “code” to the spreadsheet. In this paper we go through the design and implementation of an aspect-oriented language for spreadsheets so that users can work on different aspects of a spreadsheet in a modular way. For example, aspects can be defined in order to introduce new business rules to an existing spreadsheet, or to manipulate the spreadsheet data to be ported to another system. Aspects are defined as aspect-oriented program specifications that are dynamically woven into the underlying spreadsheet by an aspect weaver. In this aspect-oriented style of spreadsheet development, differentusers develop,orreuse,aspects withoutaddingintrusive code to the original spreadsheet. Such code is added/executed by the spreadsheet weaving mechanism proposed in this paper.

An object-oriented model for rapid prototyping of data path/control systems - a case study

Publicado em "Information control in manufacturing 1998 : (INCOM'98) : advances in industrial engineering : a proceedings volume from the 9th IFAC Symposium, Nancy-Metz, France, 24-26 June 1998. Vol. 2"

Object-oriented inheritance of statecharts for control applications

This paper discusses how object-oriented iuheritance can be re-interpreted if statecharts are used for modelling the dynamic behaviour of an object. The support of inheritance of statecharts allows the improvement of systems' development by easing the reutilization of parts of already developed euccessful systems, aad by promoting the iterative and continuous models' refinement advocated by the operatioaal approach. Statechart is the formalism used within UML to specify reactive state.based behaviours. This paper covers the use of statecharts within the modelling of embedded systems for industrial control applxications, where performance and memory usage are main concerns.

Desarrollo sustentable de Productos y Servicios de Camélidos orientados al mercado en la región andina (DECAM). Sustainable Development Products and Services Marketed oriented in Andean Region

Este proyecto cuenta con el financiamiento del sistema INCO de la Unión Europea e incluye 5 contrapartes europeas, y Bolivia y Perú como contrapartes americanos. Consta de cuatro paquetes: producto, mercado, difusión y coordinación. En el primer paquete se desarrollan fundamentalmente los aspectos relacionados con la carne fresca y los productos cárnicos tanto tradicionales como nuevos a desarrollar. Se realizan faenas protocolizadas y espontáneas comparando animales con distintos tratamientos nutricionales de edades entre 19-21 meses. Se realizan análisis de calidad de carne y paneles de degustación. Los productos tradicionales como el charqui se evalúan en su forma tradicional y se implementan sistemas mejorados como desecadores solares. Los chacinados no son tradicionales en el altiplano por eso se realizan en La Pampa con la idea de transferir la tecnología desarrollada. La evaluación de calidad de la carne incluye técnicas de evaluación del animal en pié como la conservación morfológica y la ecografía para predecir calidad de res en el animal vivo. Estas observaciones se corroboran a la faena donde se realiza toda la batería de evaluaciones de calidad de la res.

Motilidad Orientada de Células Neurales: La comunicación celular a distancia. Oriented neural cell motility: Cell comunication at a distance.

La motilidad celular orientada (o mecanismo quimiotáctico de orientación), es una respuesta celular a señales moleculares de su micro-ambiente necesaria para modular la distribución celular en sitios específicos y con elevada precisión. Nuestra hipótesis establece que la migración orientada de células neurales es regulada por gradientes de concentración de moléculas solubles liberadas por sus regiones "blanco". Este proyecto es continuación del estudio de la quimiotaxis de células de cresta neural (CCN) y de neuronas ventriculares (NV) inducida respectivamente por factores difusibles de la región del futuro ganglio ciliar y del bulbo olfatorio.En el sistema de CCN, hemos caracterizado como moléculas quimiotácticas a la quimioquina Stromal Cell-Derived Factor-1, y los factores tróficos Stem Cell Factor y Neurotrophic Factor-3, habiendo determinado la expresión de sus respectivos receptores CXCR4, TrkC y p75 en la población de CCN mesencefálicas de ambrión de pollo. Actualmente, estamos desarrollando experimentos con el Ciliary Neurotrophic Factor y factores de la familia Bone Morphogenetic Proteins. Además de la estrategia experimental in vitro, hemos determinado en el embrión entero la expresión de las moléculas quimioatractantes mediante hibridación in situ del ARNm y la presencia de las respectivas proteínas mediante inmunocitoquímica. En el sistema de NV, estamos analizando la motilidad celular en relación con moléculas liberadas por el bulbo olfatorio. En los dos sistemas biológicos, estamos analizando elementos de la transducción de señales y cambios en el citoesqueleto, en ambos casos asociados con la respuesta temprana en la orientación quimiotáctica de la célula. Asimismo, en ambos sistemas biológicos, evaluamos los efectos del etanol sobre la migración y distribución celular, en condiciones equivalentes a las que inducen el Sindrome Fetal Alcohólico en mamíferos.En base a resultados ya obtenidos en experimentos in vitro, en la presente etapa intentaremos su caracterización in vivo mediante el bloqueo funcional de las moléculas quimiotácticas (y/o sus receptores) sobre embriones enteros, mediante silenciamiento con ARNsi (o morfolinos específicos) mediante electroporación, y posterior determinación de la distribución celular mediante marcadores específicos anti-CCN (o lipofílicos de tipo DiI).Los resultados permitirán mejorar el conocimiento del mecanismo de la migración celular orientada y aportar al diseño de recursos diagnósticos, terapéuticos o de control de anomalías embrionarias o patologías tumorales por mala distribución celular como las Neurocristopatías, o inducidas por tóxicos exógenos como el Sindrome Fetal Alcohólico.

Socially integrative customer service (SICS) : identification of a symbiotic link with corporate social responsibility

The aim of this study is to answer the research question "can customer service be revitalised through identification of a symbiotic relationship with social responsibility, linked by people-centricity?" The concept of customer service remains weak and there has been a lack of attention to the underlying purpose: "to serve". To strengthen the theory the humanistic nature of the concept should be revised. Fundamental to this argument is the question of who is a customer? To fully discover the scope of the concept requires a broader or more specifically a societal view. Herein the theme of social corporate responsibility is critical to the recognition of the customer service network (CSN). This suggestion in isolation is useful but structural. Another aspect must be identified to validate the "service" ethos. Through this reasoning the relational theme (RT) provides for a mechanism for this to be achieved. Therefore the theory of socially integrative customer service is based on broadening and deepening the customer service concept. This study is illustrated in the context of the grocery retail sector in the Republic of Ireland. Four case studies are presented, three based on company-wide and in-store research and a fourth is a cross-company study. Results across companies indicate acceptance of the research question and show evidence to validate SICS. There is scope to further develop SICS and to build on the CSN and the RT. Finally the concept of SICS provides for a diverse basis for further research. This theory does no purport to cause a paradigm shift but does add innovation to the body of knowledge. As is the hallmark of good theoretical development, the author has aimed to keep the philosophy simple.

Implementation of a customer relationship management system in an SME

The research conducted for this thesis has been carried out over a two year period as part of the Mobile Tools and Technology for customer care (MOTTO) project. The project was funded under the Applied Grant scheme administered by Enterprise Ireland and Nortel Networks Ltd. It was a partnership project between Galway-Mayo Institute of Technology, University of Limerick, National University of Ireland Galway, and a global Internet and communications company, Nortel Networks. The project aimed to investigate the enabling mobile communications technologies in e-Business and mobile communications in the area of Business-to-Business (B2B) customer care. The development of the application discussed in this thesis was developed in conjunction with the Galway-Mayo Institute of Technology, University of Limerick and AMT Ireland. The decision to develop the application in the Electronics Company of AMT in Limerick came about as a result of the contact established by Mark Southern from the University of Limerick. Mark was involved in overseeing the development and assisted in establishing the user requirements.

monitoring-based approach to object-oriented real-time computing

Monitoring, object-orientation, real-time, execution-time, scheduling

System-oriented analysis of the dynamic behaviour of direct methanol fuel cells

DMFC, dynamic behaviour, current steps, system analysis, methanol oxidation, flow field design

Component oriented method for simulation of multibody dynamics

Modular modelling, dynamics simulation, multibodies, O(N) method, closed loops, post-stabilization

Framework for a service-oriented measurement infrastructure

Magdeburg, Univ., Fak. für Informatik, Diss., 2009

Document-oriented e-learning components

Magdeburg, Univ., Fak. für Informatik, Diss., 2009