Design of customer management star model in clickstream data warehouse
Xie Guang-yu · Jisuanji gongcheng yu sheji · 2008
A great deal of basic information and behavior information of customers are stored in clickstream data warehouse,and their organization strategies are closely related to the efficiencies of on line analytical processing and data mining.Fact tables of traditional click star schema and session star schema have not make the customer as a commercial behavior centre,so some directed customer-orien-ted analyses can not be provided.After analyzing the traditional schema,a customer management star model made the customer as a center is proposed according to the requirements of enterprise CRM,and a time rotation model of customer-oriented is adopted to imple-ment this kind of schema.