Journal of the Korea Society of Computer and Information (한국컴퓨터정보학회논문지)

Korean Society of Computer Information (한국컴퓨터정보학회)
권호 표지
DOI QR코드

DOI QR Code

Development of an OLAP Database System for SME Growth Support -Centering around the Small Business Policy Funds Support Project-

중소기업성장지원 OLAP 데이터베이스 시스템 구축 - 중소기업 정책금융지원 사업을 중심으로-

  • Hwang, Man-Mo (Industrial & Information Systems Engineering, Soongsil Univ.) ;
  • Choi, In-Soo (Industrial & Information Systems Engineering, Soongsil Univ.)
  • 황만모 (숭실대학교 대학원 산업.정보시스템공학과) ;
  • 최인수 (숭실대학교 산업.정보시스템공학과)
  • Received : 2012.02.18
  • Accepted : 2012.03.27
  • Published : 2012.05.31
Download PDF
⟨ Previous Next ⟩

Abstract

The purpose of this paper is to develop an OLAP (online analytical processing) database system that supports the SMBA (Small and medium Business Administration) policy funding. A heterogeneous dimension schema will be central in staged support of policy funds. In this paper, therefore, we designed the FREQUENCY dimension table which has a heterogeneous dimension schema structure. In this paper, we made a model of measuring SME (small and medium-sized enterprise) size first. The model is composed of six determinants of firm growth such as sales, employment, own technology, the operating profit to sales ratio, the debt ratio, and the current ratio. 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 policy funding in the Small Business Policy Funds Support Project (2004-2007) by using the OLAP database system.

본 연구에서는 중소기업청의 정책자금지원 사업을 도와 줄 OLAP 데이터베이스 시스템을 구축하는 것을 목적으로 하고 있다. 정책자금을 단계적으로 지원하기 위해서는 필수적으로 이질 차원 스키마를 채택해야 한다. 따라서 본 연구에서는 단계적 정책금융을 지원하도록 하는 FREQUENCY 차원테이블을 작성한 것이다. 또한 본 연구에서는 중소기업의 크기를 측정할 모델을 작성하였는데, 이 모델은 매출액, 고용인력, 기술보유, 매출액 영업이익률, 부채 비율, 유동비율의 6가지 기업크기 측정지표로 구성되어 있다. FREQUENCY 차원을 포함한 3개 차원과 기업크기 측정모델을 사용하여 OLAP 데이터베이스 시스템을 구축한 것이다. 아울러 이렇게 구축한 OLAP 데이터베이스 시스템을 이용하여 2004년~2007년 간 기 시행된 중소기업 정책자금 지원사업의 적정성을 평가해 보고 있다.

Keywords

References

  1. Small Business Survey Statistics System, "Small Business Research Statistical System", SMBA, January 2011.
  2. Deok-Hui Cho, "Small Business Performance Long-term Slump Causes and Measures", KIET, February 2006.
  3. SMBA,"A Press Report", October 10, 2011.
  4. Man-Mo Hwang, and In-Soo Choi, "Development of an OLAP Database System for SME Growth Support ; Centering around the Small Business R&D Support Project", KSCI, Vol. 17, No. 1, pp.235-245, January 2012.
  5. Hyeon-Uk Kim, "Small Business Policy Funds and Study on Effects of Assistance", KDI, May 2004.
  6. Seong-Gwon Lee, "A Press Report", November 2, 2007.
  7. The Bank of Korea, "Financial Statement Analysis for 2010", July 2011.
  8. Jong-Bok Park, and Jong-Ho Kim, and Hyun-Bong Yang, "Factors Affecting the Growth of Corporate Start-ups Focused on Sales Performance and Job Creation", KASBS, Vol. 32, No. 3, pp.109-128 March 2010.
  9. 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.
  10. Hui-Deok Cho, and Hyeon-Bong Yang, "Job Creation Performance of Manufacturing SMEs in Korea", KIET, December 2010.
  11. Jae-Han Yu, "Job Creation through Policy Funds Assistance", KOFC, July 2010.
  12. Byeong-Seop Yun, Deok-rok Lee, and Bok-Man Yun, "The Effect of the Patent Acquisition on the Management Performance", KCI, Vol. 24, No. 4, pp.261-288, April 2010.
  13. Jeong-Wook Choi, and Wan-Hee Kim, "An Empirical Study on Comparability Analysis Related to Transfer Pricing", KAIA, Vol. 28, No. 4, pp.347-373, April 2010.
  14. Young-Il Kim, "A Study on the Impact of Profitability Accounting Information in Wage-level Determination", KATA, Vol. 4, pp.243-261, December 1997.
  15. Won-Il Koo, "A Study on Accounting Changes of the Food Service Customer Loyalty Program due to Introduction of IFRS-A Case Study of Paris Croissant", KIAA, Vol. 39, No. 10, pp.1-424, October 2011.
  16. Jeong-Ok Kim, "The Effect of K-IFRS Adoption on Financial Reporting: Evidence from Early Adopted Listed Company", KAIA, Vol. 29, No. 2, pp.345-368, February 2011.
  17. Heung-Ki Kim, and Moon-Hwoan Kim, and Young-Ryul Song, "A Study on the Effect of the Changes of the Capital Structure on the Value of Firm", KCI, Vol. 23, No. 4, pp.157-178, November 2009.
  18. Yeon-Hee Park, and In-Man Song, and Su-Il Bae, Sung-Jin Park, "Problems in System of Uniform 200% Debt-equity Ratio and Suggestions for System Improvement", KAA, Vol. 20, No. 4, pp.287-328, April 2011.
  19. Hyo-Soon Choi, "Re-examination on the Debt Covenant Hypothesis for Earnings Management", KAA, Vol. 33, No. 1, pp.69-96 January 2008.
  20. In-Su Yi, and Hyun-Dol Choi, "A Study on the Debt-Equity Ratio Decrease after Korean Financial Crisis", KRABE, Vol. 19, pp.249-274, February 2008.
  21. E. Malinowski, and E. Zimányi, "OLAP Hierarchies: A Conceptual Perspective", LNCS 3084, pp.477-499, 2004.
  22. 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.
  23. Mi-Hwa Oh, and In-Soo Choi, "Transforming Non-distributive Hierarchy Schema in to the Distributive Hierarchy Schema", KSCI, Vol. 16, No. 11, pp.233-244, November 2011.
  24. "SME Basic Law Article 2", SME Basic Law, Law No. 10952, some revision, July 25, 2011.
  25. Chang-Gyu Choi, Hyun-Sik Kim, and Yong-Nam Kim, "IFRS Accounting Principle", Woongjin Passone, December 2011.