Monica M Horvath1, Shelley A Rusincovitch2, Stephanie Brinson3, Howard C Shang4, Steve Evans3, Jeffrey M Ferranti5. 1. Duke Health Technology Solutions, Duke University Health System, Durham, NC, United States. Electronic address: monica.horvath@duke.edu. 2. Duke Translational Medicine Institute, Duke University School of Medicine, Durham, NC, United States. 3. Duke Health Technology Solutions, Duke University Health System, Durham, NC, United States. 4. Duke Clinical Research Institute, Duke University School of Medicine, Durham, NC, United States. 5. Duke Health Technology Solutions, Duke University Health System, Durham, NC, United States; Department of Pediatrics, Duke University School of Medicine, Durham, NC, United States.
Abstract
PURPOSE: Data generated in the care of patients are widely used to support clinical research and quality improvement, which has hastened the development of self-service query tools. User interface design for such tools, execution of query activity, and underlying application architecture have not been widely reported, and existing tools reflect a wide heterogeneity of methods and technical frameworks. We describe the design, application architecture, and use of a self-service model for enterprise data delivery within Duke Medicine. METHODS: Our query platform, the Duke Enterprise Data Unified Content Explorer (DEDUCE), supports enhanced data exploration, cohort identification, and data extraction from our enterprise data warehouse (EDW) using a series of modular environments that interact with a central keystone module, Cohort Manager (CM). A data-driven application architecture is implemented through three components: an application data dictionary, the concept of "smart dimensions", and dynamically-generated user interfaces. RESULTS: DEDUCE CM allows flexible hierarchies of EDW queries within a grid-like workspace. A cohort "join" functionality allows switching between filters based on criteria occurring within or across patient encounters. To date, 674 users have been trained and activated in DEDUCE, and logon activity shows a steady increase, with variability between months. A comparison of filter conditions and export criteria shows that these activities have different patterns of usage across subject areas. CONCLUSIONS: Organizations with sophisticated EDWs may find that users benefit from development of advanced query functionality, complimentary to the user interfaces and infrastructure used in other well-published models. Driven by its EDW context, the DEDUCE application architecture was also designed to be responsive to source data and to allow modification through alterations in metadata rather than programming, allowing an agile response to source system changes.
PURPOSE: Data generated in the care of patients are widely used to support clinical research and quality improvement, which has hastened the development of self-service query tools. User interface design for such tools, execution of query activity, and underlying application architecture have not been widely reported, and existing tools reflect a wide heterogeneity of methods and technical frameworks. We describe the design, application architecture, and use of a self-service model for enterprise data delivery within Duke Medicine. METHODS: Our query platform, the Duke Enterprise Data Unified Content Explorer (DEDUCE), supports enhanced data exploration, cohort identification, and data extraction from our enterprise data warehouse (EDW) using a series of modular environments that interact with a central keystone module, Cohort Manager (CM). A data-driven application architecture is implemented through three components: an application data dictionary, the concept of "smart dimensions", and dynamically-generated user interfaces. RESULTS: DEDUCE CM allows flexible hierarchies of EDW queries within a grid-like workspace. A cohort "join" functionality allows switching between filters based on criteria occurring within or across patient encounters. To date, 674 users have been trained and activated in DEDUCE, and logon activity shows a steady increase, with variability between months. A comparison of filter conditions and export criteria shows that these activities have different patterns of usage across subject areas. CONCLUSIONS: Organizations with sophisticated EDWs may find that users benefit from development of advanced query functionality, complimentary to the user interfaces and infrastructure used in other well-published models. Driven by its EDW context, the DEDUCE application architecture was also designed to be responsive to source data and to allow modification through alterations in metadata rather than programming, allowing an agile response to source system changes.
Keywords:
Application development; Cohort definition; Information systems; Medical informatics applications; Research query tool; System design and architecture
Authors: Griffin M Weber; Shawn N Murphy; Andrew J McMurry; Douglas Macfadden; Daniel J Nigrin; Susanne Churchill; Isaac S Kohane Journal: J Am Med Inform Assoc Date: 2009-06-30 Impact factor: 4.497
Authors: Rachel E Behrman; Joshua S Benner; Jeffrey S Brown; Mark McClellan; Janet Woodcock; Richard Platt Journal: N Engl J Med Date: 2011-01-12 Impact factor: 91.245
Authors: Nicholas Anderson; Aaron Abend; Aaron Mandel; Estella Geraghty; Davera Gabriel; Rob Wynden; Michael Kamerick; Kent Anderson; Julie Rainwater; Peter Tarczy-Hornoch Journal: J Am Med Inform Assoc Date: 2011-08-26 Impact factor: 4.497
Authors: Jie Xu; Luke V Rasmussen; Pamela L Shaw; Guoqian Jiang; Richard C Kiefer; Huan Mo; Jennifer A Pacheco; Peter Speltz; Qian Zhu; Joshua C Denny; Jyotishman Pathak; William K Thompson; Enid Montague Journal: J Am Med Inform Assoc Date: 2015-07-29 Impact factor: 4.497
Authors: Thomas L Ortel; Katie Arnold; Michele Beckman; Audrey Brown; Nimia Reyes; Ibrahim Saber; Ryan Schulteis; Bhavana Pendurthi Singh; Andrea Sitlinger; Elizabeth H Thames Journal: Appl Clin Inform Date: 2019-07-31 Impact factor: 2.342
Authors: Li-Tzy Wu; Udi E Ghitza; Bryan C Batch; Michael J Pencina; Leoncio Flavio Rojas; Benjamin A Goldstein; Tony Schibler; Ashley A Dunham; Shelley Rusincovitch; Kathleen T Brady Journal: Drug Alcohol Depend Date: 2015-09-12 Impact factor: 4.492
Authors: Marion Hemmersbach-Miller; Barbara D Alexander; Debra L Sudan; Carl Pieper; Kenneth E Schmader Journal: Clin Transplant Date: 2019-03-28 Impact factor: 2.863
Authors: Marion Hemmersbach-Miller; Jason E Stout; Michael H Woodworth; Gary M Cox; Jennifer L Saullo Journal: Transpl Infect Dis Date: 2018-05-07 Impact factor: 2.228
Authors: Daniel L Edmonston; Kishan S Parikh; Sudarshan Rajagopal; Linda K Shaw; Dennis Abraham; Alexander Grabner; Matthew A Sparks; Myles Wolf Journal: Am J Kidney Dis Date: 2019-11-12 Impact factor: 8.860
Authors: Marion Hemmersbach-Miller; Barbara D Alexander; Debra L Sudan; Carl Pieper; Kenneth E Schmader Journal: Eur J Clin Microbiol Infect Dis Date: 2018-10-23 Impact factor: 3.267