Secondary Use of Patients' Electronic Records (SUPER): An Approach for Meeting Specific Data Needs of Clinical and Translational Researchers

AMIA Annu Symp Proc. 2018 Apr 16;2017:1581-1588. eCollection 2017.


Academic medical centers commonly approach secondary use of electronic health record (EHR) data by implementing centralized clinical data warehouses (CDWs). However, CDWs require extensive resources to model data dimensions and harmonize clinical terminology, which can hinder effective support of the specific and varied data needs of investigators. We hypothesized that an approach that aggregates raw data from source systems, ignores initial modeling typical of CDWs, and transforms raw data for specific research purposes would meet investigator needs. The approach has successfully enabled multiple tools that provide utility to the institutional research enterprise. To our knowledge, this is the first complete description of a methodology for electronic patient data acquisition and provisioning that ignores data harmonization at the time of initial storage in favor of downstream transformation to address specific research questions and applications.

Publication types

  • Research Support, N.I.H., Extramural
  • Research Support, Non-U.S. Gov't

MeSH terms

  • Academic Medical Centers
  • Clinical Studies as Topic
  • Data Aggregation*
  • Data Mining
  • Data Warehousing*
  • Electronic Health Records* / organization & administration
  • Humans
  • Information Systems / organization & administration
  • New York City
  • Systems Integration
  • Translational Medical Research*