Browse > Article

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

Cho, Jae-Hee (광운대학교 경영학부)
Ha, Byung-Kook (광운대학교 경영정보학과)
Publication Information
Journal of Information Technology Services / v.9, no.1, 2010 , pp. 127-139 More about this Journal
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
Geographical Pattern of Customer; Data Modeling; Data Visualization; Data Mart;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 황정래, 강혜영, 이기준, "시산과 공간 데이터 마이닝을 적용한 gCRM 구조", 한국정보과학회, 학술발표논문집, Vol.30, No.1(2003).
2 Card, S. K., J. D. Mackinlay, and B. Sheiderman, Readings in Information Visualization : Using Vision to Think, San Francisco, CA : Morgan Kaufmann, 1999.
3 Don Peppers and Martha Rogers, Enterprise One to One 1rd Edition, New York : Currency Doubleday, 1999.
4 조재희, 서일정, "이동객체의 데이터 시각화를 통한 이동패턴 분석에 관한 연구", 한국IT서비스학회지, Vol.6, No.1(2007), pp.127-140.   과학기술학회마을
5 조재희, 서일정, "시공간데이터 분석을 위한 다차원 모델과 시각적 표현에 관한 연구", Journal of Information Technology Applications and Management, Vol.13, No.1(2006), pp.137-147.
6 박기호, 정재곤, 황명화, "P2P LBS 기술을 이용한 gCRM의 영역 확대에 관한 연구", 한국GIS학회 춘․추계학술대회, 2003.
7 윤용근, "gCRM 기법을 이용한 상권분석 연구", 정보기술연구, 2005, pp.29-43.
8 정보통신산업진흥원, S/W시장 분석 : g-CRM시장 동향 및 전망, 정보통신산업진흥원, 2008.
9 조재희, 박성진, OLAP 테크놀로지, 시그마컨설팅그룹, 1999.
10 김형수, 김영걸, 박찬욱, CRM 고객관계관리 전략 원리와 응용, 사이텍미디어, 2009.
11 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.
12 박진수, 장남식, 황유섭, "S카드사의 가맹점 분류체계 정비를 통한 고객세분화 전략", Information Systems Review, Vol.10, No.3(2008), pp.89-109.   과학기술학회마을
13 http://www.geocoding.co.kr.
14 http://www.tableausoftware.com.
15 Teorey, T. J., Database Modeling and Design : The Entity-Relationship Approach, Morgan Kaufmann, San Mateo, CA, 1990.
16 VDI, Visualization Design. Visible Decisions, Inc. Toronto, CA, 1997.
17 Vessey, I., "Cognitive Fit : A Theory Based Analysis of the Graphs versus Tables Literature", Decision Sciences, Vol.22, No.2(1991), pp.219-240.   DOI
18 Westerman, P., Data Warehousing using the Wal-Mart Model, Morgan Kaufmann, 2001.
19 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.
20 Latham, R, The Dictionary of Computer Graphics and Virtual Reality 2nd ed. Springer- Verlag, NY, 1995.
21 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.
22 Tegarden, D. P., "Business information visualization", Communication of the AIS, Vol.1, No.4, 1999.
23 Gattuso, G., "Clothing Retailer Finds Database a Good Fit", Direct Marketing, Vol.5 (1994), pp.26-27.
24 GISMO, Geo-Marketing at your fingertips with GISMO, 6th EC-GE and GIS workshop, Presentation Document, 2000.
25 Hughes, M., Strategic Database Marketing, 3rd Ed, New York ; McGraw-Hill, 2005.
26 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.