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.

Modeling microbes: New methods for integrated metabolic and regulatory network reconstruction

PhD Thesis in Bioengineering

Evolution of the gene regulatory network controlling flower dorsoventral asymmetry

Tese de Doutoramento em Biologia de Plantas.

Triple negative breast cancer: nanosolutions for a big challenge

Triple negative breast cancer (TNBC) is a particular immunopathological subtype of breast cancer that lacks expression of estrogen and progesterone receptors (ER/PR) and amplification of the human epidermal growth factor receptor 2 (HER2) gene. Characterized by aggressive and metastatic phenotypes and high rates of relapse, TNBC is the only breast cancer subgroup still lacking effective therapeutic options, thus presenting the worst prognosis. The development of targeted therapies, as well as early diagnosis methods, is vital to ensure an adequate and timely therapeutic intervention in patients with TNBC. This review intends to discuss potentially emerging approaches for the diagnosis and treatment of TNBC patients, with a special focus on nano-based solutions that actively target these particular tumors.

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.

Evidence for inter- and intra-species biofilm formation variability among a small group of coagulase-negative staphylococci

Coagulase-negative staphylococci (CoNS) are common bacterial colonisers of the human skin. They are often involved in nosocomial infections due to biofilm formation in indwelling medical devices. While biofilm formation has been extensively studied in Staphylococcus epidermidis, little is known regarding other CoNS species. Here, biofilms from six different CoNS species were characterised in terms of biofilm composition and architecture. Interestingly, the ability to form a thick biofilm was not associated with any particular species, and high variability on biofilm accumulation was found within the same species. Cell viability assays also revealed different proportions of live and dead cells within biofilms formed by different species, although this parameter was particularly similar at the intra-species level. On the other hand, biofilm disruption assays demonstrated important inter- and intra-species differences regarding extracellular matrix composition. Lastly, confocal laser scanning microscopy (CLSM) experiments confirmed this variability, highlighting important differences and common features of CoNS biofilms. We hypothesised that the biofilm formation heterogeneity observed was rather associated with biofilm matrix composition than with cells themselves. Additionally, our results indicate that polysaccharides, DNA and proteins are fundamental pieces in the process of CoNS biofilm formation.

Attachment style impacts behavior and early oculomotor response to positive, but not negative, pictures

The present study investigated whether oculomotor behavior is influenced by attachment styles. The Relationship Scales Questionnaire was used to assess attachment styles of forty-eight voluntary university students and to classify them into attachment groups (secure, preoccupied, fearful, and dismissing). Eye-tracking was recorded while participants engaged in a 3-seconds free visual exploration of stimuli presenting either a positive or a negative picture together with a neutral picture, all depicting social interactions. The task consisted in identifying whether the two pictures depicted the same emotion. Results showed that the processing of negative pictures was impermeable to attachment style, while the processing of positive pictures was significantly influenced by individual differences in insecure attachment. The groups highly avoidant regarding to attachment (dismissing and fearful) showed reduced accuracy, suggesting a higher threshold for recognizing positive emotions compared to the secure group. The groups with higher attachment anxiety (preoccupied and fearful) showed differences in automatic capture of attention, in particular an increased delay preceding the first fixation to a picture of positive emotional valence. Despite lenient statistical thresholds induced by the limited sample size of some groups (p < 0.05 uncorrected for multiple comparisons), the current findings suggest that the processing of positive emotions is affected by attachment styles. These results are discussed within a broader evolutionary framework.

Reconstructing transcriptional regulatory networks using data integration and text mining

Transcriptional Regulatory Networks (TRNs) are powerful tool for representing several interactions that occur within a cell. Recent studies have provided information to help researchers in the tasks of building and understanding these networks. One of the major sources of information to build TRNs is biomedical literature. However, due to the rapidly increasing number of scientific papers, it is quite difficult to analyse the large amount of papers that have been published about this subject. This fact has heightened the importance of Biomedical Text Mining approaches in this task. Also, owing to the lack of adequate standards, as the number of databases increases, several inconsistencies concerning gene and protein names and identifiers are common. In this work, we developed an integrated approach for the reconstruction of TRNs that retrieve the relevant information from important biological databases and insert it into a unique repository, named KREN. Also, we applied text mining techniques over this integrated repository to build TRNs. However, was necessary to create a dictionary of names and synonyms associated with these entities and also develop an approach that retrieves all the abstracts from the related scientific papers stored on PubMed, in order to create a corpora of data about genes. Furthermore, these tasks were integrated into @Note, a software system that allows to use some methods from the Biomedical Text Mining field, including an algorithms for Named Entity Recognition (NER), extraction of all relevant terms from publication abstracts, extraction relationships between biological entities (genes, proteins and transcription factors). And finally, extended this tool to allow the reconstruction Transcriptional Regulatory Networks through using scientific literature.

Local non-negative initial data scalar characterization of the Kerr solution

For any vacuum initial data set, we define a local, non-negative scalar quantity which vanishes at every point of the data hypersurface if and only if the data are Kerr initial data. Our scalar quantity only depends on the quantities used to construct the vacuum initial data set which are the Riemannian metric defined on the initial data hypersurface and a symmetric tensor which plays the role of the second fundamental form of the embedded initial data hypersurface. The dependency is algorithmic in the sense that given the initial data one can compute the scalar quantity by algebraic and differential manipulations, being thus suitable for an implementation in a numerical code. The scalar could also be useful in studies of the non-linear stability of the Kerr solution because it serves to measure the deviation of a vacuum initial data set from the Kerr initial data in a local and algorithmic way.

Consequências da mora do segurador e o princípio neminem laedere no âmbito contratual

Relatório de atividade profissional de mestrado em Direito dos Contratos e da Empresa

Avaliação externa de escolas: efeitos no desenvolvimento de projetos de educação para a saúde

Dissertação de mestrado em Ciências da Educação (área de especialização em Desenvolvimento Curricular e Inovação Educativa)

Avaliação externa de escolas e avaliação externa de aprendizagens no contexto institucional: um estudo paralelo sobre Brasil e Portugal

Dissertação de mestrado em Ciências da Educação (área de especialização em Desenvolvimento Curricular e Inovação Educativa)

Optimization of peptide nucleic acid fluorescence in situ hybridization (PNA-FISH) for the detection of bacteria: the effect of pH, dextran sulfate and probe concentration

Fluorescence in situ hybridization (FISH) is a molecular technique widely used for the detection and characterization of microbial populations. FISH is affected by a wide variety of abiotic and biotic variables and the way they interact with each other. This is translated into a wide variability of FISH procedures found in the literature. The aim of this work is to systematically study the effects of pH, dextran sulfate and probe concentration in the FISH protocol, using a general peptide nucleic acid (PNA) probe for the Eubacteria domain. For this, response surface methodology was used to optimize these 3 PNA-FISH parameters for Gram-negative (Escherichia coli and Pseudomonas fluorescens) and Gram-positive species (Listeria innocua, Staphylococcus epidermidis and Bacillus cereus). The obtained results show that a probe concentration higher than 300 nM is favorable for both groups. Interestingly, a clear distinction between the two groups regarding the optimal pH and dextran sulfate concentration was found: a high pH (approx. 10), combined with lower dextran sulfate concentration (approx. 2% [w/v]) for Gram-negative species and near-neutral pH (approx. 8), together with higher dextran sulfate concentrations (approx. 10% [w/v]) for Gram-positive species. This behavior seems to result from an interplay between pH and dextran sulfate and their ability to influence probe concentration and diffusion towards the rRNA target. This study shows that, for an optimum hybridization protocol, dextran sulfate and pH should be adjusted according to the target bacteria.

Structural and enzymatic characterization of ABgp46, a novel phage endolysin with broad anti-Gram-negative bacterial activity

The present study demonstrates the antibacterial potential of a phage endolysin against Gram-negative pathogens, particularly against multidrug resistant strains of Acinetobacter baumannii. We have cloned, heterologously expressed and characterized a novel endolysin (ABgp46) from Acinetobacter phage vb_AbaP_CEB1 and tested its antibacterial activity against several multidrug-resistant A. baumannii strains. LC-MS revealed that ABgp46 is an N-acetylmuramidase, that is also active over a broad pH range (4.0-10.0) and temperatures up to 50°C. Interestingly, ABgp46 has intrinsic and specific anti-A. baumannii activity, reducing multidrug resistant strains by up to 2 logs within 2 hours. By combining ABgp46 with several organic acids that act as outer membrane permeabilizing agents, it is possible to increase and broaden antibacterial activity to include other Gram-negative bacterial pathogens. In the presence of citric and malic acid, ABgp46 reduces A. baumannii below the detection limit (> 5 log) and more than 4 logs P. aeruginosa and Salmonella Typhimurium strains. Overall, this globular endolysin exhibits a broad and high activity against Gram-negative pathogens, that can be enhanced in presence of citric and malic acid, and be used in human and veterinary medicine.

Reconstruction of the regulatory network for Bacillus subtilis and reconciliation with gene expression data

The Supplementary Material for this article can be found online at: http://journal.frontiersin.org/article/10.3389/fmicb. 2016.00275