Oliotietokannan muuttaminen relaatiotietokannaksi

Diplomityön tavoitteena oli parantaa oliotietokantaan perustuvan mökkivarausjärjestelmän pitkiä vasteaikoja ja epävakaata toimintaa sekä luoda tietokantaperusta uusille toiminnoille. Ratkaisua etsittiin korvaamalla oliotietokanta relaatiotietokannalla. Diplomityö on osa koko varausjärjestelmän uusintaa. Työn teoreettinen osuus käsittelee sekä olio- että relaatiotietokannan rakennetta ja oliomallin muuttamista relaatiomalliksi. Käytännön osassa esitellään relaatiotietokannan luominen vaiheittain ja kerrotaan tietojen siirron periaatteesta. Relaatiotietokannan havaittiin olevan vakaampi ja tehokkaampi vasteajoiltaan. Samoin sen vaatima levytilan ja muistin määrä oli pienempi kuin oliotietokannalla. Lisäksi siihen todettiin uusien järjestelmien liittämisen olevan yksinkertaisempaa.

Aihiovalmistustoiminnan kehittäminen ohutlevytuotetehtaassa

Työ käsittelee aihiovalmistustoiminnan kehittämistä ohutlevytuotetehtaassa. Tutkimuksen tavoitteena oli kehittää aihiovalmistustiimin toiminnan edellytyksiä uudistuvan laitekannan tuomien mahdollisuuksien avulla muuttuvassa johtamiskulttuurissa. Kirjallisuusosassa tarkastellaan konepajatoiminnan tunnuslukuja ja ohutlevytekniikoiden teoriaa. Konepajatekniikan ohella käsitellään mm. johtamismenetelmien kehitystä yleisesti sekä erityisesti prosessijohtamista. Kokeellisessa osassa tarkastellaan eri raaka-ainevaihtoehtojen soveltuvuutta ohutlevytuotteille ja –rakenteille sekä materiaalikäytön kehittämisen kustannusvaikutuksia. Laiteinvestoinnin vaikutuksia tarkastellaan käytössä olevan konekapasiteetin hyödyntämisen kannalta. Aihiovalmistustoiminnan kehittämistä tarkastellaan kahden vuoden aikajänteellä, jona aikana kohdeyrityksessä ollaan implementoimassa prosessijohtamiseen perustuvaa prosessiorganisaatiomallia. Tutkimustuloksia tullaan hyödyntämään kohdeyrityksen operatiivisessa työskentelyssä.

Hankinnan kehittäminen puunjalostusteollisuuden yrityksessä

Tämän työn tavoitteena on kehittää kohdeyrityksen hankintaa ja erityisesti poikkiorganisatorisesti toimivan hankintaelimen toimintaa. Hankinnan kehittäminen paketoidaan tässä työssä kehittämisohjelmaksi, joka muodostuu havaittujen heikkouksien ja merkittävimpien puutteiden pohjalta. Tässä työssä empiriaosa pohjautuu teoriaan, joka koostuu pääasiassa hankinnan organisoinnin ja hankintaprosessin käsittelystä. Hankinnan organisoinnin avulla luodaan pohjaa tämän työn lähtökohdalle eli edellä mainitun hankintaelimen perustamiselle ja hankintaprosessin käsittelyn avulla luodaan pohjaa kehittämisohjelmalle. Empiriaosan taustalla vaikuttaa vahvasti myös kohdeyrityksessä tehdyt haastattelut sekä osallistuvan havainnoinnin kautta saadut tiedot. Hankinnasta saatavien hyötyjen mittaaminen on hyvin hankalaa, myös tästä työstä saatavia hyötyjä voidaan tuloksellisesti todeta vasta kun kehittämisohjelmaa on hyödynnetty tietty ajanjakso. Saatavia hyötyjä ei kuitenkaan voida tällöinkään mitata, mikäli hankinnalla ei ole käytettävissä sille suunniteltuja mittareita.

Key factors in U.S. Government support of business internationalization in Finland Case: U.S. Embassy in Helsinki

This study discusses the importance of government intervention for companies and the expansion of national innovation systems. The purpose of the study is to examine the impact which the U.S. Embassy in Helsinki can have on Finnish businesses through their business support programs and events. The embassy has shifted focus in recent years with the creation of an innovation center and increased business services. The study has sub-objectives to discover the critical factors for producing impact, host and home based factor interaction, and effects produced by these initiatives. The theoretical background of the study consists of literature relating to the concepts of national innovation systems and government intervention. The empirical research conduct for this study is based on interviews with experts from the environment surrounding the U.S. Embassy in Helsinki, Finland and participation in embassy events. The data was collected between March 2014 and September 2015. Seven interviews were conducted; five with representatives of the U.S. Embassy and two with related organizations. Thematic analysis was used to categorize and interpret interview and observation data. The use of an impact radar was implemented as a basis for analysis. This study finds that the internationalization of national innovation systems provides interesting opportunities and challenges for national governments. The opportunity to provide services to foreign companies by an embassy in a stable environment opens the possibility to create positive notice and relations with the host country. The increased connections and inputs to the national innovation system of the home country have the potential to increase knowledge absorption and create positive growth. The most effective way for governments to encourage businesses is to create incentives and reduce barriers. The services are best aimed at small to medium sized companies in the early stages of development. The findings of this report suggest that the most critical factors for producing impact on companies are the ability to disseminate information effectively, the ability to create a positive image of the country, the ability to foster effective networks between the two countries, and the ability to facilitate the internationalization of companies. In the best cases, the embassy is able to create incentives to internationalize to the United States and reduce barriers which are encountered by companies. Future research is necessary to fully understand the impact of business services provided by an embassy can have on the political and economic relations of countries, and on particular industry sectors. The institutional setting provided by the embassy’s focus on business relations provides a rich environment for further study in a number of areas.

Modeling and Simulation ofReal-Time System as a Tool to Improve Capacity Management - Case Fenix

Tämän tutkimustyön kohteena on TietoEnator Oy:n kehittämän Fenix-tietojärjestelmän kapasiteettitarpeen ennustaminen. Työn tavoitteena on tutustua Fenix-järjestelmän eri osa-alueisiin, löytää tapa eritellä ja mallintaa eri osa-alueiden vaikutus järjestelmän kuormitukseen ja selvittää alustavasti mitkä parametrit vaikuttavat kyseisten osa-alueiden luomaan kuormitukseen. Osa tätä työtä on tutkia eri vaihtoehtoja simuloinnille ja selvittää eri vaihtoehtojen soveltuvuus monimutkaisten järjestelmien mallintamiseen. Kerätyn tiedon pohjaltaluodaan järjestelmäntietovaraston kuormitusta kuvaava simulaatiomalli. Hyödyntämällä mallista saatua tietoa ja tuotantojärjestelmästä mitattua tietoa mallia kehitetään vastaamaan yhä lähemmin todellisen järjestelmän toimintaa. Mallista tarkastellaan esimerkiksi simuloitua järjestelmäkuormaa ja jonojen käyttäytymistä. Tuotantojärjestelmästä mitataan eri kuormalähteiden käytösmuutoksia esimerkiksi käyttäjämäärän ja kellonajan suhteessa. Tämän työn tulosten on tarkoitus toimia pohjana myöhemmin tehtävälle jatkotutkimukselle, jossa osa-alueiden parametrisointia tarkennetaan lisää, mallin kykyä kuvata todellista järjestelmää tehostetaanja mallin laajuutta kasvatetaan.

Combination of catalyst development and chemical reaction engineering : a key aspect to improve the hydrogen peroxide direct synthesis

-

Dental Health in Preschool and Schoolchildren in Relation to Dental Fear and Some Fear-Related Factors, and the Outcome of a Caries Prevention Program in Offspring of Fearful Mothers

Dental caries and dental fear and anxiety (DFA) are common interrelated problems but so far little is known about these problems in Estonia. The aim was to study dental health in relation to DFA, some fear-related factors, and to study the effect of a caries prevention program in children of fearful mothers. Dental health and DFA were assessed in two Estonian [2-4-year-olds (n=472) and 8-10-year-olds (n=344)], and the effect of some medical conditions on DFA in one Finnish child group [3-year-olds (n=148)]. 120 mother-child-pairs participated in the xylitol-based prevention program. Dental health was examined using the WHO or the ICDAS criteria and expressed as dmft/DMFT-indices. The modified children’s fear survey schedule dental subscale (MCFSS-DS) was used to assess DFA of schoolchildren, one single question to assess parental DFA, and the Corah’s dental anxiety scale (DAS) to assess DFA of mothers in the prevention study. Dentine caries was diagnosed in 42% of the 2-4-year-old and in 93% of the 8-10-year-old Estonian children. DFA of 8-10-year-olds (17%) was associated with experience of dental treatment, and maternal and paternal DFA. Dental apprehension at 9 years of age was associated with frequent exposure to invasive medical care. The xylitol-based prevention was successful irrespective of poor dental hygiene habits and maternal severe DFA. In conclusion, experience of operative dental treatment and DFA of Estonian children were closely associated. Invasive medical care and parental DFA were also linked to children’s DFA. Habitual use of xylitol by mothers was effective in preventing caries even in children of severely fearful mothers.

PDM system functions and utilizations analysis to improve efficiency of sheet metal product design and manufacturing

This study will concentrate on Product Data Management (PDM) systems, and sheet metal design features and classification. In this thesis, PDM is seen as an individual system which handles all product-related data and information. The meaning of relevant data is to take the manufacturing process further with fewer errors. The features of sheet metals are giving more information and value to the designed models. The possibility of implementing PDM and sheet metal features recognition are the core of this study. Their integration should make the design process faster and manufacturing-friendly products easier to design. The triangulation method is the basis for this research. The sections of this triangle are: scientific literature review, interview using the Delphi method and the author’s experience and observations. The main key findings of this study are: (1) the area of focus in triangle (the triangle of three different point of views: business, information exchange and technical) depends on the person’s background and their role in the company, (2) the classification in the PDM system (and also in the CAD system) should be done using the materials, tools and machines that are in use in the company and (3) the design process has to be more effective because of the increase of industrial production, sheet metal blank production and the designer’s time spent on actual design and (4) because Design For Manufacture (DFM) integration can be done with CAD-programs, DFM integration with the PDM system should also be possible.

Design and evaluation of web interface signs to improve web usability : a semiotic framework

Technological innovations, the development of the internet, and globalization have increased the number and complexity of web applications. As a result, keeping web user interfaces understandable and usable (in terms of ease-of-use, effectiveness, and satisfaction) is a challenge. As part of this, designing userintuitive interface signs (i.e., the small elements of web user interface, e.g., navigational link, command buttons, icons, small images, thumbnails, etc.) is an issue for designers. Interface signs are key elements of web user interfaces because ‘interface signs’ act as a communication artefact to convey web content and system functionality, and because users interact with systems by means of interface signs. In the light of the above, applying semiotic (i.e., the study of signs) concepts on web interface signs will contribute to discover new and important perspectives on web user interface design and evaluation. The thesis mainly focuses on web interface signs and uses the theory of semiotic as a background theory. The underlying aim of this thesis is to provide valuable insights to design and evaluate web user interfaces from a semiotic perspective in order to improve overall web usability. The fundamental research question is formulated as What do practitioners and researchers need to be aware of from a semiotic perspective when designing or evaluating web user interfaces to improve web usability? From a methodological perspective, the thesis follows a design science research (DSR) approach. A systematic literature review and six empirical studies are carried out in this thesis. The empirical studies are carried out with a total of 74 participants in Finland. The steps of a design science research process are followed while the studies were designed and conducted; that includes (a) problem identification and motivation, (b) definition of objectives of a solution, (c) design and development, (d) demonstration, (e) evaluation, and (f) communication. The data is collected using observations in a usability testing lab, by analytical (expert) inspection, with questionnaires, and in structured and semi-structured interviews. User behaviour analysis, qualitative analysis and statistics are used to analyze the study data. The results are summarized as follows and have lead to the following contributions. Firstly, the results present the current status of semiotic research in UI design and evaluation and highlight the importance of considering semiotic concepts in UI design and evaluation. Secondly, the thesis explores interface sign ontologies (i.e., sets of concepts and skills that a user should know to interpret the meaning of interface signs) by providing a set of ontologies used to interpret the meaning of interface signs, and by providing a set of features related to ontology mapping in interpreting the meaning of interface signs. Thirdly, the thesis explores the value of integrating semiotic concepts in usability testing. Fourthly, the thesis proposes a semiotic framework (Semiotic Interface sign Design and Evaluation – SIDE) for interface sign design and evaluation in order to make them intuitive for end users and to improve web usability. The SIDE framework includes a set of determinants and attributes of user-intuitive interface signs, and a set of semiotic heuristics to design and evaluate interface signs. Finally, the thesis assesses (a) the quality of the SIDE framework in terms of performance metrics (e.g., thoroughness, validity, effectiveness, reliability, etc.) and (b) the contributions of the SIDE framework from the evaluators’ perspective.

Customer Experience Management – How to Improve the Customer Experience Management and its Measurement

The main goal of this master’s thesis was to find out, how to improve customer experience management and measurement. This study is a qualitative case study, in which the data collection method has been interviews. In addition, some of the company’s customer experience measurement methods have been analyzed. The theoretical background is applied in practice by interviewing 5 representatives from the case company. In the case company, the management has launched a customer experience focused program, and given guidelines for customer experience improvement. In the case company, customer experience is measured with different methods, one example is asking the recommendation readiness from a customer. In order to improve the customer experience management, the case company should define, what the company means with customer experience and what kind of customer experience the company is aiming to create. After the encounter, the customer should be left with feelings of satisfaction, positivity and trust. The company should focus on easiness in its processes, on top of which the processes should work fluently. The customer experience management should be improved through systematic planning, and by combining and standardizing different measures. In addition, some channel-based measures should be used. The measurement conducted should be more customer focused, and the case company should form an understanding, which touch points are the most relevant to measure.

Motives, Challenges and Success Factors in the Business Partner Network

Tässä työssä käsitellään niitä motiiveja, haasteita ja menestystekijöitä, jotka vaikuttavat lisäarvoatuottavassa liiketoimintaverkostossa. Työssä on selvitetty sitä, miten partneriverkostot syntyvät sekä mitkä seikat vaikuttavat siihen jatkuuko yhteistyö vai ei. Motiiveja partneruuteen on tutkittu kirjallisuudesta sekä analysoimalla työssä esitettyä tapausta. Tässä työssä käydään keskustelua myös partneruuden elinkaaresta, jota ei ole käsitellyssä kirjallisuudessa tuotu esille. Työssä esitettyä tapausta arvioitiin lähettämällä siihen liittyneille henkilöille kysely. Kyselyiden lähettämisen jälkeen järjestettiin haastattelu kyselyyn vastanneiden kanssa. Lopputulokset perustuvat pitkälti haastateltujen henkilöiden kanssa käytyihin keskusteluihin. Kävi ilmi, että arvoa tuottavan partneriverkoston yksi tärkeimpiä tavoitteita on saavuttaa jatkuvuutta liiketoiminnallaan. Ainoastaan pitkäaikaisella partneruudella voidaan saavuttaa merkittäviä etuja markkinoilla. Siksi on tärkeätä, jo partnerin valinnassa, kiinnittää huomiota partneruuden jatkuvuuteen pitkällä tähtäimellä. Liiketoimintaverkostossa partneruudesta syntyvät tuotot ja niiden jakaminen on tärkein yksittäinen osaalue. Oleellista partneruuden jatkuvuudelle pitkällä tähtäimellä on jo partneria valittaessa se, että kyetään arvioimaan miten partneruudesta syntyvät tuotot jaetaan tasapuolisesti ja onko partneruudesta syntyvälle liiketoiminnalle jatkuvuutta. Jotta partneriverkostolle asetetut tavoitteet voitaisiin saavuttaa, on tärkeää suunnitella partneriverkoston hallintaa myös operatiivisella tasolla. Lisäksi tärkeää on jakaa verkostolle asetetut yhteiset tavoitteet organisaatioiden sisällä. Jos ylemmänja operatiivisen tason johdon yhteistyö on riittämätöntä, se vaikeuttaa oleellisesti asetettujen tavoitteiden saavuttamista. Tiedon jakaminen aikaisessa vaiheessa sitouttaa eri sidosryhmät paremmin yhteisiin tavoitteisiin.

Nursing student-patient relationship and associated factors

The purpose of this study was to analyse the nursing student-patient relationship and factors associated with this relationship from the point of view of both students and patients, and to identify factors that predict the type of relationship. The ultimate goal is to improve supervised clinical practicum with a view to supporting students in their reciprocal collaborative relationships with patients, increase their preparedness to meet patients’ health needs, and thus to enhance the quality of patient care. The study was divided into two phases. In the first phase (1999-2005), a literature review concerning the student-patient relationship was conducted (n=104 articles) and semi-structured interviews carried out with nursing students (n=30) and internal medicine patients (n=30). Data analysis was by means of qualitative content analysis and Student-Patient Relationship Scales, which were specially developed for this research. In the second phase (2005-2007), the data were collected by SPR scales among nursing students (n=290) and internal medicine patients (n=242). The data were analysed statistically by SPSS 12.0 software. The results revealed three types of student-patient relationship: a mechanistic relationship focusing on the student’s learning needs; an authoritative relationship focusing on what the student assumes is in the patient’s best interest; and a facilitative relationship focusing on the common good of both student and patient. Students viewed their relationship with patients more often as facilitative and authoritative than mechanistic, while in patients’ assessments the authoritative relationship occurred most frequently and the facilitative relationship least frequently. Furthermore, students’ and patients’ views on their relationships differed significantly. A number of background factors, contextual factors and consequences of the relationship were found to be associated with the type of relationship. In the student data, factors that predicted the type of relationship were age, current year of study and support received in the relationship with patient. The higher the student’s age, the more likely the relationship with the patient was facilitative. Fourth year studies and the support of a person other than a supervisor were significantly associated with an authoritative relationship. Among patients, several factors were found to predict the type of nursing student-patient relationships. Significant factors associated with a facilitative relationship were university-level education, several previous hospitalizations, admission to hospital for a medical problem, experience of caring for an ill family member and patient’s positive perception of atmosphere during collaboration and of student’s personal and professional growth. In patients, positive perceptions of student’s personal and professional attributes and patient’s improved health and a greater commitment to self-care, on the other hand, were significantly associated with an authoritative relationship, whereas positive perceptions of one’s own attributes as a patient were significantly associated with a mechanistic relationship. It is recommended that further research on the student-patient relationship and related factors should focus on questions of content, methodology and education.

Transparent Network Interfaces to Mobile Peer-to-Peer Environment

The fact that most of new Personal Data Assistant (PDA) devices and smartphones have the ability to communicate via different wireless technologies has made several new applications possible. While traditional network model is based on the idea of static hosts, mobile devices can create decentralized, self-organizing ad-hoc networks and act as peers in the network. This kind of adapting network is suitable for mobile devices which can freely join and leave the networks. Because several different wireless communication technologies are involved, flexible changing of the networking technology must be handled in order to enable seamless communication between these networks. This thesis presents a transparent network interface to mobile Peer-to-Peer environment which is named as Virtual PeerHood. Different wireless technologies and aspects of providing a seamless connectivity between these technologies are explored. The result is a middleware platform for mobile Peer-to-Peer environment, capable of handling several networking technologies.

Odor emission control and reduce in betaine manufacture

This thesis was made in Naantali plant of Finnfeeds Finland Oy. In this thesis the main study was in reducing, controlling, measuring and processing odour effluents in various methods. Also are considered legislation, marketing issues and environmental requirements of reducing of odour effluents. The literature review introduces odours complications, legislations and various methods of odour removal. There is also a review of volatile organic compounds detection and measuring methods. The experimental section consists TD-GC-MS-measurements and expansive measurements with electronic nose. Electronic nose is a new solution for recognition and measuring industrial odours. In this thesis the electronic nose was adapted into reliable recognition and measuring method. Measurements with electronic nose was made in betaine factory and main targets were odour removal process and other odours from factory. As a result of experimental work with TD-GC-MS-measurements becomes odour compound of 2-and 3- methylbutanal and dimethyldisulfide, which odour is sweet and fug. Extensive study with electronic nose found many developmental subjects. Odour balance measurements of factory and after calculation made adjustment of odour removal process, over all odour effluent to environment will reduce 25 %.

Thermoplastic bioactive composite – with special reference to dissolution behaviour and tissue response

Bioactive glasses are surface-active ceramic materials which support and accelerate bone growth in the body. During the healing of a bone fracture or a large bone defect, fixation is often needed. The aim of this thesis was to determine the dissolution behaviour and biocompatibility of a composite consisting of poly(ε-caprolactone-co-DL-lactide) and bioactive glass (S53P4). In addition the applicability as an injectable material straight to a bone defect was assessed. In in vitro tests the dissolution behaviour of plain copolymer and composites containing bioactive glass granules was evaluated, as well as surface reactivity and the material’s capability to form apatite in simulated body fluid (SBF). The human fibroblast proliferation was tested on materials in cell culture. In in vivo experiments, toxicological tests, material degradation and tissue reactions were tested both in subcutaneous space and in experimental bone defects. The composites containing bioactive glass formed a unified layer of apatite on their surface in SBF. The size and amount of glass granules affected the degradation of polymer matrix, as well the material’s surface reactivity. In cell culture on the test materials the human gingival fibroblasts proliferated and matured faster compared with control materials. In in vitro tests a connective tissue capsule was formed around the specimens, and became thinner in the course of time. Foreign body cell reactions in toxicological tests were mild. In experimental bone defects the specimens with a high concentration of small bioactive glass granules (<45 μm) formed a dense apatite surface layer that restricted the bone ingrowth to material. The range of large glass granules (90-315 μm) with high concentrations formed the best bonding with bone, but slow degradation on the copolymer restricted the bone growth only in the superficial layers. In these studies, the handling properties of the material proved to be good and tissue reactions were mild. The reactivity of bioactive glass was retained inside the copolymer matrix, thus enabling bone conductivity with composites. However, the copolymer was noticed to degradate too slowly compared with the bone healing. Therefore, the porosity of the material should be increased in order to improve tissue healing.