A Study of Authorized Stockage List Selection using Market Basket Analysis

장바구니 분석을 활용한 ASL 선정 연구

  • Received : 2012.05.24
  • Accepted : 2012.05.30
  • Published : 2012.06.30

Abstract

In this study, It is assumed that customers are both usage unit of spare parts and stores of displaying and selling the goods that are installation unit of having the spare parts. The demand pattern through the effective order of spare parts and issue list in installation unit is investigated based on the assumption. Current ASL (Authorized Stockage List) selection of the army has been conducted in the way of using the analysis result of real usage experiences on spare parts used during the Korea War. For this study, ASL selection criteria and procedures based on army regulations and field manuals are specified. Since the traditional method does not presents the association analysis on spare parts used for the current equipment operating and does not have the clear criterion and analysis system about the ASL selection, in order to solve these problems, it was carried out that the association rule is employed for analyzing relationship between the effective order and issue list of the spare parts in point of the spare parts between usage unit and occurring month about purchase spare parts based on the star-schema table. Finally the new ASL selection way using the analysis result is proposed.

Keywords

References

  1. 길계호, 김충영; "목표계획법을 이용한 사단급 ASL 선정모형에 관한 연구", 한국경영과학회 학술대회 논문집, 2 : 75-78, 1998.
  2. 유한주, 최인수; "장바구니 분석용 OLAP 큐브구조의 설계", 한국컴퓨터정보학회 논문지, 12(4) : 180-189, 2007.
  3. 육군본부; "야전교범 42-0-5 수리부속관리", 2006.
  4. 육군본부; "기술교범 K9(3)-2320-501-20 1/4톤 트럭, K131", 2007.
  5. 임영문, 최영두; "연관규칙을 이용한 데이터 분석에 관한 연구", 한국산업경영시스템학회지, 23(61) : 115-126, 2000.
  6. 조재희, 박성진; "OLAP 테크놀로지", Sigma Insight, 292-295, 2003.
  7. 조재희, 서일정; "OLAP을 활용한 지하철 인구이동 맵 생성에 관한 연구", Information System Review, 7(1) : 65-80, 2006.
  8. 정영수, 강창욱; "연관규칙을 이용한 제고 공정의 불량항목 예측", 한국산업경영시스템학회 2004 춘계 학술대회논문집, 310-313, 2004.
  9. 한기원; "OLAP 기반의 창고관리 시스템 설계 및 구현", 국방대학교 석사학위논문, 2003.
  10. 한경록, 김재련; "데이터 큐브를 이용한 연관규칙 발견 알고리즘", 한국산업경영시스템학회지, 23(54) : 27-36, 2000.
  11. Agrawal, R., Imielinski, T., and Swami, A.; "Mining Association Rules between Sets of Items in Large Databases," In Proc. of the ACM SIGMOD Int'1 Conference on Management of Data, Washington, D.C., 207-216, 1993.
  12. Berson, A., Berson, Alex, Thearling, Kurt, and Smith, Stephen J.; Building Data Mining Applications for CRM, 89-92, McGraw Hill, 2000.
  13. Chen, W. K.; "Data structures for selective association mining," UMI Microform, 3167946, 2005.
  14. Craig Utley; "MS SQL Server 2005," No. SQL-200509-27, 2005.
  15. Kaya, M. and Alhajj, R.; "Integrating Fuzziness with OLAP Association Rules Mining," LNAI2734, 353-368, 2003.
  16. Tang, Z. and MacLenman, J., "Data Mining with SQL Server 2005," 265-272, Wiley, 2005.