Evaluation of PostgreSQL replication and load balancing implementations

In this final project the high availability options for PostgreSQL database management system were explored and evaluated. The primary objective of the project was to find a reliable replication system and implement it to a production environment. The secondary objective was to explore different load balancing methods and compare their performance. The potential replication methods were thoroughly examined, and the most promising was implemented to a database system gathering weather information in Lithuania. The different load balancing methods were tested performance wise with different load scenarios and the results were analysed. As a result for this project a functioning PostgreSQL database replication system was built to the Lithuanian Hydrometeorological Service's headquarters, and definite guidelines for future load balancing needs were produced. This study includes the actual implementation of a replication system to a demanding production environment, but only guidelines for building a load balancing system to the same production environment.

Hydrologic Simulations of the Maquoketa River Watershed Using SWAT Working Paper 09-WP 49,June 2009

This paper describes the application of the Soil and Water Assessment Tool (SWAT) model to the Maquoketa River watershed, located in northeast Iowa. The inputs to the model were obtained from the Environmental Protection Agency’s geographic information/database system called Better Assessment Science Integrating Point and Nonpoint Sources (BASINS). Climatic data from six weather stations located in and around the watershed, and measured streamflow data from a U.S. Geological Survey gage station at the watershed outlet were used in the sensitivity analysis of SWAT model parameters as well as its calibration and validation for watershed hydrology and streamflow. A sensitivity analysis was performed using an influence coefficient method to evaluate surface runoff and base flow variations in response to changes in model input hydrologic parameters. The curve number, evaporation compensation factor, and soil available water capacity were found to be the most sensitive parameters among eight selected parameters when applying SWAT to the Maquoketa River watershed. Model calibration, facilitated by the sensitivity analysis, was performed for the period 1988 through 1993, and validation was performed for 1982 through 1987. The model performance was evaluated by well-established statistical methods and was found to explain at least 86% and 69% of the variability in the measured stream flow data for the calibration and validation periods, respectively. This initial hydrologic modeling analysis will facilitate future applications of SWAT to the Maquoketa River watershed for various watershed analysis, including water quality.

Effects of antiresorptive agents on bone micro-architecture assessed by Trabecular Bone Score in women age 50 and older. The Manitoba Prospective Study

Antiresorptive agents such as bisphosphonates induce a rapid increase of BMD during the 1st year of treatment and a partial maintenance of bone architecture. Trabecular Bone Score (TBS), a new grey-level texture measurement that can be extracted from the DXA image, correlates with 3D parameters of bone micro-architecture. Aim: To evaluate the longitudinal effect of antiresorptive agents on spine BMD and on site-matched spine microarchitecture as assessed by TBS. Methods: From the BMD database for Province of Manitoba, Canada, we selected women age >50 with paired baseline and follow up spine DXA examinations who had not received any prior HRT or other antiresorptive drug.Women were divided in two subgroups: (1) those not receiving any HRT or antiresorptive drug during follow up (=non-users) and (2) those receiving non-HRT antiresorptive drug during follow up (=users) with high adherence (medication possession ratio >75%) from a provincial pharmacy database system. Lumbar spine TBS was derived by the Bone Disease Unit, University of Lausanne, for each spine DXA examination using anonymized files (blinded from clinical parameters and outcomes). Effects of antiresorptive treatment for users and non-users on TBS and BMD at baseline and during mean 3.7 years follow-up were compared. Results were expressed % change per year. Results: 1150 non-users and 534 users met the inclusion criteria. At baseline, users and non-users had a mean age and BMI of [62.2±7.9 vs 66.1±8.0 years] and [26.3±4.7 vs 24.7±4.0 kg/m²] respectively. Antiresorptive drugs received by users were bisphosphonates (86%), raloxifene (10%) and calcitonin (4%). Significant differences in BMD change and TBS change were seen between users and nonusers during follow-up (p<0.0001). Significant decreases in mean BMD and TBS (−0.36± 0.05% per year; −0.31±0.06% per year) were seen for non-users compared with baseline (p<0.001). A significant increase in mean BMD was seen for users compared with baseline (+1.86±0.0% per year, p<0.0018). TBS of users also increased compared with baseline (+0.20±0.08% per year, p<0.001), but more slowly than BMD. Conclusion: We observed a significant increase in spine BMD and a positive maintenance of bone micro-architecture from TBS with antiresorptive treatment, whereas the treatment naïve group lost both density and micro-architecture. TBS seems to be responsive to treatment and could be suitable for monitoring micro-architecture. This article is part of a Special Issue entitled ECTS 2011. Disclosure of interest: M.-A. Krieg: None declared, A. Goertzen: None declared, W. Leslie: None declared, D. Hans Consulting fees from Medimaps.

Development of the Acoustic Emission Based Diagnostics Concept for the Rotary Lime Kiln

Reaaliaikainen, ennakoiva kunnonvalvonta on erittäin tärkeä osa modernin tehtaan tai tuotantolinjan toimintaa. Diplomityön teettäjä haluaa edelleen kehittää akustiseen emissioon perustuvaa kunnonvalvonta järjestelmäänsä, jotta siitä olisi enemmän hyötyä asiakkaalle. Diplomityö sisältää johdannonakustiseen emissioon ja akustisiin emissio sensoreihin. Työn tavoitteena oli kehittää päätöksentekojärjestelmä, jota käytettäisiin työn teettäjän valmistamien sensoreiden antaman tiedon automatisoituun analysointiin. Työssä on vertailtu kolmea eri ohjelmistotoimittajaa ja heidän ohjelmiaan, ja tehty ehdotus hankittavasta ohjelmistosta. Lisäksi työssä on kehitetty ohjeita, joiden avulla ohjelmisto ohjelmoidaan tuottamaan reaaliaikaista tietoa ja huolto-ohjeita sen käyttäjille. Lisäksi työssä annetaan ehdotuksia kunnonvalvonta- ja päätöksentekojärjestelmän edelleen kehittämiseen.

Mielipidekyselyjärjestelmän suunnittelu ja toteutus

Tämän työn tavoitteena on suunnitella yksinkertainen Internet-pohjainen mielipidekyselyjärjestelmä sekä esitellä yksityiskohtaisesti järjestelmän toteutus ja siihen liittyvät menetelmät. Menetelmistäesitellään ainoastaan ennalta valitut menetelmät järjestelmän toteutukseen, tietojen esittämiseen, esitystavan muotoiluun sekä tietojen varastointiin. Järjestelmä toteutetaan HTML- ja PHP-kielillä sekä käyttämällä CSS-menetelmän tyylimuotoiluja ja XML-kielen muotoiluun perustuvia tiedostoja tietovarastoina. Järjestelmän suunnitteluun liittyen työssä pyritään kuvaamaan järjestelmään toteutettavat kaksi erillistä käyttöliittymää, pääkäyttäjän käyttöliittymä ja normaalin käyttäjän käyttöliittymä, sekä näihin toteutettavat toiminnot. Pääkäyttäjän tärkeimmät toiminnot ovat mielipidekyselyiden luominen, käyttäjien lisääminen kyselyihin sekä kyselyiden tulosten seuranta. Normaalin käyttäjän toiminnot taas rajoittuvat kirjautumiseen ja kyselyyn vastaamiseen. Järjestelmän toteutuksen kuvauksessa kuvataan tarkasti edellä mainittujen kahden käyttöliittymän toiminnot sekä näiden toimintojen toteutustavat. Lisäksi toteutuksen kuvauksen yhteydessä määritellään tarkasti järjestelmän tietovarastoina toimivien tiedostojen sisällön muoto. Työn lopputuloksena syntyi valituilla toteutustavoilla toteutettu toimiva mielipidekyselyjärjestelmä sekä tämä järjestelmän suunnitteluun ja toteutuksen selvittämiseen keskittynyt dokumentti. Toteutetusta järjestelmästä ei tullut täydellinen vaan jatkokehityksessä voidaan harkita esimerkiksi tietokannan käyttämistä järjestelmän tietovarastoina sekä joidenkin lisäominaisuuksien toteuttamista. Tavoitteeseen päästiin kuitenkin, sillä toteutettu järjestelmä on toimiva ja käyttötarkoitukseensa sopiva.

Hiontarobotti-solun tietojärjestelmä

Hiontarobotteja käytetään nopeuttamaan hiontaprosessia ja vähentämään henkilöiden tarvetta tehdä kuluttavaa ja raskasta työtä. Yleensä hiottavat kappaleet ovat suuria, jolloin hionta robotillakin kestää kauan. Kun hiottavat kappaleet ovat pieniä, robotti hioo kappaleen nopeasti. Tällöin tarvitaan automaattinen varastointi, jotta hiontarobotti pystyy jatkamaan nopeasti seuraavan kappaleen hiontaa. Automaattinen varastointi tarvitsee tiedonhallintajärjestelmän, jolla hallitaan varastossa olevien kappaleiden tietoja. Hiottava kappale täytyy esimerkiksi pystyä tunnistamaan ennen hionnan aloittamista. Yhtenä tunnistusmenetelmänä voidaan käyttää radiotaajuudella toimivia RFID-tunnisteita. Kun kappale tunnistetaan ennen hiontaa niin voidaan varmistua, että robotti suorittaa oikean hiontaohjelman kappaleelle. Diplomityö liittyy Master Automation Groupin ensimmäiseen automaattista varastoa hyödyntävään FlexMill™-hiontarobotti-soluun. Työssä on suunniteltu ja toteutettu tietokanta ja siihen liittyvä tietojärjestelmä. Kehitettävä ohjelma toimii solun toiminnasta vastaavan soluohjaimen tiedonhallintaosana. Ohjelma hyödyntää RFID-laitteita kappaleiden tunnistuksessa.

Improving the performance of a dismounted Future Force Warrior by means of C4I2SR

This thesis comprises seven peer-reviewed articles and examines systems and applications suitable for increasing Future Force Warrior performance, minimizing collateral damage, improving situational awareness and Common Operational Picture. Based on a literature study, missing functionalities of Future Force Warrior were identified and new ideas, concepts and solutions were created as part of early stages of Systems of Systems creation. These introduced ideas have not yet been implemented or tested in combat and for this reason benefit analyses are excluded. The main results of this thesis include the following: A new networking concept, Wireless Polling Sensor Network, which is a swarm of a few Unmanned Aerial Vehicles forming an ad-hoc network and polling a large number of fixed sensor nodes. The system is more robust in a military environment than traditional Wireless Sensor Networks. A Business Process approach to Service Oriented Architecture in a tactical setting is a concept for scheduling and sharing limited resources. New components to military Service Oriented Architecture have been introduced in the thesis. Other results of the thesis include an investigation of the use of Free Space Optics in tactical communications, a proposal for tracking neutral forces, a system for upgrading simple collaboration tools for command, control and collaboration purposes, a three-level hierarchy of Future Force Warrior, and methods for reducing incidents of fratricide.

PET Imaging of Osteomyelitis. Feasibility of 18F-FDG, 68Ga-Chloride and 68Ga-DOTAVAP-P1 Tracers in Staphylococcal Bone Infections

Due to technical restrictions of the database system the title of the thesis does not show corretly on this page. Numbers in the title are in superscript. Please see the PDF-file for correct title. ---- Osteomyelitis is a progressive inflammatory disease of bone and bone marrow that results in bone destruction due to an infective microorganism, most frequently Staphylococcus aureus. Orthopaedic concern relates to the need for reconstructive and trauma-related surgical procedures in the fast grow¬ing population of fragile, aged patients, who have an increased susceptibility to surgical site infections. Depending on the type of osteomyelitis, infection may be acute or a slowly progressing, low-grade infection. Peri-implant infections lead to implant loosening. The emerging antibiotic resistance of com¬mon pathogens further complicates the situation. With current imaging methods, significant limitations exist in the diagnosing of osteomyelitis and implant-related infections. Positron emission tomography (PET) with a glucose analogue, 18F-fluoro¬deoxyglucose (18F-FDG), seems to facilitate a more accurate diagnosis of chronic osteomyelitis. The method is based on the increased glucose consumption of activated inflammatory cells. Unfortunately, 18F-FDG accumulates also in sterile inflammation regions and causes false-positive findings, for exam¬ple, due to post-operative healing processes. Therefore, there is a clinical need for new, more infection-specific tracers. In addition, it is still unknown why 18F-FDG PET imaging is less accurate in the detec¬tion of periprosthetic joint infections, most frequently due to Staphylococcus epidermidis. This doctoral thesis focused on testing novel PET tracers (68Ga-chloride and 68Ga-DOTAVAP-P1) for early detections of bone infections and evaluated the role of pathogen-related factors in the appli¬cations of 18F-FDG PET in the diagnostics of bone infections. For preclinical models of S. epidermidis and S. aureus bone/implant infections, the significance of the causative pathogen was studied with respect to 18F-FDG uptake. In a retrospective analysis of patients with confirmed bone infections, the significance of the presence or absence of positive bacterial cultures on 18F-FDG uptake was evalu¬ated. 18F-FDG and 68Ga-chloride resulted in a similar uptake in S. aureus osteomyelitic bones. However, 68Ga-chloride did not show uptake in healing bones, and therefore it may be a more-specific tracer in the early post-operative or post-traumatic phase. 68Ga-DOTAVAP-P1, a novel synthetic peptide bind¬ing to vascular adhesion protein 1 (VAP-1), was able to detect the phase of inflammation in healing bones, but the uptake of the tracer was elevated also in osteomyelitis. Low-grade peri-implant infec¬tions due to S. epidermidis were characterized by a low uptake of 18F-FDG, which reflects the virulence of the causative pathogen and the degree of leukocyte infiltration. In the clinical study, no relationship was found between the level of 18F-FDG uptake and the presence of positive or negative bacterial cul¬tures. Thus 18F-FDG PET may help to confirm metabolically active infection process in patients with culture-negative, histologically confirmed, low-grade osteomyelitis.

Achieving Real-Time Mode Estimation through Offline Compilation

As exploration of our solar system and outerspace move into the future, spacecraft are being developed to venture on increasingly challenging missions with bold objectives. The spacecraft tasked with completing these missions are becoming progressively more complex. This increases the potential for mission failure due to hardware malfunctions and unexpected spacecraft behavior. A solution to this problem lies in the development of an advanced fault management system. Fault management enables spacecraft to respond to failures and take repair actions so that it may continue its mission. The two main approaches developed for spacecraft fault management have been rule-based and model-based systems. Rules map sensor information to system behaviors, thus achieving fast response times, and making the actions of the fault management system explicit. These rules are developed by having a human reason through the interactions between spacecraft components. This process is limited by the number of interactions a human can reason about correctly. In the model-based approach, the human provides component models, and the fault management system reasons automatically about system wide interactions and complex fault combinations. This approach improves correctness, and makes explicit the underlying system models, whereas these are implicit in the rule-based approach. We propose a fault detection engine, Compiled Mode Estimation (CME) that unifies the strengths of the rule-based and model-based approaches. CME uses a compiled model to determine spacecraft behavior more accurately. Reasoning related to fault detection is compiled in an off-line process into a set of concurrent, localized diagnostic rules. These are then combined on-line along with sensor information to reconstruct the diagnosis of the system. These rules enable a human to inspect the diagnostic consequences of CME. Additionally, CME is capable of reasoning through component interactions automatically and still provide fast and correct responses. The implementation of this engine has been tested against the NEAR spacecraft advanced rule-based system, resulting in detection of failures beyond that of the rules. This evolution in fault detection will enable future missions to explore the furthest reaches of the solar system without the burden of human intervention to repair failed components.

Running climate models on grids using G-Rex

Compute grids are used widely in many areas of environmental science, but there has been limited uptake of grid computing by the climate modelling community, partly because the characteristics of many climate models make them difficult to use with popular grid middleware systems. In particular, climate models usually produce large volumes of output data, and running them also involves complicated workflows implemented as shell scripts. A new grid middleware system that is well suited to climate modelling applications is presented in this paper. Grid Remote Execution (G-Rex) allows climate models to be deployed as Web services on remote computer systems and then launched and controlled as if they were running on the user's own computer. Output from the model is transferred back to the user while the run is in progress to prevent it from accumulating on the remote system and to allow the user to monitor the model. G-Rex has a REST architectural style, featuring a Java client program that can easily be incorporated into existing scientific workflow scripts. Some technical details of G-Rex are presented, with examples of its use by climate modellers.

Solute movement through intact columns of cryoturbated Upper Chalk

Cryoturbated Upper Chalk is a dichotomous porous medium wherein the intra-fragment porosity provides water storage and the inter-fragment porosity provides potential pathways for relatively rapid flow near saturation. Chloride tracer movement through 43 cm long and 45 cm diameter undisturbed chalk columns was studied at water application rates of 0.3, 1.0, and 1.5 cm h(-1). Microscale heterogeneity in effluent was recorded using a grid collection system consisting of 98 funnel-shaped cells each 3.5 cm in diameter. The total porosity of the columns was 0.47 +/- 0.02 m(3) m(-3), approximately 13% of pores were >15 mu m diameter, and the saturated hydraulic conductivity was 12.66 +/- 1.31 m day(-1). Although the column remained unsaturated during the leaching even at all application rates, proportionate flow through macropores increased as the application rate decreased. The number of dry cells (with 0 ml of effluent) increased as application rate decreased. Half of the leachate was collected from 15, 19 and 22 cells at 0.3, 1.0, 1.5 cm h(-1) application rates respectively. Similar breakthrough curves (BTCs) were obtained at all three application rates when plotted as a function of cumulative drainage, but they were distinctly different when plotted as a function of time. The BTCs indicate that the columns have similar drainage requirement irrespective of application rates, as the rise to the maxima (C/C-o) is almost similar. However, the time required to achieve that leaching requirement varies with application rates, and residence time was less in the case of a higher application rate. A two-region convection-dispersion model was used to describe the BTCs and fitted well (r(2) = 0.97-0-99). There was a linear relationship between dispersion coefficient and pore water velocity (correlation coefficient r = 0.95). The results demonstrate the microscale heterogeneity of hydrodynamic properties in the Upper Chalk. Copyright (C) 2007 John Wiley & Sons, Ltd.

Solar PV Powered Air Conditioner Analysis for an Office/Classroom in a Tropical Climate

This thesis focuses on using photovoltaic produced electricity to power air conditioners in a tropical climate. The study takes place in Surabaya, Indonesia at two different locations the classroom, located at the UBAYA campus and the home office, 10 km away. Indonesia has an average solar irradiation of about 4.8 kWh/m²/day (PWC Indonesia, 2013) which is for ideal conditions for these tests. At the home office, tests were conducted on different photovoltaic systems. A series of measuring devices recorded the performance of the 800 W PV system and the consumption of the 1.35 kW air conditioner (cooling capacity). To have an off grid system many of the components need to be oversized. The inverter has to be oversized to meet the startup load of the air conditioner, which can be 3 to 8 times the operating power (Rozenblat, 2013). High energy consumption of the air conditioner would require a large battery storage to provide one day of autonomy. The PV systems output must at least match the consumption of the air conditioner. A grid connect system provides a much better solution with the 800 W PV system providing 80 % of the 3.5 kWh load of the air conditioner, the other 20 % coming from the grid during periods of low irradiation. In this system the startup load is provided by the grid so the inverter does not need to be oversized. With the grid-connected system, the PV panel’s production does not need to match the consumption of the air conditioner, although a smaller PV array will mean a smaller percentage of the load will be covered by PV. Using the results from the home office tests and results from measurements made in the classroom. Two different PV systems (8 kW and 12 kW) were simulated to power both the current air conditioners (COP 2.78) and new air conditioners (COP 4.0). The payback period of the systems can vary greatly depending on if a feed in tariff is awarded or not. If the feed in tariff is awarded the best system is the 12 kW system, with a payback period of 4.3 years and a levelized cost of energy at -3,334 IDR/kWh. If the feed in tariff is not granted then the 8 kW system is the best choice with a lower payback period and lower levelized cost of energy than the 12 kW system under the same conditions.

EIT: Escalonador Inteligente de Transações

In order to guarantee database consistency, a database system should synchronize operations of concurrent transactions. The database component responsible for such synchronization is the scheduler. A scheduler synchronizes operations belonging to different transactions by means of concurrency control protocols. Concurrency control protocols may present different behaviors: in general, a scheduler behavior can be classified as aggressive or conservative. This paper presents the Intelligent Transaction Scheduler (ITS), which has the ability to synchronize the execution of concurrent transactions in an adaptive manner. This scheduler adapts its behavior (aggressive or conservative), according to the characteristics of the computing environment in which it is inserted, using an expert system based on fuzzy logic. The ITS can implement different correctness criteria, such as conventional (syntactic) serializability and semantic serializability. In order to evaluate the performance of the ITS in relation to others schedulers with exclusively aggressive or conservative behavior, it was applied in a dynamic environment, such as a Mobile Database Community (MDBC). An MDBC simulator was developed and many sets of tests were run. The experimentation results, presented herein, prove the efficiency of the ITS in synchronizing transactions in a dynamic environment

Desenvolvimento de um sistema computacional para geração automática de mapas de vulnerabilidade como ferramenta de auxílio às ações de prevenção ao derramamento de óleo em áreas costeiras

The northern portion of the Rio Grande do Norte State is characterized by intense coastal dynamics affecting areas with ecosystems of moderate to high environmental sensitivity. In this region are installed the main socioeconomic activities of RN State: salt industry, shrimp farm, fruit industry and oil industry. The oil industry suffers the effects of coastal dynamic action promoting problems such as erosion and exposure of wells and pipelines along the shore. Thus came the improvement of such modifications, in search of understanding of the changes which causes environmental impacts with the purpose of detecting and assessing areas with greater vulnerability to variations. Coastal areas under influence oil industry are highly vulnerable and sensitive in case of accidents involving oil spill in the vicinity. Therefore, it was established the geoenvironmental monitoring of the region with the aim of evaluating the entire coastal area evolution and check the sensitivity of the site on the presence of oil. The goal of this work was the implementation of a computer system that combines the needs of insertion and visualization of thematic maps for the generation of Environmental Vulnerability maps, using techniques of Business Intelligence (BI), from vector information previously stored in the database. The fundamental design interest was to implement a more scalable system that meets the diverse fields of study and make the appropriate system for generating online vulnerability maps, automating the methodology so as to facilitate data manipulation and fast results in cases of real time operational decision-making. In database development a geographic area was established the conceptual model of the selected data and Web system was done using the template database PostgreSQL, PostGis spatial extension, Glassfish Web server and the viewer maps Web environment, the GeoServer. To develop a geographic database it was necessary to generate the conceptual model of the selected data and the Web system development was done using the PostgreSQL database system, its spatial extension PostGIS, the web server Glassfish and GeoServer to display maps in Web

A STORM* environment for building multimedia presentations

This paper describes an environment for constructing multimedia applications which are used to present different multimedia database objects in accordance with spatiotemporal constraints and from different sources. The main contribution of this paper is to propose an environment which integrates both a modelling case tool and an object-oriented database system.