Metadata-driven creation of data marts from an EAV-modeled clinical research database

International Journal of Medical Informatics

Volumn 65, Issue 3, 2002, Pages 225-241

  Brandt, Cynthia A ^a   Morse, Richard ^a   Matthews, Keri ^a   Sun, Kexin ^a   Deshpande, Aniruddha M ^a   Gadagkar, Rohit ^a   Cohen, Dorothy B ^a   Miller, Perry L ^a   Nadkarni, Prakash M ^a  

^a YALE UNIVERSITY SCHOOL OF MEDICINE   (United States)

Author keywords

Clinical study data management systems; Data marts; Entity Attribute Value databases

Indexed keywords

DATA RECORDING; METADATA;

CLINICAL STUDY;

DATABASE SYSTEMS;

AUTOMATION; DATA BASE; ERROR; MEDICAL INFORMATICS; MEDICAL INFORMATION; MEDICAL RESEARCH; MODEL; PRIORITY JOURNAL; REVIEW;

BREAST NEOPLASMS; DATABASE MANAGEMENT SYSTEMS; DATABASES; FEMALE; HUMANS; INFORMATION STORAGE AND RETRIEVAL; MEDICAL INFORMATICS APPLICATIONS; SOFTWARE;

EID: 0037069315     PISSN: 13865056     EISSN: None     Source Type: Journal    
DOI: 10.1016/S1386-5056(02)00047-3     Document Type: Article

References (27)

1. Cancer Genetics Network, NCI, National Cancer Institute, available from http://epi.grants.cancer.gov/CGN/, last accessed on 6/11/2002.
2. D.J. Nigrin, I.S. Kohane, Data mining by clinicians, Proceedings of the AMIA Symposium, 1998 pp. 957-961.
3. A. Wilcox, G. Hripcsak, C. Chen, Creating an environment for linking knowledge-based systems to a clinical database: A suite of tools, Proceedings of the AMIA Annual Fall Symposium, 1997 pp. 303-307.
4. A. Wilcox, G. Hripcsak, CPMC Query Builder. 1998, available from http://www.cpmc.columbia.edu/arden/qbr/.
5. Banhart F., Klaeren H. A graphical query generator for clinical research databases. Methods Inf. Med. 34:(4):1995;328-339.
6. Hripcsak G., et al. Access to data: comparing AccessMed with Query by Review. J. Am. Med. Inform. Assoc. 3:(4):1996;288-299.
7. Safran C., Chute C.G. Exploration and exploitation of clinical databases. Int. J. Biomed. Comput. 39:(1):1995;151-156.
8. Deshpande A., Brandt C., Nadkarni P. Metadata-driven ad hoc query of patient data: meeting the needs of clinical studies. J. Am. Med. Info. Assoc. 9:(4):2002;369-382.
9. P. Wang, et al., The web enabled IHC enterprise data warehouse for clinical process improvement and outcomes measurement, in: 1997 AMIA Fall Symposium. 1997. Hanley & Belfus, Philadelphia, PA, Nashville, TN.
10. Dorda W., et al. ArchiMed: a medical information and retrieval system. Meth. Inf. Med. 38:(1):1999;16-24.
11. Gall W., Heinzl H., Sachs P. Extracting a statistical data matrix from electronic patient records. Comput. Meth. Prog. Biomed. 66:(2-3):2001;153-166.
12. A. Gouveia-Oliveira, Salgado N.C., A database system for integrated clinical trial management, control, statistical analysis and ICH-compliant reporting, Proceedings of the AMIA Symposium, 1999, pp. 72-76.
13. N.C. Salgado, A. Gouveia-Oliveira, Towards a common framework for clinical trials information systems, Proceedings of the AMIA Symposium, 2000 pp. 754-758.
14. Clinical Data Interchange Standards Consortium, C.D.I.S., Specification for the Operational Data Model (ODM) 2002, available from http://www.cdisc.org-/models/odm/v1.1/odm1-1-0.html, Last accessed on: July 1,2002.
15. 3M Health Information Systems, The 3M Clinical Data Repository. 1998: Murray, UT, USA, available from http://www.3m.com/market/healthcare/his/us/products/care_inno/.
16. S.M. Huff, et al., Evaluation of a SQL Model of the Help Patient Database, in: Proceedings of the 15th Symposium on Computer Applications in Medical Care 1991, IEEE Computer Press, Los Alamitos, CA, Washington, DC.
17. S.M. Huff, et al., HELP the next generation: A new client-server architecture, in: Proceedings of the 18th Symposium on Computer Applications in Medical Care 1994, IEEE Computer Press, Los Alamitos, CA, Washington, DC.
18. S. Johnson, et al., Using metadata to integrate medical knowledge in a clinical information system, in: Proceedings of the 14th Symposium on Computer Applications in Medical Care 1990., IEEE Computer Press, Los Alamitos, CA, Washington, DC.
19. C. Friedman, et al., A generalized relational schema for an integrated clinical patient database, in: Proceedings of the 14th Symposium on Computer Applications in Medical Care 1990, IEEE Computer Press, Los Alamitos, CA, Washington, DC.
20. Chen R.S., et al. Exploring performance issues for a clinical database organized using an entity-attribute-value representation. J. Am. Med. Inform. Assoc. 7:(5):2000;475-487.
21. Nadkarni P., Brandt C. Data extraction and ad hoc query of an Entity-Attribute-Value Database. J. Am. Med. Info. Assoc. 5:(6):1998;511-527.
22. Sedgewick R. Algorithms in C++. third ed. 2002;Addison-Wesley, Reading, MA.
23. Date C.J. An Introduction to Database Systems. ninth ed. 2001;Addison-Wesley, Reading, MA.
24. Ruberg S., McDonald M., Wolfred M. A proposal and challenge for a new approach to integrated electronic solutions. Appl. Clin. Trials. February:2002;42-49.
25. d'Hollosy W., et al. Semi-automated database design by the end-user. Meth. Inf. Med. 34:(3):1995;266-271.
26. Thomsen E. OLAP Solutions: Building Multidimensional Information Systems. 2000;Wiley, New York, NY.
27. Inmon W., Rudin K., Buss C., Anmon W., Sousa R. Data Warehouse Performance. 1998;Wiley, New York.