Developing A Medical Intelligence System in Medical Data Warehouse

의료 데이터 웨어하우스에서의 Medical Intelligence 시스템 개발

  • Received : 2004.09.22
  • Accepted : 2004.10.14
  • Published : 2004.12.31

Abstract

This research discusses knowledge contents needed to build an OLAP system for medical sector, OLAP functionalities from past studies, and a medical intelligence system which is a kind of OLAP. The knowledge requirements which consist of nine contents and OLAP fundamental functionalities are applied to the system. Most past studies have focused on developing a medical data warehouse rather than OLAP. The medical intelligence system supplies health care providers (i.e., doctors, clinicians, researchers and nurses) and non-providers (i.e., managers and business analysts) with multidimensional OLAP functionalities. The system can be used to gain a deeper understanding of specific medical issues. In this research, we focus not on medical data warehouse, but on the technical challenges of designing and implementing an effective medical intelligence system for health care information. An architecture is applied to developing the medical intelligence system for a medical center in order to illustrate its practical usage. Six packages in the developed system are discussed in this research: Explorer, Analyzer, Reporter, Statistician, Visualizer, and Meta Administrator packages. Evaluation of the system and ongoing research directions conclude the research.

Keywords

References

  1. 김기운, 서용무(2001), OLAP 도구 선정을 위한 평가항목 제시 및 검증, 경영학연구, 30(3), 929-956
  2. 김도경, 박성미, 정윤기, 이배호(2004), 원무관리를 위한 의사결정지원시스템 개발 및 데이터 마트의 구축, 대한의료정보학회지, 10(3)
  3. 김태훈, 김종호, 이희석 (2000), 메타데이터 기반 데이터 웨어하우스 아키텍쳐 -ㅅ병원 사례를 중심으로 경영정보학연구, 10(3), 79-103
  4. 송운호, 조용구, 강석중(1994), 국방 의료체계 구축방안 연구, 정보화저널, 1(2)
  5. 범희승, 박성희, 신찬호(2001), 핵의학영상 관리를 위한 미니 데이터 웨어하우징, 대한의료정보학회지, 7(3), 59-64
  6. 이희석, 김태훈, 최승현, 김인숙, 김종호, 홍정우(2001), HL7기반 의료정보 아키텍쳐 개발, Information Systems Review, 3(1), 159-175
  7. 장동인(1999), 실무자를 위한 데이터 웨어하우스, 대청
  8. 조재희, 박성진 (1996), 데이터 웨어하우칭과 OLAP , 대청 출판사
  9. 최진욱, 이연화, 김기중, 김주성, 박중신, 송정한, 이은주, 김선구, 김종득, 김성권 (2001), 데이터웨어하우스를 이용한 국내 임상자료의 분석, 대한의료정보학회지, 7(1), 1-11
  10. 황성룡, 김재균, 장길상(2002), 조선산업의 비용분석 데이터 웨어하우스 시스템 개발, IE Interfaces, 15(2), 159-171
  11. Colossi, N., Malloy, W., and Reinwald, B.(2002), Relational Extensions for OLAP, IBM Systems Journal, 41(4), 714-731
  12. Damiani, S., Woodcock, D., Brophy, J., and Gillies, I.(2000), Supporting Seamless Patient Care using Web Based and OLAP Technology, Healthcare Information and Management Systems Society Conference Proceedings
  13. Gill, H. S. and Rao, P. C. (1996), Computing Guide to Data Warehousing, Que Corporation
  14. Hackney, D.(1997), Understanding and Implementing Successful Data Marts, Addison Wesley
  15. Hristovski, D., Rogac, M., and Markota, M.(2000), Using Data Warehousing and OLAP in Public Health Care, AMIA Annual Symposium
  16. Katie, N., Quirchmayr, G., Schiefer, J., Stolba, M., and Tjoa, A. M.(1998), A Prototype Model for Data Warehouse Security Based on Metadata, Proc. of IEEE 9th International Workshop on Database and Expert Systems Applications, 300-308
  17. Lee, H., Kim, T., and Kim, J.(2001), A Metadata-oriented Architecture for Building Data Warehouse, Journal of Database Management, 12(4), 15-25
  18. Murer, C. G. and Brick, L. L.(1997), The Case Management Sourcebook: A Guide to Designing and Implementing a Centralized Case Management System, McGraw-Hill
  19. Pedersen, T. B. and Jensen, C. S.(1998), Research Issues in Clinical Data Warehousing, Proc. of the 10th IEEE International Conference on Scientific and Statistical Database Management, 43-52
  20. Pendse, N.(2003), What is OLAP, The OLAP Report (http://www.olapreport.com/FASMI.HTM; White Paper)
  21. Thomsen, E.(1997), OLAP Solutions: Building Multidimensional Information Systems, John Wiley
  22. Youness, S.(2000), Professional Data Warehousing with SQL Server 7.0 and OLAP Services, Wrox Press