Raportointitietokannan suorituskyvyn parantaminen

Tietokoneiden tallennuskapasiteetin ja sekä tietokoneiden että verkkojen nopeuden kasvaessa myös käyttäjien odotukset kasvavat. Tietoa talletetaan yhä enemmän ja näistä tiedoista laaditaan yhä monimutkaisempia raportteja. Raporttien monimutkaisuuden kasvaessa niiden tarvitseman tiedon keräämiseen kuluva aika ei kuitenkaan saisi oleellisesti kasvaa. Tämän työn tarkoituksena on tutkia ja parantaa kansainvälisen metsäteollisuusyrityksen myynnin ja logistiikan järjestelmän raportointitietokannan tehokkuutta etenkin raporttien tietojen keräämiseen kuluvalla ajalla mitattuna. Työssä keskitytään kartoittamaan nykyisen järjestelmän pullonkauloja ja pyritään parantamaan järjestelmän suorituskykyä. Tulevaisuudessa suorituskykyä tarvitaan kuitenkin lisää, joten työssä tarkastellaan myös nykyisen, yleiskäyttöisen tietokannan, korvaamista erityisesti raportointia varten suunnitellulla tietokannalla. Työn tuloksena järjestelmän raporttien tietojen keräämiseen kuluvaa aikaa pystyttiin pienentämään ja pahimmat pullonkaulat selvittämään. Käyttäjämäärän kasvaessa tietokannan suorituskyvyn rajat tulevat kuitenkin pian vastaan. Tietokanta joudutaan tulevaisuudessa vaihtamaan erityisesti raportointitietokannaksi suunniteltuun.

Delivery Reliability: Timely and Quantitative Accuracy in a Forest Industry Company

The primary objective of this thesis was to research delivery reliability of mill business unit of a forest industry company, especially timely and quantitative accuracy of sales orders. Delivery reliability is an important factor of customer satisfaction, which has a great influence for success of a company. The secondary objective was to find out reasons for possible problems of delivery reliability and give propositions for improvable performances. The empirical part of the thesis based on reporting database of the forest industry company’s ERP-software and detailed information of the mill system. The delivery reliability results of the mill business unit were compared to delivery reliability of similar mill business unit inside the forest industry company. The research results expressed problems in the supply chain. The delivery reliability reporting should be also developed further. This would advance delivery reliability monitoring. The improvement propositions of the thesis were logistic operation mode estimation, particular benchmarking of the compared mill business unit and more detailed survey on production delivery reliability.

The impact of statin use on fetal development:a meta-analysis

INTRODUCTION: Statin use inadvertently during pregnancy and proposed use of statins for the treatment of preeclampsia, led us to question the evidence behind their current contraindicated status. Several studies have evaluated the relationship between statin use in pregnancy with fetal outcome but their results have not been quantitatively assessed by meta-analysis. Our objective was to undertake a systematic review of all published clinical evidence to assess the effects of statin use in pregnancy on subsequent fetal wellbeing. METHODS: A comprehensive search strategy was performed of all electronic databases and the Merck reporting database for studies published from 1966 to 2014. Two reviewers independently screened citations and undertook study quality assessment and data extraction. We obtained summary estimates of adverse fetal events that were classified as potentially fatal, clinically significant morbidity or minor adverse event. We identified 602 titles and reviewed 30 articles for inclusion and exclusion criteria. Meta-analysis was performed on seven studies (3 cohort, 3 case-series and 1 case-control). RESULTS: Of the 922 cases of statin exposure in pregnancy, 27 exposures were associated with lethal or clinically significant fetal morbidity and 10 with minor adverse events. Statin exposure was limited to the first trimester in all but two cases. The pooled rate of lethal or clinically significant fetal abnormalities in pregnant women exposed to statins was 0.01 (95% CI 0.00-0.04), less than the European rate of 0.026 (95% CI 2.54- 2.57)EUROCAT. The rate of fetal abnormality for simvastatin was 0.03 (95% CI 0.00-0.08), atorvostatin 0.11 (95% CI 0.00-0.52), pravastatin 0.01 (95% CI 0.00-0.2) and lovastatin use 0.04 (95% CI 0.00-0.28). Systems based anomalies were also calculated, congenital heart disease was 0.8 (95% CI 0.02-0.12) compared with the background rate of 0.79 (95% CI 0.78- 0.80). CONCLUSIONS: The published data suggests that statins may not be teratogenic when given inadvertently during pregnancy and prospective studies such as The StAmP Trial may provide more data

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.

Drugs Associated with Hepatotoxicity and their Reporting Frequency of Liver Adverse Events in VigiBase (TM) Unified List Based on International Collaborative Work

BACKGROUND Challenges exist in the clinical diagnosis of drug-induced liver injury (DILI) and in obtaining information on hepatotoxicity in humans. OBJECTIVE (i) To develop a unified list that combines drugs incriminated in well vetted or adjudicated DILI cases from many recognized sources and drugs that have been subjected to serious regulatory actions due to hepatotoxicity; and (ii) to supplement the drug list with data on reporting frequencies of liver events in the WHO individual case safety report database (VigiBase). DATA SOURCES AND EXTRACTION (i) Drugs identified as causes of DILI at three major DILI registries; (ii) drugs identified as causes of drug-induced acute liver failure (ALF) in six different data sources, including major ALF registries and previously published ALF studies; and (iii) drugs identified as being subjected to serious governmental regulatory actions due to their hepatotoxicity in Europe or the US were collected. The reporting frequency of adverse events was determined using VigiBase, computed as Empirical Bayes Geometric Mean (EBGM) with 90% confidence interval for two customized terms, 'overall liver injury' and 'ALF'. EBGM of >or=2 was considered a disproportional increase in reporting frequency. The identified drugs were then characterized in terms of regional divergence, published case reports, serious regulatory actions, and reporting frequency of 'overall liver injury' and 'ALF' calculated from VigiBase. DATA SYNTHESIS After excluding herbs, supplements and alternative medicines, a total of 385 individual drugs were identified; 319 drugs were identified in the three DILI registries, 107 from the six ALF registries (or studies) and 47 drugs that were subjected to suspension or withdrawal in the US or Europe due to their hepatotoxicity. The identified drugs varied significantly between Spain, the US and Sweden. Of the 319 drugs identified in the DILI registries of adjudicated cases, 93.4% were found in published case reports, 1.9% were suspended or withdrawn due to hepatotoxicity and 25.7% were also identified in the ALF registries/studies. In VigiBase, 30.4% of the 319 drugs were associated with disproportionally higher reporting frequency of 'overall liver injury' and 83.1% were associated with at least one reported case of ALF. CONCLUSIONS This newly developed list of drugs associated with hepatotoxicity and the multifaceted analysis on hepatotoxicity will aid in causality assessment and clinical diagnosis of DILI and will provide a basis for further characterization of hepatotoxicity.

Corruption scandals, press reporting, and accountability. Evidence from Spanish mayors.

[spa] En este trabajo se analiza con datos de España los efectos de la corrupción local sobre los resultados electorales. En base a las noticias publicadas entre 1996 y 2009, se construye una nueva base de datos que recoge los casos de corrupción y noticias relativas a cambios en los planes urbanísticos que no han seguido el procedimiento legal. La base de datos muestra que los primeros escándalos de corrupción urbanística surgieron durante el mandato electoral de 1999-2003, pero que éstos alcanzaron sus niveles máximos justo antes de las elecciones de 2007. Se estima una ecuación del porcentaje de voto obtenido por el partido en el poder en estas elecciones locales y se encuentra que la pérdida media de voto después de un caso de corrupción se sitúa alrededor del 4%. Este efecto es más elevado (del 9%) si el caso de corrupción ha recibido una amplia cobertura por los diarios. Los efectos estimados para las elecciones de 2003 son significativamente inferiores. Cuando se consideran los casos en que los políticos han tenido cargas judiciales por corrupción y amplia cobertura por los diarios, la pérdida de voto asciende hasta el 12%. No obstante, la cobertura por los diarios genera un efecto negativo en el voto incluso cuando no hay cargas judiciales.

Corruption scandals, press reporting, and accountability. Evidence from Spanish mayors.

[spa] En este trabajo se analiza con datos de España los efectos de la corrupción local sobre los resultados electorales. En base a las noticias publicadas entre 1996 y 2009, se construye una nueva base de datos que recoge los casos de corrupción y noticias relativas a cambios en los planes urbanísticos que no han seguido el procedimiento legal. La base de datos muestra que los primeros escándalos de corrupción urbanística surgieron durante el mandato electoral de 1999-2003, pero que éstos alcanzaron sus niveles máximos justo antes de las elecciones de 2007. Se estima una ecuación del porcentaje de voto obtenido por el partido en el poder en estas elecciones locales y se encuentra que la pérdida media de voto después de un caso de corrupción se sitúa alrededor del 4%. Este efecto es más elevado (del 9%) si el caso de corrupción ha recibido una amplia cobertura por los diarios. Los efectos estimados para las elecciones de 2003 son significativamente inferiores. Cuando se consideran los casos en que los políticos han tenido cargas judiciales por corrupción y amplia cobertura por los diarios, la pérdida de voto asciende hasta el 12%. No obstante, la cobertura por los diarios genera un efecto negativo en el voto incluso cuando no hay cargas judiciales.

Indicent reporting in shipping. Experiences and best practices for the Baltic Sea

Incident and near miss reporting is one of the proactive tools of safety management. By analyzing incidents and near misses and by corrective actions, severe accidents can potentially be avoided. Near miss and incident reporting is widely used in many riskprone industries such as aviation or chemical industry. In shipping incident and near miss reporting is required by the mandatory safety management system International Safety Management Code (ISM Code). However, in several studies the conclusion has been that incidents are reported poorly in the shipping industry. The aim of this report is to highlight the best practices for incident reporting in shipping and to support the shipping industry in the better utilization of incident reporting information. The study consists of three parts: 1) voluntary, shared reporting systems in shipping (international experiences), 2) interview study at four shipping companies in Sweden and in Finland (best practices), 3) expert workshop on incident reporting (problems and solutions). Preconditions for a functional reporting system are an existing no blame culture, commitment of the top management, feedback, good communication, training and an easy-to-use system. Although preconditions are met, problems can still appear, for example due to psychological, interpersonal or nationality-related reasons. In order to keep the reporting system functioning, the shipping company must be committed to maintain and develop the system and to tackle the problems. The whole reporting process from compiling, handling and analyzing a report, creating corrective actions and implementing them has to be handled properly in order to gain benefits from the reporting system. In addition to avoiding accidents, the functional reporting system can also offer other benefits by increasing safety awareness, by improving the overall safety and working conditions onboard, by enhancing team work and communication onboard and between ships and the land-based organization of shipping companies. Voluntary shared reporting systems are supported in the shipping industry in principle, but their development in the Baltic Sea is still in its infancy and the potential benefits of sharing the reports have not been realized. On the basis of this study we recommend that a common reporting system be developed for the Baltic Sea area which all the ships operating in the area could use regardless of their flag. Such a wider system could prevent some of the problems related to the current national systems. There would be more incident cases available in the database and this would support anonymity and thus encourage shipping companies to report to a shared database more frequently. A shared reporting system would contribute to the sharing of experiences and to the wider use of incident information in the shipping industry.

Signaling potential gender effect in a spontaneous reporting system : cardiac effects associated with the use of antibiotics

Mémoire numérisé par la Division de la gestion de documents et des archives de l'Université de Montréal

An investigation of the shortcomings of the CONSORT 2010 statement for the reporting of group sequential randomised controlled trials: a methodological systematic review

Background It can be argued that adaptive designs are underused in clinical research. We have explored concerns related to inadequate reporting of such trials, which may influence their uptake. Through a careful examination of the literature, we evaluated the standards of reporting of group sequential (GS) randomised controlled trials, one form of a confirmatory adaptive design. Methods We undertook a systematic review, by searching Ovid MEDLINE from the 1st January 2001 to 23rd September 2014, supplemented with trials from an audit study. We included parallel group, confirmatory, GS trials that were prospectively designed using a Frequentist approach. Eligible trials were examined for compliance in their reporting against the CONSORT 2010 checklist. In addition, as part of our evaluation, we developed a supplementary checklist to explicitly capture group sequential specific reporting aspects, and investigated how these are currently being reported. Results Of the 284 screened trials, 68(24%) were eligible. Most trials were published in “high impact” peer-reviewed journals. Examination of trials established that 46(68%) were stopped early, predominantly either for futility or efficacy. Suboptimal reporting compliance was found in general items relating to: access to full trials protocols; methods to generate randomisation list(s); details of randomisation concealment, and its implementation. Benchmarking against the supplementary checklist, GS aspects were largely inadequately reported. Only 3(7%) trials which stopped early reported use of statistical bias correction. Moreover, 52(76%) trials failed to disclose methods used to minimise the risk of operational bias, due to the knowledge or leakage of interim results. Occurrence of changes to trial methods and outcomes could not be determined in most trials, due to inaccessible protocols and amendments. Discussion and Conclusions There are issues with the reporting of GS trials, particularly those specific to the conduct of interim analyses. Suboptimal reporting of bias correction methods could potentially imply most GS trials stopping early are giving biased results of treatment effects. As a result, research consumers may question credibility of findings to change practice when trials are stopped early. These issues could be alleviated through a CONSORT extension. Assurance of scientific rigour through transparent adequate reporting is paramount to the credibility of findings from adaptive trials. Our systematic literature search was restricted to one database due to resource constraints.

Database of diazotrophs in global ocean: abundances, biomass and nitrogen fixation rates

[EN] Marine N2 fixing microorganisms, termed diazotrophs, are a key functional group in marine pelagic ecosystems. The biological fixation of dinitrogen (N2) to bioavailable nitrogen provides an important new source of nitrogen for pelagic marine ecosystems 5 and influences primary productivity and organic matter export to the deep ocean. As one of a series of efforts to collect biomass and rates specific to different phytoplankton functional groups, we have constructed a database on diazotrophic organisms in the global pelagic upper ocean by compiling about 12 000 direct field measurements of cyanobacterial diazotroph abundances (based on microscopic cell counts or qPCR 10 assays targeting the nifH genes) and N2 fixation rates. Biomass conversion factors are estimated based on cell sizes to convert  abundance data to diazotrophic biomass. The database is limited spatially, lacking large regions of the ocean especially in the Indian Ocean. The data are approximately log-normal distributed, and large variances exist in most sub-databases with non-zero values differing 5 to 8 orders of magnitude. 15 Lower mean N2 fixation rate was found in the North Atlantic Ocean than the Pacific Ocean. Reporting the geometric mean and the range of one geometric standard error below and above the geometric mean, the pelagic N2 fixation rate in the global ocean is estimated to be 62 (53–73) TgNyr−1 and the pelagic diazotrophic biomass in the global ocean is estimated to be 4.7 (2.3–9.6) TgC from cell counts and to 89 (40–20 200) TgC from nifH-based abundances. Uncertainties related to biomass conversion factors can change the estimate of geometric mean pelagic diazotrophic biomass in the global ocean by about ±70 %. This evolving database can be used to study spatial and temporal distributions and variations of marine N2 fixation, to validate geochemical estimates and to parameterize and validate biogeochemical models. The database is 25 stored in PANGAEA (http://doi.pangaea.de/10.1594/PANGAEA.774851).

A PRISMA assessment of the reporting quality of systematic reviews in orthodontics

Abstract Objectives: To assess the reporting quality of Cochrane and non-Cochrane systematic reviews (SR) in orthodontics and to compare the reporting quality (PRISMA score) with methodological quality (AMSTAR criteria). Materials and Methods: Systematic reviews (n  =  109) published between January 2000 and July 2011 in five leading orthodontic journals were identified and included. The quality of reporting of the included reviews was assessed by two authors in accordance with the PRISMA guidelines. Each article was assigned a cumulative grade based on fulfillment of the applicable criteria, and an overall percentage score was assigned. Descriptive statistics and simple and multiple linear regression analyses were undertaken. Results: The mean overall PRISMA score was 64.1% (95% confidence interval [CI], 62%-65%). The quality of reporting was considerably better in reviews published in the Cochrane Database of Systematic Reviews (P < .001) than in non-Cochrane reviews. Both multivariable and univariable analysis indicated that journal of publication and number of authors was significantly associated with the PRISMA score. The association between AMSTAR score and modified PRISMA score was also found to be highly statistically significant. Conclusion: Compliance of orthodontic SRs published in orthodontic journals with PRISMA guidelines was deficient in several areas. The quality of reporting assessed using PRISMA guidelines was significantly better in orthodontic SRs published in the Cochrane Database of Systematic Reviews.

Pharmacovigilance of drug allergy and hypersensitivity using the ENDA-DAHD database and the GALEN platform. The Galenda project

Nonallergic hypersensitivity and allergic reactions are part of the many different types of adverse drug reactions (ADRs). Databases exist for the collection of ADRs. Spontaneous reporting makes up the core data-generating system of pharmacovigilance, but there is a large under-estimation of allergy/hypersensitivity drug reactions. A specific database is therefore required for drug allergy and hypersensitivity using standard operating procedures (SOPs), as the diagnosis of drug allergy/hypersensitivity is difficult and current pharmacovigilance algorithms are insufficient. Although difficult, the diagnosis of drug allergy/hypersensitivity has been standardized by the European Network for Drug Allergy (ENDA) under the aegis of the European Academy of Allergology and Clinical Immunology and SOPs have been published. Based on ENDA and Global Allergy and Asthma European Network (GA(2)LEN, EU Framework Programme 6) SOPs, a Drug Allergy and Hypersensitivity Database (DAHD((R))) has been established under FileMaker((R)) Pro 9. It is already available online in many different languages and can be accessed using a personal login. GA(2)LEN is a European network of 27 partners (16 countries) and 59 collaborating centres (26 countries), which can coordinate and implement the DAHD across Europe. The GA(2)LEN-ENDA-DAHD platform interacting with a pharmacovigilance network appears to be of great interest for the reporting of allergy/hypersensitivity ADRs in conjunction with other pharmacovigilance instruments.

Reporting completeness of abstracts of systematic reviews published in leading dental specialty journals

The aim of this study was to investigate the reporting completeness of systematic review (SR) abstracts in leading dental specialty journals. Electronic and supplementary hand searching were undertaken to identify SRs published in seven dental specialty journals and in the Cochrane Database of Systematic Reviews. Abstract reporting completeness was evaluated using a checklist derived from the Preferred Reporting Items for Systematic Reviews and Meta-Analyses (prisma) guidelines. Descriptive statistics followed by univariate and multivariate analyses were conducted. Two-hundred and eighteen SR abstracts were identified. Reporting of interventions (94%), objectives (96%), data sources (81%), eligibility criteria (77%), and conclusions (97%) was adequate in the majority of reviews. However, inadequate reporting of participants (18%), results (42%), effect size (14%), level of significance (60%), and trial registration (100%) was commonplace. The mean overall reporting score was 79.1% (95% CI, 77.6-80.6). Only journal of publication was a significant predictor of overall reporting, with inferior results for all journals relative to Cochrane reviews, with scores ranging from -4.3% (95% CI, -8.74 to 0.08) to -35.6% (95% CI, -42.0 to -24.3) for the International Journal of Prosthodontics and the British Journal of Oral and Maxillofacial Surgery, respectively. Improved reporting of dental SR abstracts is needed and should be encouraged, as these abstracts may underpin influential clinical decisions.