Design and implementation of data warehouse for CRM system
Zhu Cheng-rong · Jisuanji gongcheng yu sheji · 2007
The knowledge related to CRM system and the inevitability of applying data warehouse technique to CRM system are illus- trated,and then a system structure diagram of analytical CRM system based on data warehouse technique is provided.Then taking cus- tomer purchasing theme for example,the design of a customer-centric information data warehouse model in analytical CRM system is presented which is for an online bookstore.In the design,notation model,logistic model and physical model are described in details and finally the data warehouse is implemented on the basis of MS SQL Server 2000 which will provide reference for companies to establish data warehouses when they introduce the analytical CRM system.