Primary and Revision Hip Replacement. A University Hospital Database and Registry Study

Large-headed total hip arthroplasty (THA) and hip resurfacing arthroplasty (HRA) with metal-on-metal (MoM) bearings became popular during the last decade. Recently, it has become evident that the large-head MoM hip implants are associated with increased revision rates despite their theoretical advantages. The purpose of this study was to evaluate the early results of primary MoM hip replacements and of acetabular revisions. I analyzed retrospectively the results of four MoM implant designs and the survival rate of acetabular revisions with impaction bone grafting, as documented in the Turku University Hospital database. Further, I evaluated the correlation between femoral head size and dislocation rate, and used the Finnish Arthroplasty Register data to compare the survival of three large-head MoM THAs to analogous HRAs. The early results for the Magnum M2A–ReCap THA were good. A larger head size decreased the risk of dislocation. Articular surface replacement (ASR) THA yielded inferior results compared to analogous HRA. For two other designs the results were similar. The R3–Synergy THA yielded inferior results compared to the reference implants. The survival of acetabular reconstructions with impaction bone grafting was inferior compared to previous reports. In conclusion, the early results of the Biomet ReCap–Magnum design were promising, and large head sizes decreased the dislocation rate. The survival of different MoM hip implant designs varied. The survival of new designs and techniques may be inferior to those reported by the clinics where implants are developed. An important caveat is that early promising results of new devices may rapidly worsen. New implants need to be introduced in a controlled fashion to the market; here, arthroplasty registers are a valuable tool that needs to be used.

Improving reporting management with relational database management system

Data management consists of collecting, storing, and processing the data into the format which provides value-adding information for decision-making process. The development of data management has enabled of designing increasingly effective database management systems to support business needs. Therefore as well as advanced systems are designed for reporting purposes, also operational systems allow reporting and data analyzing. The used research method in the theory part is qualitative research and the research type in the empirical part is case study. Objective of this paper is to examine database management system requirements from reporting managements and data managements perspectives. In the theory part these requirements are identified and the appropriateness of the relational data model is evaluated. In addition key performance indicators applied to the operational monitoring of production are studied. The study has revealed that the appropriate operational key performance indicators of production takes into account time, quality, flexibility and cost aspects. Especially manufacturing efficiency has been highlighted. In this paper, reporting management is defined as a continuous monitoring of given performance measures. According to the literature review, the data management tool should cover performance, usability, reliability, scalability, and data privacy aspects in order to fulfill reporting managements demands. A framework is created for the system development phase based on requirements, and is used in the empirical part of the thesis where such a system is designed and created for reporting management purposes for a company which operates in the manufacturing industry. Relational data modeling and database architectures are utilized when the system is built for relational database platform.

Charta öfwer Finland år 1747 / sammandragen och förfärdigad wid Kongl. lantmäteri contoiret til General gouvernearens och Riksrådets högwälborne herr baron von Rosens tienst at förwaras wid gouvernaments residencet ; Suomen maantieteellisen seuran julkaisema jäljennös = Kopian publicerad av Geografiska sällskapet i Finland = Reprint published by the Geographical society of Finland.

Kartta ilmestynyt teoksen A map of Finland from 1747 / description by Sakari Härö liitteenä sarjassa Fennia. Supplementum. 1.

Adopting the Vaadin Java framework to rebuild VTT’s Web Interfaces and Database Applications

With the growth in new technologies, using online tools have become an everyday lifestyle. It has a greater impact on researchers as the data obtained from various experiments needs to be analyzed and knowledge of programming has become mandatory even for pure biologists. Hence, VTT came up with a new tool, R Executables (REX) which is a web application designed to provide a graphical interface for biological data functions like Image analysis, Gene expression data analysis, plotting, disease and control studies etc., which employs R functions to provide results. REX provides a user interactive application for the biologists to directly enter the values and run the required analysis with a single click. The program processes the given data in the background and prints results rapidly. Due to growth of data and load on server, the interface has gained problems concerning time consumption, poor GUI, data storage issues, security, minimal user interactive experience and crashes with large amount of data. This thesis handles the methods by which these problems were resolved and made REX a better application for the future. The old REX was developed using Python Django and now, a new programming language, Vaadin has been implemented. Vaadin is a Java framework for developing web applications and the programming language is extremely similar to Java with new rich components. Vaadin provides better security, better speed, good and interactive interface. In this thesis, subset functionalities of REX was selected which includes IST bulk plotting and image segmentation and implemented those using Vaadin. A code of 662 lines was programmed by me which included Vaadin as the front-end handler while R language was used for back-end data retrieval, computing and plotting. The application is optimized to allow further functionalities to be migrated with ease from old REX. Future development is focused on including Hight throughput screening functions along with gene expression database handling

Searching for music archives and composition manuscripts from the Viola database

Music archives and composition manuscripts from the Viola database.

Geographical Studies of Underwater Light Dynamics in the Coastal Archipelago of SW Finland, Baltic Sea

The underwater light field is an important environmental variable as it, among other things, enables aquatic primary production. Although the portion of solar radiation that is referred to as visible light penetrates water, it is restricted to a limited surface water layer because of efficient absorption and scattering processes. Based on the varying content of optical constituents in the water, the efficiency of light attenuation changes in many dimensions and over various spatial and temporal scales. This thesis discusses the underwater light dynamics of a transitional coastal archipelago in south-western Finland, in the Baltic Sea. While the area has long been known to have a highly variable underwater light field, quantified knowledge on the phenomenon has been scarce, patchy, or non-existent. This thesis focuses on the variability in the underwater light field through euphotic depths (1% irradiance remaining), which were derived from in situ measurements of vertical profiles of photosynthetically active radiation (PAR). Spot samples were conducted in the archipelago of south-western Finland, mainly during the ice-free growing seasons of 2010 and 2011. In addition to quantifying both the seasonal and geographical patterns of euphotic depth development, the need and usability of underwater light information are also discussed. Light availability was found to fluctuate in multiple dimensions and scales. The euphotic depth was shown to have combined spatio-temporal dynamics rather than separate changes in spatial and temporal dimensions. Such complexity in the underwater light field creates challenges in data collection, as well as in its utilisation. Although local information is needed, in highly variable conditions spot sampled information may only poorly represent its surroundings. Moreover, either temporally or spatially limited sampling may cause biases in understanding underwater light dynamics. Consequently, the application of light availability data, for example in ecological modelling, should be made with great caution.