Rapid Prototyping Strategy for a Surgical Data Warehouse

Summary

Objectives: Healthcare processes typically generate an enormous volume of patient information. This information largely represents unexploited knowledge, since current hospital operational systems (e.g., HIS, RIS) are not suitable for knowledge exploitation. Data warehousing provides an attractive method for solving these problems, but the process is very complicated. This study presents a novel strategy for effectively implementing a healthcare data warehouse.

Methods: This study adopted the rapid prototyping (RP) method, which involves intensive interactions. System developers and users were closely linked throughout the life cycle of the system development. The presence of iterative RP loops meant that the system requirements were increasingly integrated and problems were gradually solved, such that the prototype system evolved into the final operational system.

Results: The results were analyzed by monitoring the series of iterative RP loops. First a definite workflow for ensuring data completeness was established, taking a patient-oriented viewpoint when collecting the data. Subsequently the system architecture was determined for data retrieval, storage, and manipulation. This architecture also clarifies the relationships among the novel system and legacy systems. Finally, a graphic user interface for data presentation was implemented.

Conclusions: Our results clearly demonstrate the potential for adopting an RP strategy in the successful establishment of a healthcare data warehouse. The strategy can be modified and expanded to provide new services or support new application domains. The design patterns and modular architecture used in the framework will be useful in solving problems in different healthcare domains.

Keywords

Databases - data collection - integrated information - systems integration

• References

• 1 Young ST, Chang JS. Implementation of a patient-centred and physician-oriented health-care information system. Med Inform (Lond) 1997; 22: 207-14.
• 2 Graves C, Scott M, Benkovich M. et al. Professional SQL server 2000 data warehousing with analysis services. Wrox Press; Birmingham, UK: 2001
• 3 Adhikari R. Migrating legacy data: how to get there from here. Software Mag 1996; 16: 75-80.
• 4 Srivastava J, Chen PY. Warehouse creation – a potential roadblock to data warehousing. IEEE Trans Knowl Data Eng 1999; 11: 118-26.
• 5 Sakaguchi T, Frolick MN. A review of the data warehousing literature. J Data Warehousing 1997; 2: 34-54.
• 6 Wong ST, Hoo Jr KS, Knowlton RC. et al. Design and applications of a multimodality image data warehouse framework. J Am Med Inform Assoc 2002; 9: 239-54.
• 7 Breen C, Rodrigues LM. Implementing a data warehouse at Inglis Innovative Services. J Healthc Inf Manag 2001; 15: 87-97.
• 8 Shams K, Farishta M. Data warehousing: toward knowledge management. Top Health Inf Manage 2001; 21: 24-32.
• 9 Stead WW, Miller RA, Musen MA, Hersh WR. Integration and beyond: linking information from disparate sources and into workflow. J Am Med Inform Assoc 2000; 7: 135-45.
• 10 Silver M, Sakata T, Su HC. et al. Case study: how to apply data mining techniques in a healthcare data warehouse. J Healthc Inf Manag 2001; 15: 155-64.
• 11 Junger A, Benson M, Quinzio L. et al. An anesthesia information management system (AIMS) as a tool for controlling resource management of operating rooms. Methods Inf Med 2002; 41: 81-85.
• 12 van der Lei J. Closing the loop between clinical practice, research, and education: the potential of electronic patient records. Methods Inf Med 2002; 41: 51-4.
• 13 American Society for Testing and Materials. E1340-96 Standard guide for rapid prototyping of computerized systems. West Conshohocken, PA: 1996: 1-11.
• 14 Vassilacopoulos G, Chrissikopoulos V, Alexandris N, Tsouroplis A. Participative HIS development: an approach and a case study. J Med Syst 1996; 20: 157-65.
• 15 Adelhard K, Holzel D, Uberla K. Design elements for a computerized patient record. Methods Inf Med 1999; 38: 187-93.
• 16 Kaplan B. Culture counts: how institutional values affect computer use. MD Comput 2000; 17: 23-6.
• 17 Kay S. Towards relevant medical information systems. Med Inform (Lond) 1990; 15: 327-31.
• 18 Lorenzi NM, Riley RT. Managing change: an overview. J Am Med Inform Assoc 2000; 7: 116-24.
• 19 Dugas M, Schauer R, Volk A, Rau H. Interactive decision support in hepatic surgery. BMC Med Inform Decis Mak 2002; 2: 5.
• 20 Kinzie MB, Cohn WF, Julian MF, Knaus WA. A user-centered model for web site design: needs assessment, user interface design, and rapid prototyping. J Am Med Inform Assoc 2002; 9: 320-30.