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.

Platinum (II) and palladium (II) complexes with (N,N') and (C,N,N') ligands derived from pyrazole as anticancer and antimalarial agents: synthesis, characterization and in vitro activities

The study of the reactivity of three 1-(2-dimethylaminoethyl)-1H-pyrazole derivatives of general formula [1-(CH2)2NMe2}-3,5-R2-pzol] {where pzol represents pyrazole and Rdouble bond; length as m-dashH (1a), Me (1b) or Ph (1c)} with [MCl2(DMSO)2] (Mdouble bond; length as m-dashPt or Pd) under different experimental conditions allowed us to isolate and characterize cis-[M{κ2-N,N′-{[1-(CH2)2NMe2}-3,5-R2-pzol])}Cl2] {MMdouble bond; length as m-dashPtPt (2a-2c) or Pd (3a-3c)} and two cyclometallated complexes [M{κ3-C,N,N′-{[1-(CH2)2NMe2}-3-(C5H4)-5-Ph-pzol])}Cl] {Mdouble bond; length as m-dashPt(II) (4c) or Pd(II) (5c)}. Compounds 4c and 5c arise from the orthometallation of the 3-phenyl ring of ligand 1c. Complex 2a has been further characterized by X-ray crystallography. Ligands and complexes were evaluated for their in vitro antimalarial against Plasmodium falciparum and cytotoxic activities against lung (A549) and breast (MDA MB231 and MCF7) cancer cellular lines. Complexes 2a-2c and 5c exhibited only moderate antimalarial activities against two P. falciparum strains (3D7 and W2). Interestingly, cytotoxicity assays revealed that the platinacycle 4c exhibits a higher toxicity than cisplatin in the three human cell lines and that the complex 2a presents a remarkable cytotoxicity and selectivity in lung (IC50 = 3 μM) versus breast cancer cell lines (IC50 > 20 μM). Thus, complexes 2c and 4c appear to be promising leads, creating a novel family of anticancer agents. Electrophoretic DNA migration studies in presence of the synthesized compounds have been performed, in order to get further insights into their mechanism of action.

Liquid-crystalline ordering of antimicrobial peptide-DNA complexes controls TLR9 activation.

Double-stranded DNA (dsDNA) can trigger the production of type I interferon (IFN) in plasmacytoid dendritic cells (pDCs) by binding to endosomal Toll-like receptor-9 (TLR9; refs , , , , ). It is also known that the formation of DNA-antimicrobial peptide complexes can lead to autoimmune diseases via amplification of pDC activation. Here, by combining X-ray scattering, computer simulations, microscopy and measurements of pDC IFN production, we demonstrate that a broad range of antimicrobial peptides and other cationic molecules cause similar effects, and elucidate the criteria for amplification. TLR9 activation depends on both the inter-DNA spacing and the multiplicity of parallel DNA ligands in the self-assembled liquid-crystalline complex. Complexes with a grill-like arrangement of DNA at the optimum spacing can interlock with multiple TLR9 like a zipper, leading to multivalent electrostatic interactions that drastically amplify binding and thereby the immune response. Our results suggest that TLR9 activation and thus TLR9-mediated immune responses can be modulated deterministically.

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.

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.

Drug-eluting stents compared to bare-metal stents improve short-term survival in patients with acute myocardial infarction undergoing primary percutaneous coronary intervention: a nationwide prospective analysis of the AMIS Plus registry.

BACKGROUND: Recently, it has been suggested that the type of stent used in primary percutaneous coronary interventions (pPCI) might impact upon the outcomes of patients with acute myocardial infarction (AMI). Indeed, drug-eluting stents (DES) reduce neointimal hyperplasia compared to bare-metal stents (BMS). Moreover, the later generation DES, due to its biocompatible polymer coatings and stent design, allows for greater deliverability, improved endothelial healing and therefore less restenosis and thrombus generation. However, data on the safety and performance of DES in large cohorts of AMI is still limited. AIM: To compare the early outcome of DES vs. BMS in AMI patients. METHODS: This was a prospective, multicentre analysis containing patients from 64 hospitals in Switzerland with AMI undergoing pPCI between 2005 and 2013. The primary endpoint was in-hospital all-cause death, whereas the secondary endpoint included a composite measure of major adverse cardiac and cerebrovascular events (MACCE) of death, reinfarction, and cerebrovascular event. RESULTS: Of 20,464 patients with a primary diagnosis of AMI and enrolled to the AMIS Plus registry, 15,026 were referred for pPCI and 13,442 received stent implantation. 10,094 patients were implanted with DES and 2,260 with BMS. The overall in-hospital mortality was significantly lower in patients with DES compared to those with BMS implantation (2.6% vs. 7.1%,p < 0.001). The overall in-hospital MACCE after DES was similarly lower compared to BMS (3.5% vs. 7.6%, p < 0.001). After adjusting for all confounding covariables, DES remained an independent predictor for lower in-hospital mortality (OR 0.51,95% CI 0.40-0.67, p < 0.001). Since groups differed as regards to baseline characteristics and pharmacological treatment, we performed a propensity score matching (PSM) to limit potential biases. Even after the PSM, DES implantation remained independently associated with a reduced risk of in-hospital mortality (adjusted OR 0.54, 95% CI 0.39-0.76, p < 0.001). CONCLUSIONS: In unselected patients from a nationwide, real-world cohort, we found DES, compared to BMS, was associated with lower in-hospital mortality and MACCE. The identification of optimal treatment strategies of patients with AMI needs further randomised evaluation; however, our findings suggest a potential benefit with DES.

The initial oxidation of transition metal surfaces

Due to their numerous novel technological applications ranging from the example of exhaust catalysts in the automotive industry to the catalytic production of hydro- gen, surface reactions on transition metal substrates have become to be one of the most essential subjects within the surface science community. Although numerous applications exist, there are many details in the different processes that, after many decades of research, remain unknown. There are perhaps as many applications for the corrosion resistant materials such as stainless steels. A thorough knowledge of the details of the simplest reactions occuring on the surfaces, such as oxidation, play a key role in the design of better catalysts, or corrosion resistant materials in the future. This thesis examines the oxidation of metal surfaces from a computational point of view mostly concentrating on copper as a model material. Oxidation is studied from the initial oxidation to the oxygen precovered surface. Important parameters for the initial sticking and dissociation are obtained. The saturation layer is thoroughly studied and the calculated results arecompared with available experimental results. On the saturated surface, some open questions still remain. The present calculations demonstrate, that the saturated part of the surface is excluded from being chemically reactive towards the oxygen molecules. The results suggest, that the reason for the chemical activity of the saturated surface is due to a strain effect occuring between the saturated areas of the surface.

Systematic review with meta-analysis: self-expanding metal stents in patients with cirrhosis and severe or refractory oesophageal variceal bleeding.

BACKGROUND: The prognosis of patients with cirrhosis and acute variceal bleeding is very poor when the standard-of-care fails to control bleeding. New treatment modalities are needed in these patients. AIM: To synthesise the available evidence on the efficacy of self-expanding metal stents (SEMS) in patients with cirrhosis and severe or refractory oesophageal variceal bleeding. METHODS: Meta-analysis of trials evaluating SEMS in patients with cirrhosis and severe or refractory oesophageal variceal bleeding. RESULTS: Thirteen studies were included. The pooled estimate rates were 0.40 (95% confidence interval, CI = 0.31-0.49) for death, 0.41 (95% CI = 0.29-0.53) for liver-related death and 0.36 (95% CI = 0.26-0.47) for death at day 30, with low heterogeneity between studies. The pooled estimate rates were 0.12 (95% CI = 0.07-0.21) for mortality related to variceal bleeding, and 0.18 (95% CI = 0.11-0.29) for failure to control bleeding with SEMS, with no or low heterogeneity between studies. The pooled estimate rate were 0.16 (95% CI = 0.04-0.48) for rebleeding after stent removal and 0.28 (95% CI = 0.17-0.43) for stent migration, with high heterogeneity. A significant proportion of patients had access to liver transplantation or to TIPSS [pooled estimate rate 0.10 (95% CI = 0.04-0.21) and 0.26 (95% CI = 0.18-0.36), respectively]. CONCLUSIONS: Fewer than 40% of patients treated with SEMS were dead at 1 month. SEMS can be used as a bridge to TIPSS or to liver transplantation in a significant proportion of patients. Additional studies are required to identify potential risk factors leading to a poor prognosis in patients with acute variceal bleeding in whom the use of SEMS could be considered.