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.

Spatial and temporal evolution of family-farming land use in the Tapajós region of the Brazilian Amazon

Pressures on the Brazilian Amazon forest have been accentuated by agricultural activities practiced by families encouraged to settle in this region in the 1970s by the colonization program of the government. The aims of this study were to analyze the temporal and spatial evolution of land cover and land use (LCLU) in the lower Tapajós region, in the state of Pará. We contrast 11 watersheds that are generally representative of the colonization dynamics in the region. For this purpose, Landsat satellite images from three different years, 1986, 2001, and 2009, were analyzed with Geographic Information Systems. Individual images were subject to an unsupervised classification using the Maximum Likelihood Classification algorithm available on GRASS. The classes retained for the representation of LCLU in this study were: (1) slightly altered old-growth forest, (2) succession forest, (3) crop land and pasture, and (4) bare soil. The analysis and observation of general trends in eleven watersheds shows that LCLU is changing very rapidly. The average deforestation of old-growth forest in all the watersheds was estimated at more than 30% for the period of 1986 to 2009. The local-scale analysis of watersheds reveals the complexity of LCLU, notably in relation to large changes in the temporal and spatial evolution of watersheds. Proximity to the sprawling city of Itaituba is related to the highest rate of deforestation in two watersheds. The opening of roads such as the Transamazonian highway is associated to the second highest rate of deforestation in three watersheds.

Multifunctional Ti–Me (Me=Al, Cu) thin film systems for biomedical sensing devices

Ti-Me binary intermetallic thin films based on a titanium matrix doped with increasing amounts of Me (Me = Al, Cu) were prepared by magnetron sputtering (under similar conditions), aiming their application in biomedical sensing devices. The differences observed on the composition and on the micro(structural) features of the films, attributed to changes in the discharge characteristics, were correlated with the electrical properties of the intermetallic systems (Ti-Al and Ti-Cu). For the same Me exposed areas placed on the Ti target (ranging from 0.25 cm2 to 20 cm2) the Cu content increased from 3.5 at.% to 71.7 at.% in the Ti-Cu system and the Al content, in Ti-Al films, ranged from 11 to 45 at.%. The structural characterization evidenced the formation of metastable Ti-Me intermetallic phases for Al/Ti atomic ratios above 0.20 and for Cu/Ti ratios above 0.25. For lower Me concentrations, the effect of the α-Ti(Me) structure domains the overall structure. With the increase amount of the Me into Ti structure a clear trend for amorphization was observed. For both systems it was observed a significant decrease of the electrical resistivity with increasing Me/Ti atomic ratios (higher than 0.5 for Al/Ti atomic ratio and higher than 1.3 for Cu/Ti atomic ratio). Although similar trends were observed in the resistivity evolution for both systems, the Ti-Cu films presented lower resistivity values in comparison to Ti-Al system.

In-line rheo-optical microstructural characterization of complex polymer systems

Tese de Doutoramento em Ciência e Engenharia de Polímeros e Compósitos.

Empiricism in ecological economics: a perspective from complex systems theory

Economies are open complex adaptive systems far from thermodynamic equilibrium, and neo-classical environmental economics seems not to be the best way to describe the behaviour of such systems. Standard econometric analysis (i.e. time series) takes a deterministic and predictive approach, which encourages the search for predictive policy to ‘correct’ environmental problems. Rather, it seems that, because of the characteristics of economic systems, an ex-post analysis is more appropriate, which describes the emergence of such systems’ properties, and which sees policy as a social steering mechanism. With this background, some of the recent empirical work published in the field of ecological economics that follows the approach defended here is presented. Finally, the conclusion is reached that a predictive use of econometrics (i.e. time series analysis) in ecological economics should be limited to cases in which uncertainty decreases, which is not the normal situation when analysing the evolution of economic systems. However, that does not mean we should not use empirical analysis. On the contrary, this is to be encouraged, but from a structural and ex-post point of view.

Social evolution in the sweat bee Halictus scabiosae

The evolution of eusociality is one of the major evolutionary transitions of life on earth. For investigating the conditions and processes that are central to the origin of such integrated social organization, it is best to study organisms in which individuals have retained some flexibility in their reproductive strategies. Halictid bees are especially well suited as model organisms, because they show huge variation in social systems, both within and between species. In this thesis, I investigated female reproductive strategies in the primitively eusocial bee Halictus scabiosae, with a focus on the role of helpers, in order to get insight into the mechanisms governing the evolution and maintenance of eusociality. This species produces two broods per year. The females from the first brood can stay in the natal nest to help raise a second brood of males and gynes that become the next-generation foundresses in spring. We first compared the morphology of females from the two broods, as well as the nutrition they receive as larvae. Then we conducted a helper- removal experiment in the field to quantify the effects of the presence of helpers on colony survival and productivity. Finally, we reconstructed pedigree relationships of individuals using microsatellite markers in order to detect who reproduces in the nest and how much individuals drift between nests. We found that first brood females had a uniformly small size and low fat reserves, which may be caused by the restricted pollen and nectar provisions on which they develop. Colony survival and productivity was increased by the presence of a single helper, but the effect was small and mostly limited to small colonies. By inferring parentage within and across colonies, we could determine that females from the first brood rarely reproduce in their natal nests. However, foundresses are frequently replaced, and foundresses and females from the first brood occasionally move to and reproduce in foreign colonies. As a result, colonies often contain offspring from unrelated individuals, and the relatedness of females to the brood they rear is low. Overall, this thesis shows that the reproductive system of H. scabiosae is highly flexible. The production of helpers in the first brood is important for colony success and productivity, but there is a high colony failure rate and part of the first brood females drift and reproduce in foreign nests. Both foundresses and helpers appear to be constrained by harsh environmental conditions or social factors limiting reproduction and independent colony founding. - L'origine des insectes sociaux est un domaine fascinant pour la recherche. Pour comprendre les mécanismes et les conditions qui sont nécessaires pour l'évolution et le maintien de la vie en société, il est judicieux d'étudier des sociétés primitives d'insectes, où toutes les femelles ont conservé la capacité de se reproduire, même si leur rôle comportemental dans la colonie est d'aider sans se reproduire. Une des familles d'abeilles, les halictes, est idéale pour cette sorte de recherche, en raison de la grande variabilité dans leur comportement social. Dans cette thèse, j'ai étudié les stratégies reproductives des femelles de Halictus scabiosae pour mieux comprendre les mécanismes qui influencent l'évolution de la vie en société. Cette espèce produit deux cohortes de couvain par année. Les femelles du premier couvain restent souvent dans leur nid natal pour aider à élever le deuxième couvain, tandis que les femelles du deuxième couvain s'accouplent et hibernent pour devenir les nouvelles fondatrices au printemps suivant. Nous avons d'abord comparé la morphologie des femelles issues des deux couvains ainsi que leur nutrition au stade de larve. Puis, dans une expérience sur le terrain, nous avons quantifié l'apport d'une ouvrière pour la survie et la productivité de la colonie. Finalement, nous avons reconstruit des pedigrees en utilisant des marqueurs génétiques, pour savoir qui se reproduit dans la colonie et combien d'individus migrent entre colonies. Les résultats montrent que les femelles du premier couvain sont uniformément plus petites et plus maigres, ce qui indique que les fondatrices réduisent les provisions de nourriture pour leur premier couvain afin de les inciter à aider dans le nid au lieu de se reproduire indépendamment. Dans l'expérience sur le terrain, la survie et la productivité de la colonie augmentaient avec la présence d'une ouvrière additionnelle, mais l'effet était petit et limité aux petites colonies. Par la reconstruction de pedigrees, nous pouvions constater que les femelles du premier couvain pondent rarement dans leurs nids natals. Les fondatrices cependant sont souvent remplacées en cours de saison, et migrent fréquemment entre nids, tandis que les femelles du premier couvain pondent parfois des oeufs dans des nids étrangers. De ce fait, les colonies contiennent souvent des descendants d'individus étrangers, et la parenté génétique entre les femelles et le deuxième couvain est basse. Cette thèse démontre que le système reproductif de H. scabiosae est très flexible. La production d'ouvrières est importante pour la survie de la colonie et sa productivité, mais le taux d'échec est élevé et une partie des femelles du premier couvain migrent et pondent dans une colonie étrangère. Autant les fondatrices que les ouvrières semblent être contraintes par des conditions environnementales ou sociales qui limitent la reproduction et les nouvelles fondations de colonie. - Die Entstehung von sozialen Lebensformen ist eines der wichtigsten Entwicklungen in der Geschichte des Lebens. Um die Bedingungen oder Prozesse zu verstehen, welche bei der Entstehung und dem Erhalt von sozialen Merkmalen wichtig sind, sollte man Lebewesen untersuchen, welche je nach Umwelteinflüßen ihr soziales Verhalten flexibel ändern können. Furchenbienen (Halictidae) gehören dazu. Diese weisen nämlich ein breites Spektrum verschiedener sozialer Organisationsformen auf, oftmals sogar innerhalb der einzelnen Arten. In meiner Doktorarbeit befasste ich mich mit den Fortpflanzungsstrategien der Weibchen der Skabiosen-Furchenbiene Halictus scabiosae. Diese Art produziert zwei Brüten pro Jahr. Die Weibchen der ersten Brut bleiben dabei meist als Arbeiterinnen in ihrem Geburtsnest, wohingegen die Weibchen der zweiten Brut nach der Paarung überwintern, um im nächsten Frühling neue Kolonien zu gründen. In einem ersten Schritt verglichen wir die beiden Brüten bezüglich der Grösse und der Fettreserven der Weibchen sowie der Pollen-Nektar-Vorräte für die Larven. Dann bestimmten wir in einem Feldexperiment, wieviel eine zusätzliche Arbeiterin zum Überleben und zur Produktiviät der Kolonie beiträgt. Schliesslich ermittelten wir durch genetische Tests die Verwandtschaftsbeziehungen zwischen den Bienen, um herauszufinden, wer in den Kolonien tatsächlich die Eier legt und ob und wieviel die Bienen zwischen verschiedenen Nestern wandern. Wir stellten fest, dass die Weibchen von der ersten Brut einheitlich kleiner sind und weniger Fettreserven besitzen. Das weist daraufhin, dass die Nestgründerin die erste Brut unterernährt, um die Wahrscheinlichkeit zu erhöhen, dass diese Weibchen als Arbeiterinnen im Nest bleiben anstatt sich unabhängig fortzupflanzen. Schon eine einzelne zusätzliche Arbeiterin verbesserte die Überlebenschancen und Produktivität der Kolonie, der Effekt war allerdings klein und auf kleine Kolonien beschränkt. Die Verwandtschaftsanalysen zeigten, dass die Arbeiterinnen nur sehr selten ein Ei in ihr Geburtsnest legen. Erstaunlicherweise wanderten die Nestgründerinnen oft zwischen verschiedenen Nestern. Einige Weibchen der ersten Brut wanderten auch in ein fremdes Nest und produzierten dort Nachkommen. Diese Doktorarbeit zeigt, dass die Fortpflanzungsstrategien der Skabiosen-Furchenbiene tatsächlich sehr flexibel sind. Die Anwesenheit von Arbeiterinnen ist wichtig für das Überleben und die Produktivität der Kolonie. Die Misserfolgsraten bleiben jedoch hoch, und ein Teil der Weibchen der ersten Brut pflanzt sich in fremden Nestern fort. Sowohl die Nestgründerinnen als auch die Weibchen der ersten Brut scheinen durch Umweltsbedingungen oder durch soziale Faktoren in der Wahl ihrer Fortpflanzungs¬strategie eingeschränkt zu sein.

Density-dependent pollen limitation and reproductive assurance in a wind-pollinated herb with contrasting sexual systems

1. Wind pollination is thought to have evolved in response to selection for mechanisms to promote pollination success, when animal pollinators become scarce or unreliable. We might thus expect wind-pollinated plants to be less prone to pollen limitation than their insect-pollinated counterparts. Yet, if pollen loads on stigmas of wind-pollinated species decline with distance from pollen donors, seed set might nevertheless be pollen-limited in populations of plants that cannot self-fertilize their progeny, but not in self-compatible hermaphroditic populations.2. Here, we test this hypothesis by comparing pollen limitation between dioecious and hermaphroditic (monoecious) populations of the wind-pollinated herb Mercurialis annua.3. In natural populations, seed set was pollen-limited in low-density patches of dioecious, but not hermaphroditic, M. annua, a finding consistent with patterns of distance-dependent seed set by females in an experimental array. Nevertheless, seed set was incomplete in both dioecious and hermaphroditic populations, even at high local densities. Further, both factors limited the seed set of females and hermaphrodites, after we manipulated pollen and resource availability in a common garden experiment.4. Synthesis. Our results are consistent with the idea that pollen limitation plays a role in the evolution of combined vs. separate sexes in M. annua. Taken together, they point to the potential importance of pollen transfer between flowers on the same plant (geitonogamy) by wind as a mechanism of reproductive assurance and to the dual roles played by pollen and resource availability in limiting seed set. Thus, seed set can be pollen-limited in sparse populations of a wind-pollinated species, where mates are rare or absent, having potentially important demographic and evolutionary implications.

Importance of influx and efflux systems and xenobiotic metabolizing enzymes in intratumoral disposition of anticancer agents.

In this review, intratumoral drug disposition will be integrated into the wide range of resistance mechanisms to anticancer agents with particular emphasis on targeted protein kinase inhibitors. Six rules will be established: 1. There is a high variability of extracellular/intracellular drug level ratios; 2. There are three main systems involved in intratumoral drug disposition that are composed of SLC, ABC and XME enzymes; 3. There is a synergistic interplay between these three systems; 4. In cancer subclones, there is a strong genomic instability that leads to a highly variable expression of SLC, ABC or XME enzymes; 5. Tumor-expressed metabolizing enzymes play a role in tumor-specific ADME and cell survival and 6. These three systems are involved in the appearance of resistance (transient event) or in the resistance itself. In addition, this article will investigate whether the overexpression of some ABC and XME systems in cancer cells is just a random consequence of DNA/chromosomal instability, hypo- or hypermethylation and microRNA deregulation, or a more organized modification induced by transposable elements. Experiments will also have to establish if these tumor-expressed enzymes participate in cell metabolism or in tumor-specific ADME or if they are only markers of clonal evolution and genomic deregulation. Eventually, the review will underline that the fate of anticancer agents in cancer cells should be more thoroughly investigated from drug discovery to clinical studies. Indeed, inhibition of tumor expressed metabolizing enzymes could strongly increase drug disposition, specifically in the target cells resulting in more efficient therapies.

Molecular Epidemiologic Typing Systems of Bacterial Pathogens: Current Issues and Perpectives

The epidemiologic typing of bacterial pathogens can be applied to answer a number of different questions: in case of outbreak, what is the extent and mode of transmission of epidemic clone(s )? In case of long-term surveillance, what is the prevalence over time and the geographic spread of epidemic and endemic clones in the population? A number of molecular typing methods can be used to classify bacteria based on genomic diversity into groups of closely-related isolates (presumed to arise from a common ancestor in the same chain of transmission) and divergent, epidemiologically-unrelated isolates (arising from independent sources of infection). Ribotyping, IS-RFLP fingerprinting, macrorestriction analysis of chromosomal DNA and PCR-fingerprinting using arbitrary sequence or repeat element primers are useful methods for outbreak investigations and regional surveillance. Library typing systems based on multilocus sequence-based analysis and strain-specific probe hybridization schemes are in development for the international surveillance of major pathogens like Mycobacterium tuberculosis. Accurate epidemiological interpretation of data obtained with molecular typing systems still requires additional research on the evolution rate of polymorphic loci in bacterial pathogens.

Transitions from reproductive systems governed by two self-incompatible Loci to one in fungi.

Self-incompatibility (SI), a reproductive system broadly present in plants, chordates, fungi, and protists, might be controlled by one or several multiallelic loci. How a transition in the number of SI loci can occur and the consequences of such events for the population's genetics and dynamics have not been studied theoretically. Here, we provide analytical descriptions of two transition mechanisms: linkage of the two SI loci (scenario 1) and the loss of function of one incompatibility gene within a mating type of a population with two SI loci (scenario 2). We show that invasion of populations by the new mating type form depends on whether the fitness of the new type is lowered, and on the allelic diversity of the SI loci and the recombination between the two SI loci in the starting population. Moreover, under scenario 1, it also depends on the frequency of the SI alleles that became linked. We demonstrate that, following invasion, complete transitions in the reproductive system occurs under scenario 2 and is predicted only for small populations under scenario 1. Interestingly, such events are associated with a drastic reduction in mating type number.

Systems biology of plants : from intraspecific genome variation to computational morphodynamics

Recently, the introduction of second generation sequencing and further advance-ments in confocal microscopy have enabled system-level studies for the functional characterization of genes. The degree of complexity intrinsic to these approaches needs the development of bioinformatics methodologies and computational models for extracting meaningful biological knowledge from the enormous amount of experi¬mental data which is continuously generated. This PhD thesis presents several novel bioinformatics methods and computational models to address specific biological questions in Plant Biology by using the plant Arabidopsis thaliana as a model system. First, a spatio-temporal qualitative analysis of quantitative transcript and protein profiles is applied to show the role of the BREVIS RADIX (BRX) protein in the auxin- cytokinin crosstalk for root meristem growth. Core of this PhD work is the functional characterization of the interplay between the BRX protein and the plant hormone auxin in the root meristem by using a computational model based on experimental evidence. Hyphotesis generated by the modelled to the discovery of a differential endocytosis pattern in the root meristem that splits the auxin transcriptional response via the plasma membrane to nucleus partitioning of BRX. This positional information system creates an auxin transcriptional pattern that deviates from the canonical auxin response and is necessary to sustain the expression of a subset of BRX-dependent auxin-responsive genes to drive root meristem growth. In the second part of this PhD thesis, we characterized the genome-wide impact of large scale deletions on four divergent Arabidopsis natural strains, through the integration of Ultra-High Throughput Sequencing data with data from genomic hybridizations on tiling arrays. Analysis of the identified deletions revealed a considerable portion of protein coding genes affected and supported a history of genomic rearrangements shaped by evolution. In the last part of the thesis, we showed that VIP3 gene in Arabidopsis has an evo-lutionary conserved role in the 3' to 5' mRNA degradation machinery, by applying a novel approach for the analysis of mRNA-Seq data from random-primed mRNA. Altogether, this PhD research contains major advancements in the study of natural genomic variation in plants and in the application of computational morphodynamics models for the functional characterization of biological pathways essential for the plant. - Récemment, l'introduction du séquençage de seconde génération et les avancées dans la microscopie confocale ont permis des études à l'échelle des différents systèmes cellulaires pour la caractérisation fonctionnelle de gènes. Le degrés de complexité intrinsèque à ces approches ont requis le développement de méthodologies bioinformatiques et de modèles mathématiques afin d'extraire de la masse de données expérimentale générée, des information biologiques significatives. Ce doctorat présente à la fois des méthodes bioinformatiques originales et des modèles mathématiques pour répondre à certaines questions spécifiques de Biologie Végétale en utilisant la plante Arabidopsis thaliana comme modèle. Premièrement, une analyse qualitative spatio-temporelle de profiles quantitatifs de transcripts et de protéines est utilisée pour montrer le rôle de la protéine BREVIS RADIX (BRX) dans le dialogue entre l'auxine et les cytokinines, des phytohormones, dans la croissance du méristème racinaire. Le noyau de ce travail de thèse est la caractérisation fonctionnelle de l'interaction entre la protéine BRX et la phytohormone auxine dans le méristème de la racine en utilisant des modèles informatiques basés sur des preuves expérimentales. Les hypothèses produites par le modèle ont mené à la découverte d'un schéma différentiel d'endocytose dans le méristème racinaire qui divise la réponse transcriptionnelle à l'auxine par le partitionnement de BRX de la membrane plasmique au noyau de la cellule. Cette information positionnelle crée une réponse transcriptionnelle à l'auxine qui dévie de la réponse canonique à l'auxine et est nécessaire pour soutenir l'expression d'un sous ensemble de gènes répondant à l'auxine et dépendant de BRX pour conduire la croissance du méristème. Dans la seconde partie de cette thèse de doctorat, nous avons caractérisé l'impact sur l'ensemble du génome des délétions à grande échelle sur quatre souches divergentes naturelles d'Arabidopsis, à travers l'intégration du séquençage à ultra-haut-débit avec l'hybridation génomique sur puces ADN. L'analyse des délétions identifiées a révélé qu'une proportion considérable de gènes codant était affectée, supportant l'idée d'un historique de réarrangement génomique modelé durant l'évolution. Dans la dernière partie de cette thèse, nous avons montré que le gène VÏP3 dans Arabidopsis a conservé un rôle évolutif dans la machinerie de dégradation des ARNm dans le sens 3' à 5', en appliquant une nouvelle approche pour l'analyse des données de séquençage d'ARNm issue de transcripts amplifiés aléatoirement. Dans son ensemble, cette recherche de doctorat contient des avancées majeures dans l'étude des variations génomiques naturelles des plantes et dans l'application de modèles morphodynamiques informatiques pour la caractérisation de réseaux biologiques essentiels à la plante. - Le développement des plantes est écrit dans leurs codes génétiques. Pour comprendre comment les plantes sont capables de s'adapter aux changements environnementaux, il est essentiel d'étudier comment leurs gènes gouvernent leur formation. Plus nous essayons de comprendre le fonctionnement d'une plante, plus nous réalisons la complexité des mécanismes biologiques, à tel point que l'utilisation d'outils et de modèles mathématiques devient indispensable. Dans ce travail, avec l'utilisation de la plante modèle Arabidopsis thalicinci nous avons résolu des problèmes biologiques spécifiques à travers le développement et l'application de méthodes informatiques concrètes. Dans un premier temps, nous avons investigué comment le gène BREVIS RADIX (BRX) régule le développement de la racine en contrôlant la réponse à deux hormones : l'auxine et la cytokinine. Nous avons employé une analyse statistique sur des mesures quantitatives de transcripts et de produits de gènes afin de démontrer que BRX joue un rôle antagonisant dans le dialogue entre ces deux hormones. Lorsque ce-dialogue moléculaire est perturbé, la racine primaire voit sa longueur dramatiquement réduite. Pour comprendre comment BRX répond à l'auxine, nous avons développé un modèle informatique basé sur des résultats expérimentaux. Les simulations successives ont mené à la découverte d'un signal positionnel qui contrôle la réponse de la racine à l'auxine par la régulation du mouvement intracellulaire de BRX. Dans la seconde partie de cette thèse, nous avons analysé le génome entier de quatre souches naturelles d'Arabidopsis et nous avons trouvé qu'une grande partie de leurs gènes étaient manquant par rapport à la souche de référence. Ce résultat indique que l'historique des modifications génomiques conduites par l'évolution détermine une disponibilité différentielle des gènes fonctionnels dans ces plantes. Dans la dernière partie de ce travail, nous avons analysé les données du transcriptome de la plante où le gène VIP3 était non fonctionnel. Ceci nous a permis de découvrir le rôle double de VIP3 dans la régulation de l'initiation de la transcription et dans la dégradation des transcripts. Ce rôle double n'avait jusqu'alors été démontrée que chez l'homme. Ce travail de doctorat supporte le développement et l'application de méthodologies informatiques comme outils inestimables pour résoudre la complexité des problèmes biologiques dans la recherche végétale. L'intégration de la biologie végétale et l'informatique est devenue de plus en plus importante pour l'avancée de nos connaissances sur le fonctionnement et le développement des plantes.

Conceptual models for designing information systems supporting the strategic analysis of technology environments

1 6 STRUCTURE OF THIS THESIS -Chapter I presents the motivations of this dissertation by illustrating two gaps in the current body of knowledge that are worth filling, describes the research problem addressed by this thesis and presents the research methodology used to achieve this goal. -Chapter 2 shows a review of the existing literature showing that environment analysis is a vital strategic task, that it shall be supported by adapted information systems, and that there is thus a need for developing a conceptual model of the environment that provides a reference framework for better integrating the various existing methods and a more formal definition of the various aspect to support the development of suitable tools. -Chapter 3 proposes a conceptual model that specifies the various enviromnental aspects that are relevant for strategic decision making, how they relate to each other, and ,defines them in a more formal way that is more suited for information systems development. -Chapter 4 is dedicated to the evaluation of the proposed model on the basis of its application to a concrete environment to evaluate its suitability to describe the current conditions and potential evolution of a real environment and get an idea of its usefulness. -Chapter 5 goes a step further by assembling a toolbox describing a set of methods that can be used to analyze the various environmental aspects put forward by the model and by providing more detailed specifications for a number of them to show how our model can be used to facilitate their implementation as software tools. -Chapter 6 describes a prototype of a strategic decision support tool that allow the analysis of some of the aspects of the environment that are not well supported by existing tools and namely to analyze the relationship between multiple actors and issues. The usefulness of this prototype is evaluated on the basis of its application to a concrete environment. -Chapter 7 finally concludes this thesis by making a summary of its various contributions and by proposing further interesting research directions.

Evolution des transferts interhospitaliers au départ d'un centre hospitalier universitaire suisse [Trends in interhospital transfers from a Swiss university hospital center].

OBJECTIVE: Research on interhospital transfers provides a basis for describing and quantifying patient flow and its evolution over time, offering an insight into hospital organization and management and hospital overcrowding. The purpose of this study was to conduct a qualitative and quantitative analysis of patient flow and to examine trends over an eight-year period. METHODS: A retrospective descriptive study of interhospital transfers was conducted between 2003 and 2011 based on an analysis of demographic, medical and operational characteristics. Ambulance transfers and transfers requiring physician assistance were analyzed separately. RESULTS: The number of interhospital transfers increased significantly over the study period,from 4,026 in 2003 to 6,481 in 2011 (+60.9%). The number of ambulance transfers increased by almost 300% (616 in 2003 compared to 2,460 in 2011). Most of the transfers (98%) were to hospitals located less than 75 km from the university hospital (median: 24 km, 5-44). In 2011, 24% of all transfers were to psychiatric institutions. 26% of all transfer cases were direct transfers from the emergency department. An increasing number of transfers required physician assistance. 18% of these patients required ventilatory support, whole 9.8% required vasoactive drugs. 11.6% of these transfers were due to hospital overcrowding. Conclusion: The study shows that there has been a significant increase in interhospital transfers. This increase is related to hospital overcrowding and to the network-based systems governing patient care strategies.

The evolution of sex determination

Sexual reproduction is a fundamental aspect of life. Sex-determination mechanisms are responsible for the sexual fate and development of sexual characteristics in an organism, be it a unicellular alga, a plant, or an animal. Surprisingly, sex-determination mechanisms are not evolutionarily conserved but are bewilderingly diverse and appear to have had rapid turnover rates during evolution. Evolutionary biologists continue to seek a solution to this conundrum. What drives the surprising dynamics of such a fundamental process that always leads to the same outcome: two sex types, male and female? The answer is complex but the ongoing genomic revolution has already greatly increased our knowledge of sex-determination systems and sex chromosomes in recent years. This novel book presents and synthesizes our current understanding, and clearly shows that sex-determination evolution will remain a dynamic field of future research. The Evolution of Sex Determination is an advanced, research level text suitable for graduate students and researchers in genetics, developmental biology, and evolution.

Evolution and pathology in Chagas disease: a review

Trypanosoma cruzi acute infections often go unperceived, but one third of chronically infected individuals die of Chagas disease, showing diverse manifestations affecting the heart, intestines, and nervous systems. A common denominator of pathology in Chagas disease is the minimal rejection unit, whereby parasite-free target host cells are destroyed by immune system mononuclear effectors cells infiltrates. Another key feature stemming from T. cruzi infection is the integration of kDNA minicircles into the vertebrate host genome; horizontal transfer of the parasite DNA can undergo vertical transmission to the progeny of mammals and birds. kDNA integration-induced mutations can enter multiple loci in diverse chromosomes, generating new genes, pseudo genes and knock-outs, and resulting in genomic shuffling and remodeling over time. As a result of the juxtaposition of kDNA insertions with host open reading frames, novel chimeric products may be generated. Germ line transmission of kDNA-mutations determined the appearance of lesions in birds that are indistinguishable from those seen in Chagas disease patients. The production of tissue lesions showing typical minimal rejection units in birds' refractory to T. cruzi infection is consistent with the hypothesis that autoimmunity, likely triggered by integration-induced phenotypic alterations, plays a major role in the pathogenesis of Chagas disease.