基于dw_olap_dm的超市销售决策支持系统文档.pdf

33 14 2007 7 Vol.33 No.14 Computer Engineering July 2007 · · 2007 A TP311 DW+OLAP+DM ( 100037) C/S OLAP Supermarket Sale DSS Based on DW+OLAP+DM XUE Hong, WANG Min (College of Information Engineering, Beijing Technology and Business University, Beijing 100037) AbstractWith supermarket sale data, the supermarket sale DSS of C/S framework is designed and developed based on data warehouse, OLAP and data mining technologies. This paper introduces the established process of data warehouse and realization of online analytical processing technology from application requirement. The data mining function module seeks the optimal putting layout of goods shelves by analyzing the sale record of merchandise. The module can help managers set down member card serving strategy and sales promotion project according to the analysis of member information to adapt well to consumers and keep steady consumption group. Key wordsdata warehouse; OLAP; data mining; decision support system 2 2.1 ( data warehouseDW ) (OLAP) (data miningDM) [14] 1 1.1 2 1 *TimeId *CustomerId .Year TimeId .Country ProductId