Quality assurance of integrative big data for medical research within a multihospital system.

Background: The need is growing to create medical big data based on the electronic health records collected from different hospitals. Errors for sure occur and how to correct them should be explored.Methods: Electronic health records of 9,197,817 patients and 53,081,148 visits, totaling about 500 mi...

Descripción completa

Detalles Bibliográficos
Publicado en:Journal of the Formosan Medical Association Vol. 121; no. 9; pp. 1728 - 1739
Autores principales: Lee, Yi-Chia, Chao, Ying-Ting, Lin, Pei-Ju, Yang, Yen-Yun, Yang, Yu-Cih, Chu, Cheng-Chieh, Wang, Yu-Chun, Chang, Chin-Hao, Chuang, Shu-Lin, Chen, Wei-Chun, Sun, Hsing-Jen, Tsou, Hsin-Cheng, Chou, Cheng-Fu, Yang, Wei-Shiung
Formato: Journal Article
Publicado: Elsevier B.V. Sep2022
Acceso en línea:Ver este registro en EBSCOhost
fields @attributes:
  recordID: 1
pdfLink:
plink: https://search.ebscohost.com/login.aspx?direct=true&db=ccm&AN=158672278&site=ehost-live
header:
  @attributes:
    shortDbName: ccm
    uiTerm: 158672278
    longDbName: CINAHL Complete
    uiTag: AN
  controlInfo:
    bkinfo:
    dissinfo:
    jinfo:
      jid:
        09296646
        3O8P
      jtl: Journal of the Formosan Medical Association
      issn: 09296646
      maglogo: N
    pubinfo:
      dt: Sep2022
      vid: 121
      iid: 9
      pid: 467
      pub: Elsevier B.V.
      place: New York, New York
    artinfo:
      ui:
        158672278
        158672278
        NLM35168836
        10.1016/j.jfma.2021.12.024
        NLM35168836
        158672278
      ppf: 1728
      ppct: 11
      formats:
      tig:
        atl: Quality assurance of integrative big data for medical research within a multihospital system.
      aug:
        au:
          Lee, Yi-Chia
          Chao, Ying-Ting
          Lin, Pei-Ju
          Yang, Yen-Yun
          Yang, Yu-Cih
          Chu, Cheng-Chieh
          Wang, Yu-Chun
          Chang, Chin-Hao
          Chuang, Shu-Lin
          Chen, Wei-Chun
          Sun, Hsing-Jen
          Tsou, Hsin-Cheng
          Chou, Cheng-Fu
          Yang, Wei-Shiung
        affil: Integrative Medical Database Center, Department of Medical Research, National Taiwan University Hospital, Taipei, Taiwan
      sug:
        subj:
          Research, Medical
          Multiinstitutional Systems
          Resource Databases
          Scales
          Ferrans and Powers Quality of Life Index
      ab: Background: The need is growing to create medical big data based on the electronic health records collected from different hospitals. Errors for sure occur and how to correct them should be explored.Methods: Electronic health records of 9,197,817 patients and 53,081,148 visits, totaling about 500 million records for 2006-2016, were transmitted from eight hospitals into an integrated database. We randomly selected 10% of patients, accumulated the primary keys for their tabulated data, and compared the key numbers in the transmitted data with those of the raw data. Errors were identified based on statistical testing and clinical reasoning.Results: Data were recorded in 1573 tables. Among these, 58 (3.7%) had different key numbers, with the maximum of 16.34/1000. Statistical differences (P < 0.05) were found in 34 (58.6%), of which 15 were caused by changes in diagnostic codes, wrong accounts, or modified orders. For the rest, the differences were related to accumulation of hospital visits over time. In the remaining 24 tables (41.4%) without significant differences, three were revised because of incorrect computer programming or wrong accounts. For the rest, the programming was correct and absolute differences were negligible. The applicability was confirmed using the data of 2,730,883 patients and 15,647,468 patient-visits transmitted during 2017-2018, in which 10 (3.5%) tables were corrected.Conclusion: Significant magnitude of inconsistent data does exist during the transmission of big data from diverse sources. Systematic validation is essential. Comparing the number of data tabulated using the primary keys allow us to rapidly identify and correct these scattered errors.
      pubtype: Academic Journal
      doctype: Journal Article
      ougenre: Article
    language: English
    refInfo:
    holdings:
      @attributes:
        islocal: N