DATA WAREHOUSING IN A GLOBAL METAL INDUSTRIAL COMPANY

Työn tavoittena oli selvittää, miten tietovarastointi voi tukea yrityksessä tapahtuvaa päätöksentekoa. Tietovarastokomponenttien ja –prosessien kuvauksen jälkeen on käsitelty tietovarastoprojektin eri vaiheita. Esitettyä teoriaa sovellettiin käytäntöön globaalissa metalliteollisuusyrityksessä, jossa tietovarastointikonseptia testattiin. Testauksen perusteella arvioitiin olemassa olevan tiedon tilaa sekä kahden käytetyn ohjelmiston toimivuutta tietovarastoinnissa. Yrityksen operatiivisten järjestelmien tiedon laadun todettiin olevan tutkituilta osin epäyhtenäistä ja puutteellista. Siksi tiedon suora yrityslaajuinen hyödyntäminen luotettavien ja hyvälaatuisten raporttien luonnissa on vaikeaa. Lisäksi eri yksiköiden välillä havaittiin epäyhtenäisyyttä käytettyjen liiketoiminnan käsitteiden sekä järjestelmien käyttötapojen suhteen. Testauksessa käytetyt ohjelmistot suoriutuivat perustietovarastoinnista hyvin, vaikkakin joitain rajoituksia ja erikoisuuksia ilmenikin. Työtä voidaan pitää ennen varsinaista tietovarastoprojektia tehtävänä esitutkimuksena. Jatkotoimenpiteinä ehdotetaan testauksen jatkamista nykyisillä työkaluilla kohdistaen tavoitteet konkreettisiin tuloksiin. Tiedon laadun tärkeyttä tulee korostaa koko organisaatiossa ja olemassa olevan tiedon laatua pitää parantaa tulevaisuudessa.

Metal dealing at the origin of the Chordata phylum: The metallothionein system and metal overload response in Amphioxus.

Non-vertebrate chordates, specifically amphioxus, are considered of the utmost interest for gaining insight into the evolutionary trends, i.e. differentiation and specialization, of gene/protein systems. In this work, MTs (metallothioneins), the most important metal binding proteins, are characterized for the first time in the cephalochordate subphylum at both gene and protein level, together with the main features defining the amphioxus response to cadmium and copper overload. Two MT genes (BfMT1 and BfMT2) have been identified in a contiguous region of the genome, as well as several ARE (antioxidant response element) and MRE (metal response element) located upstream the transcribed region. Their corresponding cDNAs exhibit identical sequence in the two lancelet species (B. floridae and B. lanceolatum), BfMT2 cDNA resulting from an alternative splicing event. BfMT1 is a polyvalent metal binding peptide that coordinates any of the studied metal ions (Zn, Cd or Cu) rendering complexes stable enough to last in physiological environments, which is fully concordant with the constitutive expression of its gene, and therefore, with a metal homeostasis housekeeping role. On the contrary, BfMT2 exhibits a clear ability to coordinate Cd(II) ions, while it is absolutely unable to fold into stable Cu (I) complexes, even as mixed species. This identifies it as an essential detoxification agent, which is consequently only induced in emergency situations. The cephalochordate MTs are not directly related to vertebrate MTs, neither by gene structure, protein similarity nor metal-binding behavior of the encoded peptides. The closest relative is the echinoderm MT, which confirm proposed phylogenetic relationships between these two groups. The current findings support the existence in most organisms of two types of MTs as for their metal binding preferences, devoted to different biological functions: multivalent MTs for housekeeping roles, and specialized MTs that evolve either as Cd-thioneins or Cu-thioneins, according to the ecophysiological needs of each kind of organisms.

Designing of statically loaded sheet metal structures

The goal of this thesis is to give information to machine designers about how to design and size sheet metal structures and joints. Generally, the designing object is to lighten structures. To design structures that are light and can carry loads more effectively, designers have to be updated of new manufacturing techniques and new designing methods and criterions. With knowledge of this thesis, a designer can recognize objects and methods plus how and where it is possible to apply these new more effectively load carrying structures. The thesis gives answers to questions of corrosion and material planning, goes into joint types and manufacturing techniques of sheet metal structures. One of the main issues is to develop designers world of ideas to design right kind of products with new lasertechniques.

Self-expandable metal stents in the treatment of acute esophageal variceal bleeding.

Acute variceal bleeding (AVB) is a life-threatening complication in patients with cirrhosis. Hemostatic therapy of AVB includes early administration of vasoactive drugs that should be combined with endoscopic therapy, preferably banding ligation. However, failure to control bleeding or early rebleed within 5 days still occurs in 15-20% of patients with AVB. In these cases, a second endoscopic therapy may be attempted (mild bleeding in a hemodynamically stable patient) or we can use a balloon tamponade as a bridge to definitive derivative treatment (i.e., a transjugular intrahepatic portosystemic shunt). Esophageal balloon tamponade provides initial control in up to 80% of AVB, but it carries a high risk of major complications, especially in cases of long duration of tamponade (>24 h) and when tubes are inserted by inexperienced staff. Preliminary reports suggest that self-expandable covered esophageal metallic stents effectively control refractory AVB (i.e., ongoing bleeding despite pharmacological and endoscopic therapy or massive bleeding precluding endoscopic therapy) with a low incidence of complications. Thus, covered self-expanding metal stents may represent an alternative to the Sengstaken-Blakemore balloon for the temporary control of bleeding in treatment failures. Further studies are required to determine the role of this new device in AVB.

Use of alternative and complementary therapies in labor and delivery care: a cross-sectional study of midwives" training in Catalan hospitals accredited as centers for normal birth

Background: The use of complementary and alternative medicine (CAM) and complementary and alternative therapies (CAT) during pregnancy is increasing. Scientific evidence for CAM and CAT in the field of obstetrics mainly covers pain relief in labor. Midwives are responsible for labor and delivery care: hence, their knowledge of CAM and CAT is important. The aims of this study are to describe the professional profile of midwives who provide care for natural childbirth in Catalan hospitals accredited as centers for normal birth, to assess midwives" level of training in CAT and their use of these therapies, and to identify specific resources for CAT in labor wards. Methods: A descriptive, cross-sectional, quantitative method was used to assess the level of training and use of CAT by midwives working at 28 hospitals in Catalonia, Spain, accredited as public normal birth centers. Results: Just under a third of midwives (30.4%) trained in CAT after completion of basic training. They trained in an average of 5.97 therapies (SD 3.56). The number of CAT in which the midwives were trained correlated negatively with age (r = - 0.284; p < 0.001) and with their time working at the hospital in years (r = - 0.136; p = 0.036). Midwives trained in CAT considered that the following therapies were useful or very useful for pain relief during labor and delivery: relaxation techniques (64.3%), hydrotherapy (84.8%) and the application of compresses to the perineum (75.9%). The availability of resources for providing CAT during normal birth care varied widely from center to center. Conclusions: Age may influence attitudes towards training. It is important to increase the number of midwives trained in CAM for pain relief during childbirth, in order to promote the use of CAT and ensure efficiency and safety. CAT resources at accredited hospitals providing normal childbirth care should also be standardized.

Use of alternative and complementary therapies in labor and delivery care: a cross-sectional study of midwives" training in Catalan hospitals accredited as centers for normal birth

Background: The use of complementary and alternative medicine (CAM) and complementary and alternative therapies (CAT) during pregnancy is increasing. Scientific evidence for CAM and CAT in the field of obstetrics mainly covers pain relief in labor. Midwives are responsible for labor and delivery care: hence, their knowledge of CAM and CAT is important. The aims of this study are to describe the professional profile of midwives who provide care for natural childbirth in Catalan hospitals accredited as centers for normal birth, to assess midwives" level of training in CAT and their use of these therapies, and to identify specific resources for CAT in labor wards. Methods: A descriptive, cross-sectional, quantitative method was used to assess the level of training and use of CAT by midwives working at 28 hospitals in Catalonia, Spain, accredited as public normal birth centers. Results: Just under a third of midwives (30.4%) trained in CAT after completion of basic training. They trained in an average of 5.97 therapies (SD 3.56). The number of CAT in which the midwives were trained correlated negatively with age (r = - 0.284; p < 0.001) and with their time working at the hospital in years (r = - 0.136; p = 0.036). Midwives trained in CAT considered that the following therapies were useful or very useful for pain relief during labor and delivery: relaxation techniques (64.3%), hydrotherapy (84.8%) and the application of compresses to the perineum (75.9%). The availability of resources for providing CAT during normal birth care varied widely from center to center. Conclusions: Age may influence attitudes towards training. It is important to increase the number of midwives trained in CAM for pain relief during childbirth, in order to promote the use of CAT and ensure efficiency and safety. CAT resources at accredited hospitals providing normal childbirth care should also be standardized.

Fusion weld metal solidification:Continuum from weld interface to centerline

We present a brief résumé of the history of solidification research and key factors affecting the solidification of fusion welds. There is a general agreement of the basic solidification theory, albeit differing - even confusing - nomenclatures do exist, and Cases 2 and 3 (the Chalmers' basic boundary conditions for solidification, categorized by Savage as Cases) are variably emphasized. Model Frame, a tool helping to model the continuum of fusion weld solidification from start to end, is proposed. It incorporates the general solidification models, of which the pertinent ones are selected for the actual modeling. The basic models are the main solidification Cases 1…4. These discrete Cases are joined with Sub-Cases: models of Pfann, Flemings and others, bringing needed Sub-Case variables into the model. Model Frame depicts a grain growing from the weld interface to its centerline. Besides modeling, the Model Frame supports education and academic debate. The new mathematical modeling techniques will extend its use into multi-dimensional modeling, introducing new variables and increasing the modeling accuracy. We propose a model: melting/solidification-model (M/S-model) - predicting the solute profile at the start of the solidification of a fusion weld. This Case 3-based Sub-Case takes into account the melting stage, the solute back-diffusion in the solid, and the growth rate acceleration typical to fusion welds. We propose - based on works of Rutter & Chalmers, David & Vitek and our experimental results on copper - that NEGS-EGS-transition is not associated only with cellular-dendritic-transition. Solidification is studied experimentally on pure and doped copper with welding speed range from 0 to 200 cm/min, with one test at 3000 cm/min. Found were only planar and cellular structures, no dendrites - columnar or equiaxed. Cell sub structures: rows of cubic elements we call "cubelettes", "cell-bands" and "micro-cells", as well as an anomalous crack morphology "crack-eye", were detected, as well as microscopic hot crack nucleus we call "grain-lag cracks", caused by a grain slightly lagging behind its neighbors in arrival to the weld centerline. Varestraint test and R-test revealed a change of crack morphologies from centerline cracks to grainand cell boundary cracks with an increasing welding speed. High speed made the cracks invisible to bare eye and hardly detectable with light microscope, while electron microscope often revealed networks of fine micro-cracks.

False normal Lung Clearance Index in infants with cystic fibrosis due to software algorithms.

BACKGROUND: Lung clearance index (LCI), a marker of ventilation inhomogeneity, is elevated early in children with cystic fibrosis (CF). However, in infants with CF, LCI values are found to be normal, although structural lung abnormalities are often detectable. We hypothesized that this discrepancy is due to inadequate algorithms of the available software package. AIM: Our aim was to challenge the validity of these software algorithms. METHODS: We compared multiple breath washout (MBW) results of current software algorithms (automatic modus) to refined algorithms (manual modus) in 17 asymptomatic infants with CF, and 24 matched healthy term-born infants. The main difference between these two analysis methods lies in the calculation of the molar mass differences that the system uses to define the completion of the measurement. RESULTS: In infants with CF the refined manual modus revealed clearly elevated LCI above 9 in 8 out of 35 measurements (23%), all showing LCI values below 8.3 using the automatic modus (paired t-test comparing the means, P < 0.001). Healthy infants showed normal LCI values using both analysis methods (n = 47, paired t-test, P = 0.79). The most relevant reason for false normal LCI values in infants with CF using the automatic modus was the incorrect recognition of the end-of-test too early during the washout. CONCLUSION: We recommend the use of the manual modus for the analysis of MBW outcomes in infants in order to obtain more accurate results. This will allow appropriate use of infant lung function results for clinical and scientific purposes. Pediatr Pulmonol. 2015; 50:970-977. © 2015 Wiley Periodicals, Inc.

Structural and optical properties of high quality zinc-blende/wurtzite GaAs nanowire heterostructures

The structural and optical properties of three different kinds of GaAs nanowires with 100% zinc-blende structure and with an average of 30% and 70% wurtzite are presented. A variety of shorter and longer segments of zinc-blende or wurtzite crystal phases are observed by transmission electron microscopy in the nanowires. Sharp photoluminescence lines are observed with emission energies tuned from 1.515 eV down to 1.43 eV when the percentage of wurtzite is increased. The downward shift of the emission peaks can be understood by carrier confinement at the interfaces, in quantum wells and in random short period superlattices existent in these nanowires, assuming a staggered band offset between wurtzite and zinc-blende GaAs. The latter is confirmed also by time-resolved measurements. The extremely local nature of these optical transitions is evidenced also by cathodoluminescence measurements. Raman spectroscopy on single wires shows different strain conditions, depending on the wurtzite content which affects also the band alignments. Finally, the occurrence of the two crystallographic phases is discussed in thermodynamic terms.

Coleção líquida adjacente ao ligamento falciforme em pacientes no pós-operatório imediato de transplante de fígado: achado ultra sonográfico normal ou anormal? Estudo prospectivo

Os transplantes de fígado estão sendo cada vez mais realizados, havendo necessidade, cada vez maior, de uma avaliação acurada das possíveis complicações. A ultra-sonografia é entendida, nesse contexto, como o método de escolha para a avaliação inicial das complicações envolvendo o transplante. Os autores relatam, neste estudo, o achado de coleção líquida adjacente ao ligamento falciforme, no pós-operatório imediato de pacientes transplantados de fígado e que não apresentavam nenhum sinal de complicação infecciosa intra-abdominal. Foi demonstrada a presença de coleção líquida em torno do ligamento falciforme em 33 (94,3%) de 35 pacientes avaliados. Dessa forma, os autores sugerem que este achado pode corresponder a aspecto normal encontrado no pós-operatório imediato de transplante de fígado.