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.

Patterns of Mycobacterium tuberculosis-complex excretion and characterization of super-shedders in naturally-infected wild boar and red deer

Wild boar (Sus scrofa) and red deer (Cervus elaphus) are the main maintenance hosts for bovine tuberculosis (bTB) in continental Europe. Understanding Mycobacterium tuberculosis complex (MTC) excretion routes is crucial to define strategies to control bTB in free-ranging populations, nevertheless available information is scarce. Aiming at filling this gap, four different MTC excretion routes (oronasal, bronchial-alveolar, fecal and urinary) were investigated by molecular methods in naturally infected hunter-harvested wild boar and red deer. In addition MTC concentrations were estimated by the Most Probable Number method. MTC DNA was amplified in all types of excretion routes. MTC DNA was amplified in at least one excretion route from 83.0% (CI95 70.8-90.8) of wild ungulates with bTB-like lesions. Oronasal or bronchial-alveolar shedding were detected with higher frequency than fecal shedding (p < 0.001). The majority of shedders yielded MTC concentrations <10(3) CFU/g or mL. However, from those ungulates from which oronasal, bronchial-alveolar and fecal samples were available, 28.2% of wild boar (CI95 16.6-43.8) and 35.7% of red deer (CI95 16.3-61.2) yielded MTC concentrations >10(3) CFU/g or mL (referred here as super-shedders). Red deer have a significantly higher risk of being super-shedders compared to wild boar (OR = 11.8, CI95 2.3-60.2). The existence of super-shedders among the naturally infected population of wild boar and red deer is thus reported here for the first time and MTC DNA concentrations greater than the minimum infective doses were estimated in excretion samples from both species.

Distribution of cardiac geometric patterns on echocardiography in essential hypertension. Impact of two criteria of stratification

PURPOSE: To evaluate 2 left ventricular mass index (LVMI) normality criteria for the prevalence of left ventricular geometric patterns in a hypertensive population ( HT ) . METHODS: 544 essential hypertensive patients, were evaluated by echocardiography, and different left ventricular hypertrophy criteria were applied: 1 - classic : men - 134 g/m² and women - 110 g/m² ; 2- obtained from the 95th percentil of LVMI from a normotensive population (NT). RESULTS: The prevalence of 4 left ventricular geometric patterns, respectively for criteria 1 and 2, were: normal geometry - 47.7% and 39.3%; concentric remodelying - 25.4% and 14.3%; concentric hypertrophy - 18.4% and 27.7% and excentric hypertrophy - 8.8% and 16.7%, which confered abnormal geometry to 52.6% and 60.7% of hypertensive. The comparative analysis between NT and normal geometry hypertensive group according to criteria 1, detected significative stuctural differences,"( *p < 0.05):LVMI- 78.4 ± 1.50 vs 85.9 ±0.95 g/m² *; posterior wall thickness -8.5 ± 0.1 vs 8.9 ± 0.05 mm*; left atrium - 33.3 ± 0.41 vs 34.7 ± 0.30 mm *. With criteria 2, significative structural differences between the 2 groups were not observed. CONCLUSION: The use of a reference population based criteria, increased the abnormal left ventricular geometry prevalence in hypertensive patients and seemed more appropriate for left ventricular hypertrophy detection and risk stratification.

Estrategias reproductivas de lagartos del género tupinambis en distintos contextos ecológicos de la Provincia de Córdoba. Reproductive strategies of lizards of genus tupinambis in different ecological contexts of the Cordoba province.

Los caracteres de historia de vida son sensibles a la variación histórica o actual de los factores ambientales. Estudiar dicha variabilidad mediante la realización de estudios comparativos permite obtener evidencias sobre las causas de la evolución de ciertos caracteres. Los lagartos son excelentes modelos para el estudio de selección sexual y evolución del comportamiento social y reproductivo debido a que su relativa baja dispersión podría tener consecuencias evolutivas profundas en el desarrollo de distintas estrategias, ya que las poblaciones, al encontrarse más aisladas, podrían verse influenciadas por las fuerzas selectivas locales, mostrando una alta heterogeneidad espacial y temporal. Por eso nos propusimos realizar este trabajo para evaluar si existen diferentes estrategias reproductivas en los lagartos del género Tupinambis en distintos contextos ecológicos de la provincia de Córdoba. Para ello analizaremos distintas características de la historia de vida en poblaciones de estas especies tales como estructura de tamaño, sexo operativo, frecuencia reproductiva, tamaño de camada, condición corporal reproductiva, tamaño de madurez sexual, características espermáticas, elección de sitios de nidificación, etc. Además analizaremos la estructura genética de las poblaciones para inferir procesos demográficos históricos y patrones actuales de flujo génico y conectividad. The life history traits are sensitive to historical or current variation of environmental factors. Studying this variability by performing comparative studies allows obtaining evidence on the causes of the evolution of certain characters. Lizards are excellent models for studying sexual selection and evolution of social and reproductive behavior because their relatively low dispersal capabilities could have profound evolutionary consequences in the development of different strategies, since isolated populations may be stronger influenced by local selective forces, showing a high spatial and temporal heterogeneity. We decided to perform this study to assess whether there are different reproductive strategies in lizards of the genus Tupinambis in different ecological contexts of the Cordoba province. We will analyze different life history traits in populations of these species such as size structure, operational sex ratio, reproductive frequency, litter size, body condition, size at sexual maturity, sperm characteristics, choice of nesting sites, etc.. We also analyzed the genetic structure of populations to infer historical demographic processes and current patterns of gene flow and connectivity.

Can climate shape flight activity patterns of Plebeia remota Hymenoptera, Apidae)?

Flight activity of foragers of four colonies of Plebeia remota (Holmberg, 1903) was registered from December 1998 to December 1999, using an automated system (photocells and PLC system). The colonies originated from two different regions: Cunha, state of São Paulo, and Prudentópolis, state of Paraná, Brazil. Flight activity was influenced by different climatic factors in each season. In the summer, the intensity of the correlations between flight activity and climatic factors was smaller than in the other seasons. During the autumn and winter, solar radiation was the factor that most influenced flight activity, while in the spring, this activity was influenced mainly by temperature. Except in the summer, the various climatic factors similarly influenced flight activity of all of the colonies. Flight activity was not affected by geographic origin of the colonies. Information concerning seasonal differences in flight activity of P. remota will be useful for prediction of geographic distribution scenarios under climatic changes.

Generating trees for permutations avoiding generalized patterns

We construct generating trees with with one, two, and three labels for some classes of permutations avoiding generalized patterns of length 3 and 4. These trees are built by adding at each level an entry to the right end of the permutation, which allows us to incorporate the adjacency condition about some entries in an occurrence of a generalized pattern. We use these trees to find functional equations for the generating functions enumerating these classes of permutations with respect to different parameters. In several cases we solve them using the kernel method and some ideas of Bousquet-Mélou [2]. We obtain refinements of known enumerative results and find new ones.

Reproductive isolation between different forms of Lutzomyia longipalpis (Lutz & Neiva), (Diptera: Psychodidae), the vector of Leishmania donovani chagasi Cunha & Chagas and its significance to kala-azar distribution in South America

The males of the sandfly Lutzomyia longipalpis occur in two forms, one which bears a single pair of pale spots on tergite 4 and another in which an additional pair of spots characterizes tergite 3. In crosses between laboratory reared stocks of the two forms originating from allopatric and sympatric sites in Brazil nearly all males of one form fail to inseminate females of the other. In addition, insemination failure between some allopatric populaytions of Lu. longipalpis with similar tergal spot patterns is recorded, indicating the existence of additional forms in an apparent species complex. The possibility that Lu. longipalpis sensu latu represents more than a single taxon is discussed and the relevance of these findings to future epidemiological studies on kala-azar is considered.

Addressing Sea Surface Salinity retrieval at different spatial resolution. Feasibility study using OCCAM data within SEPS simulator and L2 processor tools

Projecte de recerca elaborat a partir d’una estada a la National Oceanography Centre of Southampton (NOCS), Gran Bretanya, entre maig i juliol del 2006. La possibilitat d’obtenir una estimació precissa de la salinitat marina (SSS) és important per a investigar i predir l’extensió del fenòmen del canvi climàtic. La missió Soil Moisture and Ocean Salinity (SMOS) va ser seleccionada per l’Agència Espacial Europea (ESA) per a obtenir mapes de salinitat de la superfície marina a escala global i amb un temps de revisita petit. Abans del llençament de SMOS es preveu l’anàlisi de la variabilitat horitzontal de la SSS i del potencial de les dades recuperades a partir de mesures de SMOS per a reproduir comportaments oceanogràfics coneguts. L’objectiu de tot plegat és emplenar el buit existent entre les fonts de dades d’entrada/auxiliars fiables i les eines desenvolupades per a simular i processar les dades adquirides segons la configuració de SMOS. El SMOS End-to-end Performance Simulator (SEPS) és un simulador adhoc desenvolupat per la Universitat Politècnica de Catalunya (UPC) per a generar dades segons la configuració de SMOS. Es va utilitzar dades d’entrada a SEPS procedents del projecte Ocean Circulation and Climate Advanced Modeling (OCCAM), utilitzat al NOCS, a diferents resolucions espacials. Modificant SEPS per a poder fer servir com a entrada les dades OCCAM es van obtenir dades de temperatura de brillantor simulades durant un mes amb diferents observacions ascendents que cobrien la zona seleccionada. Les tasques realitzades durant l’estada a NOCS tenien la finalitat de proporcionar una tècnica fiable per a realitzar la calibració externa i per tant cancel•lar el bias, una metodologia per a promitjar temporalment les diferents adquisicions durant les observacions ascendents, i determinar la millor configuració de la funció de cost abans d’explotar i investigar les posibiltats de les dades SEPS/OCCAM per a derivar la SSS recuperada amb patrons d’alta resolució.

Single-cell gene-expression profiling reveals qualitatively distinct CD8 T cells elicited by different gene-based vaccines.

CD8 T cells play a key role in mediating protective immunity against selected pathogens after vaccination. Understanding the mechanism of this protection is dependent upon definition of the heterogeneity and complexity of cellular immune responses generated by different vaccines. Here, we identify previously unrecognized subsets of CD8 T cells based upon analysis of gene-expression patterns within single cells and show that they are differentially induced by different vaccines. Three prime-boost vector combinations encoding HIV Env stimulated antigen-specific CD8 T-cell populations of similar magnitude, phenotype, and functionality. Remarkably, however, analysis of single-cell gene-expression profiles enabled discrimination of a majority of central memory (CM) and effector memory (EM) CD8 T cells elicited by the three vaccines. Subsets of T cells could be defined based on their expression of Eomes, Cxcr3, and Ccr7, or Klrk1, Klrg1, and Ccr5 in CM and EM cells, respectively. Of CM cells elicited by DNA prime-recombinant adenoviral (rAd) boost vectors, 67% were Eomes(-) Ccr7(+) Cxcr3(-), in contrast to only 7% and 2% stimulated by rAd5-rAd5 or rAd-LCMV, respectively. Of EM cells elicited by DNA-rAd, 74% were Klrk1(-) Klrg1(-)Ccr5(-) compared with only 26% and 20% for rAd5-rAd5 or rAd5-LCMV. Definition by single-cell gene profiling of specific CM and EM CD8 T-cell subsets that are differentially induced by different gene-based vaccines will facilitate the design and evaluation of vaccines, as well as enable our understanding of mechanisms of protective immunity.

First use of multiple substances: Identification of meaningful patterns

Context: Understanding the process through which adolescents and young adults are trying legal and illegal substances is a crucial point for the development of tailored prevention and treatment programs. However, patterns of substance first use can be very complex when multiple substances are considered, requiring reduction into a few meaningful number of categories. Data: We used data from a survey on adolescent and young adult health conducted in 2002 in Switzerland. Answers from 2212 subjects aged 19 and 20 were included. The first consumption ever of 10 substances (tobacco, cannabis, medicine to get high, sniff (volatile substances, and inhalants), ecstasy, GHB, LSD, cocaine, methadone, and heroin) was considered for a grand total of 516 different patterns. Methods: In a first step, automatic clustering was used to decrease the number of patterns to 50. Then, two groups of substance use experts, three social field workers, and three toxicologists and health professionals, were asked to reduce them into a maximum of 10 meaningful categories. Results: Classifications obtained through our methodology are of practical interest by revealing associations invisible to purely automatic algorithms. The article includes a detailed analysis of both final classifications, and a discussion on the advantages and limitations of our approach.

Discordances between phylogenetic and morphological patterns in alpine leaf beetles attest to an intricate biogeographic history of lineages in postglacial Europe.

Pleistocene glacial and interglacial periods have moulded the evolutionary history of European cold-adapted organisms. The role of the different mountain massifs has, however, not been accurately investigated in the case of high-altitude insect species. Here, we focus on three closely related species of non-flying leaf beetles of the genus Oreina (Coleoptera, Chrysomelidae), which are often found in sympatry within the mountain ranges of Europe. After showing that the species concept as currently applied does not match barcoding results, we show, based on more than 700 sequences from one nuclear and three mitochondrial genes, the role of biogeography in shaping the phylogenetic hypothesis. Dating the phylogeny using an insect molecular clock, we show that the earliest lineages diverged more than 1 Mya and that the main shift in diversification rate occurred between 0.36 and 0.18 Mya. By using a probabilistic approach on the parsimony-based dispersal/vicariance framework (MP-DIVA) as well as a direct likelihood method of state change optimization, we show that the Alps acted as a cross-roads with multiple events of dispersal to and reinvasion from neighbouring mountains. However, the relative importance of vicariance vs. dispersal events on the process of rapid diversification remains difficult to evaluate because of a bias towards overestimation of vicariance in the DIVA algorithm. Parallels are drawn with recent studies of cold-adapted species, although our study reveals novel patterns in diversity and genetic links between European mountains, and highlights the importance of neglected regions, such as the Jura and the Balkanic range.

Le nombre de reines chez les fourmis et sa conséquence sur l'organisations sociale

Nearly half of all ant species form polygyne societies (cohabitation of more than a single egg-laying queen). These queens are generally smaller and store fewer fat reserves than queens from monogyne colonies. Most queens in polygyne colonies (70-100 pour 100) are inseminated, although this proportion varies among species, and even among populations of the same species. They exhibit mutual tolerance and they all contribute to the reproductive effort of the colony. Nevertheless, their individual fecundity is considerably reduced compared with that of queens from monogyne colonies. This reduction in fecundity seems to be due to some form of mutual inhibition, in some cases the secretion by each female of a substance suppressing egg production in other queens has been implicated. In a few species, queens are organized into a hierarchy such that certain queens lay more eggs than others or even monopolize egg-laying (functional monogyny). Polygyny is linked to a particular life history. It rarely results from the association of several foundresses (primary polygyny). Usually, it is due to the adoption of young queens by an established nest just after a nuptial flight. This secondary polygyny means that the dispersal of the species is limited and is achieved by the budding of a mother nest. Thus colony founding is dependent; with workers accompanying young queens in establishing new colonies. Observation of closely related species exhibiting different social organizations, some monogyne and others polygyne, shows a possible link between queen number and ecological conditions: polygyne forms are more frequent in unstable habitats susceptible to rapid change, such as that caused by human activity. The existence of polygyne societies is an intriguing evolutionary mystery. Research into the origin and maintenance of polygyny focuses on patterns of speciation in relation to queen number and the different theories put forth for the evolution of eusociality, mainly kin selection and mutualism.

Stability of isoenzyme and kinetoplast DNA (k-DNA) patterns in successively cloned Trypanosoma cruzi populations

Four Trypanosoma cruzi strains from zymodermes A, B, C and D were successively clonedon BHI-LIT-agar-blood BLAB). Twenty clones from the first generation (F1), 10 from The second (F2) and 4 from the third (F3) from the strains A138, B147 and C23 were isolated. The D150 strain provied 29 F1 and F2 clones. The strains and clones had their isoenzyme and K-DNA patterns determined. The clones from A138, Bl47 and C231 strains presented isoemzyme and K-DNA patterns identical between thewmselves and their respective parental strains. Therefore showing the homogenety and stability of isoenzyme and K-DNA patterns after successive cloning. The Dl50 strain from zymodeme D (ZD) showed heterogeneity. Twenty-eight out of 29 clones of the first generation were of zymodeme A and only one was of zymodeme C, confirming previous reports that ZD strains consisted of ZA and ZC parasite populations. The only D150 strain clone of zymodeme C showed a K-DNA pattern identical to its parental strain. The remining clones although similar among themselves were different from the parental strain. Thus the T. cruzi strains had either homonogeneus or heterogeneous populations. The clones produced by successive cloning provided genetically homonogeous populations. Their experimental use will make future results more reliable and reproducible.

Biological characterization of Trypanosoma cruzi strains from different zymodemes and schizodemes

The development in C3H mice of thirteen strains of Trypanosoma cruzi belonging to different zymodemes ans schizodemes was studied. Host mortality, virulence, histiotropism, parasitemia and polymorphism of the parasites were recorded. The strains were grouped into: a) high virulence - causing 100% mortality and characterized by predominance of bery broad trypomastigotes in the bloodstream at the end of infection; b) medium virulence - causing no mortality and with a predominance of broad trypomastigotes; c) low virulence - causing no mortality with blood forms not described due to the very low parasitemia. During 18 months maintenance the parasitemia curves were kept constant for all strains except one. A direct correlation between either zymodeme or schizodeme and experimental biological properties of T. cruzi strains was not found. However, the parasitemia was subpatent and patent for strains from zymodeme C and the others respectively. Furthermore the high virulence seems to be related to one of two shizodemes found within zymodeme B strains. All strains presenting patent parasitemia independent of shizodeme and ymodeme showed a myotropism towards heart and skeletal muscle with varible inflammatory intensity. The present study confirmed the heterogeneity found by isoenzyme and K-DNA patterns among the strains of T. cruzi isolated from chagasic patients in Bambuí, Minas Gerais State, Brasil.

Effects of different mating scenarios on embryo viability in brown trout.

Mating with attractive or dominant males is often predicted to offer indirect genetic benefits to females, but it is still largely unclear how important such non-random mating can be with regard to embryo viability. We sampled a natural population of adult migratory brown trout (Salmo trutta), bred them in vitro in a half-sib breeding design to separate genetic from maternal environmental effects, raised 2098 embryos singly until hatching, and exposed them experimentally to different levels of pathogen stress at a late embryonic stage. We found that the embryos' tolerance to the induced pathogen stress was linked to the major histocompatibility complex (MHC) of their parents, i.e. certain MHC genotypes appeared to provide better protection against infection than others. We also found significant additive genetic variance for stress tolerance. Melanin-based dark skin patterns revealed males with 'good genes', i.e. embryos fathered by dark coloured males had a high tolerance to infection. Mating with large and dominant males would, however, not improve embryo viability when compared to random mating. We used simulations to provide estimates of how mate choice based on MHC or melanin-based skin patterns would influence embryos' tolerance to the experimentally induced pathogen stress.