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.

Kaupungin ja maaseudun vuorovaikutus alueellisessa kehittämispolitiikassa

In Finland, European Union membership and economic globalisation have changed the position of regions from closed territorial systems to nodes of open international networks. The increasing complexity of cities as globalised knowledge centres and functionally specialised and diversified rural areas, and on the other hand growing disparities between prosperous urban cores and lagging peripheral areas are also essential features in contemporary regional development. These trends have produced new needs to promote mutual dialogue between cities and the countryside in western market economies. Urban-rural interaction is an idea which was developed in the late 1990s within regional policy to pull together these new challenges to regional development and handle cities and the countryside as a whole. The aim of my study is to conceptualise the idea of urban-rural interaction, explain the phenomenon theoretically, clarify past and present urban and rural development and analyse regional policies from the interaction angle. The ultimate purpose is to illustrate the existence and nature of particular interaction policy in a globalising society. The general method is discourse analysis, which I use in three cases: Central Finland, South-Ostrobothnia and South-West Finland. Theoretically I have a two-dimensional approach. On the first hand I use World-System theory to explain how the global economy is moulding urban and rural structures at the regional level. On the other hand I use regime theory to explain local political actions and practises between cities and the countryside under the overlapping pressures deriving from reformulated regional structures and policies.

Adaptation to globalisation in Finland has been carried out by strengthening urban centres. The stress in regional policy has been in urban development. The development of the countryside has mostly been implemented by a separate rural policy. At the end of the 1990s and early 2000s Finnish cities have actually shown themselves to be competitive in global markets. The drawbacks of the new growth centre policy have been the sparse network of prosperous cities and their weak spreading effects, which have hindered comprehensive regional development. Tensions between urban and rural areas have also deepened. In this situation the interaction policy is used as a way of balancing development and moderate conflicts within the regions. From this point of view urban-rural interaction can be seen as a way of tackling the challenges of globalisation.

On the other hand the results emphasise that actors involved in regional development still believe, although the hegemonic discourse is on urban policy, that there are opportunities to stimulate progress in the countryside as well. In the situation where regional authorities control development resources, rural development can be successful only if rural actors manage to establish fruitful relationships with their urban partners. This is also the weakness of the programme-based regional policy. If rural municipalities or other actors are for any reason incapable of building development regimes with cities, the offers of interaction policy will be useless.

The problem of the interaction policy is that the focus and methods of it have so far been rather underdeveloped. In order to improve the efficiency of the interaction policy, further research should concentrate on the social processes which define the position of cities and the countryside as partners of interaction, and practises which promote or prohibit the possibilities of developing the interaction policy. The efforts to define different contents of urban-rural interaction or promote interaction projects should not have such an important role in the future as they have had so far. Instead, the focus of interaction policy should be on questions such as how to manage the political tensions between town and country and how to create a positive atmosphere for regional policy where the needs of urban and rural development are promoted equally.

Predicting the need for ditch network maintenance in drained peatland sites in Finland

Kunnostusojitustarpeen ennustaminen ojitusalueilla

Finnish oral history network

Reviews

The oral history network in the Nordic and Baltic context

Teemanumero

Performance Evaluation of Six-Sectored Configuration in Hexagonal WCDMA (UMTS) Cellular Network Layout

The objective of this master's thesis is to evaluate the optimum performance of sixsectored hexagonal layout of WCDMA (UMTS) network and analyze the performance at the optimum point. The maximum coverage and the maximum capacity are the main concern of service providers and it is always a challenging task for them to achieve economically. Because the optimum configuration of a network corresponds to a configuration which minimizes the number of sites required to provide a target service probability in the planning area which in turn reduces the deployment cost. The optimum performance means the maximum cell area and themaximum cell capacity the network can provide at the maximum antenna height satisfying the target service probability. Hexagon layout has been proven as the best layout for the cell deployment. In this thesis work, two different configurations using six-sectored sites have been considered for the performance comparison. In first configuration, each antenna is directed towards each corner of hexagon, whereas in second configurationeach antenna is directed towards each side of hexagon. The net difference in the configurations is the 30 degree rotation of antenna direction. The only indoor users in a flat and smooth semi-urban environment area have been considered for the simulation purpose where the traffic distribution is 100 Erl/km2 with 12.2 kbps speech service having maximum mobile speed of 3 km/hr. The simulation results indicate that a similar performance can be achieved in both the configurations, that is, a maximum of 947 m cellrange at antenna height of 49.5 m can be achieved when the antennas are directed towards the corner of hexagon, whereas 943.3 m cell range atantenna height of 54 m can be achieved when the antennas are directed towards the side of hexagon. However, from the interference point of view the first configuration provides better results. The simulation results also show that the network is coverage limited in both the uplink and downlink direction at the optimum point.

The electricity distribution network in Saint-Petersburg area and benchmark between Saint-Petersburg and City of Stockholm related distribution companies' performance

The main objective of the Thesis is the description of the electricity distribution networks in Saint-Petersburg area and Stockholm as well. Main similarity and differences in the construction and technicalperformance are presented in the study. Present and future development and investment into the electricity distribution network of OJSC Lenenergo are viewed. The Thesis presents the overview of the power industry reform in Russia. The current state of the electricity distribution sector is described. The study views the participation of the foreign investor "Fortum Power and Heat Oy" inthe development and management of the OJSC Lenenergo. Benchmark comparison of the prices and tangible assets of the main electricity distribution companies in Saint-Petersburg and Stockholm areas is done.

Developing of supplier network in shipbuilding industry

Työn tarkoituksena on selvittää minkälaisen verkoston Aker Yards Oy, kokonaistoimittajat ja kokonaistoimittajien alihankkijat muodostavat. Lisäksi arvioidaan verkostoriskit, joita Aker Yards Oy kohtaa toimiessaan verkostossa. Tutkimus suoritettiin tekemällä kysely verkostossa oleville kokonaistoimittajille sekä haastattelemalla kuutta henkilöä Aker Yards Oy:stä. Suhteita ja verkostoa analysoitiin tutkimalla verkoston yksittäisiä toimijoita sekä näiden välisiä suhteita. Riskejä analysoitiin tarkastelemalla niiden tunnistettuja syitä. Työn tuloksena on verkostokuva, joka piirrettiin kyselytulosten perusteella. Suhteiden ja verkoston analyysillä päädyttiin tehtäviin, joita Aker Yards Oy:n johdon tulisi toteuttaa, jotta verkostosta ja yksittäisistä toimittajista saataisiin irti mahdollisimman paljon. Lisäksi suhteita ja verkostoa käsiteltiin niiden tuloksellisen johtamisen näkökulmasta. Riskianalyysista saatiin tuloksena uhkaavimpien riskien arviointi.