DOI QR코드

DOI QR Code

Study on Improving Oriental Medicine Statistical System for Multidimensional Statistical Data

  • Yea, Sang-Jun (Information Research Center, Korea Institute of Oriental Medicine) ;
  • Kim, Chul (Information Research Center, Korea Institute of Oriental Medicine) ;
  • Kim, Jin-Hyun (Information Research Center, Korea Institute of Oriental Medicine) ;
  • Jang, Hyun-Chul (Information Research Center, Korea Institute of Oriental Medicine) ;
  • Kim, Sang-Kyun (Information Research Center, Korea Institute of Oriental Medicine) ;
  • Song, Mi-Young (Information Research Center, Korea Institute of Oriental Medicine)
  • Received : 2011.07.27
  • Accepted : 2011.09.02
  • Published : 2011.09.28

Abstract

Oriental medicine statistics are essential in research planning, research evaluation, and policy decision based on objective data. However, integrated administration of such statistics is not presently possible in the oriental medicine field, which has been slow in incorporating information communication technology. In an effort to address this problem, the Korea Institute of Oriental Medicine (KIOM) developed an oriental medicine statistical system in 2009, and the system has been offered in the traditional medicine information portal of OASIS. However, according to a 2010 survey targeting OASIS users, those surveys reported that needs for a system where various statistical data can be extracted via an interactive approach to multidimensional data. As a result of an analysis of the functions of the existing system, it was found that it is necessary to array and arithmetically analyze Stats Value, Drill Up & Drill Down, and Pivot. To this end, the existing DB schema should be redesigned. Based on our analysis result, we redesigned the database into a structure that is applicable to the reverse pivot algorithm. We used J2EE/JSP and a Flex framework to design and develop an oriental medicine statistical system that can provide multidimensional statistical data. Considering that the improved oriental medicine statistical system is planned to be offered by OASIS of KIOM, utilization and value of oriental medicine statistical data are expected to be enhanced.

Keywords

References

  1. http://www.census.go.kr/hcensus/index.jsp.
  2. C. Kim, M.Y. Song, S.K. Kim, S.J. Yea, H.C. Jang, D.M. Um, "A Study of Information Strategy Plan Through Korean Information Center", KIOM Journal, vol. 14, no. 3, 2008, pp. 127-135.
  3. http://oasis.kiom.re.kr.
  4. S.J. Yea, H.Y. Kim, C. Kim, J.H. Kim, S.K. Kim, H.C. Jang, M.Y. Song, "A Study on the User Needs Analysis to Improve OASIS", KIOM Journal, vol. 16, no. 2, 2009, pp. 109-118.
  5. C.Y. Han, D.Y. Kim, Y.J. Oh, H.S. Moon, "A Study on the Development of Statistics in Korean Medicine", KIOM Journal, vol. 13, no. 1, 2007, pp. 125-128.
  6. K.J. Lee, J.M. Park, S.K. Kang, S.C. Hwang, "Construction of Web based OLAP system for Education Statistics Information", Proc. KCC2007, 2007, pp. 110-113.
  7. S.H. Shin, J.H. Kim, Y.S. Moon, S.W. Kim, "Implementation of Constructing Pivot Tables for OLAP Analysis from Relational Database", Proc. KIISE2007, 2007, pp. 164-169.
  8. S.J. Yea, C. Kim, H.C. Jang, S.K. Kim, J.H. Kim, M.Y. Song, "Design and Implementation of Statistics System for Traditional Korean Medicine", KCC Journal, vol. 9, no. 12, 2009, pp. 332-338. https://doi.org/10.5392/JKCA.2009.9.12.332
  9. K.W. Kim, Y.M. Seo, "The Suggestion and Verification of Evaluation Factors to Select OLAP Tool", The Journal of Management Study, vol. 30, no. 3, 2001, pp. 929-956.