Skip to main content
. Author manuscript; available in PMC: 2017 Oct 1.
Published in final edited form as: Int J Med Inform. 2016 Jul 29;94:271–274. doi: 10.1016/j.ijmedinf.2016.07.009

Table 2.

PubMed Search Strategy for Clinical Operational Database to Clinical Data Warehouse Extract, Transform, Load (ETL) Validation Studies

PubMed Search Criteria Results Examination
ETL [All Fields] AND extract [All Fields] AND transform [All Fields] and load [All Fields] 11 articles None of the articles evaluated the validation of the ETL process from a healthcare institution’s operational database (EHR) to a clinical data warehouse
clinical [All Fields] AND research [All Fields] AND database [All Fields] AND accuracy [All Fields] AND validation [All Fields] 231 articles With the exception of natural language processing studies, none of the articles evaluated the validation of the ETL process from a healthcare institution’s operational database (EHR) to a clinical data warehouse