2003 Volume 23 Issue 2 Pages 159-164
By unifying and simplifying the system for the management of various kinds of medical information in different sections of a hospital, our team has developed a method of accessing useful information for the support of medical care and hospital management. We developed a Caché server created by Japan DynaSystems Inc., which was made to accumulate different medical information, and built a data warehouse. And we finally succeeded a system, in which medical records can be referred to by one hospitalization unit using a web form. Moreover, needed data in the Caché server was shifted to a Microsoft SQLServer2000. We also developed a system (CUBE) that allows multiple-dimension analysis through the use of Analysis Services, acts as a tool or function in the SQLServer2000. When we searched for information regarding patient number or condition, relevant patient care records could easily be accessed by the web form system. Such information could also be analyzed by PivotTable of Microsoft Excel even under the complex condition of the multiple-dimension analysis system. The structure of these systems and their evaluation are described in this paper. The further development and possibilities of the system is also discussed.
