The DEDUCE Guided Query tool: providing simplified access to clinical data for research and quality improvement.

Published

Journal Article

In many healthcare organizations, comparative effectiveness research and quality improvement (QI) investigations are hampered by a lack of access to data created as a byproduct of patient care. Data collection often hinges upon either manual chart review or ad hoc requests to technical experts who support legacy clinical systems. In order to facilitate this needed capacity for data exploration at our institution (Duke University Health System), we have designed and deployed a robust Web application for cohort identification and data extraction--the Duke Enterprise Data Unified Content Explorer (DEDUCE). DEDUCE is envisioned as a simple, web-based environment that allows investigators access to administrative, financial, and clinical information generated during patient care. By using business intelligence tools to create a view into Duke Medicine's enterprise data warehouse, DEDUCE provides a Guided Query functionality using a wizard-like interface that lets users filter through millions of clinical records, explore aggregate reports, and, export extracts. Researchers and QI specialists can obtain detailed patient- and observation-level extracts without needing to understand structured query language or the underlying database model. Developers designing such tools must devote sufficient training and develop application safeguards to ensure that patient-centered clinical researchers understand when observation-level extracts should be used. This may mitigate the risk of data being misunderstood and consequently used in an improper fashion.

Full Text

Duke Authors

Cited Authors

  • Horvath, MM; Winfield, S; Evans, S; Slopek, S; Shang, H; Ferranti, J

Published Date

  • April 2011

Published In

Volume / Issue

  • 44 / 2

Start / End Page

  • 266 - 276

PubMed ID

  • 21130181

Pubmed Central ID

  • 21130181

Electronic International Standard Serial Number (EISSN)

  • 1532-0480

International Standard Serial Number (ISSN)

  • 1532-0464

Digital Object Identifier (DOI)

  • 10.1016/j.jbi.2010.11.008

Language

  • eng