Tietovaraston latausprosessin kehittämisen osittainen automatisointi Microsoft SQL Server 2008 -ympäristössä

Tässä työssä tutkitaan tietovaraston latausprosessin kehittämisen nopeuttamista Mic-rosoft SQL Server 2008 -ympäristössä. Työn teoriaosuudet on tarkoitettu tukemaan sekä työn tutkimus- että käytännönosia. Aiheeseen liittyviä tutkimuksia käytiin läpi parhaiden latausprosessin kehittämiseen kuluvaa aikaa vähentävien tapojen selvittä-miseksi. Nykytutkimus keskittyy valmistajasta riippumattomien mallien kehittämiseen ja valmistajakohtaisen latausprosessin luomiseen näiden mallien pohjalta. Yleinen konsensus parhaan mallin suhteen kuitenkin puuttuu. Aiheeseen liittyvien tutkimusten pohjalta esitetään arkkitehtuuri, joka saattaisi tule-vaisuudessa vähentää latausprosessin kehittämiseen kuluvaa aikaa huomattavasti. Tästä arkkitehtuurista luotiin yksinkertaistettu versio sekä siihen pohjautuva sovellus nopeuttamaan latausprosessin kehittämistä Microsoftin ETL-työkalulla.

Laskentasovelluksen kehittäminen modulaariselle vesiputkikattilalle

Modulaarisella vesiputkikattilalla tarkoitetaan täysin konepajalla valmistettavissa olevaa kattilaa, joka voidaan kuljettaa yhtenä tai muutamana suurena moduulina työmaalle. Tässä diplomityössä käsiteltiin modulaarisen vesiputkikattilan laskentasovelluksen ke-hittämistä KPA Unicon Oy:lle. Työn tavoitteena oli tarkastella modulaarisen vesiputkikattilan lämpöteknistä mitoitusta ja suunnittelua sekä kehittää laskentasovellus, jonka avulla voidaan arvioida kattilan mittoja ja painoa. Laskentasovellus laadittiin Microsoftin Excel-alustalle, josta se on myöhemmin mahdollista siirtää muille ohjelma-alustoille. Laskentasovelluksessa hyödynnetään lämmönsiirron ja virtaustekniikan laskentayhtälöitä sekä -menetelmiä. Sovellukseen valitut laskentayhtälöt sekä -menetelmät ovat yleisesti hyväksyttyjä ja käytännössä testattuja. Diplomityön tuloksena valmistui laskentasovellus, joka kykenee modulaarisen vesiputkikattilan lämpötekniseen mitoittamiseen. Sovelluksen avulla voidaan mitoittaa kattilan tulipesä, tulistimet, höyrystinpinnat sekä ekonomaiseri. Laskentasovellusta on tarkoitus hyödyntää yrityksen tarjousvaiheen projekteissa sekä mahdollisesti kattiloiden esisuunnittelussa. Laskentasovelluksen laatimista varten ei ollut mahdollista hyödyntää toiminnassa olevien kattiloiden prosessitietoja, koska ensimmäiset tämän tyyppiset kattilat ovat asenteilla. Sen sijaan sovelluksen antamia laskentatuloksia verrattiin toisen mitoitusohjelman antamiin tuloksiin, joiden perusteella laskentasovelluksen voidaan olettaa antavan oikeita tuloksia.

Structural modelling of liquid ZrO2 and glassy B2O3 by using AB INITIO Molecular Dynamics method

Atomic structure of ZrO2 and B2O3 was investigated in this work. New data under extreme conditions (T = 3100 K) was obtained for the liquid ZrO2 structure. A fractional number of boron was investigated for glassy structure of B2O3. It was shown that it is possible to obtain an agreement for the fractional number between NMR and DFT techniques using a suitable initial configuration.

Spin-Dynamics in Cold Gases of 87Rb and Atomic Hydrogen. The spins they are a-changin’

In this thesis the dynamics of cold gaseous atoms is studied. Two different atomic species and two different experimental techniques have been used. In the first part of the thesis experiments with Bose-Einstein condensates of Rb-87 are presented. In these experiments the methods of laser cooling and magnetic trapping of atoms were utilized. An atom chip was used as the experimental technique for implementation of magnetic trapping. The atom chip is a small integrated instrument allowing accurate and detailed manipulation of the atoms. The experiments with Rb-87 probed the behaviour of a falling beam of atoms outcoupled from the Bose-Einstein condensate by electromagnetic field induced spin flips. In the experiments a correspondence between the phases of the outcoupling radio frequency field and the falling beam of atoms was found. In the second part of the thesis experiments of spin dynamics in cold atomic hydrogen gas are discussed. The experiments with atomic hydrogen are conducted in a cryostat using a dilution refrigerator as the cooling method. These experiments concentrated on explaining and quantifying modulations in the electron spin resonance spectra of doubly polarized atomic hydrogen. The modifications to the previous experimental setup are described and the observation of electron spin waves is presented. The observed spin wave modes were caused by the identical spin rotation effect. These modes have a strong dependence on the spatial profile of the polarizing magnetic field. We also demonstrated confinement of these modes in regions of strong magnetic field and manipulated their spatial distribution by changing the position of the field maximum.

Photoexcitation dynamics in organic solar cell donor/acceptor systems

Solceller presenteras ofta som ett miljövänligt alternativ för energiproduktion. Det största hindret för en bredare ibruktagning av kiselbaserade solceller är deras höga pris. I och med upptäckten av ledande och halvledande organiska (kolbaserade) molekyler och polymerer har ett nytt forskningsområde, organisk elektronik, vuxit fram. Den stora fördelen med organisk elektronik är att de använda materialen oftast är lösliga. Tillverkning av elektroniska komponenter kan då göras med hjälp av konventionella trycktekniker där bläcket ersatts med upplösta organiska material. Detta har potential att betydligt sänka priset för solceller. Nackdelen med organisk elektronik är att de använda materialen är komplexa, och de fysikaliska processerna i dem likaså. I min avhandling har jag studerat fotofysiken i två polymerer, P3HT och APFO3, som kan användas för att tillverka organiska solceller. Blandade med fullerenderivatet PCBM, som är en stark elektronacceptor, fås ett material som effektivt producerar elektroner och hål under belysning. I praktiken bidrar dock inte alla skapade laddningar till strömmen ur solcellen. Elektronerna och hålen kan förbli bundna till varandra i olika exciterade tillstånd, och även de som är fria kan träffa på motsatta laddningar under vägen till kontakterna och rekombinera. Centralt i mitt arbete har varit att identifiera olika typer av exciterade tillstånd i dessa solcellsmaterial, samt att bestämma deras livstider och rekombination. Metoden för detta har varit s.k. fotoinducerad absorption, som mäter fotoexcitationernas absorptioner i infraröda våglängdsområdet. De två viktigaste resultaten som presenteras i avhandlingen är en ratekvationsmodell för fotoexcitationsdynamiken i APFO3 på ultrasnabba tidsskalor (femtosekund - microsekund) och bildandet av en rekombinationshämmande dipol vid gränsytan för P3HT och PCBM som följd av värmebehandling. Dessa resultat bidrar till förståelsen av de fotofysikaliska processerna i relaterade material.

Dispersal and metacommunity dynamics in a soft-sediment benthic system : how well is the seafloor connected?

Connectivity depends on rates of dispersal between communities. For marine soft-sediment communities continued small-scale dispersal as post-larvae and as adults can be equally important in maintaining community composition, as initial recruitment of substrate by pelagic larvae. In this thesis post-larval dispersal strategies of benthic invertebrates, as well as mechanisms by which communities are connected were investigated. Such knowledge on dispersal is scarce, due to the difficulties in actually measuring dispersal directly in nature, and dispersal has not previously been quantified in the Baltic Sea. Different trap-types were used underwater to capture dispersing invertebrates at different sites, while in parallel measuring waves and currents. Local community composition was found to change predictably under varying rates of dispersal and physical connectivity (waves and currents). This response was, however, dependent on dispersal-related traits of taxa. Actively dispersing taxa will be relatively better at maintaining their position, as they are not as dependent on hydrodynamic conditions for dispersal and will be less prone to be passively transported by currents. Taxa also dispersed in relative proportions that were distinctly different from resident community composition and a significant proportion (40 %) of taxa were found to lack a planktonic larval life-stage. Community assembly was re-started in a large-scale manipulative field experiment over one year across several sites, which revealed how patterns of community composition (α-, β- and λ-diversity) change depending on rates of dispersal. Results also demonstrated that in response to small-scale disturbance, initial recruitment was by nearby-dominant species after which other species arrived from successively further away. At later assembly time, the number of coexisting species increased beyond what was expected purely by local niche requirements (species sorting), transferring regional differences in community composition (β-diversity) to the local scale (α-diversity, mass effect). Findings of this thesis complement more theoretical studies in metacommunity ecology by demonstrating that understanding how and when individuals disperse relative to underlying environmental heterogeneity is key to interpreting how patterns of diversity change across different spatial scales. Such information from nature is critical when predicting responses to, for example, different types of disturbances or management actions in conservation.

Images of the future of privacy: A privacy dynamics framework and a causal layered

The future of privacy in the information age is a highly debated topic. In particular, new and emerging technologies such as ICTs and cognitive technologies are seen as threats to privacy. This thesis explores images of the future of privacy among non-experts within the time frame from the present until the year 2050. The aims of the study are to conceptualise privacy as a social and dynamic phenomenon, to understand how privacy is conceptualised among citizens and to analyse ideal-typical images of the future of privacy using the causal layered analysis method. The theoretical background of the thesis combines critical futures studies and critical realism, and the empirical material is drawn from three focus group sessions held in spring 2012 as part of the PRACTIS project. From a critical realist perspective, privacy is conceptualised as a social institution which creates and maintains boundaries between normative circles and preserves the social freedom of individuals. Privacy changes when actors with particular interests engage in technology-enabled practices which challenge current privacy norms. The thesis adopts a position of technological realism as opposed to determinism or neutralism. In the empirical part, the focus group participants are divided into four clusters based on differences in privacy conceptions and perceived threats and solutions. The clusters are fundamentalists, pragmatists, individualists and collectivists. Correspondingly, four ideal-typical images of the future are composed: ‘drift to low privacy’, ‘continuity and benign evolution’, ‘privatised privacy and an uncertain future’, and ‘responsible future or moral decline’. The images are analysed using the four layers of causal layered analysis: litany, system, worldview and myth. Each image has its strengths and weaknesses. The individualistic images tend to be fatalistic in character while the collectivistic images are somewhat utopian. In addition, the images have two common weaknesses: lack of recognition of ongoing developments and simplistic conceptions of privacy based on a dichotomy between the individual and society. The thesis argues for a dialectical understanding of futures as present images of the future and as outcomes of real processes and mechanisms. The first steps in promoting desirable futures are the awareness of privacy as a social institution, the awareness of current images of the future, including their assumptions and weaknesses, and an attitude of responsibility where futures are seen as the consequences of present choices.

Kalman filter for computational market dynamics

Kalman filter is a recursive mathematical power tool that plays an increasingly vital role in innumerable fields of study. The filter has been put to service in a multitude of studies involving both time series modelling and financial time series modelling. Modelling time series data in Computational Market Dynamics (CMD) can be accomplished using the Jablonska-Capasso-Morale (JCM) model. Maximum likelihood approach has always been utilised to estimate the parameters of the JCM model. The purpose of this study is to discover if the Kalman filter can be effectively utilized in CMD. Ensemble Kalman filter (EnKF), with 50 ensemble members, applied to US sugar prices spanning the period of January, 1960 to February, 2012 was employed for this work. The real data and Kalman filter trajectories showed no significant discrepancies, hence indicating satisfactory performance of the technique. Since only US sugar prices were utilized, it would be interesting to discover the nature of results if other data sets are employed.

Dynamics of chest wall volume regulation during constant work rate exercise in patients with chronic obstructive pulmonary disease

This study evaluated the dynamic behavior of total and compartmental chest wall volumes [(V CW) = rib cage (V RC) + abdomen (V AB)] as measured breath-by-breath by optoelectronic plethysmography during constant-load exercise in patients with stable chronic obstructive pulmonary disease. Thirty males (GOLD stages II-III) underwent a cardiopulmonary exercise test to the limit of tolerance (Tlim) at 75% of peak work rate on an electronically braked cycle ergometer. Exercise-induced dynamic hyperinflation was considered to be present when end-expiratory (EE) V CW increased in relation to resting values. There was a noticeable heterogeneity in the patterns of V CW regulation as EEV CW increased non-linearly in 17/30 "hyperinflators" and decreased in 13/30 "non-hyperinflators" (P < 0.05). EEV AB decreased slightly in 8 of the "hyperinflators", thereby reducing and slowing the rate of increase in end-inspiratory (EI) V CW (P < 0.05). In contrast, decreases in EEV CW in the "non-hyperinflators" were due to the combination of stable EEV RC with marked reductions in EEV AB. These patients showed lower EIV CW and end-exercise dyspnea scores but longer Tlim than their counterparts (P < 0.05). Dyspnea increased and Tlim decreased non-linearly with a faster rate of increase in EIV CW regardless of the presence or absence of dynamic hyperinflation (P < 0.001). However, no significant between-group differences were observed in metabolic, pulmonary gas exchange and cardiovascular responses to exercise. Chest wall volumes are continuously regulated during exercise in order to postpone (or even avoid) their migration to higher operating volumes in patients with COPD, a dynamic process that is strongly dependent on the behavior of the abdominal compartment.

Computational fluid dynamics evaluation of liquid food thermal process in a brick shaped package

Food processes must ensure safety and high-quality products for a growing demand consumer creating the need for better knowledge of its unit operations. The Computational Fluid Dynamics (CFD) has been widely used for better understanding the food thermal processes, and it is one of the safest and most frequently used methods for food preservation. However, there is no single study in the literature describing thermal process of liquid foods in a brick shaped package. The present study evaluated such process and the influence of its orientation on the process lethality. It demonstrated the potential of using CFD to evaluate thermal processes of liquid foods and the importance of rheological characterization and convection in thermal processing of liquid foods. It also showed that packaging orientation does not result in different sterilization values during thermal process of the evaluated fluids in the brick shaped package.

Dynamics of gas levels inside packages containing minimally processed Pera orange

The purpose of this study was to evaluate the changes in concentrations of O2 and CO2 inside packages of minimally processed Pera orange. Previously selected oranges that were washed, sanitized, and chilled were peeled using hydrothermal treatment (immersion of fruits in water at 50 °C for 8 minutes). The peeled oranges were then packed in five different plastic packages under passive and active modified atmosphere (5% O2 + 10% CO2 + 85% N2). The fruits were stored at 6 °C and 12 °C. The package headspace gas composition was evaluated for twelve days at 6 °C and nine days at 12 °C. The polypropylene film (32 µm) promoted modified atmosphere similar to that initially injected (5% O2 + 10% CO2 + 85% N2) at 6 °C and 12 °C. With regard to the atmosphere modification system, the injection of a gas mixture anticipated achieving an equilibrium atmosphere inside the packages at 12 °C. At 6 °C, the gas composition inside the packages was kept close to that of the injection, but the equilibrium was not verified.

Icewine fermentation by Saccharomyces cervisiae : fundamental stress responses and comparative fermentation dynamics

Please consult the paper edition of this thesis to read. It is available on the 5th Floor of the Library at Call Number: Z 9999.5 B63 P54 2007

The dynamics of sustained reentry in a loop model with discrete gap junction resistance

Mémoire numérisé par la Division de la gestion de documents et des archives de l'Université de Montréal.

Reconsidérer les interactions entre l’écoulement, le transport de sédiments en charge de fond et la morphologie en rivière à lit de graviers : approches, échelles et analyses

L'objectif ultime en géomorphologie fluviale est d'expliquer les formes des cours d'eau et leur évolution temporelle et spatiale. La multiplication des études nous a mené à la réalisation que les systèmes géomorphologiques sont complexes. Les formes observées sont plus que la somme des processus individuels qui les régissent en raison d’interactions et de rétroactions non-linéaires à de multiples échelles spatiales et temporelles. Dans ce contexte, le but général de la thèse est de proposer et de tester de nouvelles avenues de recherche afin de mieux appréhender la complexité des dynamiques fluviales en utilisant des approches méthodologiques et analytiques mettant l’accent sur les interactions entre l’écoulement, le transport de sédiments en charge fond et la morphologie du lit en rivière graveleuse. Cette orientation découle du constat que les paradigmes actuels en géomorphologie fluviale n’arrivent pas à expliquer adéquatement la variabilité naturelle du transport en charge de fond ainsi que des formes du lit qui en résultent. Cinq pistes de réflexion sont développées sous forme d’articles basés sur des études de cas : 1. L'intégration des échelles de variation de l'écoulement permet d’insérer la notion de structures turbulentes dans des pulsations de plus grande échelle et d'améliorer la compréhension de la variabilité du transport de sédiments. 2. La quantification des taux de changement de l’écoulement (accélération /décélération) au cours d’une crue permet d’expliquer la variabilité des flux de transport en charge fond autant que la magnitude de l’écoulement. 3. L’utilisation de techniques de mesures complémentaires révèle une nouvelle dynamique du lit des rivières graveleuses, la dilatation et la contraction du lit suite à une crue. 4. La remise en cause du fait généralement accepté que le transport en charge de fond est corrélé positivement à l'intensité des modifications morphologiques en raison d’un problème associé aux échelles différentes des processus en cause. 5. L’approche systémique des dynamiques fluviales par l’utilisation d’analyses multivariées permet d’appréhender la complexité des dynamiques de rétroactions linéaires et non-linéaires dans l’évolution d’un chenal et d’illustrer l’importance de l’historique récent des changements géomorphologiques en réponse aux crues. Cette thèse se veut une avancée conceptuelle issue d'une profonde réflexion sur les approches classiques que l'on utilise en géomorphologie fluviale depuis plusieurs décennies. Elle est basée sur un jeu de données unique récolté lors du suivi intensif de 21 évènements de crue dans un petit cours d’eau à lit de graviers, le ruisseau Béard (Québec). Le protocole expérimental axé sur la simultanéité des mesures de l’écoulement, de la morphologie du lit et du transport de sédiments en charge de fond a permis de centrer la recherche directement sur les interactions entre les processus plutôt que sur les processus individuels, une approche rarement utilisée en géomorphologie fluviale. Chacun des chapitres illustre un nouveau concept ou une nouvelle approche permettant de résoudre certaines des impasses rencontrées actuellement en géomorphologie fluviale. Ces travaux ont des implications importantes pour la compréhension de la dynamique des lits de rivières et des habitats fluviaux et servent de point de départ pour de nouveaux développements.

Elementary steps in aqueous proton transfer reactions : a first principles molecular dynamics study

La nature des acides dans un environnement aqueux est primordiale dans de nombreux aspects de la chimie et de la biologie. La caractéristique principale d'un acide est sa capacité à transférer un proton vers une molécule d'eau ou vers n'importe quelle base, mais ce procédé n'est pas aussi simple qu'il y paraît. Il peut au contraire être extrêmement complexe et dépendre de manière cruciale de la solvatation des différents intermédiaires de réaction impliqués. Cette thèse décrit les études computationnelles basées sur des simulations de dynamique moléculaire ab initio qui ont pour but d'obtenir une description à l'échelle moléculaire des divers procédés de transferts de proton entre acide et bases dans un milieu aqueux. Pour cela, nous avons étudié une serie de système, dont l'acide hydrofluorique aqueux, l'acide trifluoroacétique aqueux, et un système modèle constitué d'un phénol et d'une entité carboxylate reliés entre eux par une molécule d'eau en solution aqueuse. Deux états intermédiaires ont été identifiés pour le transfert d'un proton depuis un acide. Ces intermédiaires apparaissent stabilisés par un motif local de solvatation via des ponts H. Leurs signatures spectroscopiques ont été caractérisées au moyen de la spectroscopie infrarouge, en utilisant le formalisme de la dynamique moléculaire ab initio, qui inclut l'effet quantique nucléaire de manière explicite. Cette étude a aussi identifié trois chemins de réaction élémentaire, qui sont responsable pour le transfert d'un proton d'un acide à une base, ainsi que leurs échelles de temps caractéristiques. Les conclusions tirées de ces études sont discutées dans les détails, au niveau moléculaire, avec une emphase sur les comparaisons entre les résultats théoriques et les mesures expérimentales obtenues dans a littérature ou via des collaborateurs.