Tapiola-ryhmän Yhtiökokousjärjestelmä-ohjelmiston määrittely ja suunnittelu

Tässä insinöörityössä selvitettiin mahdollisuuksia parantaa Tapiola-ryhmän Yhtiökokousjärjestelmä-ohjelmiston ominaisuuksia ja tietoturvallisuutta. Järjestelmää käytetään Tapiola-ryhmän vakuutusyhtiöiden yhtiökokouksiin osallistuvien osakkaiden kirjaamiseen ja heidän äänten laskentaan. Tutkimuksen perusteella tehtiin järjestelmän määrittely ja suunnittelu, joiden tuloksena syntyivät toiminnallinen ja tekninen määrittelydokumentaatio, jotka toimivat pohjana uuden Yhtiökokousjärjestelmän toteutukselle. Työ tehtiin Tapiola-ryhmälle Tieto-Tapiola Oy:n tilauksesta. Työn alussa tutkittiin erilaisia mahdollisuuksia toteuttaa järjestelmän ohjelmisto- ja tietokanta-arkkitehtuuri, joiden perusteella määrittelyä ja suunnittelua alettiin toteuttaa. Tutkimuksen perusteella päädyttiin käyttämään Java SE -arkkitehtuuria sovelluksen toteutukseen ja SQL Server -tietokantaa järjestelmän tietovarastona. Valittuihin ratkaisuihin päädyttiin niiden hyvien tietoturvallisuus- ja kertakirjausominaisuuksien takia. Toiminnallisessa määrittelydokumentissa käydään läpi järjestelmälle asetettuja vaatimuksia ja kuvataan sen toiminnot, liiketoimintaluokkamalli, käyttöliittymä ja tulosteet. Lisäksi siinä otetaan kantaa järjestelmän käyttöympäristöön, ulkoisiin tietokantaliittymiin, käyttäjän tunnistautumiseen ja tietoturvallisuuteen sekä käydään läpi sen toiminta käyttäjien näkökulmasta. Toiminnallisen määrittelydokumentin pohjalta luotiin tekninen määrittelydokumentti. Siinä kuvataan järjestelmän ympäristö ja ohjelmisto- sekä tietokanta-arkkitehtuuri yleisellä tasolla. Tämän lisäksi järjestelmän arkkitehtuuria käydään myös tarkemmin läpi sekä kuvataan moduulit ja toiminnot niin tarkasti, että niiden perusteella voidaan toteuttaa koko järjestelmä. Työn tuloksena syntyivät kattava toiminnallinen ja tekninen määrittelydokumentaatio, joissa käydään läpi kaikki järjestelmän toteuttamiseen tarvittavat elementit sillä tarkkuudella, että järjestelmän toteuttaminen voidaan aloittaa.

Induktiosilmukka kuulolaitteen käyttäjän apuvälineenä

Tämä insinöörityö tehtiin Kuulonhuoltoliitto ry:n Esteetön kuuntelu -projektille. Työ käsittelee kuulolaitteen käyttäjän apuvälineenä käytettäviä induktiosilmukkajärjestelmiä. Induktiivisen äänensiirtojärjestelmän avulla huonokuuloinen saa kuunteluympäristöstään paremman signaali-kohinasuhteen ilman tilan kaikua ja taustahälyä. Tämä helpottaa kuuntelua esimerkiksi puhetilaisuuksissa. Työn tarkoituksena oli päivittää aiempia tutkimuksia kokoamalla uusin tietous induktiosilmukoiden tekniikasta. Kirjallisuustutkimuksen lisäksi kartoitettiin nykyinen silmukkavahvistinkanta haastattelemalla maahantuojia ja jälleenmyyjiä. Silmukkavahvistimien hintakartoituksen tarkoituksena oli rakentaa perusteet sopivan tehoisen ja hintaisen vahvistimen hankintaa varten suunniteltaessa induktiivisella äänensiirtojärjestelmällä varustettavia tiloja. Työ tarkastelee induktiivisen äänensiirtojärjestelmän ensisijaisen kohderyhmän, kuulokojeita käyttävien huonokuuloisten keskeisiä tarpeita ja heidän käyttämäänsä apuvälinetekniikkaa. Työ käy läpi audiotekniikan perusteita, sähkömagneettisen induktioilmiön, induktiivisen äänensiirtojärjestelmän rakenteen, sen ylikuulumisongelmat ja häiriötekijät sekä IEC:n 60118-4 edition 2.0 standardin CDV-luonnoksen mukaiset periaatteelliset asennusja mittausohjeet. IEC:n tuleva standardi tekee työstä ajankohtaisen. Työn tuloksena saatua tietoa voidaan käyttää Kuulonhuoltoliitto ry:n opas- ja tiedotusmateriaalin uudistamisessa, pohjana hyvän kuunteluympäristön malliratkaisujen ja esteettömyyskriteerien soveltamisessa. Työstä on hyötyä erityisesti Kuulonhuoltoliitto ry:n vapaaehtoiskartoittajille kuten myös kenelle tahansa aiheesta syvemmin kiinnostuneelle.

Taajuusmuuttajien suorituskyvyn automaattinen testausympäristö

Tämä insinöörityö tehtiin ABB Oy, Drivesin Product AC -tulosyksikön tuotekehitysosastolle Helsingissä. Työssä kehitettiin taajuusmuuttajien suorituskyvyn automaattinen testausympäristö. ABB:n taajuusmuuttajien suorituskykytestejä ei ole aikaisemmin automatisoitu. Testit on tehty käsin ja niiden suorittamiseen ja tulosten käsittelyyn on kulunut paljon aikaa. Automaattisella testauksella pyrittiin testien suorittamiseen ja tulosten käsittelyyn kuluvan ajan huomattavaan pienentymiseen. Työssä ei ollut tarkoituksena tehdä suorituskykytestejä vaan kehittää automaattinen testausympäristö eli suorituskykytestipenkki, jossa suorituskykytestit on mahdollista suorittaa. Työssä keskityttiin taajuusmuuttajan nopeus- ja momenttisäätäjien suorituskykyyn. Työ toteutettiin suunnittelu- ja ohjelmointityönä. Testausympäristön laitteisto perustuu ABB:n tuotekehityslaboratorioiden olemassaoleviin testipaikkoihin. Testausympäristössä käytetään taajuusmuuttajien lisäksi pääasiassa kolmivaiheisia oikosulkumoottoreita. Lisäksi laitteistoon kuuluu ACS800-sarjan taajuusmuuttaja kuormakäyttönä, momenttianturi ja takometri eli kierrosnopeusmittari. Ohjelmointi tehtiin National Instrumentsin LabVIEW-ohjelmointiympäristön versiolla 8.0. Testausympäristön käyttöliittymänä toimii saman yrityksen TestStand-testausohjelmiston versio 3.5. Testattavien taajuusmuuttajien ohjausta ja momenttianturin lukemista varten ohjelmoitiin virtuaali-instrumentteja. Virtuaali-instrumentteja kutsutaan TestStand-testisekvensseistä. Testisekvenssit luodaan TestStandin sekvenssieditorilla ja suoritetaan sekvenssieditorissa tai operaattorin käyttöliittymässä. Työn tuloksena syntyi taajuusmuuttajien suorituskyvyn automaattinen testausympäristö. Testausympäristöä voidaan hyödyntää sekä nykyisen että seuraavan sukupolven taajuusmuuttajien testauksessa. Sillä on mahdollista suorittaa yleisimmät taajuusmuuttajien suorituskykytestit, kuten nopeus- ja momenttisäätöjen staattinen ja dynaaminen tarkkuus, hyvin kattavasti. Testit voidaan automaattisesti suorittaa koko testikäytön sallimalla pyörimisnopeus- ja kuormitusalueella. Näytteenottotaajuus voi olla enintään 1 kHz luettaessa pyörimisnopeutta ACS800-sarjan taajuusmuuttajan kautta ja momenttianturia samanaikaisesti. Virtuaali-instrumenteista koostuvia testisekvenssejä voidaan vapaasti muokata ja kehittää testejä edelleen tai luoda kokonaan uusia testejä. Testausympäristö perustuu teollisuudessa yleisesti käytettyihin ohjelmistoihin ja tarjoaa hyvät mahdollisuudet jatkokehitykselle.

Global mass wasting during the Middle Ordovician: Meteoritic trigger or plate-tectonic environment ?

Mass wasting at continental margins on a global scale during the Middle Ordovician has recently been related to high meteorite influx. Although a high meteorite influx during the Ordovician should not be neglected, we challenge the idea that mass wasting was mainly produced by meteorite impacts over a period of almost 10 Ma. Having strong arguments against the impact-related hypothesis, we propose an alternative explanation, which is based on a re-evaluation of the mass wasting sites, considering their plate-tectonic distribution and the global sea level curve. A striking and important feature is the distribution of most of the mass wasting sites along continental margins characterised by periods of magmatism, terrane accretion and continental or back-arc rifting, respectively, related to subduction of oceanic lithosphere. Such processes are commonly connected with seismic activity causing earthquakes, which can cause downslope movement of sediment and rock. Considering all that, it seems more likely that most of this mass wasting was triggered by earthquakes related to plate-tectonic processes, which caused destabilisation of continental margins resulting in megabreccias and debris flows. Moreover, the period of mass wasting coincides with sea level drops during global sea level lowstand. In some cases, sea level drops can release pore-water overpressure reducing sediment strength and hence promoting instability of sediment at continental margins. Reduced pore-water overpressure can also destabilise gas hydrate-bearing sediment, causing slope failure, and thus resulting in submarine mass wasting. Overall, the global mass wasting during the Middle Ordovician does not need meteoritic trigger. (C) 2010 International Association for Gondwana Research. Published by Elsevier B.V. All rights reserved.

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.

Lésions iatrogènes des voies biliaires lors de la cholécystectomie laparoscopique

Objective: Laparoscopic cholecystectomy (LC) has become the gold standard in the treatment of symptomatic cholelithiasis. The aim of this study was to determine the frequency of occurrence and risk factors of iatrogenic bile duct injuries (IBDI) in the LC and study their treatment modalities. Methods: Between January 2000 and December 2011, a series of 13 patients (6 men, 7 women, mean age 66.7 years, mean BMI 27.9 kg/m2) underwent IBDI in our institution for 2'840 LC performed. These patients were identified retrospectively using a wide range of classification codes in our medical center for archiving. Their medical records were examined individually to identify a IBDI. Results: The frequency of IBDI was 0.46% (n=13). The most common indication for surgery was acute cholecystitis (69.2%). The main cause was the confusion of the common bile duct with the cystic duct in 38.5% of cases. Strasberg classification applied to our sample identified the following injuries: A (n=4), D (n=4), E1 (n=3) and E5 (n=2). They were diagnosed intraoperatively in 46.2% of cases and postoperatively in 53.8% of cases. The rate of type D lesions was significantly higher in the group with intraoperative recognition (p= 0.009), while the rate of type A lesions was significantly higher in the group with postoprative recognition (p = 0.026). Intraoperatively, 83.3% of the lesions were treated by primary suture with a biliary drainage and a hepatico-jejunal anastomosis was performed immediately in one case (16.7%). Postoperatively, 85.7% of the lesions were treated by non-surgical techniques in first- line and 4 of them have undergone biliary surgery later. The total number of therapeutic procedures for each IBDI after LC was significantly higher when the diagnosis was made postoperatively (3.4 vs. 1.5, p= 0.040). Conclusion: This study has identified a patient at risk of IBDI, this one is relatively old, overweight and has an inflammatory environment. Misidentification of biliary anatomy remains the main cause. There is a clear relationship between the timing of recognition and the type of injury involved. The primary suture with adequate drainage seems to be the method of choice for intraoperative discovery, while in case of postoperative recognition, the treatment must be adapted after a multidisciplinary consensus by combining interventional radiology, endoscopy and surgery.

Clinical Learning Environment and Supervision. Development and Validation of the CLES Evaluation Scale

The purpose of the study is: (1) to describe how nursing students' experienced their clinical learning environment and the supervision given by staff nurses working in hospital settings; and (2) to develop and test an evaluation scale of Clinical Learning Environment and Supervision (CLES). The study has been carried out in different phases. The pilot study (n=163) explored the association between the characteristics of a ward and its evaluation as a learning environment by students. The second version of research instrument (which was developed by the results of this pilot study) were tested by an expert panel (n=9 nurse teachers) and test-retest group formed by student nurses (n=38). After this evaluative phase, the CLES was formed as the basic research instrument for this study and it was tested with the Finnish main sample (n=416). In this phase, a concurrent validity instrument (Dunn & Burnett 1995) was used to confirm the validation process of CLES. The international comparative study was made by comparing the Finnish main sample with a British sample (n=142). The international comparative study was necessary for two reasons. In the instrument developing process, there is a need to test the new instrument in some other nursing culture. Other reason for comparative international study is the reflecting the impact of open employment markets in the European Union (EU) on the need to evaluate and to integrate EU health care educational systems. The results showed that the individualised supervision system is the most used supervision model and the supervisory relationship with personal mentor is the most meaningful single element of supervision evaluated by nursing students. The ward atmosphere and the management style of ward manager are the most important environmental factors of the clinical ward. The study integrates two theoretical elements - learning environment and supervision - in developing a preliminary theoretical model. The comparative international study showed that, Finnish students were more satisfied and evaluated their clinical placements and supervision with higher scores than students in the United Kingdom (UK). The difference between groups was statistical highly significant (p= 0.000). In the UK, clinical placements were longer but students met their nurse teachers less frequently than students in Finland. Arrangements for supervision were similar. This research process has produced the evaluation scale (CLES), which can be used in research and quality assessments of clinical learning environment and supervision in Finland and in the UK. CLES consists of 27 items and it is sub-divided into five sub-dimensions. Cronbach's alpha coefficient varied from high 0.94 to marginal 0.73. CLES is a compact evaluation scale and user-friendliness makes it suitable for continuing evaluation.

Content validation of the dimensions constituting non-adherence to treatment of arterial hypertension

The objective of the study was to validate the content of the dimensions that constituted nonadherence to treatment of arterial systemic hypertension. It was a methodological study of content validation. Initially an integrative review was conducted that demonstrated four dimensions of nonadherence: person, disease/treatment, health service, and environment. Definitions of these dimensions were evaluated by 17 professionals, who were specialists in the area, including: nurses, pharmacists and physicians. The Content Validity Index was calculated for each dimension (IVCi) and the set of the dimensions (IVCt), and the binomial test was conducted. The results permitted the validation of the dimensions with an IVCt of 0.88, demonstrating reasonable systematic comprehension of the phenomena of nonadherence.

A tumor-specific cellular environment at the brain invasion border of adamantinomatous craniopharyngiomas.

Craniopharyngiomas (CP) are benign epithelial tumors of the sellar region and can be clinicopathologically distinguished into adamantinomatous (adaCP) and papillary (papCP) variants. Both subtypes are classified according to the World Health Organization grade I, but their irregular digitate brain infiltration makes any complete surgical resection difficult to obtain. Herein, we characterized the cellular interface between the tumor and the surrounding brain tissue in 48 CP (41 adaCP and seven papCP) compared to non-neuroepithelial tumors, i.e., 12 cavernous hemangiomas, 10 meningiomas, and 14 metastases using antibodies directed against glial fibrillary acid protein (GFAP), vimentin, nestin, microtubule-associated protein 2 (MAP2) splice variants, and tenascin-C. We identified a specific cell population characterized by the coexpression of nestin, MAP2, and GFAP within the invasion niche of the adamantinomatous subtype. This was especially prominent along the finger-like protrusions. A similar population of presumably astroglial precursors was not visible in other lesions under study, which characterize them as distinct histopathological feature of adaCP. Furthermore, the outer tumor cell layer of adaCP showed a distinct expression of MAP2, a novel finding helpful in the differential diagnosis of epithelial tumors in the sellar region. Our data support the hypothesis that adaCP, unlike other non-neuroepithelial tumors of the central nervous system, create a tumor-specific cellular environment at the tumor-brain junction. Whether this facilitates the characteristic infiltrative growth pattern or is the consequence of an activated Wnt signaling pathway, detectable in 90% of these tumors, will need further consideration.

Gestão dos recursos hídricos no processo de desenvolvimento sustentável de Cabo Verde: uma proposta

A água é vital para a sobrevivência, saúde e dignidade do ser humano e uma fonte fundamental para o seu desenvolvimento. As reservas de água potável no mundo estão sob pressão constante embora muitos ainda não tenham acesso a esse precioso líquido para atender ás necessidades básicas. A água é um recurso natural com valor económico, estratégico e social. A percepção da escassez tem levado governos, a reorganizar o ambiente institucional e definir novos direitos de propriedade por meio de um sistema de gestão participativo e descentralizado que estimule a utilização do recurso de forma racional. A investigação está direccionada à gestão e à implementação da Lei n.º 41/II/84 de 18 de Junho, que Aprova o Código de Águas que estabelece as bases gerais do regime jurídico de propriedade, protecção, conservação, desenvolvimento, administração e uso dos recursos. O enfoque da pesquisa é as Instituições Governamentais que lidam com a água e as Associações de Bacias hidrográficas que, com os seus olhares e saberes, contribuem com informações para que se construa uma Proposta de Modelo de Gestão numa perspectiva de sustentabilidade. A proposta de modelo pretende contribuir para uma gestão sustentada. A pesquisa é do tipo qualitativa e usa como metodologia o Estudo de Caso. Foi constatada a complexidade da gestão das águas em Cabo Verde, na qual existem ainda muitos entraves e desafios. A Bacia Hidrográfica é a unidade básica de gestão, onde as Associações, as Câmaras Municipais, os Serviços Autónomos de Água e Saneamento, o Instituto Nacional de Gestão dos recursos Hidricos desempenham o papel de gerí-la e preservá-la. Foram identificados como dificuldades: a posse da água não está bem clara, o que dificulta a gestão da Bacia; os conflitos sociais são frequentes quanto ao uso da água no que tange à poluição; a população rural não está devidamente contemplada na gestão dos recursos hídricos. Por fim, constatou-se que Cabo Verde possui as ferramentas para a evolução da Gestão dos Recursos Hídricos, que é o Código de Água. Water is vital for the survival, health and dignity of the human being and a basic source for development. The drinking waters reserves in the world are under constant pressure. The water can be considered a natural resource with economic, strategically and social values. The perception of the scarcity has taken governments, to reorganize the institutional environment and to define new rights of property by means of participation and decentralized system of management that stimulates the use of the resource in rational form. This investigation addressed the Administration of Water Resources in Cabo Verde and the implementation of Law n.º 41/II/84 of 18 of June, which established the National Policy of Water Resources and the National System of Management. The approach of the research is the Governmental Institutions that deal with the water and the Associations that, at a glance, contribute with information that builds the proposal of water resources management in a sustainability perspective. The proposal has as objective to provide subsidies to advance more and more the research regarding sustainability in the administration of waters. The research was qualitative and it used as methodology the Study Case. We identified as difficulties: the ownership of the water is not well clear; the social conflicts are frequent concerning how to use the water. Finally, it was evidenced that Cape Verde has the tools for the evolution of water resources management, which is the Water Code.

The use of the Family Management Style Framework to evaluate the family management of liver transplantation in adolescence

Objective: To understand the family management experience of liver transplantation during adolescence based on the Family Management Style Framework(FMSF). Method: This is a case study that used the FMSF as theoretical framework and the hybrid model of thematic analysis as methodological reference. The case presented is from an adolescent’s family that lives in Salvador, Bahia. The data were collected through interviews with the mother and the patient charts analysis. Results: The results shows that the family defines the transplantation as threatening and there are divergence between mother and daughter related to the teen’s capabilities perception. Facing those discrepancies, the family assumes a protective posture by believing that the teen cannot take care of herself alone. The perceived consequences reflect how much the uncertainty permeates the family environment. Conclusion: It is concluded that the use of a model to evaluate the management can help professionals to direct and plan specific interventions.



Family functioning of elderly with depressive symptoms

Objective: To classify families of elderly with depressive symptoms regarding their functioning and to ascertain the presence of an association between these symptoms, family functioning and the characteristics of the elderly. Method: This was an observational, analytical, cross-sectional study performed with 33 teams of the Family Health Strategy in Dourados, MS. The sample consisted of 374 elderly divided into two groups (with and without depressive symptoms). The instruments for data collection were a sociodemographic instrument, the GeriatricDepression Scale (15 items) and the Family Apgar. Results: An association was observed between depressive symptoms and family dysfunction, female gender, four or more people living together, and physical inactivity. Conclusion: The functional family may represent effective support for the elderly with depressive symptoms, because it offers a comfortable environment that ensures the well-being of its members. The dysfunctional family can barely provide necessary care for the elderly, which can exacerbate depressive symptoms.