The impact of spatial data redundancy on SOLAP query performance

Geographic Data Warehouses (GDW) are one of the main technologies used in decision-making processes and spatial analysis, and the literature proposes several conceptual and logical data models for GDW. However, little effort has been focused on studying how spatial data redundancy affects SOLAP (Spatial On-Line Analytical Processing) query performance over GDW. In this paper, we investigate this issue. Firstly, we compare redundant and non-redundant GDW schemas and conclude that redundancy is related to high performance losses. We also analyze the issue of indexing, aiming at improving SOLAP query performance on a redundant GDW. Comparisons of the SB-index approach, the star-join aided by R-tree and the star-join aided by GiST indicate that the SB-index significantly improves the elapsed time in query processing from 25% up to 99% with regard to SOLAP queries defined over the spatial predicates of intersection, enclosure and containment and applied to roll-up and drill-down operations. We also investigate the impact of the increase in data volume on the performance. The increase did not impair the performance of the SB-index, which highly improved the elapsed time in query processing. Performance tests also show that the SB-index is far more compact than the star-join, requiring only a small fraction of at most 0.20% of the volume. Moreover, we propose a specific enhancement of the SB-index to deal with spatial data redundancy. This enhancement improved performance from 80 to 91% for redundant GDW schemas.

Changes in optical properties caused by UV-irradiation of aquatic humic substances from the amazon river basin: Seasonal variability evaluation

Aquatic humic substances (AHS) isolated from two characteristic seasons of the Negro river, winter and summer corresponding to floody and dry periods, were structurally characterized by (13)C nuclear magnetic ressonance. Subsequently, AHS aqueous solutions were irradiated with a polychromatic lamp (290-475 nm) and monitored by its total organic carbon (TOC) content, ultraviolet-visible (UV-vis) absorbance, fluorescence and Fourier transformed infrared spectroscopy (FTIR). As a result, a photobleaching upto 80% after irradiation of 48 h was observed. Conformational rearrangements and formation of low molecular complexity structures were formed during the irradiation, as deduced from the pH decrement and the fluorescence shifting to lower wavelengths. Additionally a significant mineralization with the formation Of CO(2), CO, and inorganic carbon compounds was registered, as assumed by TOC losses of up to 70%. The differences in photodegradation between samples expressed by photobleaching efficiency were enhanced in the summer sample and related to its elevated aromatic content. Aromatic structures are assumed to have high autosensitization capacity effects mediated by the free radical generation from quinone and phenolic moieties.

Heterogeneous sensor database framework for the sensor observation service: integrating remote and in-situ sensor observations at the database backend

Dissertation submitted in partial fulfillment of the requirements for the Degree of Master of Science in Geospatial Technologies.

Natural evidence for rapid abiogenic hydrothermal generation of CH4

Although recent hydrothermal experiments imply that abiogenic methane (CH4) generation from hydrothermal reduction of CO2 can occur, evidence from natural systems was still lacking. Based on the chemical and isotopic equilibrium signatures of low-temperature fumarolic gas discharges, we are able to provide hard evidence for its natural occurrence, namely in three subduction-related bi-phase hydrothermal systems of the Mediterranean, whose temperatures range from 260 to 470 degrees C. The attainment of equilibrium and the time spans of recent volcanic dormancy allowed us to calculate minimum rates for chemical and isotopic equilibration. These are significantly higher than those previously reported and might be due to the presence of a saturated water vapor phase in the investigated systems. The fact that nature provides conditions enabling relatively fast production of hydrocarbons from CO2 strongly supports the concerns that were recently raised from laboratory experiments. These address the use of the carbon isotope composition of reduced carbon in Archean sediments as a tracer of early life and the occurrence of CH4 on extraterrestrial planets as a bioindicator. In view of the potential role of abiogenic CH4 as a precursor of life, we also present an estimate of abiogenic hydrothermal CH4 fluxes throughout the Archean. It is not expected that these fluxes exceeded 80 Mt/yr during the past 4.0 Ga. This, however, would have been enough to facilitate HCN production on the prebiotic Earth. (C) 2007 Elsevier Ltd. All rights reserved.

Segmentation and grid generation for numerical simulations of vad connections with patient-specific data

Objectives: We are interested in the numerical simulation of the anastomotic region comprised between outflow canula of LVAD and the aorta. Segmenta¬tion, geometry reconstruction and grid generation from patient-specific data remain an issue because of the variable quality of DICOM images, in particular CT-scan (e.g. metallic noise of the device, non-aortic contrast phase). We pro¬pose a general framework to overcome this problem and create suitable grids for numerical simulations.Methods: Preliminary treatment of images is performed by reducing the level window and enhancing the contrast of the greyscale image using contrast-limited adaptive histogram equalization. A gradient anisotropic diffusion filter is applied to reduce the noise. Then, watershed segmentation algorithms and mathematical morphology filters allow reconstructing the patient geometry. This is done using the InsightToolKit library (www.itk.org). Finally the Vascular Model¬ing ToolKit (www.vmtk.org) and gmsh (www.geuz.org/gmsh) are used to create the meshes for the fluid (blood) and structure (arterial wall, outflow canula) and to a priori identify the boundary layers. The method is tested on five different patients with left ventricular assistance and who underwent a CT-scan exam.Results: This method produced good results in four patients. The anastomosis area is recovered and the generated grids are suitable for numerical simulations. In one patient the method failed to produce a good segmentation because of the small dimension of the aortic arch with respect to the image resolution.Conclusions: The described framework allows the use of data that could not be otherwise segmented by standard automatic segmentation tools. In particular the computational grids that have been generated are suitable for simulations that take into account fluid-structure interactions. Finally the presented method features a good reproducibility and fast application.

Are invasive marsh frogs (Pelophylax ridibundus) replacing the native P. lessonae /P. esculentus hybridogenetic complex in Western Europe? Genetic evidence from a field study.

The water-frog L-E system, widespread in Western Europe, comprises the pool frog Pelophylax lessonae and the hybridogenetic edible frog P. esculentus, which originated from hybridization between pool frogs and marsh frogs (P. ridibundus). In P. esculentus, the lessonae (L) genome is eliminated during meiosis and has to be gained anew each generation from a P. lessonae partner, while the ridibundus (R') genome is transmitted clonally. It therefore accumulates deleterious mutations, so that R'R' offspring from P. esculentus x P. esculentus crosses are normally unviable. This system is now threatened by invasive P. ridibundus (RR) imported from Eastern Europe and the Balkans. We investigated the genetic interactions between invasive marsh frogs and native water frogs in a Swiss wetland area, and used genetic data collected in the field to validate several components of a recently postulated mechanism of species replacement. We identified neo-ridibundus individuals derived from crosses between invasive ridibundus and native esculentus, as well as newly arisen hybridogenetic esculentus lineages stemming from crosses between invasive ridibundus (RR) and native lessonae (LL). As their ridibundus genomes are likely to carry less deleterious mutations, such lineages are expected to produce viable ridibundus offspring, contributing to species replacement. However, such crosses with invasive ridibundus only occurred at a limited scale; moreover, RR x LL crosses did not induce any introgression from the ridibundus to the lessonae genome. We did not find any ridibundus stemming from crosses between ancient esculentus lineages. Despite several decades of presence on the site, introduced ridibundus individuals only represent 15% of sampled frogs, and their spatial distribution seems shaped by specific ecological requirements rather than history of colonization. We therefore expect the three taxa to coexist stably in this area.

CATMA: a complete Arabidopsis GST database.

The Complete Arabidopsis Transcriptome Micro Array (CATMA) database contains gene sequence tag (GST) and gene model sequences for over 70% of the predicted genes in the Arabidopsis thaliana genome as well as primer sequences for GST amplification and a wide range of supplementary information. All CATMA GST sequences are specific to the gene for which they were designed, and all gene models were predicted from a complete reannotation of the genome using uniform parameters. The database is searchable by sequence name, sequence homology or direct SQL query, and is available through the CATMA website at http://www.catma.org/.

Assessment of Coals from Russia and Countries of Former Soviet Union for Utility Fluidized Bed Boilers

With the occurrence of fossil fuels such as oil, gas and coal we found new sources of energy that have played a critical role in the progress of our modern society. Coal is very ample compared to the other two fossil fuels. Global coal reserves at the end of 2005 were estimated at 847,5 billion tones. Along with the major energy sources, coal is the most fast growing fuel on a global basis, it provides 26% of primary energy needs and remains essential to the economies of many developed and developing countries. Coal-fired power generation accounts for 41% of the world‘s total electricity production and in some countries, such as South Africa, Poland, China, Australia, Kazakhstan and India is on very high level. Still, coal utilization represents challenges related to high emissions of air pollutants such as sulphur and nitrogen dioxides, particulate matter, mercury and carbon dioxide. In relation to these a number of technologies have been developed and are in marketable use, with further potential developments towards ―Near Zero Emission‖ coal plants. In present work, coals mined in Russia and countries of Former Soviet Union were reviewed. Distribution of coal reserves on the territory of Russia and the potential for power generation from coal-fired plants across Russia was shown. Physical and chemical properties of coals produced were listed and examined, as main factor influencing on design of the combustion facility and incineration process performance. The ash-related problems in coal-fired boilers were described. The analysis of coal ash of Russia and countries of Former Soviet Union were prepared. Feasible combustion technologies also were reviewed.

Potential of biogas production from swine manure supplemented with glycerine waste

In this study, was studied the biogas generation from swine manure, using residual glycerine supplementation. The biogas production by digestion occurred in the anaerobic batch system under mesophilic conditions (35°C), with a hydraulic retention time of 48 days. The experiment was performed with 48 samples divided into four groups, from these, one was kept as a control (without glycerin) and the other three groups were respectively supplemented with residual glycerine in the percentage of 3%, 6% and 9% of the total volume of the samples. The volume of biogas was controlled by an automated system for reading in laboratory scale and the quality of the biogas (CH4) measured from a specific sensor. The results showed that the residual glycerine has high potential for biogas production, with increases of 124.95%, 156.98% and 197.83% in the groups 3%, 6% and 9%, respectively, relative to the sample control. However, very high organic loads can compromise the process of digestion affecting the quality of the biogas generated in relation to methane.

Alternative pathways for angiotensin II generation in the cardiovascular system

The classical renin-angiotensin system (RAS) consists of enzymes and peptides that regulate blood pressure and electrolyte and fluid homeostasis. Angiotensin II (Ang II) is one of the most important and extensively studied components of the RAS. The beneficial effects of angiotensin converting enzyme (ACE) inhibitors in the treatment of hypertension and heart failure, among other diseases, are well known. However, it has been reported that patients chronically treated with effective doses of these inhibitors do not show suppression of Ang II formation, suggesting the involvement of pathways alternative to ACE in the generation of Ang II. Moreover, the finding that the concentration of Ang II is preserved in the kidney, heart and lungs of mice with an ACE deletion indicates the important role of alternative pathways under basal conditions to maintain the levels of Ang II. Our group has characterized the serine protease elastase-2 as an alternative pathway for Ang II generation from Ang I in rats. A role for elastase-2 in the cardiovascular system was suggested by studies performed in heart and conductance and resistance vessels of normotensive and spontaneously hypertensive rats. This mini-review will highlight the pharmacological aspects of the RAS, emphasizing the role of elastase-2, an alternative pathway for Ang II generation.

Characterization and Investigation on Material Compatibilities of Building Integrated Photovoltaic Module Components

Building Integrated Photovoltaics (BIPV) are considered as the future of photovoltaic (PV) technology. The advantage of BIPV system is its multi-functionality; they fulfil the functions of a building envelope with the added benefit of generating power by replacing the traditional roofing and façade materials with PV that generate power. In this thesis, different types of PV cells and modules have been described in detail with their efficiencies and usage trends in the last decade. The different BIPV products for roof and façade are discussed in detail giving several examples. The electricity generation potential of BIPV in selected countries is compared with their actual electricity consumption. Further, the avoided greenhouse gas (GHG) emissions associated with electricity generation from traditional sources and transportation and distribution (T&D) losses are calculated. The results illustrate huge savings in GHGs. In BIPV different types of façade and backsheets are used. In this thesis, selected backsheets and façade were characterized in terms of their surface structure identification using infrared spectroscopy (FTIR-ATR), scanning electron microscopy with energy dispersive X-ray (SEM-EDX) and physical characterization using surface energy measurements. By using FTIR-ATR, surface polymeric materials were identified and with SEM-EDX, identification of the surface elements was possible. Surface energy measurements were useful in finding the adhesives and knowing the surface energies of the various backsheets and façade. The strength of adhesion between the facade and backsheets was studied using peel test. Four different types of adhesives were used to study the fracture pattern and peel tests values to identify the most suitable adhesive. It was found out that pretreatment increased the adhesive strength significantly.

Improving automation in model-driven engineering using examples

Cette thèse a pour but d’améliorer l’automatisation dans l’ingénierie dirigée par les modèles (MDE pour Model Driven Engineering). MDE est un paradigme qui promet de réduire la complexité du logiciel par l’utilisation intensive de modèles et des transformations automatiques entre modèles (TM). D’une façon simplifiée, dans la vision du MDE, les spécialistes utilisent plusieurs modèles pour représenter un logiciel, et ils produisent le code source en transformant automatiquement ces modèles. Conséquemment, l’automatisation est un facteur clé et un principe fondateur de MDE. En plus des TM, d’autres activités ont besoin d’automatisation, e.g. la définition des langages de modélisation et la migration de logiciels. Dans ce contexte, la contribution principale de cette thèse est de proposer une approche générale pour améliorer l’automatisation du MDE. Notre approche est basée sur la recherche méta-heuristique guidée par les exemples. Nous appliquons cette approche sur deux problèmes importants de MDE, (1) la transformation des modèles et (2) la définition précise de langages de modélisation. Pour le premier problème, nous distinguons entre la transformation dans le contexte de la migration et les transformations générales entre modèles. Dans le cas de la migration, nous proposons une méthode de regroupement logiciel (Software Clustering) basée sur une méta-heuristique guidée par des exemples de regroupement. De la même façon, pour les transformations générales, nous apprenons des transformations entre modèles en utilisant un algorithme de programmation génétique qui s’inspire des exemples des transformations passées. Pour la définition précise de langages de modélisation, nous proposons une méthode basée sur une recherche méta-heuristique, qui dérive des règles de bonne formation pour les méta-modèles, avec l’objectif de bien discriminer entre modèles valides et invalides. Les études empiriques que nous avons menées, montrent que les approches proposées obtiennent des bons résultats tant quantitatifs que qualitatifs. Ceux-ci nous permettent de conclure que l’amélioration de l’automatisation du MDE en utilisant des méthodes de recherche méta-heuristique et des exemples peut contribuer à l’adoption plus large de MDE dans l’industrie à là venir.

Une approche heuristique pour l’apprentissage de transformations de modèles complexes à partir d’exemples

L’ingénierie dirigée par les modèles (IDM) est un paradigme d’ingénierie du logiciel bien établi, qui préconise l’utilisation de modèles comme artéfacts de premier ordre dans les activités de développement et de maintenance du logiciel. La manipulation de plusieurs modèles durant le cycle de vie du logiciel motive l’usage de transformations de modèles (TM) afin d’automatiser les opérations de génération et de mise à jour des modèles lorsque cela est possible. L’écriture de transformations de modèles demeure cependant une tâche ardue, qui requiert à la fois beaucoup de connaissances et d’efforts, remettant ainsi en question les avantages apportés par l’IDM. Afin de faire face à cette problématique, de nombreux travaux de recherche se sont intéressés à l’automatisation des TM. L’apprentissage de transformations de modèles par l’exemple (TMPE) constitue, à cet égard, une approche prometteuse. La TMPE a pour objectif d’apprendre des programmes de transformation de modèles à partir d’un ensemble de paires de modèles sources et cibles fournis en guise d’exemples. Dans ce travail, nous proposons un processus d’apprentissage de transformations de modèles par l’exemple. Ce dernier vise à apprendre des transformations de modèles complexes en s’attaquant à trois exigences constatées, à savoir, l’exploration du contexte dans le modèle source, la vérification de valeurs d’attributs sources et la dérivation d’attributs cibles complexes. Nous validons notre approche de manière expérimentale sur 7 cas de transformations de modèles. Trois des sept transformations apprises permettent d’obtenir des modèles cibles parfaits. De plus, une précision et un rappel supérieurs à 90% sont enregistrés au niveau des modèles cibles obtenus par les quatre transformations restantes.

Diversified query expansion

La diversification des résultats de recherche (DRR) vise à sélectionner divers documents à partir des résultats de recherche afin de couvrir autant d’intentions que possible. Dans les approches existantes, on suppose que les résultats initiaux sont suffisamment diversifiés et couvrent bien les aspects de la requête. Or, on observe souvent que les résultats initiaux n’arrivent pas à couvrir certains aspects. Dans cette thèse, nous proposons une nouvelle approche de DRR qui consiste à diversifier l’expansion de requête (DER) afin d’avoir une meilleure couverture des aspects. Les termes d’expansion sont sélectionnés à partir d’une ou de plusieurs ressource(s) suivant le principe de pertinence marginale maximale. Dans notre première contribution, nous proposons une méthode pour DER au niveau des termes où la similarité entre les termes est mesurée superficiellement à l’aide des ressources. Quand plusieurs ressources sont utilisées pour DER, elles ont été uniformément combinées dans la littérature, ce qui permet d’ignorer la contribution individuelle de chaque ressource par rapport à la requête. Dans la seconde contribution de cette thèse, nous proposons une nouvelle méthode de pondération de ressources selon la requête. Notre méthode utilise un ensemble de caractéristiques qui sont intégrées à un modèle de régression linéaire, et génère à partir de chaque ressource un nombre de termes d’expansion proportionnellement au poids de cette ressource. Les méthodes proposées pour DER se concentrent sur l’élimination de la redondance entre les termes d’expansion sans se soucier si les termes sélectionnés couvrent effectivement les différents aspects de la requête. Pour pallier à cet inconvénient, nous introduisons dans la troisième contribution de cette thèse une nouvelle méthode pour DER au niveau des aspects. Notre méthode est entraînée de façon supervisée selon le principe que les termes reliés doivent correspondre au même aspect. Cette méthode permet de sélectionner des termes d’expansion à un niveau sémantique latent afin de couvrir autant que possible différents aspects de la requête. De plus, cette méthode autorise l’intégration de plusieurs ressources afin de suggérer des termes d’expansion, et supporte l’intégration de plusieurs contraintes telles que la contrainte de dispersion. Nous évaluons nos méthodes à l’aide des données de ClueWeb09B et de trois collections de requêtes de TRECWeb track et montrons l’utilité de nos approches par rapport aux méthodes existantes.

A study into the accuracy of using meteorological wind data to estimate turbine generation output

Meteorological (met) station data is used as the basis for a number of influential studies into the impacts of the variability of renewable resources. Real turbine output data is not often easy to acquire, whereas meteorological wind data, supplied at a standardised height of 10 m, is widely available. This data can be extrapolated to a standard turbine height using the wind profile power law and used to simulate the hypothetical power output of a turbine. Utilising a number of met sites in such a manner can develop a model of future wind generation output. However, the accuracy of this extrapolation is strongly dependent on the choice of the wind shear exponent alpha. This paper investigates the accuracy of the simulated generation output compared to reality using a wind farm in North Rhins, Scotland and a nearby met station in West Freugh. The results show that while a single annual average value for alpha may be selected to accurately represent the long term energy generation from a simulated wind farm, there are significant differences between simulation and reality on an hourly power generation basis, with implications for understanding the impact of variability of renewables on short timescales, particularly system balancing and the way that conventional generation may be asked to respond to a high level of variable renewable generation on the grid in the future.