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.

IL-17A promotes intracellular growth of Mycobacterium by inhibiting apoptosis of infected macrophages

The fate of infected macrophages is a critical aspect of immunity to mycobacteria. By depriving the pathogen of its intracellular niche, apoptotic death of the infected macrophage has been shown to be an important mechanism to control bacterial growth. Here, we show that IL-17 inhibits apoptosis of Mycobacterium bovis BCG- or Mycobacterium tuberculosis-infected macrophages thus hampering their ability to control bacterial growth. Mechanistically, we show that IL-17 inhibits p53, and impacts on the intrinsic apoptotic pathway, by increasing the Bcl2 and decreasing Bax expression, decreasing cytochrome c release from the mitochondria, and inhibiting caspase-3 activation. The same effect of IL-17 was observed in infected macrophages upon blockade of p53 nuclear translocation. These results reveal a previously unappreciated role for the IL-17/p53 axis in the regulation of mycobacteria-induced apoptosis and can have important implications in a broad spectrum of diseases where apoptosis of the infected cell is an important host defense mechanism.

Gellan gum-coated gold nanorods: an intracellular nanosystem for bone tissue engineering

Gold nanorods (AuNRs) have emerged as an exceptional nanotool for a myriad of applications ranging from cancer therapy to tissue engineering. However, their surface modification with biocompatible and stabilizing biomaterials is crucial to allow their use in a biological environment. Herein, low-acyl gellan gum (GG) was used to coat AuNRs surface, taking advantage of its stabilizing, biocompatible and gelling features. The layer-by-layer based strategy implied the successive deposition of poly(acrylic acid), poly(allylamine hydrochloride) and GG, which allowed the formation of a GG hydrogel-like shell with 7 nm thickness around individual AuNRs. Stability studies in a wide range of pH and salt concentrations showed that the polysaccharide coating can prevent AuNRs aggregation. Moreover, a reversible pH-responsive feature of the nanoparticles was observed. Cytocompatibility and osteogenic ability of GG-coated AuNRs was also addressed. After 14 days of culturing within SaOS-2, an osteoblast-like cell line, in vitro studies revealed that AuNRs-GG exhibit no cytotoxicity, were internalized by the cells and localized inside lysosomes. AuNRs-GG combined with osteogenic media enhanced the mineralization capacity two-fold, as compared to cells exposed to osteogenic media alone. The proposed system has shown interesting features for osteogenesis, and further insights might be relevant for drug delivery, tissue engineering and regenerative medicine.

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