DOI QR코드

DOI QR Code

Development of an OLAP Database System for SME Growth Support -Centering around the Small Business R&D Support Project-

중소기업성장지원 OLAP 데이터베이스 시스템 구축 -중소기업기술개발지원사업을 중심으로-

  • Hwang, Man-Mo (Industrial & Information Systems Engineering, Soongsil Univ.) ;
  • Choi, In-Soo (Industrial & Information Systems Engineering, Soongsil Univ.)
  • 황만모 (숭실대학교 대학원 산업.정보시스템공학과) ;
  • 최인수 (숭실대학교 산업.정보시스템공학과)
  • Received : 2011.12.12
  • Accepted : 2012.12.28
  • Published : 2012.01.31

Abstract

The purpose of this paper is to develop an online analytical processing (OLAP) database system for small and medium-sized enterprises (SMEs) growth support. In this paper, we made a model of measuring SME size first. The model is composed of five determinants of firm growth such as employment, sales, the amount of export, own technology, and the ratio of R&D expenditure to sales. Second, we designed the FREQUENCY dimension table which will make staged support of R&D expenditure. We developed the OLAP database system by using three dimensions including the FREQUENCY dimension, and using the model of measuring SME size. Also we assessed past decisions on R&D expenditure support in the Small Business R&D Support Project by using the OLAP database system.

본 연구에서는 중소기업성장을 지원할 OLAP 데이터베이스 시스템을 구축하는 것을 목적으로 하고 있다. 본 연구의 특징은 중소기업의 크기를 측정할 모델을 작성하는 것이다. 이 모델은 고용인력, 매출액, 수출액, 기술보유, 매출액 대비 기술개발투자비 비율 등의 5가지 기업크기 측정지표로 구성된다. 또한 단계적 기술개발자금 지원을 가능케 할 FREQUENCY 차원 테이블을 설계하는 것이다. FREQUENCY 차원을 포함한 3개 차원과 기업크기 측정모델을 사용하여 OLAP 데이터베이스 시스템을 구축한 것이다. 그리고 이 OLAP 데이터베이스 시스템을 이용하여 기 시행된 중소기업기술개발지원사업의 적정성을 평가해 보고 있다.

Keywords

References

  1. KDI, "The NARA Economy", May 2010.
  2. Small Business Survey Statistics System, "Small Business Research Statistical System", SMBA, January 2011.
  3. National Business Survey Research, "2008. SME Businesses and Workers by Industry", Statistics Korea, January 2010.
  4. Daijun Development Institute, "Company's Integrated Operations Support System ", August 2008.
  5. Jae-Hyun Lee, and Seung-Hee Ko, "Supporting Reality and Support System Improvement for the Small and Medium Size Enterprises", The Korea Contents Association, Vol. 9, NO. 7, pp. 333-341, July 2009.
  6. Hyeon-jeong Jo, "Development of National S&T Indicators Framework and Preparation Method of Numerical Statements", Korea Institute of Science & Technology Evaluation and Planning, May 2005.
  7. Christopher T. Street, and Darren B. Meister, "Small Business Growth and Internal Transparency: The Role of Information Systems", Management Information Systems Research Center, Vol. 28, No. 3, pp. 473-506, September 2004.
  8. Alex Coad, and Werner Holzl, "Firm Growth: Empirical Analysis", February 2010.
  9. Korea Evaluation Institute of Industrial Technology, "Industrial Technology Development Status and Utilization Survey Report", Government Publications, September 2008.
  10. Small and Medium Business Administration, "Growth Stage Companies", SMBA, December 2010.
  11. Jeong-il Lee, and Won-Yu Tae, "Role of Business and Challenges for Acceleration of Employment", Korea Listed Companies Association, Vol. 61, pp. 40-64, March 2010.
  12. Ministry of Education Science and Technology, "Year 2009 National Science and Technology Innovation Evaluation", KISTEP, February 2010.
  13. Eun-Yeong Kim, "A Study on Utilization of Export Assistance Programs for SMEs and their Exportation ", Hannam University, December 2010.
  14. Byeong-Seop Yun, Deok-Rok Lee, and Bok-Man Yun, "Patent for its Effects on Business Performance Analysis Activities", KCI, Vol. 24, No. 4, pp. 261-288, December 2009.
  15. E. Malinowski, and E. Zimányi, "OLAP Hierarchies: A Conceptual Perspective", LNCS 3084, pp. 477-499, 2004.
  16. Mi-hwa Oh, Man-Mo Hwang, Jung-Woo Choi, and In-Soo Choi, "An Approach to Navigating Data Cubes with a Hierarchical Visualization Technique", KSCI, Vol. 16, No. 2, pp. 290-305, February 2011.
  17. Mi-hwa Oh, and In-Soo Choi, "Transforming Non-distributive Hierarchy Schemas into the Distributive Hierarchy Schema", KSCI, Vol. 16, No. 11, pp. 233-244, November 2011.