Temporal query of attribute-value patient data: Utilizing the constraints of clinical studies

International Journal of Medical Informatics

Volumn 70, Issue 1, 2003, Pages 59-77

  Deshpande, Aniruddha M ^a   Brandt, Cynthia ^a   Nadkarni, Prakash M ^a  

^a YALE UNIVERSITY SCHOOL OF MEDICINE   (United States)

Author keywords

Clinical patient record systems; Clinical study data management systems; Entity attribute value databases; Temporal query

Indexed keywords

ALGORITHMS; DATA STORAGE EQUIPMENT; DATABASE SYSTEMS; DRUG THERAPY;

TEMPORAL QUERY ALGORITHMS;

PATIENT TREATMENT;

ALGORITHM; ARTICLE; CLINICAL STUDY; INFORMATION PROCESSING; MEDICAL RECORD; MODEL; PATIENT CODING; PRIORITY JOURNAL;

EID: 0037394357     PISSN: 13865056     EISSN: None     Source Type: Journal    
DOI: 10.1016/S1386-5056(02)00183-1     Document Type: Article

References (29)

1. Nadkarni P.M., Brandt C., Frawley S., et al. Managing attribute-value clinical trials data using the ACT/DB client-server database system. J. Am. Med. Inform. Assoc. 5:(2):1998;139-151.
2. Brandt C., Nadkarni P., Marenco L., et al. Reengineering a database for clinical trials management: lessons for system architects. Control. Clin. Trials. 21:(5):2000;440-461.
3. Shahar Y., Chen H., Stites D.P., et al. Semi-automated entry of clinical temporal-abstraction knowledge. J. Am. Med. Inform. Assoc. 6:(6):1999;494-511.
4. Shahar Y., Musen M. Knowledge-based temporal abstraction in clinical domains. Artif. Intell. Med. 8:(3):1996;267-298.
5. Shahar Y., Cheng C. Intelligent visualization and exploration of time-oriented clinical data. Top. Health Inf. Manage. 20:(2):1999;15-31.
6. Nigrin D., Kohane I. Temporal expressiveness in querying a time-stamp-based clinical database. J. Am. Med. Inform. Assoc. 7:2000;152-163.
7. Shoham Y., McDermott D. Problems in formal temporal reasoning. Artif. Intell. 36:(1):1988;49-61.
8. Shoham Y. Reasoning About Change: Time and Causation from the Standpoint of Artificial Intelligence. 1988;MIT Press, Cambridge, MA.
9. Allen J.F. Maintaining knowledge of temporal intervals. Commun. ACM. 26:1983;832-843.
10. Das A.K., Musen M.A. A temporal query system for protocol-directed decision support. Methods Inform. Med. 33:(4):1994;358-370.
11. A.K. Das, Y. Shahar, S.W. Tu, M.A. Musen, A temporal abstraction mediator for protocol-based decision support, in: Proceedings of the 18th Symposium on Computer Applications in Medical Care, Baltimore, MD, 1994.
12. Das A.K., Musen M.A. A comparison of the temporal expressiveness of three database query methods. Annual Symposium on Computer Applications in Medical Care. 1995;IEEE Press, Los Alamitos, CA.
13. Shahar Y. A framework for knowledge-based temporal abstraction. Artif. Intell. 90:1997;79-133.
14. Snodgrass R.T., Ahn I., Ariav G., et al. TSQL2 language specification. ACM SIGMOD Rec. 23:(1):1994;65-86.
15. Snodgrass R.T., Boehlen M.H., Jensen C.S., et al. Adding Valid Time to SQL Temporal. ANSI Experts' Contribution. 1996;International Organization for Standardization, Geneva, Switzerland.
16. Snodgrass R.T., Boehlen M.H., Jensen C.S., et al. Adding Transaction time to SQL Temporal. ANSI Experts' Contribution. 1996;International Organization for Standardization, Geneva, Switzerland.
17. Niedner C.D. The entity-attribute-value data model in radiology informatics. Proceedings of the 10th Conference on Computer Applications in Radiology, Anaheim, CA. 1990;Symposia Foundation, Carlsbad, CA.
18. Huff S.M., Berthelsen C.L., Pryor T.A., et al. Evaluation of a SQL model of the help patient database. Proceedings of the 15th Symposium on Computer Applications in Medical Care, Washington, DC. 1991;IEEE Computer Press, Los Alamitos, CA.
19. Huff S.M., Haug D.J., Stevens L.E., et al. HELP the next generation: a new client-server architecture. Proceedings of the 18th Symposium on Computer Applications in Medical Care, Washington, DC. 1994;IEEE Computer Press, Los Alamitos, CA.
20. 3M Health Information Systems, 3M Clinical Data Repository, 3M Corporation, Murray, UT, 2002.
21. Friedman C., Hripcsak G., Johnson S., et al. A generalized relational schema for an integrated clinical patient database. Proceedings of the 14th Symposium on Computer Applications in Medical Care, Washington, DC. 1990;IEEE Computer Press, Los Alamitos, CA.
22. Johnson S., Cimino J., Friedman C., et al. Using metadata to integrate medical knowledge in a clinical information system. Proceedings of the 14th Symposium on Computer Applications in Medical Care, Washington, DC. 1990;IEEE Computer Press, Los Alamitos, CA.
23. Kahn M.G., Tu S., Fagan L.M. TQuery: a context-sensitive temporal query language. Comput. Biomed. Res. 24:(5):1991;401-419.
24. Deshpande A., Brandt C., Nadkarni P. Metadata-driven ad hoc query of patient data: meeting the needs of clinical studies. J. Am. Med. Inform. Assoc. 9:(4):2002;369-382.
25. Combi C., Cucchi G., Pinciroli F. Applying object-oriented technologies in modeling and querying temporally oriented clinical databases dealing with temporal granularity and indeterminacy. IEEE Trans. Inf. Technol. Biomed. 1:(2):1997;100-127.
26. Aho A.V., Sethi R., Ullman J.D. Section 2.3: syntax-directed translation. Compilers: Principles, Techniques, Tools. 1988;33-40 Addison-Wesley, Reading, MA.
27. Garcia-Molina H., Ullman J., Widom J. Database Systems Implementation. 2000;Prentice Hall, Upper Saddle River, NJ.
28. M.J. O'Connor, S. Tu, M. Musen, Applying temporal joins to clinical databases, in: Proceedings of the AMIA Fall Symposium, 1999.
29. Date C.J. An Introduction to Database Systems. 9th ed. 2001;Addison-Wesley, Reading, MA.