BACKGROUND: The development and adoption of health care common data models (CDMs) has addressed some of the logistical challenges of performing research on data generated from disparate health care systems by standardizing data representations and leveraging standardized terminology to express clinical information consistently. However, transforming a data system into a CDM is not a trivial task, and maintaining an operational, enterprise capable CDM that is incrementally updated within a data warehouse is challenging. OBJECTIVES: To develop a quality assurance (QA) process and code base to accompany our incremental transformation of the Department of Veterans Affairs Corporate Data Warehouse health care database into the Observational Medical Outcomes Partnership (OMOP) CDM to prevent incremental load errors. METHODS: We designed and implemented a multistage QA) approach centered on completeness, value conformance, and relational conformance data-quality elements. For each element we describe key incremental load challenges, our extract, transform, and load (ETL) solution of data to overcome those challenges, and potential impacts of incremental load failure. RESULTS: Completeness and value conformance data-quality elements are most affected by incremental changes to the CDW, while updates to source identifiers impact relational conformance. ETL failures surrounding these elements lead to incomplete and inaccurate capture of clinical concepts as well as data fragmentation across patients, providers, and locations. CONCLUSION: Development of robust QA processes supporting accurate transformation of OMOP and other CDMs from source data is still in evolution, and opportunities exist to extend the existing QA framework and tools used for incremental ETL QA processes. Georg Thieme Verlag KG Stuttgart · New York.
BACKGROUND: The development and adoption of health care common data models (CDMs) has addressed some of the logistical challenges of performing research on data generated from disparate health care systems by standardizing data representations and leveraging standardized terminology to express clinical information consistently. However, transforming a data system into a CDM is not a trivial task, and maintaining an operational, enterprise capable CDM that is incrementally updated within a data warehouse is challenging. OBJECTIVES: To develop a quality assurance (QA) process and code base to accompany our incremental transformation of the Department of Veterans Affairs Corporate Data Warehouse health care database into the Observational Medical Outcomes Partnership (OMOP) CDM to prevent incremental load errors. METHODS: We designed and implemented a multistage QA) approach centered on completeness, value conformance, and relational conformance data-quality elements. For each element we describe key incremental load challenges, our extract, transform, and load (ETL) solution of data to overcome those challenges, and potential impacts of incremental load failure. RESULTS: Completeness and value conformance data-quality elements are most affected by incremental changes to the CDW, while updates to source identifiers impact relational conformance. ETL failures surrounding these elements lead to incomplete and inaccurate capture of clinical concepts as well as data fragmentation across patients, providers, and locations. CONCLUSION: Development of robust QA processes supporting accurate transformation of OMOP and other CDMs from source data is still in evolution, and opportunities exist to extend the existing QA framework and tools used for incremental ETL QA processes. Georg Thieme Verlag KG Stuttgart · New York.
Authors: Dukyong Yoon; Eun Kyoung Ahn; Man Young Park; Soo Yeon Cho; Patrick Ryan; Martijn J Schuemie; Dahye Shin; Hojun Park; Rae Woong Park Journal: Healthc Inform Res Date: 2016-01-31
Authors: F FitzHenry; F S Resnic; S L Robbins; J Denton; L Nookala; D Meeker; L Ohno-Machado; M E Matheny Journal: Appl Clin Inform Date: 2015-08-26 Impact factor: 2.342
Authors: Erica A Voss; Rupa Makadia; Amy Matcho; Qianli Ma; Chris Knoll; Martijn Schuemie; Frank J DeFalco; Ajit Londhe; Vivienne Zhu; Patrick B Ryan Journal: J Am Med Inform Assoc Date: 2015-02-10 Impact factor: 4.497
Authors: Michael G Kahn; Jeffrey S Brown; Alein T Chun; Bruce N Davidson; Daniella Meeker; Patrick B Ryan; Lisa M Schilling; Nicole G Weiskopf; Andrew E Williams; Meredith Nahm Zozus Journal: EGEMS (Wash DC) Date: 2015-03-23
Authors: C Maier; L Lang; H Storf; P Vormstein; R Bieber; J Bernarding; T Herrmann; C Haverkamp; P Horki; J Laufer; F Berger; G Höning; H W Fritsch; J Schüttler; T Ganslandt; H U Prokosch; M Sedlmayr Journal: Appl Clin Inform Date: 2018-01-24 Impact factor: 2.342
Authors: Michael G Kahn; Tiffany J Callahan; Juliana Barnard; Alan E Bauck; Jeff Brown; Bruce N Davidson; Hossein Estiri; Carsten Goerg; Erin Holve; Steven G Johnson; Siaw-Teng Liaw; Marianne Hamilton-Lopez; Daniella Meeker; Toan C Ong; Patrick Ryan; Ning Shang; Nicole G Weiskopf; Chunhua Weng; Meredith N Zozus; Lisa Schilling Journal: EGEMS (Wash DC) Date: 2016-09-11
Authors: Adriana M Hung; Shailja C Shah; Alexander G Bick; Zhihong Yu; Hua-Chang Chen; Christine M Hunt; Frank Wendt; Otis Wilson; Robert A Greevy; Cecilia P Chung; Ayako Suzuki; Yuk-Lam Ho; Elvis Akwo; Renato Polimanti; Jin Zhou; Peter Reaven; Philip S Tsao; J Michael Gaziano; Jennifer E Huffman; Jacob Joseph; Shiuh-Wen Luoh; Sudha Iyengar; Kyong-Mi Chang; Juan P Casas; Michael E Matheny; Christopher J O'Donnell; Kelly Cho; Ran Tao; Katalin Susztak; Cassianne Robinson-Cohen; Sony Tuteja; Edward D Siew Journal: JAMA Intern Med Date: 2022-04-01 Impact factor: 21.873
Authors: Sudha R Raman; Emily C O'Brien; Bradley G Hammill; Adam J Nelson; Laura J Fish; Lesley H Curtis; Keith Marsolo Journal: J Am Med Inform Assoc Date: 2022-04-13 Impact factor: 4.497
Authors: Byungkon Kang; Jisang Yoon; Ha Young Kim; Sung Jin Jo; Yourim Lee; Hye Jin Kam Journal: J Am Med Inform Assoc Date: 2021-07-14 Impact factor: 4.497
Authors: Philipp Unberath; Hans Ulrich Prokosch; Julian Gründner; Marcel Erpenbeck; Christian Maier; Jan Christoph Journal: Appl Clin Inform Date: 2020-06-03 Impact factor: 2.342
Authors: Asieh Golozar; Lana Yh Lai; Anthony G Sena; David Vizcaya; Lisa M Schilling; Vojtech Huser; Fredrik Nyberg; Scott L Duvall; Daniel R Morales; Thamir M Alshammari; Hamed Abedtash; Waheed-Ul-Rahman Ahmed; Osaid Alser; Heba Alghoul; Ying Zhang; Mengchun Gong; Yin Guan; Carlos Areia; Jitendra Jonnagaddala; Karishma Shah; Jennifer C E Lane; Albert Prats-Uribe; Jose D Posada; Nigam H Shah; Vignesh Subbian; Lin Zhang; Maria Tereza Fernandes Abrahão; Peter R Rijnbeek; Seng Chan You; Paula Casajust; Elena Roel; Martina Recalde; Sergio Fernández-Bertolín; Alan Andryc; Jason A Thomas; Adam B Wilcox; Stephen Fortin; Clair Blacketer; Frank DeFalco; Karthik Natarajan; Thomas Falconer; Matthew Spotnitz; Anna Ostropolets; George Hripcsak; Marc Suchard; Kristine E Lynch; Michael E Matheny; Andrew Williams; Christian Reich; Talita Duarte-Salles; Kristin Kostka; Patrick B Ryan; Daniel Prieto-Alhambra Journal: medRxiv Date: 2020-10-27