Automated data extraction—A feasible way to construct patient registers of primary care utilization

  • MATS MARTINELL Department of Public Health and Caring Sciences, Uppsala University, Uppsala, Box 564, SE 751 22, Uppsala, Sweden
  • JAN STÅLHAMMAR Department of Public Health and Caring Sciences, Uppsala University, Uppsala, Box 564, SE 751 22, Uppsala, Sweden
  • JOHAN HALLQVIST Department of Public Health and Caring Sciences, Uppsala University, Uppsala, Box 564, SE 751 22, Uppsala, Sweden
Keywords: Data extraction, data mining, electronic medical records (EMRs), knowledge discovery in databases (KDD), primary health care

Abstract

Introduction. Electronic medical records (EMRs) enable analysis of health care data by using data mining techniques to build research databases. Though the reliability of the data extraction process is crucial for the credibility of the final analysis, there are few published validations of this process. In this paper we validate the performance of an automated data mining tool on EMR in a primary care setting.

Methods. The Pygargus Customized eXtraction Program (CXP) was programmed to find and then extract data from patients meeting criteria for type 2 diabetes mellitus (T2DM) at one primary health care clinic (PHC). The ability of CXP to extract relevant cases was assessed by comparing cases extracted by an EMR integrated search engine. The concordance of extracted data with the original EMR source was manually controlled.

Results. Prevalence of T2DM was 4.0%, which correspond well to previous estimations. By searching for drug prescriptions, diagnosis codes, and laboratory values, 38%, 53%, and 91% of relevant cases were found, respectively. The sensitivity of CXP regarding extraction of relevant cases was 100%. The specificity was 99.9% due to 12 non-T2DM cases extracted. The congruity at single-item level was 99.6%. The 13 incorrect data items were all located in the same structural module.

Conclusion. The CXP is a reliable and accurate data mining tool to extract selective data from EMR.

Downloads

Download data is not yet available.
Published
2012-02-15
How to Cite
MARTINELL M., STÅLHAMMAR J., & HALLQVIST J. (2012). Automated data extraction—A feasible way to construct patient registers of primary care utilization. Upsala Journal of Medical Sciences, 117(1), 52–56. https://doi.org/10.3109/03009734.2011.653015
Section
Original Articles