This paper deals with data warehouses and OLAP. These technologies are defined and described here. Then an introduction of the architecture of product MS SQL Server and its tools for work with data warehouses and OLAP folow. The knowledge gained is used for creation of sample application.

In this thesis, the focus is on studying BaZrO3-BaCeO3 based proton conductors due to that they represent very promising proton conductors to be used for Intermediate Temperature Solid Oxide Fuel Cells (ITSOFCs). Here, dense BaZr0.5Ce0.3Y0.2O3-δ (BZCY532) ceramics were selected as the major studied materials. These ceramics were prepared by different sintering methods and doping strategies. Based on achieved results, the thesis work can simply be divided into the following parts: 1) An improved synthesis method, which included a water-based milling procedure followed by a freeze-drying post-processing, was presented. A lowered calcination and sintering temperature for a Hf0.7Y0.3O2-δ (YSH) compound was achieved. The value of the relative density in this work was higher than previously reported data. It is also concluded that this improved method can be used for mass-production of ceramics. 2) As the solid-state reactive sintering (SSRS) represent a cost-effective sintering method, the sintering behaviors of proton conductors BaZrxCe0.8-xLn0.2O3-δ (x = 0.8, 0.5, 0.1; Ln = Y, Sm, Gd, Dy) during the SSRS process were investigated. According to the obtained results, it was found that the sintering temperature will decrease, when the Ce content increases from 0 (BZCLn802) to 0.3 (BZCLn532) and 0.7 (BZCLn172). Moreover, the radii of the dopant ions similar to the radii of Zr4+ or Ce4+ ions show a better sinterability. This means that it is possible to obtain dense ceramics at a lower temperature. Moreover, the conductivities of dense BZCLn532 ceramics were determined. The conductivity data indicate that dense BZCY532 ceramics are good candidates as either oxygen ion conductors or proton conductors used for ITSOFCs. 3) The effect of NiO on the sintering behaviors, morphologies and conductivities of BZCY532 based electrolytes were systematically investigated. According to the achieved results, it can be concluded that the dense BZCY532B ceramics (NiO was added during ball-milling before a powder mixture calcination) show an enhanced oxygen and proton conductivity. Also, that BZCY532A (NiO was added after a powder mixture calcination) and BZCY532N (No NiO was added in the whole preparation procedures) showed lower values. In addition, dense BZCY532B and BZCY532N ceramics showed only small electronic conductivities, when the testing temperature was lower than 800 ℃. However, the BZCY532A ceramics revealed an obvious electronic conduction, when they were tested in the range of 600 ℃ to 800 ℃. Therefore, it is preferable to add the NiO powder during the BZCY532 powder preparation, which can lower the sintering temperature and also increase the conductivity. 4) Dense BZCY532 ceramics were successfully prepared by using the Spark Plasma Sintering (SPS) method at a temperature of 1350 ℃ with a holding time of 5 min. It was found that a lower sintering temperature (&lt; 1400 ℃) and a very fast cooling rate (&gt; 200 ℃/min) are two key parameters to prepare dense BZCY532 ceramics. These results confirm that the SPS technique represents a feasible and cost-effective sintering method to prepare dense Ce-containing BaZrO3-BaCeO3 based proton conductors. 5) Finally, a preliminary study for preparation of Ce0.8Sm0.2O2-δ (SDC) and BZCY532 basedcomposite electrolytes was carried out. The novel SDC-BZCY532 based composite electrolytes were prepared by using the powder mixing and co-sintering method. The sintering behaviors, morphologies and ionic conductivities of the composite electrolytes were investigated. The obtained results show that the composite electrolyte with a composition of 60SDC-40BZCY532 has the highest conductivity. In contrast, the composite electrolyte with a composition of 40SDC-60BZCY532 shows the lowest conductivity. In summary, the results show that BaZrO3-BaCeO3 based proton-conducting ceramic materials represent very promising materials for future ITSOFCs electrolyte applications. / <p>QC 20150423</p>

Ophiostoma novo-ulmi is the causal agent of Dutch elm disease (DED) which has had a severe impact on the urban landscape in Canada. This research program focused on developing molecular genetic strategies to control this pathogenic fungus. The first strategy involved the development of RNA interference (RNAi) for the down-regulation of genes involved in pathogenicity. An efficient RNAi cassette was developed to suppress the expression of the endopolygalacturonase (epg1) locus which encodes a cell-wall degrading enzyme. This epg1-RNAi cassette significantly reduced the amount of polygalacturonase activity in the fungus and resulted in almost complete degradation of epg1 mRNA. The need for a native promoter to selectively down-regulate specific gene loci was addressed by developing a carbon-catabolite regulated promoter (alcA) to drive the expression of the epg1-RNAi cassette. The expression of an alcA-driven epg1-RNAi cassette resulted in the down-regulation of epg expression under glucose starvation but normal levels of expression in high glucose. The expression could therefore be controlled by culture conditions. The second strategy explored the potential of using dsRNA viruses to vector disruptive RNAi cassettes. An isolate of O. novo-ulmi strain 93-1224 collected in the city of Winnipeg, was infected by two dsRNA mitoviruses which upon sequence characterization were named OnuMV1c and OnuMV7. To assess the transmissibility of this dsRNA virus the infected isolate 93-1224 was paired with three naive isolates of the related fungi O. ulmi and O. himal-ulmi. Through the use of nuclear and mitochondrial markers it was determined that the virus OnuMV1c may not rely on mitochondrial fusion for transmission but may have a cytoplasmic transmission route. This investigation of gene expression and manipulation has provided tools to help understand gene regulation in O. novo-ulmi. It has also added to our knowledge of mitoviruses, their transmission and potential use as a biological control. By enhancing our understanding of transmissible hypovirulence this work contributes to efforts to develop a new approach to target DED as well as a potential model for the control of other fungal diseases. / Graduate / 0307 / 0306 / 0369 / jscarneiro@hotmail.com

Many plant species are closely related to river biotopes or to biotopes influenced by rivers. River systems create important linear corridors in ecosystems and directly or non-directly influence spatial spread of species in these environments. This offer many questions about species spread in this system. We can answer these questions by using molecular methods. Using 10 microsatellite (SSRs) primers, 202 individuals of Phragmites australis from 60 populations were analysed. Those analyses allowed reveal kinship of individuals, obtain information about spatial spread of populations and about spreading of common reed. Phragmites australis creates both - monoclonal and polyclonal - populations. Dependence of rate of clonality on environment was revealed. Populations from river banks are more monoclonal, populations from pond shores are more polyclonal. Populations are isolated. The highest percentage of variability was explained on among-population level. This is common for anemochoric species. Communication between populations is present, more on shorter distances. Evidence for vegetative spread was found on short distance. Generative spread is much more common. Long-distance spreading is mediated by generative diaspores - seeds. This spreading includes within-river spread, among-river spread and spreading...

The usage of autonomous vehicles is starting to appear in several different domains and the domain of public safety is no exception. Wallenberg Artificial Intelligence, Autonomous Systems and Software Program (WASP) has created a research arena for public safety (WARA-PS) to explore experimental features, usages, and implementation of autonomous vehicles within the domain of public safety. Collaborating in the arena are several companies, universities, and researchers. This thesis examines, in collaboration with Combitech, a company partnered in WARA-PS, how the implementation of autonomous vehicles affects the sociotechnical system of a search and rescue operation during a drifting boat with potential castaways. This is done by creating a case together with domain experts, analyzing the sociotechnical system within the case using cognitive work analysis and then complementing the analyses with the unmanned autonomous vehicles of WARA-PS. This thesis has shown how the WARA-PS vehicles can be implemented in the case of a drifting boat with potential castaways and how the implementation affects the sociotechnical system. Based on the analyses and opinions of domain experts’ future guidelines has been derived to further the work with sociotechnical aspects in WARA-PS. / WARA-PS