CDI Exclusive Queries

Clinical Data Integration Project

Exclusionary Query Risks in Health Care Databases

Other Pages:

2. Page 2: in development

3. Page 3: in development

Resources:

Harvey VJ, Ruzich CM, Baugh JM, Johnston BA, and Grant AJ, "The Challenge of Negation in Health Care Searches and Queries," Poster Session, November 11, 2003, at the 2003 Fall Symposium of the American Medical Informatics Association (AMIA), Washington, DC.. Abstract available online at : http://www.pubmedcentral.nih.gov/articlerender.fcgi?artid=1480075: “This poster deals with exclusionary queries implemented using the database language SQL and the VA FileMan database system and with retrieval searches involving negated concepts in medical narratives. The poster describes and presents error patterns in designing database queries, underlying comprehension issues regarding negative statements and queries, strategies and software for avoiding false positives in searches, and makes practical recommendations on identifying potential sources of error and avoiding incorrect or misleading results.”

Harvey VJ, Ruzich CM, Baugh JM, and Johnston BA, “Exclusionary Queries in Health Care,” WorldVista Community Event (health information technology conference), Greenbelt, Maryland, March 2003.

Harvey VJ, Ruzich CM, Baugh JM, Johnston BA, and Grant AJ, "The Challenge of Negation in Searches and Queries," The Review of Business Information Systems 7, 4 (Fall 2003): 63-75.

Harvey VJ, Ruzich CM, Baugh JM, Johnston BA, and Grant AJ, "The Challenge of Negation in Searches and Queries," 2003 International Applied Business Research Conference, Acapulco, Guerrero, México, March, 2003. Published in IABR conference proceedings. Award: best paper in session.

Clark, HH. Semantics and Comprehension Mouton, 1976.

Wright P, Bernard P. Effects of “More Than” and “Less Than” Decisions on the Use of Numerical Tables. Journal of Applied Psychology. 1975:60, 5: 606–611. Also Wright, P, Hull, AJ. Answering Questions about Negative Conditionals. Journal of Memory and Language. 1986;25:691–709.

Mutalik PG, Deshpands A, Nadkarni PM. Use of General-purpose Negation Detection to Augment Concept Indexing of Medical Documents: A Quantitative Study Using the UMLS. Proceedings of the American Medical Informatics Association 2001. 2001:598–609.

Chapman WW, Bridewell W, Hanbury P, Cooper GF, Buchanan BG. Evaluation of Negation Phrases in Narrative Clinical Reports. Proceedings of the American Medical Informatics Association Symposium 2001. 2001:105–109.

Melton, J, Simon, AR. SQL:1999: Understanding Relational Language Components. Morgan Kaufman, 2002

Updated: September 25, 2009