Temporal expressiveness in querying a time-stamp--based clinical database

• Published in: Journal of the American Medical Informatics Association : JAMIA Vol. 7; no. 2; pp. 152 - 163
• Main Authors: Nigrin, D J, Kohane, I S
• Format: Journal Article
• Language: English
• Published: England American Medical Informatics Association 01.03.2000
• Subjects: Database Management Systems; Databases as Topic - organization & administration; Hospital Information Systems - organization & administration; Humans; Information Storage and Retrieval - methods; Medical Records Systems, Computerized - classification; Medical Records Systems, Computerized - organization & administration; Programming Languages; The Practice of Informatics; Time
• ISSN: 1067-5027; 1527-974X
• DOI: 10.1136/jamia.2000.0070152

Most health care databases include time-stamped instant data as the only temporal representation of patient information. Many previous efforts have attempted to provide frameworks in which medical databases could be queried in relation to time. These, however, have required either a sophisticated database representation of time, including time intervals, or a time-stamp-based database coupled with a nonstandard temporal query language. In this work, the authors demonstrate how their previously described data retrieval application, DXtractor, can be used as a database querying application with expressive power close to that of temporal databases and temporal query languages, using only standard SQL and existing time-stamp-based repositories. DXtractor provides the ability to compose temporal queries through an interface that is understood by nonprogramming medical personnel. Not all temporal constructs are easily implemented using this framework; nonetheless, DXtractor's temporal capabilities provide a significant improvement in the temporal expressivity accessible to clinicians using standard time-stamped clinical databases.