Estudio de la evolución de los sistemas Open Source de BI durante la última década.

El presente documento tiene por objetivo identificar la evolución que ha tenido la inteligencia de negocios en la ultima década, para determinar en que punto se encuentra y para donde va, además de identificar las alternativas de desarrollo que tiene, apalancándose con las Tecnologías de la Información, y más específicamente con las herramientas empaquetadas de BI de tipo Open Source.Así mismo, la presente investigación identifica las prácticas más convenientes, para sistematizar la elección y adaptación de la inteligencia de negocios en las organizaciones, analizando estas en uncaso exitoso real de implantación de la inteligencia de negocios sobre una herramienta BI tipo Open Source.

Sistemas de Información BI: Estado Actual y Herramientas de Software Libre

Actualmente muchas empresas ya sean grandes o pequeñas, se plantean implantar en su organización un sistema de información que les ayude en la toma de decisiones. Una de las tendencias actuales es implantar un sistema de BI (Business Intelligence). Muchas organizaciones implantan este tipo de sistemas sin haber realizado un estudio previo de las necesidades y problemas de la empresa, de los beneficios que se pretenden obtener con la implantación del sistema, de la aceptación y formación de los usuarios, de las herramientas y proveedores de BI,... y así un largo etcétera de situaciones y condiciones que se deberían tener en cuenta para la implantación de esta clase de sistemas en cualquier tipo de organización, ya sea grande o pequeña.En el presente artículo se realiza una síntesis de la amalgama de información existente en los sistemas de BI, se realiza una definición aclaratoria, así como también se expone su estado actual, beneficios, factores de riesgo, pasos para conseguir una implantación exitosa y los componentes y herramientas open source de los sistemas de BI. Primero se exponen las principales herramientas open source existentes en el mercado y se profundiza más especialmente en la Suite open source de BI Pentaho.

The effect of translocation-induced nuclear reorganization on gene expression.

Translocations are known to affect the expression of genes at the breakpoints and, in the case of unbalanced translocations, alter the gene copy number. However, a comprehensive understanding of the functional impact of this class of variation is lacking. Here, we have studied the effect of balanced chromosomal rearrangements on gene expression by comparing the transcriptomes of cell lines from controls and individuals with the t(11;22)(q23;q11) translocation. The number of differentially expressed transcripts between translocation-carrying and control cohorts is significantly higher than that observed between control samples alone, suggesting that balanced rearrangements have a greater effect on gene expression than normal variation. Many of the affected genes are located along the length of the derived chromosome 11. We show that this chromosome is concomitantly altered in its spatial organization, occupying a more central position in the nucleus than its nonrearranged counterpart. Derivative 22-mapping chromosome 22 genes, on the other hand, remain in their usual environment. Our results are consistent with recent studies that experimentally altered nuclear organization, and indicated that nuclear position plays a functional role in regulating the expression of some genes in mammalian cells. Our study suggests that chromosomal translocations can result in hitherto unforeseen, large-scale changes in gene expression that are the consequence of alterations in normal chromosome territory positioning. This has consequences for the patterns of gene expression change seen during tumorigenesis-associated genome instability and during the karyotype changes that lead to speciation.

Analysis of TNFAIP3, a feedback inhibitor of nuclear factor-κB and the neighbor intergenic 6q23 region in rheumatoid arthritis susceptibility

INTRODUCTION Genome-wide association studies of rheumatoid arthritis (RA) have identified an association of the disease with a 6q23 region devoid of genes. TNFAIP3, an RA candidate gene, flanks this region, and polymorphisms in both the TNFAIP3 gene and the intergenic region are associated with systemic lupus erythematosus. We hypothesized that there is a similar association with RA, including polymorphisms in TNFAIP3 and the intergenic region. METHODS To test this hypothesis, we selected tag-single nucleotide polymorphisms (SNPs) in both loci. They were analyzed in 1,651 patients with RA and 1,619 control individuals of Spanish ancestry. RESULTS Weak evidence of association was found both in the 6q23 intergenic region and in the TNFAIP3 locus. The rs582757 SNP and a common haplotype in the TNFAIP3 locus exhibited association with RA. In the intergenic region, two SNPs were associated, namely rs609438 and rs13207033. The latter was only associated in patients with anti-citrullinated peptide antibodies. Overall, statistical association was best explained by the interdependent contribution of SNPs from the two loci TNFAIP3 and the 6q23 intergenic region. CONCLUSIONS Our data are consistent with the hypothesis that several RA genetic factors exist in the 6q23 region, including polymorphisms in the TNFAIP3 gene, like that previously described for systemic lupus erythematosus.

The nuclear receptor DHR3 modulates dS6 kinase-dependent growth in Drosophila.

S6 kinases (S6Ks) act to integrate nutrient and insulin signaling pathways and, as such, function as positive effectors in cell growth and organismal development. However, they also have been shown to play a key role in limiting insulin signaling and in mediating the autophagic response. To identify novel regulators of S6K signaling, we have used a Drosophila-based, sensitized, gain-of-function genetic screen. Unexpectedly, one of the strongest enhancers to emerge from this screen was the nuclear receptor (NR), Drosophila hormone receptor 3 (DHR3), a critical constituent in the coordination of Drosophila metamorphosis. Here we demonstrate that DHR3, through dS6K, also acts to regulate cell-autonomous growth. Moreover, we show that the ligand-binding domain (LBD) of DHR3 is essential for mediating this response. Consistent with these findings, we have identified an endogenous DHR3 isoform that lacks the DBD. These results provide the first molecular link between the dS6K pathway, critical in controlling nutrient-dependent growth, and that of DHR3, a major mediator of ecdysone signaling, which, acting together, coordinate metamorphosis.

Tumor architecture exerts no bias on nuclear grading in breast cancer diagnosis.

We recently reported that nuclear grading in prostate cancer is subject to a strong confirmation bias induced by the tumor architecture. We now wondered whether a similar bias governs nuclear grading in breast carcinoma. An unannounced test was performed at a pathology conference. Pathologists were asked to grade nuclei in a PowerPoint presentation. Circular high power fields of 27 invasive ductal carcinomas were shown, superimposed over low power background images of either tubule-rich or tubule-poor carcinomas. We found (a) that diagnostic reproducibility of nuclear grades was poor to moderate (weighed kappa values between 0.07 and 0.54, 27 cases, 44 graders), but (b) that nuclear grades were not affected by the tumor architecture. We speculate that the categorized grading in breast cancer, separating tubule formation, nuclear pleomorphism, and mitotic figure counts in a combined three tier score, prevents the bias that architecture exerts on nuclear grades in less well-controlled situations.

Tests for sex-biased dispersal using bi-parentally inherited genetic markers.

Understanding why dispersal is sex-biased in many taxa is still a major concern in evolutionary ecology. Dispersal tends to be male-biased in mammals and female-biased in birds, but counter-examples exist and little is known about sex bias in other taxa. Obtaining accurate measures of dispersal in the field remains a problem. Here we describe and compare several methods for detecting sex-biased dispersal using bi-parentally inherited, codominant genetic markers. If gene flow is restricted among populations, then the genotype of an individual tells something about its origin. Provided that dispersal occurs at the juvenile stage and that sampling is carried out on adults, genotypes sampled from the dispersing sex should on average be less likely (compared to genotypes from the philopatric sex) in the population in which they were sampled. The dispersing sex should be less genetically structured and should present a larger heterozygote deficit. In this study we use computer simulations and a permutation test on four statistics to investigate the conditions under which sex-biased dispersal can be detected. Two tests emerge as fairly powerful. We present results concerning the optimal sampling strategy (varying number of samples, individuals, loci per individual and level of polymorphism) under different amounts of dispersal for each sex. These tests for biases in dispersal are also appropriate for any attribute (e.g. size, colour, status) suspected to influence the probability of dispersal. A windows program carrying out these tests can be freely downloaded from http://www.unil.ch/izea/softwares/fstat.html

CA88, a nuclear repetitive DNA sequence identified in Schistosoma mansoni, aids in the genotyping of nine Schistosoma species of medical and veterinary importance

CA88 is the first long nuclear repetitive DNA sequence identified in the blood fluke, Schistosoma mansoni. The assembled S. mansoni sequence, which contains the CA88 repeat, has 8,887 nucleotides and at least three repeat units of approximately 360 bp. In addition, CA88 also possesses an internal CA microsatellite, identified as SmBr18. Both PCR and BLAST analysis have been used to analyse and confirm the CA88 sequence in other S. mansoni sequences in the public database. PCR-acquired nuclear repetitive DNA sequence profiles from nine Schistosoma species were used to classify this organism into four genotypes. Included among the nine species analysed were five sequences of both African and Asian lineages that are known to infect humans. Within these genotypes, three of them refer to recognised species groups. A panel of four microsatellite loci, including SmBr18 and three previously published loci, has been used to characterise the nine Schistosoma species. Each species has been identified and classified based on its CA88 DNA fingerprint profile. Furthermore, microsatellite sequences and intra-specific variation have also been observed within the nine Schistosoma species sequences. Taken together, these results support the use of these markers in studying the population dynamics of Schistosoma isolates from endemic areas and also provide new methods for investigating the relationships between different populations of parasites. In addition, these data also indicate that Schistosoma magrebowiei is not a sister taxon to Schistosoma mattheei, prompting a new designation to a basal clade.

New insights into trypanosomatid U5 small nuclear ribonucleoproteins

Several protozoan parasites exist in the Trypanosomatidae family, including various agents of human diseases. Multiple lines of evidence suggest that important differences are present between the translational and mRNA processing (trans splicing) systems of trypanosomatids and other eukaryotes. In this context, certain small complexes of RNA and protein, which are named small nuclear ribonucleoproteins (U snRNPs), have an essential role in pre-mRNA processing, mainly during splicing. Even though they are well defined in mammals, snRNPs are still not well characterized in trypanosomatids. This study shows that a U5-15K protein is highly conserved among various trypanosomatid species. Tandem affinity pull-down assays revealed that this protein interacts with a novel U5-102K protein, which suggests the presence of a sub-complex that is potentially involved in the assembly of U4/U6-U5 tri-snRNPs. Functional analyses showed that U5-15K is essential for cell viability and is somehow involved with the trans and cis splicing machinery. Similar tandem affinity experiments with a trypanonosomatid U5-Cwc21 protein led to the purification of four U5 snRNP specific proteins and a Sm core, suggesting U5-Cwc-21 participation in the 35S U5 snRNP particle. Of these proteins, U5-200K was molecularly characterized. U5-200K has conserved domains, such as the DEAD/DEAH box helicase and Sec63 domains and displays a strong interaction with U5 snRNA.

From molecular action to physiological outputs: peroxisome proliferator-activated receptors are nuclear receptors at the crossroads of key cellular functions.

Peroxisome proliferator-activated receptors (PPARs) compose a family of three nuclear receptors which act as lipid sensors to modulate gene expression. As such, PPARs are implicated in major metabolic and inflammatory regulations with far-reaching medical consequences, as well as in important processes controlling cellular fate. Throughout this review, we focus on the cellular functions of these receptors. The molecular mechanisms through which PPARs regulate transcription are thoroughly addressed with particular emphasis on the latest results on corepressor and coactivator action. Their implication in cellular metabolism and in the control of the balance between cell proliferation, differentiation and survival is then reviewed. Finally, we discuss how the integration of various intra-cellular signaling pathways allows PPARs to participate to whole-body homeostasis by mediating regulatory crosstalks between organs.

Three-dimensional high-resolution fast spin-echo coronary magnetic resonance angiography.

Due to SNR constraints, current "bright-blood" 3D coronary MRA approaches still suffer from limited spatial resolution when compared to conventional x-ray coronary angiography. Recent 2D fast spin-echo black-blood techniques maximize signal for coronary MRA at no loss in image spatial resolution. This suggests that the extension of black-blood coronary MRA with a 3D imaging technique would allow for a further signal increase, which may be traded for an improved spatial resolution. Therefore, a dual-inversion 3D fast spin-echo imaging sequence and real-time navigator technology were combined for high-resolution free-breathing black-blood coronary MRA. In-plane image resolution below 400 microm was obtained. Magn Reson Med 45:206-211, 2001.

Bi-ventricular axial micropump: impact on blood cell integrity.

BACKGROUND AND OBJECTIVE: Off-pump coronary artery bypass grafting has stimulated the development of micro-pumps designed to prevent the hemodynamic instability induced by heart luxation for the exposure of target vessels of the posterior wall. Impella (Aachen, Germany) developed micro-pumps with a miniaturized propeller system for both sides of the heart. The aim of this study was to analyze the impact of both pumps working together on blood cell integrity. MATERIALS AND METHODS: Both right and left-sided micro-pumps were implanted in 5 calves (body weight, 72_4 Kg) during 3 h. Blood samples for hematology and hemolysis parameters were drawn hourly. RESULTS: Both pumps performed well with a flow of 3.6 L +/- 0.3 L during the 3 h of the experiment with stable hemodynamic conditions. Mixed venous oxygen saturation was 63.4 +/- 15.2% at baseline and 63.8 +/- 16.3% at the end of the experiment (P = ns). Red cell count, LDH and free plasma hemoglobin were 6.7 +/- 2.1 x 10(12)/L, 1807 +/- 437 IU/L, and 32 +/- 9 mg/L at baseline vs. 6.1 +/- 2.1 x 10(12)/L, 1871 +/- 410 IU/L, and 52 +/- 9 mg/L at the end of the experiment (P = ns for all comparisons). Platelet count exhibited a non-significant drop (872 +/- 126 vs. 715 +/- 22 x 10(9)/L). CONCLUSIONS: This double pump system based on the Archimed screw principle is hematologically well tolerated under conditions of prolonged cardiac assist.

Oxidants positively or negatively regulate nuclear factor kappaB in a context-dependent manner.

Redox-based mechanisms play critical roles in the regulation of multiple cellular functions. NF-kappaB, a master regulator of inflammation, is an inducible transcription factor generally considered to be redox-sensitive, but the modes of interactions between oxidant stress and NF-kappaB are incompletely defined. Here, we show that oxidants can either amplify or suppress NF-kappaB activation in vitro by interfering both with positive and negative signals in the NF-kappaB pathway. NF-kappaB activation was evaluated in lung A549 epithelial cells stimulated with tumor necrosis factor alpha (TNFalpha), either alone or in combination with various oxidant species, including hydrogen peroxide or peroxynitrite. Exposure to oxidants after TNFalpha stimulation produced a robust and long lasting hyperactivation of NF-kappaB by preventing resynthesis of the NF-kappaB inhibitor IkappaB, thereby abrogating the major negative feedback loop of NF-kappaB. This effect was related to continuous activation of inhibitor of kappaB kinase (IKK), due to persistent IKK phosphorylation consecutive to oxidant-mediated inactivation of protein phosphatase 2A. In contrast, exposure to oxidants before TNFalpha stimulation impaired IKK phosphorylation and activation, leading to complete prevention of NF-kappaB activation. Comparable effects were obtained when interleukin-1beta was used instead of TNFalpha as the NF-kappaB activator. This study demonstrates that the influence of oxidants on NF-kappaB is entirely context-dependent, and that the final outcome (activation versus inhibition) depends on a balanced inhibition of protein phosphatase 2A and IKK by oxidant species. Our findings provide a new conceptual framework to understand the role of oxidant stress during inflammatory processes.

Metabolic and structural rearrangement during dark-induced autophagy in soybean (Glycine max L.) nodules: an electron microscopy and 31P and 13C nuclear magnetic resonance study.

The effects of dark-induced stress on the evolution of the soluble metabolites present in senescent soybean (Glycine max L.) nodules were analysed in vitro using (13)C- and (31)P-NMR spectroscopy. Sucrose and trehalose were the predominant soluble storage carbons. During dark-induced stress, a decline in sugars and some key glycolytic metabolites was observed. Whereas 84% of the sucrose disappeared, only one-half of the trehalose was utilised. This decline coincides with the depletion of Gln, Asn, Ala and with an accumulation of ureides, which reflect a huge reduction of the N(2) fixation. Concomitantly, phosphodiesters and compounds like P-choline, a good marker of membrane phospholipids hydrolysis and cell autophagy, accumulated in the nodules. An autophagic process was confirmed by the decrease in cell fatty acid content. In addition, a slight increase in unsaturated fatty acids (oleic and linoleic acids) was observed, probably as a response to peroxidation reactions. Electron microscopy analysis revealed that, despite membranes dismantling, most of the bacteroids seem to be structurally intact. Taken together, our results show that the carbohydrate starvation induced in soybean by dark stress triggers a profound metabolic and structural rearrangement in the infected cells of soybean nodule which is representative of symbiotic cessation.