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.

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.

BIOMedical search engine framework: lightweight and customized implementation of domain-specific biomedical search engines

The Smart Drug Search is publicly accessible at http://sing.ei.uvigo.es/sds/. The BIOMedical Search Engine Framework is freely available for non-commercial use at https://github.com/agjacome/biomsef

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.

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.

Development of advanced cell/tissue culture systems, based on enhanced polymeric scaffolds and sophisticated bioreactors, for tissue engineering applications

Programa Doutoral em Engenharia Biomédica

Reverse engineering of web applications

The MAP-i Doctoral Program of the Universities of Minho, Aveiro and Porto

Otimização com restrições de complementaridade: algoritmos e aplicações

Tese de Doutoramento em Engenharia Industrial e de Sistemas (PDEIS)

Engineering modular viral scaffolds for targeted bacterial population editing

Bacteria are central to human health and disease, but existing tools to edit microbial consortia are limited. For example, broad-spectrum antibiotics are unable to precisely manipulate bacterial communities. Bacteriophages can provide highly specific targeting of bacteria, but assembling well-defined phage cocktails solely with natural phages can be a time-, labor- and cost-intensive process. Here, we present a synthetic biology strategy to modulate phage host ranges by engineering phage genomes in Saccharomyces cerevisiae. We used this technology to redirect Escherichia coli phage scaffolds to target pathogenic Yersinia and Klebsiella bacteria, and conversely, Klebsiella phage scaffolds to target E. coli by modular swapping of phage tail components. The synthetic phages achieved efficient killing of their new target bacteria and were used to selectively remove bacteria from multi-species bacterial communities with cocktails based on common viral scaffolds. We envision this approach accelerating phage biology studies and enabling new technologies for bacterial population editing.

Piezoelectric polymers as biomaterials for tissue engineering applications

Tissue engineering often rely on scaffolds for supporting cell differentiation and growth. Novel paradigms for tissue engineering include the need of active or smart scaffolds in order to properly regenerate specific tissues. In particular, as electrical and electromechanical clues are among the most relevant ones in determining tissue functionality in tissues such as muscle and bone, among others, electroactive materials and, in particular, piezoelectric ones, show strong potential for novel tissue engineering strategies, in particular taking also into account the existence of these phenomena within some specific tissues, indicating their requirement also during tissue regeneration. This referee reports on piezoelectric materials used for tissue engineering applications. The most used materials for tissue engineering strategies are reported together with the main achievements, challenges and future needs for research and actual therapies. This review provides thus a compilation of the most relevant results and strategies and a start point for novel research pathways in the most relevant and challenging open questions.

Piezoelectric poly(vinylidene fluoride) microstructure and poling state in active tissue engineering

Tissue engineering often rely on scaffolds for supporting cell differentiation and growth. Novel paradigms for tissue engineering include the need of active or smart scaffolds in order to properly regenerate specific tissues. In particular, as electrical and electromechanical clues are among the most relevant ones in determining tissue functionality in tissues such as muscle and bone, among others, electroactive materials and, in particular, piezoelectric ones, show strong potential for novel tissue engineering strategies, in particular taking also into account the existence of these phenomena within some specific tissues, indicating their requirement also during tissue regeneration. This referee reports on piezoelectric materials used for tissue engineering applications. The most used materials for tissue engineering strategies are reported together with the main achievements, challenges and future needs for research and actual therapies. This review provides thus a compilation of the most relevant results and strategies and a start point for novel research pathways in the most relevant and challenging open questions.

Development of high specific strength components, with internal cellular structure, for several applications

Dissertação de mestrado em Engenharia Mecânica

Highly functional and biodegradable nanofibrous scaffolds combined with stem cells for bone and cartilage tissue engineering

Among the various possible embodiements of Advanced Therapies and in particular of Tissue Engineering the use of temporary scaffolds to regenerate tissue defects is one of the key issues. The scaffolds should be specifically designed to create environments that promote tissue development and not merely to support the maintenance of communities of cells. To achieve that goal, highly functional scaffolds may combine specific morphologies and surface chemistry with the local release of bioactive agents. Many biomaterials have been proposed to produce scaffolds aiming the regeneration of a wealth of human tissues. We have a particular interest in developing systems based in nanofibrous biodegradable polymers1,2. Those demanding applications require a combination of mechanical properties, processability, cell-friendly surfaces and tunable biodegradability that need to be tailored for the specific application envisioned. Those biomaterials are usually processed by different routes into devices with wide range of morphologies such as biodegradable fibers and meshes, films or particles and adaptable to different biomedical applications. In our approach, we combine the temporary scaffolds populated with therapeutically relevant communities of cells to generate a hybrid implant. For that we have explored different sources of adult and also embryonic stem cells. We are exploring the use of adult MSCs3, namely obtained from the bone marrow for the development autologous-based therapies. We also develop strategies based in extra-embryonic tissues, such as amniotic fluid (AF) and the perivascular region of the umbilical cord4 (Whartonâ s Jelly, WJ). Those tissues offer many advantages over both embryonic and other adult stem cell sourcess. These tissues are frequently discarded at parturition and its extracorporeal nature facilitates tissue donation by the patients. The comparatively large volume of tissue and ease of physical manipulation facilitates the isolation of larger numbers of stem cells. The fetal stem cells appear to have more pronounced immunomodulatory properties than adult MSCs. This allogeneic escape mechanism may be of therapeutic value, because the transplantation of readily available allogeneic human MSCs would be preferable as opposed to the required expansion stage (involving both time and logistic effort) of autologous cells. Topics to be covered: This talk will review our latest developments of nanostructured-based biomaterials and scaffolds in combination with stem cells for bone and cartilage tissue engineering.

Biomaterials for cartilage tissue engineering under mechanical stimulus

Tese de Doutoramento em Ciências (Especialidade de Física)

Introducing biomimetic approaches to materials development and product design for engineering students

In this paper, we present a new course entitled “Biomimicry: from life to nanotechnological innovations” at the Mines Nancy Engineering School, Nancy, France, and explain how we developed a specific curriculum covering biomimicry. We discuss strategies that can be followed by teachers to explain selected contents in the multi-disciplinary field of biomimicry and/or bioinspiration to undergraduate students and how practical classroom activities can be conducted as individual or team work. We hope that sharing our experience will help teachers and senior researchers disseminate useful concepts and real examples of biomimetic principles and tools for the development of new materials, new/improved design and fabrication strategies, and innovation methodologies.