Journal of Information Technology Services (한국IT서비스학회지)

Korea Society of IT Services (한국IT서비스학회)
권호 표지

Buying Pattern Discovery Using Spatio-Temporal Data Mart and Visual Analysis

고객군의 지리적 패턴 발견을 위한 데이터마트 구현과 시각적 분석에 관한 연구

  • Received : 2010.01.17
  • Accepted : 2010.03.08
  • Published : 2010.03.31
Download PDF
⟨ Previous Next ⟩

Abstract

Due to the development of information technology and business related to geographical location of customer, the need for the storage and analysis of geographical location data is increasing rapidly. Geographical location data have a spatio-temporal nature which is different from typical business data. Therefore, different methods of data storage and analysis are required. This paper proposes a multi-dimensional data model and data visualization to analyze geographical location data efficiently and effectively. Purchase order data of an online farm products brokerage business was used to build prototype datamart. RFM scores are calculated to classify customers and geocoding technology is applied to display information on maps, thereby to enhance data visualization.

Keywords

References

  1. 김형수, 김영걸, 박찬욱, CRM 고객관계관리 전략 원리와 응용, 사이텍미디어, 2009.
  2. 박기호, 정재곤, 황명화, "P2P LBS 기술을 이용한 gCRM의 영역 확대에 관한 연구", 한국GIS학회 춘․추계학술대회, 2003.
  3. 박진수, 장남식, 황유섭, "S카드사의 가맹점 분류체계 정비를 통한 고객세분화 전략", Information Systems Review, Vol.10, No.3(2008), pp.89-109.
  4. 윤용근, "gCRM 기법을 이용한 상권분석 연구", 정보기술연구, 2005, pp.29-43.
  5. 정보통신산업진흥원, S/W시장 분석 : g-CRM시장 동향 및 전망, 정보통신산업진흥원, 2008.
  6. 조재희, 박성진, OLAP 테크놀로지, 시그마컨설팅그룹, 1999.
  7. 조재희, 서일정, "이동객체의 데이터 시각화를 통한 이동패턴 분석에 관한 연구", 한국IT서비스학회지, Vol.6, No.1(2007), pp.127-140.
  8. 조재희, 서일정, "시공간데이터 분석을 위한 다차원 모델과 시각적 표현에 관한 연구", Journal of Information Technology Applications and Management, Vol.13, No.1(2006), pp.137-147.
  9. 황정래, 강혜영, 이기준, "시산과 공간 데이터 마이닝을 적용한 gCRM 구조", 한국정보과학회, 학술발표논문집, Vol.30, No.1(2003).
  10. Card, S. K., J. D. Mackinlay, and B. Sheiderman, Readings in Information Visualization : Using Vision to Think, San Francisco, CA : Morgan Kaufmann, 1999.
  11. Don Peppers and Martha Rogers, Enterprise One to One 1rd Edition, New York : Currency Doubleday, 1999.
  12. Gattuso, G., "Clothing Retailer Finds Database a Good Fit", Direct Marketing, Vol.5 (1994), pp.26-27.
  13. GISMO, Geo-Marketing at your fingertips with GISMO, 6th EC-GE and GIS workshop, Presentation Document, 2000.
  14. Guo, Y., S. Tang, Y. Tong, and D. Yang, Triple-Driven Data Modeling Methodology in Data Warehousing : A Case Study, In Proc. 9th ACM international workshop on Data warehousing and OIAP, 2006, pp.59-66.
  15. Hughes, M., Strategic Database Marketing, 3rd Ed, New York ; McGraw-Hill, 2005.
  16. Kuijpers, B. and A. A. Vaisman, A Data Model for Moving Objects Supporting Aggregation, in Data Engineering Workshop, IEEE 23rd International Conference, 2007, pp.546-554.
  17. Latham, R, The Dictionary of Computer Graphics and Virtual Reality 2nd ed. Springer- Verlag, NY, 1995.
  18. List, B., R. Bruckner, K. Machaczek, and J. Schiefer, A comparison of data warehouse development methodologies : Case study of the process warehouse, In Proc. DEXA 2002, pp.203-215.
  19. Schroeder, W., K. Martin, and B. Lorensen, The Visualization Toolkit : An Object-Oriented Approach to 3D Graphics 2nd edition. Upper Saddle River, NJ; Prentice Hall, 1998.
  20. Tegarden, D. P., "Business information visualization", Communication of the AIS, Vol.1, No.4, 1999.
  21. Teorey, T. J., Database Modeling and Design : The Entity-Relationship Approach, Morgan Kaufmann, San Mateo, CA, 1990.
  22. VDI, Visualization Design. Visible Decisions, Inc. Toronto, CA, 1997.
  23. Vessey, I., "Cognitive Fit : A Theory Based Analysis of the Graphs versus Tables Literature", Decision Sciences, Vol.22, No.2(1991), pp.219-240. https://doi.org/10.1111/j.1540-5915.1991.tb00344.x
  24. Westerman, P., Data Warehousing using the Wal-Mart Model, Morgan Kaufmann, 2001.
  25. http://www.geocoding.co.kr.
  26. http://www.tableausoftware.com.