An Open Source BI Approach: Concept Proof Tracking Fleet

É possível assistir nos dias de hoje, a um processo tecnológico evolutivo acentuado por toda a parte do globo. No caso das empresas, quer as pequenas, médias ou de grandes dimensões, estão cada vez mais dependentes dos sistemas informatizados para realizar os seus processos de negócio, e consequentemente à geração de informação referente aos negócios e onde, muitas das vezes, os dados não têm qualquer relacionamento entre si. A maioria dos sistemas convencionais informáticos não são projetados para gerir e armazenar informações estratégicas, impossibilitando assim que esta sirva de apoio como recurso estratégico. Portanto, as decisões são tomadas com base na experiência dos administradores, quando poderiam serem baseadas em factos históricos armazenados pelos diversos sistemas. Genericamente, as organizações possuem muitos dados, mas na maioria dos casos extraem pouca informação, o que é um problema em termos de mercados competitivos. Como as organizações procuram evoluir e superar a concorrência nas tomadas de decisão, surge neste contexto o termo Business Intelligence(BI). A GisGeo Information Systems é uma empresa que desenvolve software baseado em SIG (sistemas de informação geográfica) recorrendo a uma filosofia de ferramentas open-source. O seu principal produto baseia-se na localização geográfica dos vários tipos de viaturas, na recolha de dados, e consequentemente a sua análise (quilómetros percorridos, duração de uma viagem entre dois pontos definidos, consumo de combustível, etc.). Neste âmbito surge o tema deste projeto que tem objetivo de dar uma perspetiva diferente aos dados existentes, cruzando os conceitos BI com o sistema implementado na empresa de acordo com a sua filosofia. Neste projeto são abordados alguns dos conceitos mais importantes adjacentes a BI como, por exemplo, modelo dimensional, data Warehouse, o processo ETL e OLAP, seguindo a metodologia de Ralph Kimball. São também estudadas algumas das principais ferramentas open-source existentes no mercado, assim como quais as suas vantagens/desvantagens relativamente entre elas. Em conclusão, é então apresentada a solução desenvolvida de acordo com os critérios enumerados pela empresa como prova de conceito da aplicabilidade da área Business Intelligence ao ramo de Sistemas de informação Geográfica (SIG), recorrendo a uma ferramenta open-source que suporte visualização dos dados através de dashboards.

Tracking the source of cerebellar epilepsy: hemifacial seizures associated with cerebellar cortical dysplasia.

Traditionally, subcortical structures such as the cerebellum are supposed to exert a modulatory effect on epileptic seizures, rather than being the primary seizure generator. We report a 14-month old girl presenting, since birth, with seizures symptomatic of a right cerebellar dysplasia, manifested as paroxystic contralateral hemifacial spasm and ipsilateral facial weakness. Multimodal imaging was used to investigate both anatomical landmarks related to the cerebellar lesion and mechanisms underlying seizure generation. Electric source imaging (ESI) supported the hypothesis of a right cerebellar epileptogenic generator in concordance with nuclear imaging findings; subsequently validated by intra-operative intralesional recordings. Diffusion spectrum imaging-related tractography (DSI) showed severe cerebellar structural abnormalities confirmed by histological examination. We suggest that hemispheric cerebellar lesions in cases like this are likely to cause epilepsy via an effect on the facial nuclei through ipsilateral and contralateral aberrant connections.

Virulence profiles of bacteremic extended-spectrum β-lactamase-producing Escherichia coli: association with epidemiological and clinical features.

There is scarce data about the importance of phylogroups and virulence factors (VF) in bloodstream infections (BSI) caused by extended-spectrum β-lactamase-producing Escherichia coli (ESBLEC). A prospective multicenter Spanish cohort including 191 cases of BSI due to ESBLEC was studied. Phylogroups and 25 VF genes were investigated by PCR. ESBLEC were classified into clusters according to their virulence profiles. The association of phylogropus, VF, and clusters with epidemiological features were studied using multivariate analysis. Overall, 57.6%, 26.7%, and 15.7% of isolates belonged to A/B1, D and B2 phylogroups, respectively. By multivariate analysis (adjusted OR [95% CI]), virulence cluster C2 was independently associated with urinary tract source (5.05 [0.96-25.48]); cluster C4 with sources other than urinary of biliary tract (2.89 [1.05-7.93]), and cluster C5 with BSI in non-predisposed patients (2.80 [0.99-7.93]). Isolates producing CTX-M-9 group ESBLs and from phylogroup D predominated among cluster C2 and C5, while CTX-M-1 group of ESBL and phylogroup B2 predominantes among C4 isolates. These results suggest that host factors and previous antimicrobial use were more important than phylogroup or specific VF in the occurrence of BSI due to ESBLEC. However, some associations between virulence clusters and some specific epidemiological features were found.

Improving the microbial production of biofuels through metabolic engineering

Les défis conjoints du changement climatique d'origine anthropique et la diminution des réserves de combustibles fossiles sont le moteur de recherche intense pour des sources d'énergie alternatives. Une avenue attrayante est d'utiliser un processus biologique pour produire un biocarburant. Parmi les différentes options en matière de biocarburants, le bio-hydrogène gazeux est un futur vecteur énergétique attrayant en raison de son efficacité potentiellement plus élevé de conversion de puissance utilisable, il est faible en génération inexistante de polluants et de haute densité d'énergie. Cependant, les faibles rendements et taux de production ont été les principaux obstacles à l'application pratique des technologies de bio-hydrogène. Des recherches intensives sur bio-hydrogène sont en cours, et dans les dernières années, plusieurs nouvelles approches ont été proposées et étudiées pour dépasser ces inconvénients. À cette fin, l'objectif principal de cette thèse était d'améliorer le rendement en hydrogène moléculaire avec un accent particulier sur l'ingénierie métabolique et l’utilisation de bioprocédés à variables indépendantes. Une de nos hypothèses était que la production d’hydrogène pourrait être améliorée et rendue plus économiquement viable par ingénierie métabolique de souches d’Escherichia coli producteurs d’hydrogène en utilisant le glucose ainsi que diverses autres sources de carbone, y compris les pentoses. Les effets du pH, de la température et de sources de carbone ont été étudiés. La production maximale d'hydrogène a été obtenue à partir de glucose, à un pH initial de 6.5 et une température de 35°C. Les études de cinétiques de croissance ont montré que la μmax était 0.0495 h-1 avec un Ks de 0.0274 g L-1 lorsque le glucose est la seule source de carbone en milieu minimal M9. .Parmi les nombreux sucres et les dérivés de sucres testés, les rendements les plus élevés d'hydrogène sont avec du fructose, sorbitol et D-glucose; 1.27, 1.46 et 1.51 mol H2 mol-1 de substrat, respectivement. En outre, pour obtenir les interactions entre les variables importantes et pour atteindre une production maximale d'hydrogène, un design 3K factoriel complet Box-Behnken et la méthodologie de réponse de surface (RSM) ont été employées pour la conception expérimentale et l'analyse de la souche d'Escherichia coli DJT135. Le rendement en hydrogène molaire maximale de 1.69 mol H2 mol-1 de glucose a été obtenu dans les conditions optimales de 75 mM de glucose, à 35°C et un pH de 6.5. Ainsi, la RSM avec un design Box-Behken était un outil statistique utile pour atteindre des rendements plus élevés d'hydrogène molaires par des organismes modifiés génétiquement. Ensuite, l'expression hétérologue de l’hydrogénases soluble [Ni-Fe] de Ralstonia eutropha H16 (l'hydrogénase SH) a tenté de démontrer que la mise en place d'une voie capable de dériver l'hydrogène à partir de NADH pourrait surpasser le rendement stoechiométrique en hydrogène.. L’expression a été démontrée par des tests in vitro de l'activité enzymatique. Par ailleurs, l'expression de SH a restaurée la croissance en anaérobie de souches mutantes pour adhE, normalement inhibées en raison de l'incapacité de réoxyder le NADH. La mesure de la production d'hydrogène in vivo a montré que plusieurs souches modifiées métaboliquement sont capables d'utiliser l'hydrogénase SH pour dériver deux moles d’hydrogène par mole de glucose consommé, proche du maximum théorique. Une autre stratégie a montré que le glycérol brut pourrait être converti en hydrogène par photofermentation utilisant Rhodopseudomonas palustris par photofermentation. Les effets de la source d'azote et de différentes concentrations de glycérol brut sur ce processus ont été évalués. À 20 mM de glycérol, 4 mM glutamate, 6.1 mol hydrogène / mole de glycérol brut ont été obtenus dans des conditions optimales, un rendement de 87% de la théorie, et significativement plus élevés que ce qui a été réalisé auparavant. En prolongement de cette étude, l'optimisation des paramètres a également été utilisée. Dans des conditions optimales, une intensité lumineuse de 175 W/m2, 30 mM glycérol et 4.5 mM de glutamate, 6.69 mol hydrogène / mole de glycérol brut ont été obtenus, soit un rendement de 96% de la valeur théorique. La détermination de l'activité de la nitrogénase et ses niveaux d'expression ont montré qu'il y avait relativement peu de variation de la quantité de nitrogénase avec le changement des variables alors que l'activité de la nitrogénase variait considérablement, avec une activité maximale (228 nmol de C2H4/ml/min) au point central optimal. Dans la dernière section, la production d'hydrogène à partir du glucose via la photofermentation en une seule étape a été examinée avec la bactérie photosynthétique Rhodobacter capsulatus JP91 (hup-). La méthodologie de surface de réponse avec Box-Behnken a été utilisée pour optimiser les variables expérimentales de façon indépendante, soit la concentration de glucose, la concentration du glutamate et l'intensité lumineuse, ainsi que d'examiner leurs effets interactifs pour la maximisation du rendement en hydrogène moléculaire. Dans des conditions optimales, avec une intensité lumineuse de 175 W/m2, 35 mM de glucose, et 4.5 mM de glutamate,, un rendement maximal d'hydrogène de 5.5 (± 0.15) mol hydrogène /mol glucose, et un maximum d'activité de la nitrogénase de 246 (± 3.5) nmol C2H4/ml/min ont été obtenus. L'analyse densitométrique de l'expression de la protéine-Fe nitrogenase dans les différentes conditions a montré une variation significative de l'expression protéique avec un maximum au point central optimisé. Même dans des conditions optimales pour la production d'hydrogène, une fraction significative de la protéine Fe a été trouvée dans l'état ADP-ribosylée, suggérant que d'autres améliorations des rendements pourraient être possibles. À cette fin, un mutant amtB dérivé de Rhodobacter capsulatus JP91 (hup-) a été créé en utilisant le vecteur de suicide pSUP202. Les résultats expérimentaux préliminaires montrent que la souche nouvellement conçue métaboliquement, R. capsulatus DG9, produit 8.2 (± 0.06) mol hydrogène / mole de glucose dans des conditions optimales de cultures discontinues (intensité lumineuse, 175 W/m2, 35 mM de glucose et 4.5 mM glutamate). Le statut d'ADP-ribosylation de la nitrogénase-protéine Fe a été obtenu par Western Blot pour la souche R. capsulatus DG9. En bref, la production d'hydrogène est limitée par une barrière métabolique. La principale barrière métabolique est due au manque d'outils moléculaires possibles pour atteindre ou dépasser le rendement stochiométrique en bio-hydrogène depuis les dernières décennies en utilisant les microbes. À cette fin, une nouvelle approche d’ingénierie métabolique semble très prometteuse pour surmonter cette contrainte vers l'industrialisation et s'assurer de la faisabilité de la technologie de la production d'hydrogène. Dans la présente étude, il a été démontré que l’ingénierie métabolique de bactéries anaérobiques facultatives (Escherichia coli) et de bactéries anaérobiques photosynthétiques (Rhodobacter capsulatus et Rhodopseudomonas palustris) peuvent produire de l'hydrogène en tant que produit majeur à travers le mode de fermentation par redirection métabolique vers la production d'énergie potentielle. D'autre part, la méthodologie de surface de réponse utilisée dans cette étude représente un outil potentiel pour optimiser la production d'hydrogène en générant des informations appropriées concernant la corrélation entre les variables et des producteurs de bio-de hydrogène modifiés par ingénierie métabolique. Ainsi, un outil d'optimisation des paramètres représente une nouvelle avenue pour faire un pont entre le laboratoire et la production d'hydrogène à l'échelle industrielle en fournissant un modèle mathématique potentiel pour intensifier la production de bio-hydrogène. Par conséquent, il a été clairement mis en évidence dans ce projet que l'effort combiné de l'ingénierie métabolique et la méthodologie de surface de réponse peut rendre la technologie de production de bio-hydrogène potentiellement possible vers sa commercialisation dans un avenir rapproché.

Molecular inventory of faecal microflora in patients with Crohn's disease

Intestinal microbial community is involved in the pathogenesis of Crohn's disease, but knowledge of its potential abnormalities has been limited by the impossibility to grow many dominant intestinal bacteria. Using sequence analysis of randomly cloned bacterial 16S ribosomal DNA, the dominant faecal species from four Crolin's disease patients and four controls were compared. Whereas marked inter-individual differences were observed in the faecal microflora of patients, three remained distantly related to controls on the basis of their operational taxonomic unit composition. Bacteroides vidgatus and closely related organisms represented the only molecular species shared by all patients and exhibited an unusually high rate of occurrence. Escherichia coli clones were isolated only in two patients with ileocolonic Crohn's disease. Moreover, numerous clones belonged to phylogenetic groups or species that are commonly not dominant in the faecal microflora of healthy subjects: Pectinatus, Sutterella, Verritcomicrobium, Fusobacterium, Clostridium disporicum, clostridium glycolicum, Clostridium ramosum, Clostridium innocuum and Clostridium perfringens. (C) 2004 Federation of European Microbiological Societies. Published by Elsevier B.V. All rights reserved.

Predicting microbial pollution concentrations in UK rivers in response to land use change

The Water Framework Directive has caused a paradigm shift towards the integrated management of recreational water quality through the development of drainage basin-wide programmes of measures. This has increased the need for a cost-effective diagnostic tool capable of accurately predicting riverine faecal indicator organism (FIO) concentrations. This paper outlines the application of models developed to fulfil this need, which represent the first transferrable generic FIO models to be developed for the UK to incorporate direct measures of key FIO sources (namely human and livestock population data) as predictor variables. We apply a recently developed transfer methodology, which enables the quantification of geometric mean presumptive faecal coliforms and presumptive intestinal enterococci concentrations for base- and high-flow during the summer bathing season in unmonitored UK watercourses, to predict FIO concentrations in the Humber river basin district. Because the FIO models incorporate explanatory variables which allow the effects of policy measures which influence livestock stocking rates to be assessed, we carry out empirical analysis of the differential effects of seven land use management and policy instruments (fiscal constraint, production constraint, cost intervention, area intervention, demand-side constraint, input constraint, and micro-level land use management) all of which can be used to reduce riverine FIO concentrations. This research provides insights into FIO source apportionment, explores a selection of pollution remediation strategies and the spatial differentiation of land use policies which could be implemented to deliver river quality improvements. All of the policy tools we model reduce FIO concentrations in rivers but our research suggests that the installation of streamside fencing in intensive milk producing areas may be the single most effective land management strategy to reduce riverine microbial pollution.

Gut microbial catabolism of grape seed flavan-3-ols by human faecal microbiota. Targetted analysis of precursor compounds, intermediate metabolites and end-products.

In vitro batch culture fermentations were conducted with grape seed polyphenols and human faecal microbiota, in order to monitor both changes in precursor flavan-3-ols and the formation of microbial-derived metabolites. By the application of UPLC-DAD-ESI-TQ MS, monomers, and dimeric and trimeric procyanidins were shown to be degraded during the first 10 h of fermentation, with notable inter-individual differences being observed between fermentations. This period (10 h) also coincided with the maximum formation of intermediate metabolites, such as 5-(3′,4′-dihydroxyphenyl)-γ-valerolactone and 4-hydroxy-5-(3′,4′-dihydroxyphenyl)-valeric acid, and of several phenolic acids, including 3-(3,4-dihydroxyphenyl)-propionic acid, 3,4-dihydroxyphenylacetic acid, 4-hydroxymandelic acid, and gallic acid (5–10 h maximum formation). Later phases of the incubations (10–48 h) were characterised by the appearance of mono- and non-hydroxylated forms of previous metabolites by dehydroxylation reactions. Of particular interest was the detection of γ-valerolactone, which was seen for the first time as a metabolite from the microbial catabolism of flavan-3-ols. Changes registered during fermentation were finally summarised by a principal component analysis (PCA). Results revealed that 5-(3′,4′-dihydroxyphenyl)-γ-valerolactone was a key metabolite in explaining inter-individual differences and delineating the rate and extent of the microbial catabolism of flavan-3-ols, which could finally affect absorption and bioactivity of these compounds.

Assessing the microbial oxidative stress mechanism of ozone treatment through the responses of Escherichia coli mutants

Aims: To investigate the effect of the oxidative stress of ozone on the microbial inactivation, cell membrane integrity and permeability and morphology changes of Escherichia coli. Methods and Results: Escherichia coli BW 25113 and its isogenic mutants in soxR, soxS, oxyR, rpoS and dnaK genes were treated with ozone at a concentration of 6 lg ml)1 for a period up to 240 s. A significant effect of ozone exposure on microbial inactivation was observed. After ozonation, minor effects on the cell membrane integrity and permeability were observed, while scanning electron microscopy analysis showed slightly altered cell surface structure. Conclusions: The results of this study suggest that cell lysis was not the major mechanism of microbial inactivation. The deletion of oxidative stress–related genes resulted in increased susceptibility of E. coli cells to ozone treatment, implying that they play an important role for protection against the radicals produced by ozone. However, DnaK that has previously been shown to protect against oxidative stress did not protect against ozone treatment in this study. Furthermore, RpoS was important for the survival against ozone. Significance and Impact of the Study: This study provides important information about the role of oxidative stress in the responses of E. coli during ozonation.

The role of type 1 and curli fimbriae of Shiga toxin-producing Escherichia coli in adherence to abiotic surfaces

Biofilm formation on abiotic surfaces may provide a source of microbial contamination and may also enhance microbial environmental survival. The role of fimbrial expression by Shiga toxin-producing Escherichia coli (STEC) in biofilm formation is poorly understood. This study aimed to investigate the role of STEC type 1 and curli fimbriae in adhesion to and biofilm formation on abiotic surfaces. None of 13 O157:H7 isolates expressed either fimbrial type whereas 11 of 13 and 5 of 13 non-O157 STEC elaborated type 1 fimbriae and curli fimbriae, respectively. Mutants made by allelic exchange of a diarrhoeal non-O157 STEC isolate, O128:H2 (E41509), unable to elaborate type 1 and curli fimbriae were made for adherence and biofilm assays. Elaboration of type 1 fimbriae was necessary for the adhesion to abiotic surfaces whereas curliation was associated with both adherence and subsequent biofilm formation. STEC O157:H7 adhered to thermanox and glass but poorly to polystyrene. Additionally, STEC O157:H7 failed to form biofilms. These data indicate that certain STEC isolates are able to form biofilms and that the elaboration of curli fimbriae may enhance biofilm formation leading to possible long-term survival and a potential source of human infection.

The impact of date palm fruits and their component polyphenols, on gut microbial ecology, bacterial metabolites and colon cancer cell proliferation

The fruit of the date palm (Phoenix dactylifera L.) is a rich source of dietary fibre and polyphenols. We have investigated gut bacterial changes induced by the whole date fruit extract (digested date extract; DDE) and its polyphenol-rich extract (date polyphenol extract; DPE) using faecal, pH-controlled, mixed batch cultures mimicking the distal part of the human large intestine, and utilising an array of microbial group-specific 16S rRNA oligonucleotide probes. Fluorescence microscopic enumeration indicated that there was a significant increase in the growth of bifidobacteria in response to both treatments, whilst whole dates also increased bacteroides at 24 h and the total bacterial counts at later fermentation time points when compared with DPE alone. Bacterial metabolism of whole date fruit led to the production of SCFA, with acetate significantly increasing following bacterial incubation with DDE. In addition, the production of flavonoid aglycones (myricetin, luteolin, quercetin and apigenin) and the anthocyanidin petunidin in less than 1 h was also observed. Lastly, the potential of DDE, DPE and metabolites to inhibit Caco-2 cell growth was investigated, indicating that both were capable of potentially acting as antiproliferative agents in vitro, following a 48 h exposure. This potential to inhibit growth was reduced following fermentation. Together these data suggest that consumption of date fruits may enhance colon health by increasing beneficial bacterial growth and inhibiting the proliferation of colon cancer cells. This is an early suggestion that date intake by humans may aid in the maintenance of bowel health and even the reduction of colorectal cancer development.

Chemiluminescence as a PDT light source for microbial control

The photodynamic therapy (PDT) is a combination of using a photosensitizer agent, light and oxygen that can cause oxidative cellular damage. This technique is applied in several cases, including for microbial control. The most extensively studied light sources for this purpose are lasers and LED-based systems. Few studies treat alternative light sources based PDT. Sources which present flexibility, portability and economic advantages are of great interest. In this study, we evaluated the in vitro feasibility for the use of chemiluminescence as a PDT light source to induce Staphylococcus aureus reduction. The Photogem (R) concentration varied from 0 to 75 mu g/ml and the illumination time varied from 60 min to 240 min. The long exposure time was necessary due to the low irradiance achieved with chemiluminescence reaction at mu W/cm(2) level. The results demonstrated an effective microbial reduction of around 98% for the highest photosensitizer concentration and light dose. These data suggest the potential use of chemiluminescence as a light source for PDT microbial control, with advantages in terms of flexibility, when compared with conventional sources. (C) 2011 Elsevier B.V. All rights reserved.

Chemiluminescence as a PDT light source for microbial control

Fundação de Amparo à Pesquisa do Estado de São Paulo (FAPESP)

Use of probiotics to reduce faecal shedding of Shiga toxin-producing Escherichia coli in sheep

Fundação de Amparo à Pesquisa do Estado de São Paulo (FAPESP)

Assessing drinking water quality at source and point-of-use : a case study of Koila Bamana, Mali, West Africa

Ensuring water is safe at source and point-of-use is important in areas of the world where drinking water is collected from communal supplies. This report describes a study in rural Mali to determine the appropriateness of assumptions common among development organizations that drinking water will remain safe at point-of-use if collected from a safe (improved) source. Water was collected from ten sources (borehole wells with hand pumps, and hand-dug wells) and forty-five households using water from each source type. Water quality was evaluated seasonally (quarterly) for levels of total coliform, E.coli, and turbidity. Microbial testing was done using the 3M Petrifilm™ method. Turbidity testing was done using a turbidity tube. Microbial testing results were analyzed using statistical tests including Kruskal-Wallis, Mann Whitney, and analysis of variance. Results show that water from hand pumps did not contain total coliform or E.coli and had turbidity under 5 NTUs, whereas water from dug wells had high levels of bacteria and turbidity. However water at point-of-use (household) from hand pumps showed microbial contamination - at times being indistinguishable from households using dug wells - indicating a decline in water quality from source to point-of-use. Chemical treatment at point-of-use is suggested as an appropriate solution to eliminating any post-source contamination. Additionally, it is recommended that future work be done to modify existing water development strategies to consider water quality at point-of-use.

Prevalence and risk-factor analysis of Shiga toxigenic Escherichia coli in faecal samples of organically and conventionally farmed dairy cattle

Cattle are a natural reservoir for Shiga toxigenic Escherichia coli (STEC), however, no data are available on the prevalence and their possible association with organic or conventional farming practices. We have therefore studied the prevalence of STEC and specifically O157:H7 in Swiss dairy cattle by collecting faeces from approximately 500 cows from 60 farms with organic production (OP) and 60 farms with integrated (conventional) production (IP). IP farms were matched to OP farms and were comparable in terms of community, agricultural zone, and number of cows per farm. E. coli were grown overnight in an enrichment medium, followed by DNA isolation and PCR analysis using specific TaqMan assays. STEC were detected in all farms and O157:H7 were present in 25% of OP farms and 17% of IP farms. STEC were detected in 58% and O157:H7 were evidenced in 4.6% of individual faeces. Multivariate statistical analyses of over 250 parameters revealed several risk-factors for the presence of STEC and O157:H7. Risk-factors were mainly related to the potential of cross-contamination of feeds and cross-infection of cows, and age of the animals. In general, no significant differences between the two farm types concerning prevalence or risk for carrying STEC or O157:H7 were observed. Because the incidence of human disease caused by STEC in Switzerland is low, the risk that people to get infected appears to be small despite a relatively high prevalence in cattle. Nevertheless, control and prevention practices are indicated to avoid contamination of animal products.