Version 2.5.2.0

Abstract

Grant Number:	5R01LM006843-02
Project Title:	ROBUST QUERY OF HETEROGENEOUS CLINICAL DATABASES

PI Information:	Name	Email	Title
	NADKARNI, PRAKASH M.	prakash.nadkarni@yale.edu	ASSOCIATE PROFESSOR

Abstract: This proposal aims to devise algorithms for ad hoc (non-real-time) query of heterogeneous electronic patient record systems (EPRSs) that store patient data in at least three forms: Conventional relational structure, with an attribute represented by a column in a table, Entity-Attribute-Value (EAV) form, where one or more tables record information that includes entity (Patient, Date/Time of Event, etc.), the name or ID of the Attribute on which information is to be stored, and the value corresponding to that attribute, Free text or quasi-structured textual information, such as discharge summaries, and surgical operation notes. The proposed work will evaluate these algorithms in at least two production systems, ACT/DB and a pilot data warehouse at the West Haven, CT, Veterans Administration Medical Center. The user interface will be Web-based and will be designed for expressive power as well as ease of use by analysts who are non-database professionals. Additional research issues will involve integration of the query system with one or more controlled medical vocabularies, integration of information-retrieval (IR) technology with relational database (RDBMS) technology to provide advanced query functionality, and support of complex temporal queries on the data. Finally, the proposed work will explore architectural issues impacting the efficiency of the query process. In particular, research will be performed on utilization of newer database technologies, such as new indexing methods, as well as parallel database implementations.

Public Health Relevance:
This Public Health Relevance is not available.

Thesaurus Terms:
computer system design /evaluation, health care facility information system, information system analysis
computer program /software, indexing, information retrieval, patient /disease registry, vocabulary development for information system
human data

Institution:	YALE UNIVERSITY
	47 COLLEGE STREET, STE 203
	NEW HAVEN, CT 065208047
Fiscal Year:	2001
Department:	CENTER FOR MEDICAL INFORMATICS
Project Start:	01-FEB-2000
Project End:	31-JAN-2003
ICD:	NATIONAL LIBRARY OF MEDICINE
IRG:	BLR

---