Data extraction and ad hoc query of an entity-attribute-value database

Journal of the American Medical Informatics Association

Volumn 5, Issue 6, 1998, Pages 511-527

  Nadkarni, Prakash M ^a,b   Brandt, Cynthia ^a  

^a YALE UNIVERSITY   (United States)

^b YALE UNIVERSITY SCHOOL OF MEDICINE   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ARTICLE; CLINICAL TRIAL; DATA BASE; INFORMATION PROCESSING; INFORMATION RETRIEVAL; MEDICAL RECORD;

EID: 0031743090     PISSN: 10675027     EISSN: None     Source Type: Journal    
DOI: 10.1136/jamia.1998.0050511     Document Type: Article

References (31)

1. The 3M Clinical Data Repository. Murray, Utah: 3M Health Information Systems, 1998.
2. Huff SM, Haug DJ, Stevens LE, Dupont CC, Pryor TA. HELP the next generation: a new client-server architecture. Proc 18th Symp Comput Appl Med Care. 1994:271-5.
3. Huff SM, Berthelsen CL, Pryor TA, Dudley AS. Evaluation of a SQL model of the HELP patient database. Proc 15th Symp Comput Appl Med Care. 1991:386-90.
4. Friedman C, Hripcsak G, Johnson S, Cimino J, Clayton P. A generalized relational schema for an integrated clinical patient database. Proc 14th Symp Comput Appl Med Care. 1990:335-9.
5. Johnson S, Cimino J, Friedman C, Hripcsak G, Clayton P. Using metadata to integrate medical knowledge in a clinical information system. Proc 14th Symp Comput Appl Med Care. 1990:340-4.
6. Nadkarni PM, Brandt C, Frawley S, et al. ACT/DB: a client-server database for managing entity-attribute-value clinical trials data. J Am Med Inform Assoc. 1998;5(2):139-51.
7. Cimino JJ, Clayton PD, Hripcsak G, Johnson SB. Knowledge-based approaches to the maintenance of a large controlled medical terminology. J Am Med Inform Assoc. 1994; 1:35-50.
8. Date CJ, McGoveran D. A guide to the SQL standard. Reading, Mass.: Addison-Wesley, 1992.
9. Sybase Inc. System 11 Reference. Vol 1. Emeryville, Calif.: Sybase, 1996.
10. Melton J, Simon AR. Understanding the new SQL: a complete guide. San Mateo, Calif.: Morgan Kaufman, 1993.
11. Celko J. Everything you know is wrong. DBMS Magazine. 1996;9(9):18-20.
12. Prather JC, Lobach DF, Hales JW, Hage ML, Fehrs SJ, Hammond WE. Converting a legacy system database into relational format to enhance query efficiency. Proc AMIA Annu Fall Symp. 1995:372-6.
13. Darwen H, Date C. Introducing the Third Manifesto. Database Programming and Design. 1995;8(1):10-14.
14. Wilcox A, Hripcsak G. CPMC Query Builder. Available at: http://www.cpmc.columbia.edu/arden/qbr/. Accessed Sep 1998.
15. Hripcsak G. Writing Arden Syntax Medical Logic Modules. Comput Biol Med. 1994;24(5):331-63.
16. Wang P, Pryor TA, Narus S, Hardman R, Deavila M. The Web-enabled IHC enterprise data warehouse for clinical process improvement and outcomes measurement. Proc AMIA Annu Fall Symp. 1997:1028.
17. 17: Kimball R. The Data Warehousing Toolkit. New York: John Wiley, 1997.
18. McKie S. Software agents: application intelligence goes undercover. DBMS Magazine. 1995;8(4):56-60.
19. Ludemann P, Wilcox A, Hripcsak G. Standard specification for defining and sharing modular health knowledge bases (Arden Syntax for Medical Logic Modules), version 4. Philadelphia, Pa.: American Society for Testing Materials, 1997. Also available at: http://www.cpmc.columbia.edu/ arden/.
20. Nadkarni PM, Cheung KH. SQLGEN: an environment for rapid client-server database application development. Comput Biomed Res. 1995;28(12):479-99.
21. Aho AV, Sethi R, Ullman JD. Section 2.3: Syntax-Directed Translation. Compilers: Principles, Techniques, Tools. Reading, Mass.: Addison-Wesley, 1988:33-40.
22. Nadkarni PM. Concept Locator: A client-server application for retrieval of UMLS Metathesaurus concepts through complex Boolean query. Comput Biomed Res. 1997;30: 323-36.
23. Ullman JD. Principles of database and knowledge-base systems. Rockville, Md.: Computer Science Press, 1989.
24. Date CJ. Selected Database Readings, 1985-1989. 7th ed. Reading, Mass.: Addison-Wesley, 1990.
25. Elkins SB. Open OLAP. DBMS Magazine. 1998;11(4):34-8.
26. Lindberg DAB, Humphreys BL, McCray AT. The Unified Medical Language System. Methods Inform Med. 1993;32: 281-91.
27. Chen H, Ng TD, Martinez J, Schatz BR. Concept space approach to addressing the vocabulary problem in scientific information retrieval: an experiment on the worm community system. J Am Soc Inform Sci. 1997;48(1):17-31.
28. Das AK, Musen MA. A temporal query system for protocoldirected decision support. Methods Inform Med. 1994;33(4): 358-70.
29. Das AK, Musen MA. A comparison of the temporal expressiveness of three database query methods. Proc 19th Annu Symp Comput Appl Med Care. 1995:331-7.
30. Snedgrass RT, Boehlen MH, Jensen CS, Steiner A. Adding Transaction Time to SQL Temporal: ANSI Experts' Contribution. Geneva, Switzerland: International Organization for Standardization, 1996.
31. Snodgrass RT, Boehlen MH, Jensen CS, Steiner A. Adding Valid Time to SQL Temporal: ANSI Experts' Contribution. Geneva, Switzerland: International Organization for Standardization, 1996.