TQuery: a context-sensitive temporal query language.

Users of electronic medical databases request pertinent information by recasting their clinical questions into a formal database query language. Because the query language is the user's only access to the data, the query language must be powerful enough to enable users to express their data requirements. However, a competing need is for the query language to be restrictive enough so that queries can have unambiguous semantics and the query processor can generate correct answers. We describe a query language, called TQuery , that was designed specifically to formulate database queries that are dependent on temporal and contextual relationships. TQuery specifications express contextual constraints without the need to explicitly reference calendar dates. TQuery is the database query language used to retrieve patient data from an object-oriented electronic patient medical-record system called the temporal network (TNET). TNET and TQuery were developed to support the real-time temporal reasoning and representation needs of a LISP workstation-based medical expert system.

[1]  J B Adams Three surveillance and query languages for medical care. , 1986, M.D. computing : computers in medical practice.

[2]  Lawrence M. Fagan,et al.  Representation and Use of Temporal Information in ONCOCIN , 1985 .

[3]  C J McDonald,et al.  The Medical Gopher--a microcomputer system to help find, organize and decide about patient data. , 1986, The Western journal of medicine.

[4]  C. McDonald,et al.  Reminders to physicians from an introspective computer medical record. A two-year randomized trial. , 1984, Annals of internal medicine.

[5]  Rita D. Zielstorff,et al.  The medical query language , 1981 .

[6]  Q. Whiting-O'Keefe,et al.  A computerized summary medical record system can provide more information than the standard medical record. , 1985, JAMA.

[7]  Clement J. McDonald,et al.  The Regenstrief Medical Record System , 1977 .

[8]  Lawrence M. Fagan,et al.  Extensions to the Time-Oriented Database Model to Support Temporal Reasoning in Medical Expert Systems , 1991, Methods of Information in Medicine.

[9]  C J McDonald,et al.  The Regenstrief medical records. , 1988, M.D. computing : computers in medical practice.

[10]  C. McDonald Protocol-based computer reminders, the quality of care and the non-perfectability of man. , 1976, The New England journal of medicine.

[11]  G. Octo Barnett,et al.  Medical Query Language: Improved Access to MUMPS Databases , 1987 .

[12]  Lawrence M. Fagan,et al.  Episodic skeletal-plan refinement based on temporal data , 1989, CACM.