Designing OLAP Cube Structures for Market Basket Analysis

Han-Ju Yoo; CHOI IN SOO

Journal of The Korea Society of Computer and Information

Abbr : JKSCI
2007, 12(4), pp.179-190
Publisher : The Korean Society Of Computer And Information
Research Area : Computer Science

Han-Ju Yoo ¹ , CHOI IN SOO ²

¹ 숭실대학교
² 숭실대학교

ABSTRACT

Every purchase a customer makes builds patterns about how products are purchased together. The process of finding these patterns, called market basket analysis, is composed of two steps in the Microsoft Association Algorithm. The first step is to find frequent item-sets. The second step which requires much less time than the first step does is to generate association rules based on frequent item-sets. Even though the first step, finding frequent item-sets, is the core part of market basket analysis, when applied to Online Analytical Processing(OLAP) cubes it always raises several points such as longitudinal analysis becomes impossible and many unpractical transactions are built up. In this paper, a new OLAP cube structures designing method which makes longitudinal analysis be possible and also makes only real customers' purchase patterns be identified is proposed for market basket analysis.
KEYWORDS

장바구니 분석(Market Basket Analysis) , 빈발항목집합(Frequent Item-sets) , 큐브구조 (Cube Structures) , 추적분석(Longitudinal Analysis)
REFERENCES (17)

[book] 권오주 / 2001 / OLAP Solutions +α SQL Server Analysis Services / 대림 : 40~54

[book] 조재희 / 2003 / OLAP 테크놀로지 / Sigma Insight : 292~295

[journal] 이덕근 / 2005 / A Data Structuring Technique for Performance Enhancement of Query Processing in the Data Warehouses / 한국컴퓨터정보학회논문지 / 한국컴퓨터정보학회 10 (1) : 7~13

[journal] 유한주 / 2007 / A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing / 한국컴퓨터정보학회논문지 / 한국컴퓨터정보학회 12 (1) : 179~190

[book] Berson, A. / 2000 / Building Data Mining Applications for CRM / McGraw Hill : 89~92

[book] Craig, R. S. / 1999 / Microsoft Data Warehousing / Wiley : 63~66

[book] Inman, W. H. / 1996 / Building the Data Warehouse, 2nd Edition / Wiley : 127~128

[book] Kroenke, D. M. / 2006 / Database Processing, 10th Edition / Prentice Hall : 547~549

[book] Spofford, G. / 2006 / MDX Solutions, 2nd Edition / Wiley : 295~305

[book] Tang, Z. / 2005 / Data Mining with SQL Server 2005 / Wiley : 265~272

[book] Thomsen, E. / 2002 / OLAP Solutions, 2nd edition / Wiley : 375~386

[book] Turban, E. / 2006 / Introduction To Information Technology / Wiley : 424~427

[other] Chen, W. K. / 2005 / Data structures for selective association mining / UMI Microform 3167946

[other] Giuffrida, G. / 2002 / Data mining of large relational databases / UMI Microform 3040197

[other] Yang, Y. / 2004 / New data mining and marketing approaches for customer segmentation and promotion planning on the Internet / UMI Microform 3125924

[confproc] Jensen, M. R. / 2004 / Discovering Multidimensional Structure in Relational Data / LNCS3181 : 138~148

[confproc] Kaya, M. / 2003 / Integrating Fuzziness with OLAP Association Rules Mining / LNAI2734 353 (368) : 353~368
KCI Citation (3)

KJC Korea
Journal Central

Statistics

Tools