The Development of Health Care Data Warehouses to Support Data Mining

Clinics in Laboratory Medicine

Volumn 28, Issue 1, 2008, Pages 55-71

  Lyman, Jason A ^a,b   Scully, Kenneth ^a,b   Harrison Jr , James H ^a,b  

^a UNIVERSITY OF VIRGINIA   (United States)

^b UNIVERSITY OF VIRGINIA   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ACCESS TO INFORMATION; CLINICAL DATA REPOSITORY; CLINICAL STUDY; COMPUTER PROGRAM; CONFIDENTIALITY; DATA BASE; DATA EXTRACTION; DATA MINING; DATA STORAGE DEVICE; HEALTH CARE SYSTEM; INFORMATION PROCESSING; LARGE SCALE PRODUCTION; MEDICAL INFORMATION; MEDICAL INFORMATION SYSTEM; MEDICAL RESEARCH; ONLINE ANALYTICAL PROCESSING; ORGANIZATION AND MANAGEMENT; PRIORITY JOURNAL; PRIVACY; PROGRAM DEVELOPMENT; REVIEW;

ARTIFICIAL INTELLIGENCE; DATABASE MANAGEMENT SYSTEMS; DATABASES, FACTUAL; DELIVERY OF HEALTH CARE; HUMANS; MEDICAL INFORMATICS; PATTERN RECOGNITION, AUTOMATED;

EID: 37849004680     PISSN: 02722712     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.cll.2007.10.003     Document Type: Review

References (43)

1. Dewitt J.G., and Hampton P.M. Development of a data warehouse at an academic health system: knowing a place for the first time. Acad Med 80 (2005) 1019-1025
2. Kamal J., Pasuparthi K., Rogers P., et al. Using an information warehouse to screen patients for clinical trials: a prototype. Proc AMIA Symp (2005) 1004
3. Bock B.J., Dolan C.T., Miller G.C., et al. The data warehouse as a foundation for population-based reference intervals. Am J Clin Pathol 120 (2003) 662-670
4. Einbinder J.S., Scully K.W., Pates R.D., et al. Case study: a data warehouse for an academic medical center. J Healthc Inf Manag 15 (2001) 165-175
5. Tusch G., Muller M., Rohwer-Mensching K., et al. Data warehouse and data mining in a surgical clinic. Stud Health Technol Inform 77 (2000) 784-789
6. Wisniewski M.F., Kieszkowski P., Zagorski B.M., et al. Development of a clinical data warehouse for hospital infection control. J Am Med Inform Assoc 10 (2003) 454-462
7. Murphy S.N., Morgan M.M., Barnett G.O., et al. Optimizing healthcare research data warehouse design through past COSTAR query analysis. Proc AMIA Symp (1999) 892-896
8. Verma R., and Harper J. Life cycle of a data warehousing project in healthcare. J Healthc Inf Manag 15 (2001) 107-117
9. Berndt D.J., Hevner A.R., and Studnicki J. The catch data warehouse: support for community health care decision-making. Decision Support Systems 35 3 (2003) 367-384
10. Sittig DF, Pappas J, Rubalcaba P. Building and using a clinical data repository. Available at: http://www.informatics-review.com/thoughts/cdr.html. Accessed April 23, 2007.
11. Kimball R. The data warehouse toolkit (1996), John Wiley & Sons, Inc., New York, NY
12. McNamee L.A., Launsby B.D., Frisse M.E., et al. Scaling an expert system data mart: more facilities in real-time. Proc AMIA Symp (1998) 498-502
13. Brandt C.A., Morse R., Matthews K., et al. Metadata-driven creation of data marts from an EAV-modeled clinical research database. Int J Med Inform 65 (2002) 225-241
14. Rob P., and Coronel C. Database systems: design, implementation, and management. 7th edition (2007), Thomson/Course Technology, Boston
15. Inmon W.H. Building the data warehouse. 4th edition (2005), Wiley, Indianapolis (IN)
16. Prather J.C., Lobach D.F., Goodwin L.K., et al. Medical data mining: knowledge discovery in a clinical data warehouse. Proc AMIA Symp (1997) 101-105
17. Goodwin L.K., and Iannacchione M.A. Data mining methods for improving birth outcomes prediction. Outcomes Manag 6 (2002) 80-85
18. Cao H., Markatou M., Melton G.B., et al. Mining a clinical data warehouse to discover disease-finding associations using co-occurrence statistics. Proc AMIA Symp (2005) 106-110
19. Mullins I.M., Siadaty M.S., Lyman J., et al. Data mining and clinical data repositories: insights from a 667,000 patient data set. Comput Biol Med 36 (2006) 1351-1377
20. Humphries K.H., Rankin J.M., Carere R.G., et al. Co-morbidity data in outcomes research: are clinical data derived from administrative databases a reliable alternative to chart review?. J Clin Epidemiol 53 (2000) 343-349
21. Iezzoni L.I. Assessing quality using administrative data. Ann Intern Med 127 (1997) 666-674
22. Gorla N. Features to consider in a data warehousing system. Commun ACM 46 11 (2003) 111-115
23. Weber R, Schek H, Blott S. A quantitative analysis and performance study for similarity-search methods in high-dimensional spaces. VLDB'98, Proceedings of the twenty fourth International Conference on Very Large Data Bases; 1998. p. 194-205.
24. Levene M., and Loizou G. Why is the snowflake schema a good data warehouse design?. Information Systems 28 3 (2003) 225-240
25. Nadkarni P.M., and Brandt C. Data extraction and ad hoc query of an entity-attribute-value database. J Am Med Inform Assoc 5 (1998) 511-527
26. Breen C., and Rodrigues L.M. Implementing a data warehouse at Inglis Innovative Services. J Healthc Inf Manag 15 (2001) 87-97
27. Murphy S.N., Gainer V., and Chueh H.C. A visual interface designed for novice users to find research patient cohorts in a large biomedical database. Proc AMIA Symp (2003) 489-493
28. Ledbetter C.S., and Morgan M.W. Toward best practice: leveraging the electronic patient record as a clinical data warehouse. J Healthc Inf Manag 15 (2001) 119-131
29. Nigrin D.J., and Kohane I.S. Scaling a data retrieval and mining application to the enterprise-wide level. Proc AMIA Symp (1999) 901-905
30. Corwin J., Silberschatz A., Miller P.L., et al. Dynamic tables: an architecture for managing evolving, heterogeneous biomedical data in relational database management systems. J Am Med Inform Assoc 14 (2007) 86-93
31. Lyman J.A., Scully K., Tropello S., et al. Mapping from a clinical data warehouse to the HL7 reference information model. Proc AMIA Symp (2003) 920
32. HL7. Health level 7. Available at: http://www.hl7.org. Accessed June 15, 2007.
33. Nardon F.B., and Moura L.A. Knowledge sharing and information integration in healthcare using ontologies and deductive databases. Medinfo 11 Pt 1 (2004) 62-66
34. Khan A.N., Griffith S.P., Moore C., et al. Standardizing laboratory data by mapping to LOINC. J Am Med Inform Assoc 13 3 (2006) 353-355
35. Berman J.J. Concept-match medical data scrubbing. How pathology text can be used in research. Arch Pathol Lab Med 127 (2003) 680-686
36. National Institutes of Health. Clinical research and the HIPAA privacy rule. Available at: http://privacyruleandresearch.nih.gov/clin_research.asp. Accessed June 18, 2007.
37. Schell S.R. Creation of clinical research databases in the 21st century: a practical algorithm for HIPAA compliance. Surg Infect (Larchmt) 7 1 (2006) 37-44
38. El Emam K., Jabbouri S., Sams S., et al. Evaluating common de-identification heuristics for personal health information. J Med Internet Res 8 4 (2006) E28
39. Gupta D., Saul M., and Gilbertson J. Evaluation of a deidentification (de-id) software engine to share pathology reports and clinical documents for research. Am J Clin Pathol 121 (2004) 176-186
40. Beckwith B.A., Mahaadevan R., Balis U.J., et al. Development and evaluation of an open source software tool for deidentification of pathology reports. BMC Med Inform Decis Mak 6 (2006) 12-21
41. Nadkarni P., Chen R., and Brandt C. UMLS concept indexing for production databases: a feasibility study. J Am Med Inform Assoc 8 (2001) 80-91
42. Hazlehurst B., Frost H.R., Sittig D.F., et al. MediClass: a system for detecting and classifying encounter-based clinical events in any electronic medical record. J Am Med Inform Assoc 12 (2005) 517-529
43. McDonald C.J., Dexter P., Schadow G., et al. SPIN query tools for de-identified research on a humongous database. Proc AMIA Symp (2005) 515-519