title: Metadata-driven Clinical Data Loading into i2b2 for Clinical and Translational Science Institutes.
abstract: Clinical and Translational Science Award (CTSA) recipients have a need to create research data marts from their clinical data warehouses, through research data networks and the use of i2b2 and SHRINE technologies. These data marts may have different data requirements and representations, thus necessitating separate extract, transform and load (ETL) processes for populating each mart. Maintaining duplicative procedural logic for each ETL process is onerous. We have created an entirely metadata-driven ETL process that can be customized for different data marts through separate configurations, each stored in an extension of i2b2 's ontology database schema. We extended our previously reported and open source Eureka! Clinical Analytics software with this capability. The same software has created i2b2 data marts for several projects, the largest being the nascent Accrual for Clinical Trials (ACT) network, for which it has loaded over 147 million facts about 1.2 million patients.
authors: Atlanta Clinical and Translational Science Institute, Emory University, Atlanta, GA.
authors: Andrew R
authors: AR
authors: Post
authors: Atlanta Clinical and Translational Science Institute, Emory University, Atlanta, GA.
authors: Akshatha K
authors: AK
authors: Pai
authors: Atlanta Clinical and Translational Science Institute, Emory University, Atlanta, GA.
authors: Richard
authors: R
authors: Willard
authors: Atlanta Clinical and Translational Science Institute, Emory University, Atlanta, GA.
authors: Bradley J
authors: BJ
authors: May
authors: Atlanta Clinical and Translational Science Institute, Emory University, Atlanta, GA.
authors: Andrew C
authors: AC
authors: West
authors: Atlanta Clinical and Translational Science Institute, Emory University, Atlanta, GA.
authors: Sanjay
authors: S
authors: Agravat
authors: Institute for Computational Medicine, Johns Hopkins University, Baltimore, MD.
authors: Stephen J
authors: SJ
authors: Granite
authors: Institute for Computational Medicine, Johns Hopkins University, Baltimore, MD.
authors: Raimond L
authors: RL
authors: Winslow
authors: Atlanta Clinical and Translational Science Institute, Emory University, Atlanta, GA.
authors: David S
authors: DS
authors: Stephens